Logging query errors: following

Showing posts with label following. Show all posts

Friday, March 30, 2012

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Hi ,
I am using IIS 6.0 and have an ASP.NET where get the following error when
trying to connect from a .NET assembly.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
So I read some info from other forums and understand that I must add
the 'NT AUTHORITY\NETWORK SERVICE' as a user on my SQL Server 2005 database.
My problem is when I try to add this user by browsing for "Objects" in
Windows Server 2003, I don see this object. What am I missing?
Any ideas?By the way, my connection string is
"data source=NDS2214;Initial Catalog=UATP;Integrated Security=true"
"Opa" wrote:

> Hi ,
> I am using IIS 6.0 and have an ASP.NET where get the following error when
> trying to connect from a .NET assembly.
> Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
> So I read some info from other forums and understand that I must add
> the 'NT AUTHORITY\NETWORK SERVICE' as a user on my SQL Server 2005 databas
e.
> My problem is when I try to add this user by browsing for "Objects" in
> Windows Server 2003, I don see this object. What am I missing?
> Any ideas?

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>

HI all ,
i am getting the following error message. <Message>Login failed for user
'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
my database is on server1 and report database on server2. I am getting this
error when rendering. I am using default credentials
Please Help me.
<detail>
<ErrorCode
xmlns="http://www.microsoft.com/sql/reportingservices">rsProc
essingAborted</ErrorCode>
<HttpStatus
xmlns="http://www.microsoft.com/sql/reportingservices">400</
HttpStatus>
<Message xmlns="http://www.microsoft.com/sql/reportingservices">An
error
has occurred during report processing.</Message>
<HelpLink
xmlns="http://www.microsoft.com/sql/reportingservices">http://
go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
elpLink>
<ProductName
xmlns="http://www.microsoft.com/sql/reportingservices">Micr
osoft SQL Server Reporting Services</ProductName>
<ProductVersion
xmlns="http://www.microsoft.com/sql/reportingservices">8
.00.743.00</ProductVersion>
<ProductLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</ProductLocaleId>
<OperatingSystem
xmlns="http://www.microsoft.com/sql/reportingservices">
OsIndependent</OperatingSystem>
<CountryLocaleId
xmlns="http://www.microsoft.com/sql/reportingservices">
1033</CountryLocaleId>
<MoreInformation
xmlns="http://www.microsoft.com/sql/reportingservices">
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsProcessingAborted"
msrs:HelpLink="http://go
.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" xml
ns:msrs="http://www.microsoft.com/sql/reportingservices">An error has
occurred d
uring report processing.</Message>
<MoreInformation>
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsErrorOpeningConnection"
msrs:HelpLink="ht
tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
er=8.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot
crea
te a connection to data source 'HMIS_Interface'.</Message>
<MoreInformation>
<Source>.Net SqlClient Data Provider</Source>
<Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.</Me
ssage>
</MoreInformation>
</MoreInformation>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>It looks like you are using Anoymous Authentication on your IIS Virtual
Directory. You can change the authentication to Basic or NTLM to pass in
user credentials.
--
| Thread-Topic: Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.</Message>
| thread-index: AcS8DqlvxtkWDhbwR8+PqdeSKelavg==| X-WBNR-Posting-Host: 202.56.199.242
| From: "=?Utf-8?B?bW9oYW4=?=" <mohan@.discussions.microsoft.com>
| Subject: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
| Date: Wed, 27 Oct 2004 03:21:03 -0700
| Lines: 134
| Message-ID: <CBEB19F8-B211-468C-B282-BD1ECC6087E9@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33264
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| HI all ,
| i am getting the following error message. <Message>Login failed for user
| 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
|
| my database is on server1 and report database on server2. I am getting
this
| error when rendering. I am using default credentials
| Please Help me.
|
|
|
| <detail>
| <ErrorCode
| xmlns="rsProc">http://www.microsoft.com/sql/reportingservices">rsProc
| essingAborted</ErrorCode>
| <HttpStatus
| xmlns="400</">http://www.microsoft.com/sql/reportingservices">400</
| HttpStatus>
| <Message
xmlns="An">http://www.microsoft.com/sql/reportingservices">An
| error
| has occurred during report processing.</Message>
| <HelpLink
| xmlns="http://">http://www.microsoft.com/sql/reportingservices">http://
|
go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
|
gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
|
amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
| elpLink>
| <ProductName
| xmlns="Micr">http://www.microsoft.com/sql/reportingservices">Micr
| osoft SQL Server Reporting Services</ProductName>
| <ProductVersion
| xmlns="8">http://www.microsoft.com/sql/reportingservices">8
| .00.743.00</ProductVersion>
| <ProductLocaleId
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| 1033</ProductLocaleId>
| <OperatingSystem
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| OsIndependent</OperatingSystem>
| <CountryLocaleId
| xmlns="">http://www.microsoft.com/sql/reportingservices">
| 1033</CountryLocaleId>
| <MoreInformation
| xmlns="">http://www.microsoft.com/sql/reportingservices">
|
| <Source>Microsoft.ReportingServices.Processing</Source>
| <Message msrs:ErrorCode="rsProcessingAborted"
| msrs:HelpLink="http://go
|
microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
|
ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
| p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
xml
| ns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error has
| occurred d
| uring report processing.</Message>
| <MoreInformation>
| <Source>Microsoft.ReportingServices.Processing</Source>
| <Message msrs:ErrorCode="rsErrorOpeningConnection"
| msrs:HelpLink="ht
|
tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
|
s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
| onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
| er=8.00"
xmlns:msrs="Cannot">http://www.microsoft.com/sql/reportingservices">Cannot
| crea
| te a connection to data source 'HMIS_Interface'.</Message>
| <MoreInformation>
| <Source>.Net SqlClient Data Provider</Source>
| <Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
| LOGON'.</Me
| ssage>
| </MoreInformation>
| </MoreInformation>
| </MoreInformation>
| <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
/>
| </detail>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||I am having the same problem as mohan.
I do not have Anonymous Authentication on the IIS Virtual Directory enabled.
Both the Reports and ReportServer folders are using windows integrated
security.
I have done a fresh install of Windows 2000 Server along with SQL Server
2000 Standard Editon and SQL Reporting Services Standard Edition. I have
also updated these to the relevant service packs.
From what I can gather the report server has no problems recognising
different domain users (with my folders enabled - a new folder is created for
the user that just navigated to the report server). Where it is having the
problem is then sending on those credentials to a SQL database on a different
server always get the 'NT AUTHORITY\ANONYMOUS LOGON' error message.
""Brad Syputa - MS"" wrote:
> It looks like you are using Anoymous Authentication on your IIS Virtual
> Directory. You can change the authentication to Basic or NTLM to pass in
> user credentials.
> --
> | Thread-Topic: Login failed for user 'NT AUTHORITY\ANONYMOUS
> LOGON'.</Message>
> | thread-index: AcS8DqlvxtkWDhbwR8+PqdeSKelavg==> | X-WBNR-Posting-Host: 202.56.199.242
> | From: "=?Utf-8?B?bW9oYW4=?=" <mohan@.discussions.microsoft.com>
> | Subject: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
> | Date: Wed, 27 Oct 2004 03:21:03 -0700
> | Lines: 134
> | Message-ID: <CBEB19F8-B211-468C-B282-BD1ECC6087E9@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33264
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | HI all ,
> | i am getting the following error message. <Message>Login failed for user
> | 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>
> |
> | my database is on server1 and report database on server2. I am getting
> this
> | error when rendering. I am using default credentials
> | Please Help me.
> |
> |
> |
> | <detail>
> | <ErrorCode
> | xmlns="rsProc">http://www.microsoft.com/sql/reportingservices">rsProc
> | essingAborted</ErrorCode>
> | <HttpStatus
> | xmlns="400</">http://www.microsoft.com/sql/reportingservices">400</
> | HttpStatus>
> | <Message
> xmlns="An">http://www.microsoft.com/sql/reportingservices">An
> | error
> | has occurred during report processing.</Message>
> | <HelpLink
> | xmlns="http://">http://www.microsoft.com/sql/reportingservices">http://
> |
> go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Dia
> |
> gnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&
> |
> amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</H
> | elpLink>
> | <ProductName
> | xmlns="Micr">http://www.microsoft.com/sql/reportingservices">Micr
> | osoft SQL Server Reporting Services</ProductName>
> | <ProductVersion
> | xmlns="8">http://www.microsoft.com/sql/reportingservices">8
> | .00.743.00</ProductVersion>
> | <ProductLocaleId
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | 1033</ProductLocaleId>
> | <OperatingSystem
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | OsIndependent</OperatingSystem>
> | <CountryLocaleId
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> | 1033</CountryLocaleId>
> | <MoreInformation
> | xmlns="">http://www.microsoft.com/sql/reportingservices">
> |
> | <Source>Microsoft.ReportingServices.Processing</Source>
> | <Message msrs:ErrorCode="rsProcessingAborted"
> | msrs:HelpLink="http://go
> |
> .microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagn
> |
> ostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsProcessingAborted&am
> | p;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> xml
> | ns:msrs="An">http://www.microsoft.com/sql/reportingservices">An error has
> | occurred d
> | uring report processing.</Message>
> | <MoreInformation>
> | <Source>Microsoft.ReportingServices.Processing</Source>
> | <Message msrs:ErrorCode="rsErrorOpeningConnection"
> | msrs:HelpLink="ht
> |
> tp://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingService
> |
> s.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsErrorOpeningC
> | onnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdV
> | er=8.00"
> xmlns:msrs="Cannot">http://www.microsoft.com/sql/reportingservices">Cannot
> | crea
> | te a connection to data source 'HMIS_Interface'.</Message>
> | <MoreInformation>
> | <Source>.Net SqlClient Data Provider</Source>
> | <Message>Login failed for user 'NT AUTHORITY\ANONYMOUS
> | LOGON'.</Me
> | ssage>
> | </MoreInformation>
> | </MoreInformation>
> | </MoreInformation>
> | <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
> />
> | </detail>
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
>

Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

get the following error when a user tries to logon from work station.
The website is hosted on IIS on the same server as sql server 2005
website is asp.net 2.0

SqlException (0x80131904): Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734883
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehaviorrunBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)+1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionString connectionOptions, Object providerInfo,String newPassword, SqlConnection owningObject, BooleanredirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(Stringusername, Boolean updateLastLoginActivityDate, Int32& status,String& password, Int32& passwordFormat, String&passwordSalt, Int32& failedPasswordAttemptCount, Int32&failedPasswordAnswerAttemptCount, Boolean& isApproved,DateTime& lastLoginDate, DateTime& lastActivityDate) +1121
System.Web.Security.SqlMembershipProvider.CheckPassword(Stringusername, String password, Boolean updateLastLoginActivityDate, BooleanfailIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42
System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160
System.Web.UI.WebControls.Login.AttemptLogin() +105
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

Hi,

i think you have allowed ANONYMOUS Access to your website in the IIS Admin. The ASP.NET worker process using the ANONYMOUS user account and the process-user will connect to your SQL Database. Is that realy what you want? I think you have a special sql user account, or? So you must impersonate your asp.net worker process. See this MSDN Article for more information about impersonation:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsent7/html/vxconImpersonation.asp

Regards
Marc André

|||

thanks for the reply, I want to be able to use the NetworkService account.

"In Internet Information Services (IIS) 6, the default identity is the NetworkService account."

How do I go about setting this up so the website and sql server 2005 allow the NetworkService user?

|||

ghw123:
thanks for the reply, I want to be able to use the NetworkService account.
"In Internet Information Services (IIS) 6, the default identity is the NetworkService account."
How do I go about setting this up so the website and sql server 2005 allow the NetworkService user?

Try the link below for how to use T-SQL to grant the Networkservice account permissions in SQL Server to run Asp.net. Hope this helps.

http://www.thedatafarm.com/blog/PermaLink.aspx?guid=2bd8f8c8-1b16-46ee-91f6-d8d3080e562b

|||

Thanks for the reply I tried the

sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' on the master database

but no luck still get the same error msg.

|||

ghw123:
Thanks for the reply I tried the
sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE' on the master database
but no luck still get the same error msg.

The first thing to do is verify in the Master database that the account was created and if yes then your only option is to use basic autthentication which could leave your application passwords in plain text. Hope this helps.

|||

Add the aspnet account to the SQL server 2005

Please have a look at thishttp://ambarishganguly.blogspot.com/2007/01/aspnet-account-and-sql-server.html. .

To add a user in SQL Server 2005, you can follow the following steps as outlined in

http://ambarishganguly.blogspot.com/2006/12/sql-server-2005-adding-user.html

In this way, you can easily use the website along with SQL Server 2005

Thanks

Ambarish.

|||

thanks for the replies,

this site was originally on a different server. I moved both the site and the database to the new server.

The problem was in one of the connection strings used on the site.
I had changed all but one of the strings to reflect the change of server name.
Once this string was changed as well then everything worked ok.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I get the following error message when I select a report:

An error has occurred during report processing.

Cannot create a connection to data source 'PSS5'.

My Data source is set to Windows Integrated Security when I get this error message. If I change my data source to be "Credential supplied by the user running the report", the report generates fine. I am running SQL 2005 SP2. I have SQL reporting services installed on different server than my database services. Both servers are W2K3 R2 x64.

My IIS website and virtual directories are set up for Integrated Windows Authentication. My IIS application pool is set up to use an AD service account. I have followed the step/procedures outlined at: http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerbdel.mspx

http://blogs.msdn.com/sql_protocols/archive/2005/10/12/479871.aspx
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

but to no avail. I am sure that I am missing something, but I can't figure out what. I would like to use Integrated Authentication, any ideas?

You are using allow anonymous in IIS. This means that your ReportViewer control is not passing the users credentials to the report server. If you want to use "allow anonymous" you will need to pass valid credentials to the report server. This can be done in your code that calls the Report Viewer control/Report Server.|||

Hi,

see more information about passing credentials programmatically here:

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I don't think that the problem is related to ReportViewer or IIS configuration (Since the credantial information is passed to the datasource and denied). When u select Windows Intedrated Security for report options, the credantials of the user that initiates the Reporting Services at every start up (by default this user is: 'NT AUTHORITY\ANONYMOUS LOGON') are sent to the datasource (And if this user is not authorized in the target database you get the following error).

You can authorize the Reporting Services user in the target database ('NT AUTHORITY\ANONYMOUS LOGON' exists within your SQL Server Machines Users.

You can change the Reporting Services' user to a domain user that both computers can authanticate.

Administrative Tools -> Services. (Find 'SQL Server Reporting Services (MSSQLSERVER)' change user from LOG ON tab.)

I hope this helps.

|||Thanks for the replies, but they didn't seem to help. To clear up a few questions, this report was developed in Visual Studio 2005 and it works fine in it. The report renders ok if I launch in on the server, but not anywhere else. My Reporting Services' user is an AD account that both my servers can authenicate against, and this user does have access to the DB. My Website and virtual directories have "allow anonymous access" unchecked.|||I decided to try one more thing. I went into the web.config file and changed the <identity impersonate="false"/> and that fixed it for me. Thanks for all the replies.|||

Note:

The above fix will force IIS to use the Application pool account to connect to SQL on the remote server.

This is still not the permanent solution that I am looking for, I believe my problem is a kerberos issue at this point. Any tips/hints/suggestions on troubleshooting this problem would be helpful.

sql

Wednesday, March 28, 2012

Login failed for user ASPNET

Hello,
I am getting following error when I tried to connect to the database.

Login failed for user 'SHALINI\ASPNET'

I am new to this and don't know how to fix it. I am runningSQL Server Desktop engine 2000. I could connect through Server Explorer window, but not through ADO.NET
Here's my connection string:

sConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyStore;Data Source=SHALINI;Workstation ID=SHALINI"

I have IIS and SQL Server running on the same machine.
Please please help me.
Thanks in Advance

If you are just developing on your local machine, be sure the database has the proper permissions.
Also, you may want to try this conn string...

sql = "Initial Catalog=MyStore;Data Source=localhost;Integrated Security=SSPI;"
But once the database is moved to a production server, you would want to change the string to something like...

sql = "Server=isp.com;Database=MyStore;UID=****;PWD=****;"
But this sounds like a permission problem, one in sql server db and in the folder.
You may also want to check the permissions on you folder where you are developing the app, the one in wwwroot.

Hope this helps,
Zath

sql

Login failed for user ''. The user is not associated with a trusted SQL Server connection. &qu

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

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.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

Have you added the ASP.Net service account as a user in SQL Server? The error message is saying that the current user that is trying to connect has not been registered as a login in SQL Server.|||Hi there,

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

The username with which the ASP.NET web application runs is different to the username you used to log into the computer with so chances are that the user is not defined in SQL Server's list of logins and so you get problems when using Windows Authentication.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

In a production system you would probably do more to secure that password (i.e. don't place it plain-text in the code) like putting it in the registry or some other methods but as an example I think it will do.

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

With ASP.Net generally the asp.net system by default runs under the Network Service account, to use it in the database you will need to make sure that the Network Service account has permissions for the database that you are using.

Another option is to make the asp.net application that you are working use a different account, this will help to secure your application. One way to do this is to reconfigure the application pool for the asp.net application that you have and make it run under the new account.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you are lucky to have Microsoft SQL server Management Studio installed, then can browse to the SQL server Instance and right-click to bring up the Server Property. Server Property -> Security -> check "SQL Server and Windows Authentication Mode" option under "Server Authentication" section, and then restart the SQLExpress.

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

Hope that will help.

Derek

|||

Hey Glen, I have the same problem only I can't get sqlexpress to allow me to logon in SQL Server Auth mode. I can't even logon using my server (in my house). It will let me log on in Windows Authentication but not SQL Server Authentication? I have nothing on this machine and I reininstalled SQL Express twice. I am the sole admin .

All I want to do is create a blank database (which I did) and log onto it. I watched video 7 on microsoft and opened my fireall udp and added me as doadmin. I added sqlbrowser.exe,sqlserver.exe and udp port 1434 for sql via web in windows firewall. I also opened port 1434 on my hardlinksys router which only has port 80 and 1434 udp opened. (Public Webserver not hacked yet). Eventually, I added all permissions for my self (admin). I right clicked on my new database ("WebWizforums") IE not real database name. I added permissions under my user name and granted all permissions.It's only my user name in permissions noone else. I'll tighten ship perms after I see that she works...

Forum software is what I want to try http://www.webwizguide.com/webwizforums/kb/sql_server_install.asp seems real easy but I can't figure it out? MS Access I knew inside and out but now ...no more MSDE or MSJet on Longhorn OS.

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

Hope that will help.

Derek

|||

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

Hope that will help.

Derek

|||

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

Hope that will help.

Derek

|||

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Hi all,

Can someone explain it to me why I am getting the following error when I try to connect SQL server express with .NET 2.0?

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Here is my code and i am using windows authentication:

<%@. Import Namespace="System.Data" %>
<%@. Import Namespace="System.Data.SqlClient" %>

Dim connAkaki As SqlConnection
Dim cmdSelectAuthers As SqlCommand
Dim dtrAuthers As SqlDataReader

connAkaki = New SqlConnection("Server=.\SQLEXPRESS;database=akaki")

connAkaki.Open()

cmdSelectAuthers = New SqlCommand("select Firstname from UserTableTest", connAkaki)
dtrAuthers= cmdSelectAuthers.ExecuteReader()

While dtrAuthers.Read()
Response.Write("<li>")
Response.Write(dtrAuthers("Firstname"))

End While

dtrAuthers.Close()
connAkaki.Close()

I was going to reply to your earlier post on the same/similar topic but since this one's newer I will post here.

A way around this is to use SQL Server authentication when trying to access your SQL Server. If you do this, your connection string will be:

connAkai = new System.Data.SqlClient.SqlConnection("Server=.\\NATHAN;database=Northwind; User ID=<SQL Server Login>; Password=<Password For Login>");

Hope that helps a bit, but sorry if it doesn't

|||

The SQL Server system by default is set to use only Windows Accounts and not SQL Server authentication, you can turn it on but I would leave it as is and use the windows accounts.

|||

Hi All!

How can add the ASP.Net service account as a user in SQL Server 2005?

|||

Huh? An MS Knowledge base article (http://support.microsoft.com/kb/555332) says just the opposite:

RESOLUTION

Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)"
to "Mixed Mode (Windows Authentication and SQL Server Authentication)".

|||

Steps to change SQLExpress to "SQL Server and Windows Authentication Mode"

If you don't have Microsoft SQL server Management Studio installed, the if you are running on XP Professional, following SQL statements will do the same:

You have to first login to SQLExpress using osql utility.

USE [master]

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2

Hope that will help.

Derek

|||

Can anyone explain this simple task "Clearly?" Pretend I have no idea what I'm doing .... Thanks Gates for forcing my higher "edgeamycashun."

SQL Express for dummies!

Learning SQL is like filing tax returns...put it off to the last minute!

Mike C

|||

Ok, I triple checked everything then I rebooted....now it works? I guess start and stop will be learned as stupid sql tricks.

ok, I added the database tables with no problems however, I get this message when I log into the (ADMIN.asp) page

Server Error in Forum Application
An error has occurred while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

I searched for Common.asp and right clicked it. It has READ at min. So next is connection String?

I got yarn? but no connection.

Getting closer Watson.

Mike

Monday, March 26, 2012

Login failed for user '(null)'.

I have recently been getting the following error message:
Login failed for user '(null)'. Reason: Not associated
with a trusted SQL Server connection.
Is someone trying to hack into my server, or is there
another explanation for this?
Thanks,
VictorTry this :-
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q269587
--
HTH
Ryan Waight, MCDBA, MCSE
"Victor Davis" <anonymous@.discussions.microsoft.com> wrote in message
news:0b5801c3a3a0$cbb7efb0$a501280a@.phx.gbl...
> I have recently been getting the following error message:
> Login failed for user '(null)'. Reason: Not associated
> with a trusted SQL Server connection.
> Is someone trying to hack into my server, or is there
> another explanation for this?
> Thanks,
> Victor|||you get this error when trying to create a connection
(login) to the server using a trusted connection/Windows
NT authentication and you don't have access through your
windows domain account, hence the 'null' ie the user does
not exist as far as SQL Server is concerned.
>--Original Message--
>I have recently been getting the following error message:
>Login failed for user '(null)'. Reason: Not associated
>with a trusted SQL Server connection.
>Is someone trying to hack into my server, or is there
>another explanation for this?
>Thanks,
>Victor
>.
>

Friday, March 23, 2012

Login failed for user (null) , any ideas

I try to connect to the pubs database but get the following error:
Server Error in '/myWebApp' Application.
----
--
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se
rver connection.
Im logged in as myself, and also I've created a SQLUSER login to access the
data, and assiged SQLUSER to userid but still no luck
any ideas?Check on the server that Authentication is so to "SQL Server and Windows"
and not just "Windows"
In Enterprise Manager, right click on the server > Properties > Security
Tab.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:681F9E28-3428-4805-A062-CFD362FE4370@.microsoft.com...

quote:

> I try to connect to the pubs database but get the following error:
> Server Error in '/myWebApp' Application.
> ----

quote:

> Login failed for user '(null)'. Reason: Not associated with a trusted SQL

Server connection.

quote:

> Im logged in as myself, and also I've created a SQLUSER login to access

the data, and assiged SQLUSER to userid but still no luck

quote:

> any ideas?

|||Security is fine. and other ideas?
Lee|||> I try to connect to the pubs database
How? Could you show your code?

Login failed for user '(null)' - Not associated with a trusted connection

We had a DTS package that was working fine until yesterday and since
today it does not work and we get the following error message:
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'(null)'. Reason not associated with a trusted SQL Server connection.
Please clarify how do we fix this problem.
Thanks
KarenHi
Did you change Authentication mode of SQL Server?
<karenmiddleol@.yahoo.com> wrote in message
news:1118220803.108259.111330@.f14g2000cwb.googlegroups.com...
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>|||Hey Karen!
Generally when you see the "login failed for user NULL" it's a kerberos issue.
I know that sounds far fetched, but it's true.
If you get "login failed for user BOB" that's a different story. But the
fact that we are passing a NULL value to SQL instead of a user token means
that Kerberos is failing.
Sometimes this is called a double hop scenario, but you can get that error
even when there is only a single hop.
Follow this article to resolve that error:
How to troubleshoot the "Cannot generate SSPI context" error message
This step-by-step article describes how to troubleshoot the most typical
sources of the "Cannot generate SSPI context" error message. You may receive
this error message under the following conditions: You are connecting to SQL
Server.You are using...
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Basically you will be getting the utility setspn, dropping the old spn and
recreating a new SPN (rebooting might be necessary).
Donna Lambert
"karenmiddleol@.yahoo.com" wrote:
> We had a DTS package that was working fine until yesterday and since
> today it does not work and we get the following error message:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> '(null)'. Reason not associated with a trusted SQL Server connection.
>
> Please clarify how do we fix this problem.
> Thanks
> Karen
>|||You may also want to check that the account logging in hasn't been
locked out because of invalid password entries exceeding the limit set.
Usually this scenario takes place when you are forced to change your
password, but services are running using old passwords and try to login
multiple times. If the account is locked out because of this, you will
see this error message.
Simon Worth
Donna Lambert wrote:
> Hey Karen!
> Generally when you see the "login failed for user NULL" it's a kerberos issue.
> I know that sounds far fetched, but it's true.
> If you get "login failed for user BOB" that's a different story. But the
> fact that we are passing a NULL value to SQL instead of a user token means
> that Kerberos is failing.
> Sometimes this is called a double hop scenario, but you can get that error
> even when there is only a single hop.
> Follow this article to resolve that error:
> How to troubleshoot the "Cannot generate SSPI context" error message
> This step-by-step article describes how to troubleshoot the most typical
> sources of the "Cannot generate SSPI context" error message. You may receive
> this error message under the following conditions: You are connecting to SQL
> Server.You are using...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
> Basically you will be getting the utility setspn, dropping the old spn and
> recreating a new SPN (rebooting might be necessary).
> Donna Lambert
> "karenmiddleol@.yahoo.com" wrote:
>
>>We had a DTS package that was working fine until yesterday and since
>>today it does not work and we get the following error message:
>>
>>[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
>>'(null)'. Reason not associated with a trusted SQL Server connection.
>>
>>Please clarify how do we fix this problem.
>>Thanks
>>Karen
>>

Login failed for user '(null)' - Not associated with a trusted connection

Login failed for user '(null)'

I get the following error in the SQL Logs.

What does this error mean and how can I resolve this?

18452 :
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Se
rver connection.

Thanks

Santhosh

Some client tries to login to SQL Server without passing the WIndows credentials.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

How can I resolve this?

The scenario is... We use a third party backup software. This backup software uses SQL as its database to store session records. Whenever, the tape engine starts it logs on the above message and also during the backups it logs on the above message.

While configuring SQL to be as the backup software's database, there is a option to enter SQL Security. When we enter SA as security, we do not get this error. When we use windows security, we get this error.

Any help is appreciated.

Thanks

Santhosh

|||

Check the KBAs

http://support.microsoft.com/kb/265808

http://support.microsoft.com/kb/555332

And http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx if its a SQL 2005 box.

As suggested you have to check and configure the SQL Server authentication to allow this backup software to connect to database.

|||

Is the backup software running on the same machine as SQL Server? If not, are the machines in the same domain?

Thanks
Laurentiu

sql

Login failed for user '(null)'

I'm getting the following error:
An error has occurred during report processing.
Cannot create a connection to data source 'MyReports-ReportServer-PHX'.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
This is only for data sources that use integrated authenticaiton. This is
on a fresh install of SQL Server 2005 and Reporting Services 2005 using
Visual Studio 2005. Per several articles/disuccsions, I've configured IIS
directory secruity to NOT allow anonymous access and to allow the Integrated
Windows Authentication exactly as I have on my other database server. This
is Windows Server 2003 IIS 6.0 and my other server is Windows 2000, IIS 5.0.
Any help would be GREATLY appreciated. Does this have something to do with
the IIS_WPG group not having correct permissions? The users do have the
correct permissions in my environment.Here's the stack trace as well from the reporting services error log...lots
of errors about the connection pool?
-- End of inner exception stack trace --
w3wp!webserver!1!01/24/2006-15:04:38:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'MyReports-ReportServer-PHX'. -->
System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper.Open()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.OpenConnection(DataSource
dataSourceObj, ReportProcessingContext pc)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ReportRuntimeDataSourceNode.Process()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSourceNode.ProcessConcurrent(Object threadSet)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.AbortHelper.ThrowAbortException(Int32 reportUniqueName)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.CheckAndThrowIfAborted()
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
ProcessingContext& context)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
CreateReportChunk cacheDataCallback, Boolean& dataCached)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Login failed for user '(null)'

Hello world,
I'm getting the following error when trying to register an instance of SQL
in Enterprise Manager (connecting using Windows authentication):
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
EM sits on a developer's PC running XP Professional SP2, and SQL Server 2000
Standard Ed. SP4 resides on a Windows 2000 Server (SP4)
This particular PC was previously able to connecte to this manner prior to
migrating the SQL server from being a member server within an NT4 domain to
being a member server within a Windows 2003 Active Directory Domain.
Any thought's as to why Windows authentication has stopped working would be
most appreciated.Chris
Do you grant access to SQL Server,for login? What is a default database
did you assign to him?
"Chris Ford" <ChrisFord@.discussions.microsoft.com> wrote in message
news:0189E38E-31FC-4E43-A79E-FCABE2726A9A@.microsoft.com...
> Hello world,
> I'm getting the following error when trying to register an instance of SQL
> in Enterprise Manager (connecting using Windows authentication):
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> EM sits on a developer's PC running XP Professional SP2, and SQL Server
> 2000
> Standard Ed. SP4 resides on a Windows 2000 Server (SP4)
> This particular PC was previously able to connecte to this manner prior to
> migrating the SQL server from being a member server within an NT4 domain
> to
> being a member server within a Windows 2003 Active Directory Domain.
> Any thought's as to why Windows authentication has stopped working would
> be
> most appreciated.|||Uri
Thanks for replying so quickly.
Yes for the purposes of testing the connection, I've assigned the developer
(an ordinary domain user) public access to Northwind.
I've also tried making them a member of the Sysadmin Server role to no effec
t.
The same user can connect to another SQL server using Windows Authentication
(SQL 2000 Workgroup Ed SP4 running on Windows 2003 SP1).
I've just tried the same user from a different PC and he can log in from
there too (that one runs Windows 2000 Professional SP4).
"Uri Dimant" wrote:

> Chris
> Do you grant access to SQL Server,for login? What is a default database
> did you assign to him?
>|||Chris
Any errors in event viewer, sql server log file?
"Chris Ford" <ChrisFord@.discussions.microsoft.com> wrote in message
news:5DD31C06-D0ED-4DC1-9768-A072FBBBBA1B@.microsoft.com...
> Uri
> Thanks for replying so quickly.
> Yes for the purposes of testing the connection, I've assigned the
> developer
> (an ordinary domain user) public access to Northwind.
> I've also tried making them a member of the Sysadmin Server role to no
> effect.
> The same user can connect to another SQL server using Windows
> Authentication
> (SQL 2000 Workgroup Ed SP4 running on Windows 2003 SP1).
> I've just tried the same user from a different PC and he can log in from
> there too (that one runs Windows 2000 Professional SP4).
> "Uri Dimant" wrote:
>
>|||Uri
Nothing that appears to by related to the problem on either the Server SQL
and Event logs or the client event logs.
Most of the events in the security logs appear to be Privilege Use types
related to other processes.
"Uri Dimant" wrote:

> Chris
> Any errors in event viewer, sql server log file?
>|||Can anyone offer any other suggestions?|||Further tests have revealed that only clients with Windows XP Professional
are affected. Prior OS versions seem to work fine.|||Several things...
1) Depending on how your active directory is setup, you may need to be in
the domain to authenticate to it if it's only supporting kerberos rather
than just ntlm
2) Domain policies can restrict stuff. If both computers aren't in the
domain than perhaps one is more restrictive than the other.
3) If using kerberos to authenticate, you may need to enable kerberos
delegation on the sql server.
"Chris Ford" <ChrisFord@.discussions.microsoft.com> wrote in message
news:0189E38E-31FC-4E43-A79E-FCABE2726A9A@.microsoft.com...
> Hello world,
> I'm getting the following error when trying to register an instance of SQL
> in Enterprise Manager (connecting using Windows authentication):
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> EM sits on a developer's PC running XP Professional SP2, and SQL Server
> 2000
> Standard Ed. SP4 resides on a Windows 2000 Server (SP4)
> This particular PC was previously able to connecte to this manner prior to
> migrating the SQL server from being a member server within an NT4 domain
> to
> being a member server within a Windows 2003 Active Directory Domain.
> Any thought's as to why Windows authentication has stopped working would
> be
> most appreciated.

Login failed for user (null)

I am creating a Data Web Form using the Data Form Wizard.
After configuring a valid connection to a SQL Server on my network, I receive the following error when trying to run the page: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Any ideas?

Thanks,
MarkYou need to put a proper user id and password in your connection string? Or you haven't filled out the properties properly to do the click and drag method.|||Kay -
Thanks for the response.
I initially configured the connection to use Windows Authentication. Since this didn't work, I entered my username and password using SQL Authentication. Neither seems to work. Now, I'm thinking it has something to do with not having the ASPNET username set up as having access to the SQL database.
Does this make sense?

Mark|||Did you try using IUSR_machinename?|||Jake -
What exactly is IUSR_machinename?
Where would I reference this in my connection string?

Thanks,
Mark|||Are you doing this on an Intranet or are you using a webhost?

IUSR_machinename is an anonymous internet user set up by IIS.|||I am attaching to my localhost for testing purposes.
If I attach to a SQL database on my local machine, I have no problems with the login.
If I try attaching to a database on any other server, I receive the error.

Mark|||Here's my connection string in my web.config


 <appSettings>
<add key="connString" value="server=66.24.255.01;pwd=Jeckel;uid=Jake;database=JakeJeck" />
 </appSettings>

What does your connection string look like?|||Jake -
I don't have an <appSettings> tag within my web.config file.
I added one using your example, but receive an error about an unrecognizable configuration section.
Where else could my connection string be located?

Thanks,
Mark|||Your entire web.config could look something like this:


<?xml version="1.0" encoding="utf-8" ?>
<configuration
 <appSettings>
<add key="connString" value="server=69.56.xxx.xxx;uid=xxx;pwd=xxx;database=JakeJeck"/>
</appSettings
 <system.web>
 <!-- DYNAMIC DEBUG COMPILATION
 Set compilation debug="true" to insert debugging symbols (.pdb information)
 into the compiled page. Because this creates a larger file that executes
 more slowly, you should set this value to true only when debugging and to
 false at all other times. For more information, refer to the documentation about
 debugging ASP.NET files.
 -->
 <compilation defaultLanguage="vb" debug="true" /
 <!-- CUSTOM ERROR MESSAGES
 Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable.
 Add <error> tags for each of the errors you want to handle.
 -->
 <customErrors mode="RemoteOnly" /
 <!-- AUTHENTICATION
 This section sets the authentication policies of the application. Possible modes are "Windows",
 "Forms", "Passport" and "None"
 -->
 <authentication mode="Forms" /
 <!-- AUTHORIZATION
 This section sets the authorization policies of the application. You can allow or deny access
 to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous
 (unauthenticated) users.
 -->
 <authorization>
 <allow users="*" /> <!-- Allow all users --
 <!-- <allow users="[comma separated list of users]"
 roles="[comma separated list of roles]"/>
 <deny users="[comma separated list of users]"
 roles="[comma separated list of roles]"/>
 -->
 </authorization
 <!-- APPLICATION-LEVEL TRACE LOGGING
 Application-level tracing enables trace log output for every page within an application.
 Set trace enabled="true" to enable application trace logging. If pageOutput="true", the
 trace information will be displayed at the bottom of each page. Otherwise, you can view the
 application trace log by browsing the "trace.axd" page from your web application
 root.
 -->
 <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" /
 <!-- SESSION STATE SETTINGS
 By default ASP.NET uses cookies to identify which requests belong to a particular session.
 If cookies are not available, a session can be tracked by adding a session identifier to the URL.
 To disable cookies, set sessionState cookieless="true".
 -->
 <sessionState
 mode="InProc"
 stateConnectionString="tcpip=127.0.0.1:42424"
 sqlConnectionString="data source=127.0.0.1;user id=sa;password="
 cookieless="false"
 timeout="20"
 /
 <!-- GLOBALIZATION
 This section sets the globalization settings of the application.
 -->
 <globalization requestEncoding="utf-8" responseEncoding="utf-8" /
 </system.web
</configuration>

Then you simply access connString and you have your connection information available.sql

Friday, March 30, 2012

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.</Message>

Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

Wednesday, March 28, 2012

Login failed for user ASPNET

Login failed for user ''. The user is not associated with a trusted SQL Server connection. &qu

RESOLUTION

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

RESOLUTION

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

RESOLUTION

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

RESOLUTION

Login failed for user ''. The user is not associated with a trusted SQL Server connection.

RESOLUTION

Monday, March 26, 2012

Login failed for user '(null)'.

Friday, March 23, 2012

Login failed for user (null) , any ideas

Login failed for user '(null)' - Not associated with a trusted connection

Login failed for user '(null)' - Not associated with a trusted connection

Login failed for user '(null)' - Not associated with a trusted connection

Login failed for user '(null)' - Not associated with a trusted connection

Login failed for user '(null)'

Login failed for user '(null)'

Login failed for user '(null)'

Login failed for user (null)

Logging query errors

Blog Archive

About Me