?
Solved

Login failed for user '(null)'

Posted on 2005-03-14
14
Medium Priority
?
331 Views
Last Modified: 2008-02-26

I have a SQL 2000 Server running on Windows 2003. The server is a secure internal build, and I must confess I don't have full visibility of all the security elements that have been performed at the OS level, but for the SQL server, I do have.

I have added my account as a Sysadmin login to the server (e.g. DOMAIN1\USER1).

Now when I run Query Analyser from a client logged on as DOMAIN1\USER1, I receive the error:

Server: Msg 18452, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

It's as if my domain credentials are not being passed across to the server.

Thanks in advance.
0
Comment
Question by:lozzamoore
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +1
14 Comments
 
LVL 7

Expert Comment

by:jackiechen858
ID: 13536254
Check the SQL Server enterprise manager->your database server-> Security->logins,
Add Domain1\User1
0
 
LVL 11

Expert Comment

by:saleek
ID: 13536262
More than likely that your user does not have access to the sql server. You should test that this is the case by creating a connection to your sql server from another server. E.,g., use webpage, vb.net app or file dsn etc.
0
 
LVL 7

Expert Comment

by:jackiechen858
ID: 13536269
oh, You already did it.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 7

Author Comment

by:lozzamoore
ID: 13536427
Saleek,

I'm testing access from another workstation using SQL Query Analyser.

The login has been added in SQL Server. Does the user need additional access?

Thanks,
0
 
LVL 11

Expert Comment

by:saleek
ID: 13536568
Can you gain access by logging in (at the client end) using the built-in sql server admin account?
0
 
LVL 7

Author Comment

by:lozzamoore
ID: 13536609

I can log into the client using the SQL Server Service account no problem.

However-I just tried logging into the Win2003 Server using the Service account, and I get the following:

The system cannot log you on due to the following error:
The RPC server is unavailable.

Please try again or.....

Does this mean anything to you?
Could a service that is required not be running?

Thanks,
0
 
LVL 11

Expert Comment

by:saleek
ID: 13536726
Hmmm. Did you recently create the service account? I'm just wondering if you did, then whether the change has been propogated over the network.  
0
 
LVL 11

Expert Comment

by:saleek
ID: 13536740
Some possible cause I found on the internet:

1. The RPC service may not be started.
2. You are unable to resolve a DNS or NetBIOS name.
3. An RPC channel cannot be established.

0
 
LVL 7

Author Comment

by:lozzamoore
ID: 13537173

1. I've checked the RPC Service on the server, and it is started ok.

2. As the environment is AD, Win2003 Server, and XP Client, I'm assuming NetBIOS use should be minimal.

So-I have checked:
resolving client DNS name from server. OK
resolving DC name from server. OK

3. Not sure how I would go about checking this?

Thanks,


0
 
LVL 7

Author Comment

by:lozzamoore
ID: 13566227

UPDATE:

We got our OS guys here to remove the win2003 "security template" that they had applied.

This has removed the issue.

I don't know much about the security template features, but from what I have heard, these are largely an automated way of applying Local Policies and Registry Settings.

Anyone have any experience of which setting could have caused this issue?

BTW: The RPC error message when I try and logon to the server still persists (?)
0
 
LVL 7

Author Comment

by:lozzamoore
ID: 13865454
OK,

Please post if you wish me to arrange to have the question deleted.

Incidentally-for all subscribed: I recently found out, we did get a resolution for this issue, and were able to get connections working with the security template applied also.

The account running SQL services must have the "Impersonate a client after authentication" right.  This doesn't seem to be necessary if LOCAL SYSTEM is running them, but is for a domain account.

Thanks,
0
 

Accepted Solution

by:
PAQ_Man earned 0 total points
ID: 13948847
PAQed with points refunded (500)

PAQ_Man
Community Support Moderator
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question