March 28, 2018 at 8:40 am
IT at work installed SQL Express 2014 on my machine but I dont have the ability to add a new database, or user. They dont know how to help me. I was able to walk them through adding a login, but I can't add a database and I cant give myself permissions. Dones anyone know how to let me add rights?
March 28, 2018 at 9:30 am
It sounds like since this is just on your machine they should have added your login as an Administrator.
This is done in the Setup wizard on the "Database Engine Configuration" page, on the "Server Configuration" tab in the bottom pane of that tab. Did they set up this instance for Windows Authentication mode or Mixed mode?
If Mixed mode then someone who knows the SA login password can connect to the instance and add your login to the sysadmin group.
If it is setup as Windows Authentication only, I believe there are some tricks for restarting the instance in a special mode to allow you to get in as a sysadmin temporarily, but I'm not as familiar with those techniques.
March 28, 2018 at 11:42 am
I'm the only one in the office using this. I have no idea who IT did during setup. I handed them my laptop and they installed it. How do I confirm 'Windows Authentication mode or Mixed mode'?
March 28, 2018 at 12:08 pm
if you can connect to this using the Object Explorer in SQL Server Management Studio, try to right click on the instance name, then select the "Security" page. The first setting on the page is "Server Authentication". I can see that page even on instances I'm not in the sysadmin group of.
March 28, 2018 at 12:27 pm
Its Windows authentication mode
March 28, 2018 at 12:41 pm
unfortunately you may be stuck having to reinstall SQL Server on your machine, or trying the process described here for restarting it in single user mode:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out
March 28, 2018 at 1:06 pm
I've attempted that fix and only get a 'No process is on the other end of the pipe'. I'm not going to have the software reinstalled as I dont know what went wrong during installation, so I will likely have the same issue. I've been working on this for a month now at work. I wanted to use an MDF, but can't do that on the server. Then I've had never-ending issues attempting to get sql online. I think I may have to revert to ms access and hope its enough for my needs.
It's a shame IT can't seem to install this properly.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply