Recently, I installed a fresh copy of Windows Vista Business.
Then, I installed SQL Server 2005 Developer Edition.
Upon completion I get a message saying that I should update my SQL Server with SQL
Server SP1.
Good. Go to Microsoft.com, download and installed it. Update succesful.
Then I get another message telling me that I need to update to SQL Server 2005 SP2
because that one is also need it for compatibility with Windows Vista.
Good. Go again to Microsoft.com and install SP2.
Trying to connect to the server is imposible. When I try I get the folowing message:
Cannot connect to Val-PC ( the server name )
Login failed for for user 'Val-Pc\Val' (Microsoft SQL Server, Error 18456 )
Can anyone help? It would be very much appriciated.
Thanks.
What is the state of the error message ?Jens K. Suessmeyer.
http://www.sqlserver2005.de|||It seems that you are using windows authentication. check whether this user has enough permission to the server|||
For some reason, as soon as Service Pack 2 was installed successfully, the problem
was gone. I could connect to the server right away.
I understand by looking at the documentation that previous versions of SQL Server 2005 have
compatibility problems with Windows Vista and Service Pack 2 is supposed to address them.
Thanks for the help, anyway!
No comments:
Post a Comment