July 22, 2008 at 10:52 am
Hello room,
I installed the sql 2008 on Window 2003.
The SQL server's service account assigned "User1" with minimal privilege.
The service is up and running.
When I open Microsoft SQL Server Manager Studio,
Errors: Login failed for user "Domain name\DC login". Microsoft SQL Server, Error: 18456.
The login window screen indicated: default to DC admin login.
Is this a bug?
Any advise will be appreciated.
TJ
July 22, 2008 at 10:58 am
What rights does Domain name\DC login have on the machine running SQl server? Is it local admin?
Have a look in the error log (it's just a text file if you can't access it through SQL. look in the install dir for SQL under log)
It will give you far more info on why the login failed. What does it say?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply