Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Login failed for user''.

0 views
Skip to first unread message

Fear@discussions.microsoft.com Vikki Fear

unread,
Feb 17, 2010, 9:49:02 AM2/17/10
to
I am getting the error "login failed for user''" when trying to connect to my
SQL 2005 from a remote server using windows authentication. Using SQL
authentication works, but is not a suitable work-around.

The database is in mixed mode.

The user has DBO access to the database.

This worked last week, but following a database restore at the weekend is no
longer working. I have reset all the users who had access to the database
prior to the restore.

This does not appear to be a specific user issue, but an issue with windows
authentication in general

Erland Sommarskog

unread,
Feb 19, 2010, 8:46:41 PM2/19/10
to

How do you connect? From Mgmt Studio? An application? Do you specify
the database when you connect? What happens if you try:

SQLCMD -d tempdb -E -S THESERVER


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

0 new messages