SQL Server Service Account login failure

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server Service Account login failure

Author

Topic

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2010-08-17 : 11:35:11

Hi all,

I'm getting the following error on my SQL Server:

Login failed for user 'Domain\ServiceAccount'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]

The service account has sysadmin rights on SQL Server.

Has anyone had this issue before? Are there additional permissions that need to be granted to the service account on Windows 2008?

guptam
Posting Yak Master

161 Posts

Posted - 2010-08-17 : 12:47:07

Are you sure it is SQL Agent? If so check to see the default database still exists, sometimes it gets set to a database that gets dropped.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2010-08-17 : 13:05:45

The default database is master.
The SQL Server agent is disabled. Could this be causing the issue?

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-18 : 04:50:45

no need to enable the service

post the result of the following queries:

exec sp_helplogins 'Domain\ServiceAccount'
select * from sys.server_principals where name='Domain\ServiceAccount'

--------------------
keeping it simple...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources