Timeline for Restricted user on my local SQL Server database?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 12, 2015 at 17:54 | comment | added | Spörri | Yes, you will need an administrator to give you access or to do the following msdn.microsoft.com/en-us/library/dd207004.aspx | |
| Jun 12, 2015 at 17:45 | comment | added | Juan Velez | I right clicked on the SSMS icon and then "Run as Administrator". Then logged in to .\SQLEXPRESS using win. authent. Under Security>Logins I double clicked on the BUILTIN\Users login and tried adding it to the sysadmin server role but got an error saying "Add member failed for ServerRole 'sysadmin' User does not have permission to perform this action." I also created a login with my Domain\Username but I also get the same error message when I try to add it to the sysadmin server role. Even though I am running SSMS as Administrator like u mentioned I am not Admin on my PC cld that be issue? | |
| Jun 12, 2015 at 17:12 | comment | added | Spörri | Yes you can, if you can start ssms with run as admin | |
| Jun 12, 2015 at 17:07 | comment | added | Juan Velez | Thank you, so basically I will need to do a default installation of SQL Server before following the steps you suggested right? In other words with the SQL EXPRESS installation I currently have I will not be able to create databases right? | |
| Jun 12, 2015 at 14:58 | vote | accept | Juan Velez | ||
| Jun 11, 2015 at 21:18 | history | answered | Spörri | CC BY-SA 3.0 |