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 |
|
poratips
Posting Yak Master
105 Posts |
 Posted - 2013-08-15 : 16:26:38
|
| I have installed the sql 2008R2 on new Windows server 2008R2 but after instalaltion, i see the error in sql server error log.Login failed for user 'MSSqlDB2K8\sqlsrvAcct'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]I have created this account during installation but didn't add account int oadministrator group.I have also tried to login using same credential in SSMS and I can't connect.When tried to sto pand start the service i can do it.I have added user into Administer group but still not working.I have also assigned account in Sysadmin server Role into Security. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-19 : 06:48:35
|
| I think you have assigned a default database for the login which it doesnt have necessary privileges------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Service Account Error in log after installing Sql