asked on Sql Server 2005 error: 18456
I installed Sql Server 2005 on my 64 bit Windows Vista. I had all the prerequites and there were no error messages in the installation. I used Windows authentication for security, and I am an Administrator on my laptop.
However, I get an error when I try to connect to the database engine.
Here's the error below. What do I need to look at? Thank you.
TITLE: Connect to Server
--------------------------
Cannot connect to PHIL-PC\SQLSERVER2K5.
--------------------------
ADDITIONAL INFORMATION:
Login failed for user 'Phil-PC\Phil'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
However, I get an error when I try to connect to the database engine.
Here's the error below. What do I need to look at? Thank you.
TITLE: Connect to Server
--------------------------
Cannot connect to PHIL-PC\SQLSERVER2K5.
--------------------------
ADDITIONAL INFORMATION:
Login failed for user 'Phil-PC\Phil'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Microsoft SQL Server
Last Comment
psmithphil
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I assume I have to log in with Sql Server Authentication if I use sa. I tried that but got the same error. However, I don't recall being asked to set a "sa" password when I installed Sql Server. Have I just forgotten I made a password for the sa account and therefore don't know the password? If I uninstall Sql Server and re-install, would I be asked to set an "sa" password?
You will be required to setup an sa password during the install.
ASKER
Ok, thank you. It looks like I need to uninstall/reinstall and used Mixed Mode this time. I will try this and let you know asap.
I appreciate your help!
I appreciate your help!
ASKER
Thank you for your excellent help! I have reinstalled Sql Server in mixed mode this time, and can now access it with the sa account. Now I can research the issue.