March 19, 2018 at 9:34 am
I couldn't add databases, so I attempted to give myself the privilege. It wouldn't let me. So I went to SQL Server Configuration Manager>SQL Server(SQLSERVEREXPRESS)>Properties>Startup Parameters to add privileges. But it's greyed out. So I tried to stop the sql server so that I could add the parameters, but stop will not work. Pause is useless as well.
March 19, 2018 at 9:45 am
wperciful - Monday, March 19, 2018 9:34 AMI couldn't add databases, so I attempted to give myself the privilege. It wouldn't let me. So I went to SQL Server Configuration Manager>SQL Server(SQLSERVEREXPRESS)>Properties>Startup Parameters to add privileges. But it's greyed out. So I tried to stop the sql server so that I could add the parameters, but stop will not work. Pause is useless as well.
You will have you ask someone who has sysadmin to amend your permissions so you can add databases.
Thanks
March 29, 2018 at 5:24 am
IT doesn't know how to do that.
March 29, 2018 at 8:26 am
OK, based on this and your previous posting, I believe we're back to having SQL Server reinstalled on your PC. When they get to the "Database Engine Configuration" page of the install, on the "Server Configuration" tab, make sure they either use "Mixed Mode" and give you the SA password, or they use "Windows Authentication Mode" and add your network login to the "Specify SQL Server Administrators" section at the bottom. I've attached a screenshot of this page for reference.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply