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 2005 Forums
 SQL Server Administration (2005)
 SQL Server 2005 on Windows Server 2008

Author  Topic 

rghenriques
Starting Member

1 Post

Posted - 2010-05-06 : 15:56:32
Hi All,

Hi had installed the SQL Server 2005 on windows 2008 with mixed authentication but the windows authentication doesn't work.

"login failed for user "Domain\User" microsoft sql server, error: 18456"

Anyone have any ideas?

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-06 : 16:18:42
The account doesn't have access to the database server. Add the access by logging in with the sa account or an account that has Local Admin.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -