September 8, 2008 02:04am pdt

Member Login

Hall of Fame

Yearly

1angelIII 304,014
2chapmandew 204,583
3mark_wills 200,618
4ee_rlee 138,745
5capricorn1 125,106
6matthews... 123,771
7jimpen 78,127
8BillBach 75,988
9aneeshatti... 73,852
10sdstuber 73,139
11jinesh_ka... 69,454
12DatabaseMX 68,169
13dtodd 58,600
14Thomasian 58,264
15LSMCons... 56,898
16peter57r 54,454
17dportas 51,915
18schwertner 45,045
19Arthur_... 39,661
20frankytee 37,985
21dqmq 36,070
22jimhorn 34,518
23boag2000 33,876
24TextReport 33,668
25harfang 31,274

	[x] Attachment Details

SQL Server 2005: Login failed for user ''

Zone: Databases Miscellaneous

Tags: sql, failed, user, server, login

We are really getting crazy for this:

Suddenly when trying to connect to Management Studio with trusted connection, our db server is returning this error :

Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: X.X.X.X]

In the sql server log and in the event viewer this error is always associated with this one:

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: X.X.X.X]

We don't own the sa password (the guy who installed the server says he didn't input any password for sa, is that possible?), blank password doesn't work.

We have access to the phisical computer with an administrator account. The very same administrator account has been used to access SQL using trusted connection until friday and now suddenly is returning this error, apparently with no logical reason.

I have been trying in any possible way using a remote connection with terminal service:

1. tried connecting with oSql -E -S <servername> (same result)
2. tried to add the administrator account to every possible SQL SERVER group on the machine
3. tried connecting using SQL server authentication using the administrator username e password

The computer is not even in a domain, it's the only machine in a workgroup.

Any suggestion to find a way out other than spending at least 99 euros to open a microsoft incident with technical support is welcome...

Start your free trial to view this solution

Related Solutions: change maximum error count on sql server 2005'

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.7

Question Stats

Zone: Database

Question Asked By: cip

Solution Provided By: lokeshgm7

Participating Experts: 2

Solution Grade: C

Translate:

Loading Advertisement...

20080723-EE-VQP-34