May 2, 2012 at 10:02 am
I am getting this error "Login failed for user 'DomainName\Administrator'.Reason:Failed to open the explicitly specified database"
In log file viewer "sql server agent must be connect to sqlserver as sysadmin but 'unknown' is not a member of sysadmin."
Please help me to resolve this...Thanks in advance
May 2, 2012 at 10:50 pm
What do you mean by "SQL server Agent not working"? Do you mean SQL Server Agent service is not running?
Or do you mean SQL Server Agent service is running, but some jobs are failing?
Where did you find the first error? In the SQL Server log? That error means, in the Connection String a database name is mentioned (may be other than the default database). But failed to open the db either due to permission issue or the db does not exist. So you need to check the connection string first.
Not sure about the second message. Looks like some has messed up the permissions.
May 3, 2012 at 12:38 am
- Keep in mind , your domain administrator account doesn't automatically have SQLServer administrator privileges !
- did you try changing the default database for DomainName\Administrator ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply