In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties. On the General page, you may have to create and confirm a password for the sa login. On the Status page, in the Login section, click Enabled, and then click OK.

I am not sure why is it happening, but did you check, what is the value set for Maximum No of Concurrent connections at Server Level ?

You can check this, Right Click Server Name in SSMS, Select Properties, Go to Connections tab.

Other scenario could be, if you have used that windows Login to run any service, and you recently changed password for that Windows Account but for got to change password at the service logon. Then for every 5 attempts of the service, the Windows Account will be locked because of incorrect password attempt made by the service. And as per Windows Policy Set, Windows Account are reset after some times, (most of the times this will be 30 minutes).

Try checking if you have used this windows Account in any of the service, if you did then change the password at the service logon to new password of windows account. Checking Event Viewer could give you more information.

Hi Imran, I have checked it and we assign 0 for unlimited connections.

Other thing is we are using window authentication for sql2008r2 and we have an application running which uses sql2008 as a backend .

All the user are domain user using the domain account. It works fine with some users but some user have an issue Error 18452(Untrusted Domain connection).If you log off and Log back in , it starts working fine.

Hi Sukh, Hi All,
The network – guru’s did finally figure out at least what the problem was we were having. For those of you running on an “authenticated” network this may be useful:
They changed a few parameters – the ID of which I don’t know – but the basic error message stayed the same.
The “Fix” that caused the error message to go away and everything to work was to make sure that the UserID and password with which I was signing into my computer – and thus onto the Microsoft Active Domain server – was the same as the UserID and password entered into the Sql2008 database server.

From what I can understand – I was signing into the AD server and the AD server was signing me in to the SQL server – but it was giving the SQL server my ACTIVE DOMAIN UserID and Password. As soon as the UserID and password being provided to the SQL server matched the UserID and password it was expecting – then it knew me and let me in.

Your artical really help me, when I am trying this in the production. Because I wrongly selected Authentication Mode of the SQL server from “Windows Authentication Mode (Windows Authentication)” with the help of your script I have change to “Mixed Mode (Windows Authentication and SQL Server Authentication)”, its work out…

Hi,
why should I change the authentication??
Actually, I am trying to run a query thru linked server. I linked the server by windows login and my target SQL server is running under windows authentication only and I am getting the same error.

Please clear my doubt why should we use only mixed mode? Why it is not working with windows authentication, even I am using a domain account to connect?

There should not be any need to change the authentication in theory. However, this error is quite generic and this way it can be fixed first and then you can work backwards towards your original configuration and see what is the issue.

Dear Sir,
I would to discuss a problem with you. I used sql SERVER 2000. in this server when I work on server itself than it work properly and i connect a client to it than client not working. “error server not found”

I am using linked server and getting same error when trying to access linked server. I have Server1 with linked Server2. I am connected to Server1 using management studio remotely and trying to access linked server Server2. If I connect locally to Server1 and try to access linked Server2 this works. Any help will be appreciated.

I received this error when connecting to the SQL Server remotely via my application. After researching, I found that you had to both enable trusted authentication on my SQL Server machine and grant the User Right “Enable computer and user accounts to be trusted for delegation” (Group Policy…under Local Policies\User Rights Assignment) to the Windows account you are using. I just granted it for the Administrators group.

For the SQL Server machine, I set the property in Active Directory (check the box labeled “Trust computer for delegation” in the computer’s properties).

I have clustered SQL 2005 Enterprise 64 bit and SQL 2005 SP2 on a Windows 2003 server and I can log in fine with domain credentials, but not with ‘sa’. SQL is installed in mixed auth mode and has all the default protocols, including Named Pipes and TCP/IP. I get error 18452 and I have read many, but not found any articles or discussions on the Internet or from Microsoft that solves the problem. My head hurts.

Are there any problem if the server is on different network than client?
In my scenario my client is working into a network without Windows servers (so any AD is running or required for validation) but the SQL server (that is an SQL server 2000 SP3 running on a Windows 2003 server R2) is into another network WITH AD.
The connection is transparent through router. All other network services runs fine between both networks.
I’ve followed all steps but I’m still having the same problem.
2 clients running same OS with same ODBC have different behaviors. The client connected on same server’s network runs fine but the other one raises this error.

Please check the Server name is in Sink with server name of SQL Server. The host name should be the same as
Select @@Servername. If they are not the same, then use SP_Dropserver ‘oldServername’ and then Supply SP_addserver ‘Servername’,’Local’. then restart the server (OS) to take effect.

sql express05 does allow me change password when
iam logged with windows authentification,on next restart doesnt allow me to login with sa(by the way it shows some long password with asterixs).meaning it is not changing the password and
reports below error.this is LOG
TITLE: Connect to Server
——————————
Cannot connect to BLEEDING-DESKTO\SQLEXPRESS.
——————————
ADDITIONAL INFORMATION:
Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
—————–
any way to change to mixed mode authentification?

I have an ASP.NET 2.0 Application on machine A. I am using forms authentication with Active Directory. My SQL 2K database is on machine B. On machine A, I can access my application, with no problem. When i try to access the application over the network from different machines, i get this error.

Server Error in ‘/EXACT-WHRM’ Application.
——————————————————————————–
Login failed for user ‘sa’. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

I have the same problem, but in my case, changing to Mixed Mode authentication did not fix the problem.

I can login under Windows Authentication without problem, but any attempt to use SQL Server Authentication results in the “not associated” error.

I have also tried using the “sa” account, changing “sa” passwords, and even dropping password policy on the “sa” account… no joy. I have also tried creating new users, with explicit server authentication permission and passwords, but still no luck.

Hi
Thank you for the solution. I tried many ways to change the authentication mode from Windows to Sql Server Authentication mode. But there is no use. But after trying the above, the problem solved immediately. Thank you for the code.

Hi All
i am using SQL Server 2005 SP2 mixed mode of authentication is in use still getting this error
Login failed for user ”. The user is not associated with a trusted SQL Server connection
Error: 18452, Severity: 14, State: 1.

This article is useful but because of some security requirements we have to use windows authentication only. So, i wanted to ask whether there is a possiblity to solve it by using the windows authentication mode.

I have SQL SERVER 2005 (EXPRESS) running on my home desktop machine. However, on this desktop machine there is no Query Analyzer and neither SQL Server Management Studio. It’s my first time to use SQL Server 2005.

On my office laptop, I have SQL Server Management Studio. When I try to connect to the SQL server on my desktop machine, I get this error.

Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

He was able to use the Access program before. I did set up the ODBC connection as I always do on everyone else’s pc.

I also tried to log into the sql server at the prompt with my userid and password as I have admin rights, but I still get the error. I also tried the administrator logon id / pw and still get the error.

Why can’t he use the Access database on Vista Pro? Is there something I need to download? Is there something I need to update from Microsoft?

This article was really helpful .
But I am not able to connect to database from VB.Net using Windows Authentication . I am able to do it using “sa” account . Meanwhile I am also able to get in Sql Management Studio using local as well as sa account .

Mixed Mode Authentication Used

In the below code if i change UserId to sa then my task is accomplished .

SQLServer running on Win2k3. Ran sysprep to generate a new SID in attempt to fix blue-screen problem with domain authentication (another story…).

Anyway, since generating the new SID, Windows authentication to SQL Server is broken. The sa account is disabled. I can log in with a read-only SQL user and that is all I can do. The agent won’t start – fails to authenticate as Local System.

I need to re-initialize SQL security so I can log in via Windows (Administrator). Or enable ‘sa’ somehow. Any ideas?

I have developed ASP.net 2005 website. It has connectin with SQL server 2000 SP4. Whwn I run the site from VS 2005, it runs perfactly. But when I upload it on the IIS server (OS Win2000), the SQL server is not getting connected the error is… Not associated with trusted SQL Server connection.

I have tried will all following options :
1. Changed the authentication mode to SQL Server and Windows mode with audit option None.
2. Included Integrated security=SSPI in connection string
3. Included Trusted_Connection=True in connection string
4. Tried with user name and password in connection string
5. Created a new user and assigned dbo.owner permission to the user and provided user id and password in conncetion string.

I have an Access 2003 DB with an ODBC connection to a SQL 2000 Server. There are about 4 different people with similar security rights who use this and 3 are able to use the db with no problem.

One person has the same error as described on this page

Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

This user claims that he usually does not log into the domain but he claims that in this case he was logged in and it still did not work. I submitted a ticket to IT to take a look at his account and they verified that he has admin rights to his PC.

Do you know why one person would have this error when others with the same security rights do not have problems? Would this indicate a domain issue perhaps?

Scenario: You are using SQL Server 2005/2008 management studio to connect to a SQL Server. In management studio, you are trying to set up a linked server. When trying to access the linked server, you receive the error message in this plog.

Problem: Because you are remotely connected to your SQL Server and trying to access a linked server, you are engaged in a double-hop authentication. IE, your credentials are passed to your SQL Server and your SQL server is trying to pass them to the linked server. This requires Kereberos authentication.

i have installed SQL SErver 2000, when i try connect using ‘SQL server authentication’ mode with ‘SA’ or my username, it is giving me 18452 – user not assoiciated with a trusted connection. i noticed ‘Mixed authentication’ mode set to disabled. how should i fix this issue?

Does anyone know what might cause this error to occur sporadically? I have a service which makes a connection every few minutes to several servers. If the connection fails, I get paged. Once it’s able to connect, I get paged again. This error is occurring randomly on a few of the servers; the service is able to reconnect after a few minutes. So I’ve had many sleepless nights lately!

I am having similar issues where my application would occassionally lose connection to SQL Server. After a few mins, the connection would be restored automatically but it is definitely cauing problems in the production environment.

My SQL is clustered but no failover occurred when the connection was lost.

I am try to use the following script to open some linked tables from an SQL 2005 Server from a client with Access 2003. I can do it manually with no problem, but when running the script I get the following error.

Hi !!!
Just a simple and wonderful solution. I’m migrating an application on VB6, SQLServer2000 and Windows2000 to a new server (Win2003 Server) and I got this message. I didn’t believe the solution will work, but anyway I tried and it worked perfectly.

I am using the MS SQL 2005(64Bit) on Windows 2003 64Bit. SQL Server is running on cluster. So time when I restart one of the domain controler , getting the following error. SQL Server has setup on mix mode and has given the correct DNS setting

I have a problem with sql server 2005. I have created a web setup project using custom action to create database at installation time. Every thing is ok. It creates prerequisites (.net farmework 2.0, sqlserver 2005 express, etc.) and database successfully during installation. I have used the connection string

I have my Server set to SQL Server and Windows Authentication Mode, but I get “Login filed for user ”.
My app settings are as follows:

In my web.config settings, I have the authentication mode defined within as follows:

I have been wrestling with this problem for over a week and still don’t have a solution. My problem seems similar to the others, but I already had the authentication mode set to both Windows and SQL Server.
Can you tell me what I need to do to correct my error?
Thank you very much,
Art
P.S. The error message with stack is as follows:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

I have many servers, and one of them is in different network
We just do this

“Frank Stevens

This is for WINDOWS AUTHENTICATION:

I received this error when connecting to the SQL Server remotely via my application. After researching, I found that you had to both enable trusted authentication on my SQL Server machine and grant the User Right “Enable computer and user accounts to be trusted for delegation” (Group Policy…under Local Policies\User Rights Assignment) to the Windows account you are using. I just granted it for the Administrators group.

For the SQL Server machine, I set the property in Active Directory (check the box labeled “Trust computer for delegation” in the computer’s properties).

I had the same problem.
SQL 2000 on a server in windows authentication mode.
The Active Directory role set in the SQL security tab.
My colleagues could log on to the server using the enterprice manager. I couldn’t, getting the same error “Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection”. Setting the server in mixed mode is no option because of business policy.

The solution:
With the windows explorer I connected to a shared directory on the server.
Problem solved.

when we are running the insert statement with the linked server, it is working fine.
If i create the job , it is failing with the folowing error
Executed as user: SYNTEL\user1. Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452). The step failed.

I am having the error
“Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection.”.

I have Windows XP Service Pack 2,
I have MS SQL 2005 Express,
I can have either ‘Windows Authentication’ or ‘SQL server Authentication’ in SQL.
I have MS SQL Server Compact 3.5 Design, ENU,
I have MS SQL Server Native Client

This advice is great unless you are ALREADY in mixed mode on SQL 2005 and STILL receiving the same error. The services HAVE been restarted and STILL receiving the same error. I am using Rightfax. It is trying to alert the database that the fax was successful. My System DSN (ODBC connection) verifies fine using SQL user and password, but when the Rightfax program goes to run the process, It gives me the dreaded User not associated error and the user is ”. This is maddening! I have spent two full days so far, but all I find is change the mode to mixed mode, I am already there!

I have already change the mode to “SQL Server and Windows Authentication mode” but I am still getting the error of “The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452).

I too have the same problem. So long i am getting errors for SSPI handshake and login failed for the user etc. This blog was very helpful.. Thanks a lot…

For me, the solution was the host had two DNS names. So, I had changed the DNS to the same which is recognized under Network (My Computer –> Properties –> Network Identification) in client network utility. (Run –> cliconfg). Restart the SQL Server. It won’t show any more errors in Agent log & event viewer … It will allow windows authentication also…

Mine turned out to be a change to a registry key for Rightfax. I had to include a user and password in the registry key. Apparently Rightfax only looks at the ODBC driver for the server name, why bother at all?!

Hello, I’m faced with the following problem. We are one of many applications that are being deployed to hundreds of sites. The help application is developed by one group and we have to use their help. Our application is using asp.net 2005 and SQL Server 2005. When we call the help application then try to navigate in our application we sometimes get the error below. It is random and it only effects users who are not administrators on the server. Intially our application was opening a new window for the help, after the user closed the window it would cause this error. I’ve embedded the help into our application, but that still didn’t work.

Our connection string in the web.config is:

I changed the connection string to include some of the following, but it didn’t make a difference.

Please provide us the information for following questions:
How are you trying to connect to server I mean from SSMS or using linkedserver or from some application?
Where from you are trying to login, server machine itself or from remote computer?
Is this error coming for some specific login or for all logins?
When this error started occurring?

May be this will be the most weird case:
my co-worker can use windows login to connect to all servers except this one (say, named OperationServer) from his own computer.
It will gives the 18452 error.
However, login on other’s workstation using his login won’t throw error. Meaning the login and security are good.

All other co-workers don’t have problem with this OperationServer with windows authentication.

Every SQL Server instance has its own security and login on one server does not gaurantee to login on all servers. Please verify that on SQL Server, an enabled login having proper rights exists for user.
Also verify that defult database for the user is available on server.

I had the same problem and tried almost all the tips in this thread and others around the Internet. However, none of them were useful for me. In my development environment I had been using a connection string which used a DNS name (Host A record, as a matter of fact) pointing to the IP of the server where SQL 2005 is installed.

After trying several things, I finally went to the web.config and changed the connection string to the server name. After this, I got another message: Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. [CLIENT: ]

I had seen another article saying to give this user access to the data base under User Mappings and after that all worked like a charm.

The Execute method on the task returned error code 0x80131904
(A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server
is configured to allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made
because the target machine actively refused it.)). The Execute method must succeed, and indicate the result
using an “out” parameter. End Error Warning: 2010-02-15 10:41:09.83 Code: 0x80019002
Source: OnPostExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.
The Execution method succeeded, but the number of errors raised (2) reached … The package execution fa…
The step failed.

From my experience with this issue, the real solution is to ensure that the Windows account that the client is using to connect to the SQL server has been assigned “Access this computer from the network” rights in the Computer Config\Windows Settings\Security Settings\Local Policies\User Rights Assignment part of the group policy that applies to the computers in the domain where Windows authentication is being attempted.

Moving to Mixed Mode is a work around. As best as I can tell, when you go to mixed mode, the client uses the Network Service account to connect to the SQL sever, and passes through the SQL credentials. However when you use Windows authentication, it uses the context of the logged in user to make the initial contact with the SQL server (before attempting to log in to the SQL database itself) and if the Windows account does not have the right to even access the SQL server computer on the network, then the request is rejected. Hence the username (null) in the response.

Some of this is just guessing, but what I know for sure is that I was getting the (null) error using Windows only authentication, and setting up a GPO to allow the user account from the client to access the SQL sever computer from the network fixed it.

Hi All,
If you do all ways that mentioned above and after than your problem does not solve, You look at your sql server Configuration Tools, and notice to your sql server services such as SQL Server Browser is running.
if it’s not running or you can not runnig it, you can use this help:

Can anyone explain the internal procedure how the Client connects to the SQL Server using Windows Authentication?

I have two SQL 2005 servers A and B in two different windows 2003 servers . I have changed the IP of A server to point to B in the DNS and Flushed the resolver cache. Then connecting to the SQL server A is pointing B if the client is on another machine. Bu tif I connect to the SQL Server A from the B machine it is giving the following error:

“Login failed for the user . The user is not associated with a trusted SQL Server Connection. (Microsoft SQL Server Error: 18452)

this string i running in my three computer to connect Remote Connection to Server
but One Computer is showing me below Error

TITLE: Connect to Server
——————————

Cannot connect to MAINSERVER\SQLEXPRESS.

——————————
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 – No such host is known.) (Microsoft SQL Server, Error: 11001)

Initial problem resolved but now getting error “a connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)”

I am running SQL 2000 Standard edition (SP3) and am getting the error though the instance is in Mixed authentication mode.

I am trying to access the SQL server from the domain A while the SQL server is in Domain B. But I know that both these domains trust each other and we have other servers in domain B which are accessible from the server in domain A.

I had the problem that I could log in as sa but when I tried my windows account I got that error about not being associated with a trusted connection even though my windows acount had all the necessary permissions.

Turned out that when we changed our domain server the database server had been left using the wrong DNS server IP Address and so all we had to do to fix this was change the database server’s network connection to use the correct DNS server IP address for the new domain.

i’ve installed sql server 2008 R2 on windows 2003 server successfully. Later i’ve created a sql login (eg: laddu) and tried to access the sql server with the sql login created. But i’m getting an error stating that “Login failed to connect to sql server”. i’ve tried many times, but unable to success. please help me out with this problem.

Thanks for this post. I have a strange problem, I’m using a VB6 application to connect to a SQL Server 2005 database. I set up a DSN connection which I use in the code. It connects with no problem when the SQL Server is on the same computer. But when the database in on a remote server, it gives me the error “Login failed for user ”. The user is not associated with a trusted SQL Server connection.

The SQL Server has Mixed Mode enabled, and when I set up the DSN it connects ok when I put in the correct sa login and password. However, when the VB6 application tries to connect using this same DSN, it fails with that error. What could be the problem?

Hi,
We are about to DR setup using Window Server 2003 and MSSQL 2005 SP3.
Our PRD and DR server domains are differ but they do have a trusted relationship between each other.
DB restoration is completed on DR server but I am stuck when I am applying Log shipping method to make PRD and DR server in sync.
At the point when I have to select DR as a secondary server, I am not getting my DR server name only PRD server name is there.
While if I tried the same thing on DR server (just for check) I got PRD server SID as a secondary server.

hello Sir,
i read all the problem and reply above but my problem very strange and unique .
i install sql server 2008 operation system window2003 and sql database connected to attendance software.

after installation sql server2008 running very well without any problem and login sucessfuly. but after 15 to 20 days sql server not login .

so i uninstall and again new install sql server 2008 many time but this problem comes again reaptly after 15 to 20 days sql server not login .
please help me to solved
Thank you.
narendra

Error Details ————->

TITLE: Connect to Server
——————————

Cannot connect to SCIL-SINGACH.

——————————
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

OK, this is odd. new replacement machine everything installed fine, local administrator account can connect fine. PC user account can’t connect and won’t configure ODBC. I can’t see any issues with the account name etc, It’s a replacement machine so the account is an old one. workgroup not domain.

My problem may not be strictly related to SQL Server, but here is my problem. I connect to SQL Server in domain using my domain account. The domain account password expires every three months. I have changed the password several times in the past without a hitch. This time around, my account gets locked out periodically. I checked all the jobs in all SQL Servers in the domain to see if any of them is using my account. I found couple of jobs running ssis packages with credentials using my account. I updated the password on them and jobs run fine. However, I keep getting locked out periodically.

I check the error longs and I find error message:
Error:18456, Severity:14 State:11

State 11 refers to “valid login but server access failure”.

I tried changing back the password to previous password (which was working fine) but didn’t help.

I also checked if any services are running under my account, didn’t find any.

I have one problem. I have two SQL Server, e.g. ‘Server1′ and ‘Server2′. Server1 is connected with windows authentication and Server2 is connected with SQL Authentication.

I am trying to create LinkedServer of Server1 in Server 2. but i am unable to do it because i don’t know how to create linked server of Windows authenticated Server.

I enabled and set password of sa login of Server1. I again tried to create linked server of Server1 in Server2 by giving Server1 ‘sa’ login credentials as remote login and password. but still i am getting connection failed error in linked server. When i tried to create linked server of Server 2 in Server1 following the same steps, it created successfully. I was able to run SQL command from Server2 to Server1 using Linked Server.

i’ve been looking around for a solution to my issue but to no avail ! Here is the scenario:

I am using Visual C# 2005 Express Edition and SQL 2005 Express Edition.
I wrote a little C# windows application that is using a sql database. I tested it and published it locally and my application works locally, on, in my PC.
Now, what i want is to be able to take this application (with all its related files to make it work after publishing) and put it (literally) in a another PC running Server 2003 so that people in my office can use this application from their PC through the LAN.

The steps (that come from my readings in various online forums) i have done for that are:

– i created a folder on a central PC (the one running Server 2003) and shared it so that users can access the .exe file and the related
.mdf file along with the other linked files.
– using SQL Server Management Studio Express (SSMSE) 2005, i changed my SQL instance (on that central PC) to allow remote
connections and to allow for both SQL server and Windows authentication mode
– i created a user account, on the central PC, through SSMSE -> Security -> Logins
– i created a user: SQLServer2005SQLBrowserUser$SERVERNAME, through MY Computer -> Manage -> Local User Groups and Groups option
– this is the connection string (took from the .config file):

I guess that this connection string has to be changed (among other things) for my application to work on a LAN,
would you mind helping me and show me the EXACT steps to carry out in order for my app to work on a LAN, PLEASE ?

I tried every thing..
1)changed from windows authenticate mode to mixed mode
2)enabme tcp/ip port
3)set default port number 1433
4)created database and gave access to that database for perticular login and use

hi Pinal i am very new user to sql-server, I’am using sqlserver SQL 2005 Express Edition on my computer with windows authenticationm mode. i have created a user named “testUser” now i want to login with the user which i hve created bu when i try to login with “testUser” server gives an error.
SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

hi Pinal, im very new to sqlserver. I am using 2005 Express Edition with windows authentication mode. here i have created a new user named “testUser”. but when i’m trying to login with “testUser” server gives Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection. how can i login with “testUser”?

I am getting this error on 2008 R2 when I am calling a SSRS report from another report. The report with the error has the same shared datasource as all the other reports and the dataset in the report is calling a stored procedure. This stored procedure is basically executing 14 different stored procedures in a sequential manner. Please note that all the stored procedures reside in the same database (no linked server or external server reference in the code). The SSRS reports are hosted on a different server from the database server. All reports run great except for this one report where I get the error
“An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset ‘NewRefreshMacroDataset’. (rsErrorExecutingCommand)
Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.”

Any help is greatly appreciated. I have tried all possible solutions listed in this blog but to no avail. Thanks in advance!!!

i have local server which is running properly, but i fix static ip to that particular server machine, from that day it gives me error(login failed ‘sa’ user) after 2-3 days contentiously .pls help me.
Regards Vijay….

Hello I am so delighted I found your blog page, I really found you by error, while I was researching on Yahoo for something else, Anyways I am here now and would just like to say cheers for a tremendous post and a all round interesting blog (I also love the theme/design), I don’t have time to look over it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read more, Please do keep up the awesome jo.

While it’s usually a better picture than 720p, the “i” in 1080i suggests that it is an “interlaced” resolution which is not as smooth or clear as a 1080p “progressive-scan” picture. My personal opinion on this TV is that for the price, you can not beat $500 for a 32″ Hi-Definition TV. Sony will not give a clear alternative for accessing the 120Hz processing. You can either bring it to the manufacturer’s service center (which may entail some costs, if it’s no longer covered by warranty), or you could troubleshoot it yourself.

Community Initiatives

About Pinal Dave

Pinal Dave is a Pluralsight Developer Evangelist. He has authored 11 SQL Server database books, 17 Pluralsight courses and have written over 3200 articles on the database technology on his blog at a http://blog.sqlauthority.com. Along with 11+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). His past work experiences include Technology Evangelist at Microsoft and Sr. Consultant at SolidQ. Follow @pinaldave
Send Author Pinal Dave
an email at pinal@sqlauthority.com

Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.