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 |
|
vanbasten
Starting Member
7 Posts |
 Posted - 2011-02-01 : 19:43:09
|
| I have a SQL Server 2008 running on this Windows Server 2008 box. The owner of the SQL Server service was owned by an user and I wanted to change it. After I changed services to be owned by a service account using the services console (which i should have done it using the SQL Server Configuration Manger), I am now getting "The database xx is not accessible" when using the Management Studio to access the db. I also notice that a number of logins are not missing.Is there any way to fix this such as using the Configuration Manager? Any help is appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-02 : 10:03:10
|
| What credentials are you connecting with?Does new service account have sysadmin permission?Changing the service account won't make logins disappear. You did something else too that you haven't told us. Or, the account you're using doesn't have permission to see the logins. |
 |
|
|
|
|
|
database not accessible