Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-04-29 : 06:21:22
|
| HI folks,Hope someone can help.I've recently had SQL Server express installed on my machine at work. However, I'm not an administrator. I tried to set the server up so I was sysadmin. i can create the login but when I attempt to change the server role I get a permission error.I asked my IT dept to do this and they're having the same problem. The login to my machine, add and add me as a login and can't change the server role, it's saying they don't have permissions to do this. They then add themselves as a login. Again, they receive a permissions error when attempting to add themselves as sysadmin.I'm obviously missing something here but don't know what. Please can someone help me? Perhaps this has happened to you?It's SQL Server express 2005 running from Vista.Thanks |
|
|
|
|
|
Not got permissions in SQLExpress