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 (but user.identity.name is correct)

I need help. The security principal is the correct Domain\User, but the error message says I am not authenticated.

So here is my error Message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Me.User.Identity.Name=CompanyDomain\Ryan; System.Security.Principal.WindowsIdentity.GetCurrent=CompanyDomain\Ryan; HttpContext.Current.User.Identity.Name=Company\Ryan

Generated by:

Dim

secPrincAs System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrentMe.lblError.Text = ex.Message & vbCrLf & vbCrLf &"Me.User.Identity.Name=" &Me.User.Identity.Name &"; System.Security.Principal.WindowsIdentity.GetCurrent=" & secPrinc.Name &"; HttpContext.Current.User.Identity.Name=" & HttpContext.Current.User.Identity.Name

Here is the Connection String:

Private ConnStringAsString ="Server=10.144.162.111;Database=DNS;Trusted_Connection=True"

IIS has 4 websites hosted on it. The parent level allows anonymous with windows auth off, but the website level has anonymous off with widnows auth and digest.

In IIS, is there a problem with having the parent level anonymous and website level windows auth?

I think i found the error. My web server is a different machine from my data server. When my browser connects to the webserver it uses impersonation and delegation, but the web server is not trusted for delegation on the active directory. So when the webserver tries to pass the credentials to the data server the domain controller will not allow it.

Working on a 3 tier setup here...

Ryan

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'.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

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.

or

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

Login failed for user MCTSERVER01\ASPNET.

Hi,

Hope someone can help me to solve the error message.

I am using Visual Studio 2005 and MS SQL Server 2005. When I tried to run the aspx, I encountered the error listed below.

Server Error in '/webtime' Application.
------------------------

Login failed for user 'MCTSERVER01\ASPNET'.
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 'MCTSERVER01\ASPNET'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user 'MCTSERVER01\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734947
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, ...

Siew Hin

As the error message states, looks like the user does not have enough permissions. Check under the Database -> Security -> Logins and see what permissions the user has.sql

Login failed for user Domainname\computername

Hi,

I am using SQL Server 2005. The below message is added to the Application Event Viewer frequently.

Failure Audit: Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx)

abc is my domain name and xyz is my computer name.

When I look @. the SQL error logs, I find the following message:

Error 18456 Severity 14 state 11

Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx)

Please let me know if you have any suggessions.

Thanks

Santhosh

It seems like a service running in the computer xyz is trying to connect to your SQL Server instance. This service must likely is running with local system or network service credentials.

I would recommend investigating what is this service by verifying the services installed in machine xyz; and if indeed it is a service that should be connecting to that SQL Server instance, you can grant access by creating a login for the Windows user [abc\xyz$] and then grant proper permissions.

I hope this information helps. Let us know if you have any further questions.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||But, xyz$ is a computer account. How can I create a login for Computer Account in SQL? Is this possible?|||

CREATE LOGIN [abc\xyz$] FROM WINDOWS

It should work, let us know if it worked.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||

Hi Raul,

I created the login using the above mentioned command. It created find.

But, now I get two messages in event viewer.

One is success audit where is says login successful for user abc\xyz$.

immeditely, it also logs in the below failure message.

Failure Audit: Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx)

In the earlier posts, you had mentioned about granting permissions to abc\xyz$ account?

What permissions should we grant.

Can you also help me with the syntax to grant those permissions.

Thanks

Santhosh

|||

Creating the loginshould typically be enough to connect to the system (using master DB).I would recommend using SLQ Server Profiler and check the Security Events section (mark show all events to see all possibilities), to be more specific mark everything under Audit Login & Audit logout

I hope this helps,

-Raul Garcia

SDE/T

SQL Server Engine

|||

We created a login for the computer account name in SQL Server.
From SQL Server, we ran
CREATE LOGIN [Domainname\computername$] FROM WINDOWS
The login created successfully.
Now, we see two audit messages for Domainname\Computername$.
First audit message is..

Login Succeded for user Domainname\Computername$. Connection Trusted.(Client :xx.xx.xx.xx)
Second Audit message is.. Login failed for user Domainname\Computername$. (Client :xx.xx.xx.xx)

Before creating the login, we had only login failed message. But, now we get login succeded message and login failed message for the same username.

Any thoughts would be helpful.

Thanks

Santhosh

|||

Unfortunately I really have no idea on what may be happening. I would suggest trying to enable other events, including any permission checks or any queries being started. Hopefully this extra information will give us a clue on why the connection is failing.

-Raul Garcia

SDE/T

SQL Server Engine

Login failed for user Domainname\computername

Hi,

I am using SQL Server 2005. The below message is added to the Application Event Viewer frequently.

Failure Audit: Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx)

abc is my domain name and xyz is my computer name.

When I look @. the SQL error logs, I find the following message:

Error 18456 Severity 14 state 11

Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx)

Please let me know if you have any suggessions.

Thanks

Santhosh

It seems like a service running in the computer xyz is trying to connect to your SQL Server instance. This service must likely is running with local system or network service credentials.

I would recommend investigating what is this service by verifying the services installed in machine xyz; and if indeed it is a service that should be connecting to that SQL Server instance, you can grant access by creating a login for the Windows user [abc\xyz$] and then grant proper permissions.

I hope this information helps. Let us know if you have any further questions.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||But, xyz$ is a computer account. How can I create a login for Computer Account in SQL? Is this possible?|||

CREATE LOGIN [abc\xyz$] FROM WINDOWS

It should work, let us know if it worked.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||

Hi Raul,

I created the login using the above mentioned command. It created find.

But, now I get two messages in event viewer.

One is success audit where is says login successful for user abc\xyz$.

immeditely, it also logs in the below failure message.

Failure Audit: Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx)

In the earlier posts, you had mentioned about granting permissions to abc\xyz$ account?

What permissions should we grant.

Can you also help me with the syntax to grant those permissions.

Thanks

Santhosh

|||

Creating the loginshould typically be enough to connect to the system (using master DB).I would recommend using SLQ Server Profiler and check the Security Events section (mark show all events to see all possibilities), to be more specific mark everything under Audit Login & Audit logout

I hope this helps,

-Raul Garcia

SDE/T

SQL Server Engine

|||

We created a login for the computer account name in SQL Server.
From SQL Server, we ran
CREATE LOGIN [Domainname\computername$] FROM WINDOWS
The login created successfully.
Now, we see two audit messages for Domainname\Computername$.
First audit message is..

Login Succeded for user Domainname\Computername$. Connection Trusted.(Client :xx.xx.xx.xx)
Second Audit message is.. Login failed for user Domainname\Computername$. (Client :xx.xx.xx.xx)

Before creating the login, we had only login failed message. But, now we get login succeded message and login failed message for the same username.

Any thoughts would be helpful.

Thanks

Santhosh

|||

Unfortunately I really have no idea on what may be happening. I would suggest trying to enable other events, including any permission checks or any queries being started. Hopefully this extra information will give us a clue on why the connection is failing.

-Raul Garcia

SDE/T

SQL Server Engine

Login failed for user computername\ASPNET

Hi all,
I get the error message Login failed for user 'computername\ASPNET'
when trying to log to MSDE 2000 SP 3 with .NET application.
My computer is Windows 2000 + SP4 with latest security patches.
I have tried to set the permissions to the database I am connecting
(mydatabase) with script:
sp_grantlogin 'mycomputer\ASPNET'
go
use mydatabase
go
sp_grantdbaccess 'mycomputer\ASPNET'
go
sp_addrolemember 'db_owner', 'mycomputer\ASPNET'
go
Still the error comes.
Does anybody have ideas what to try next.
PS. Software reinstall has been tried (.NET framework 1.1, MSDE).
Regards
Jarmo
Hi,
Did you logged into your machine using 'mycomputer\ASPNET' ? If not login to
the machine using 'mycomputer\ASPNET' and try
connecting using OSQL and confirm.
Thanks
Hari
MCDBA
"jarmopy" <jarmo.pyorny@.luukku.com> wrote in message
news:5d70b654.0408152138.6ca4d0d8@.posting.google.c om...
> Hi all,
> I get the error message Login failed for user 'computername\ASPNET'
> when trying to log to MSDE 2000 SP 3 with .NET application.
> My computer is Windows 2000 + SP4 with latest security patches.
> I have tried to set the permissions to the database I am connecting
> (mydatabase) with script:
>
> sp_grantlogin 'mycomputer\ASPNET'
> go
> use mydatabase
> go
> sp_grantdbaccess 'mycomputer\ASPNET'
> go
> sp_addrolemember 'db_owner', 'mycomputer\ASPNET'
> go
> Still the error comes.
> Does anybody have ideas what to try next.
> PS. Software reinstall has been tried (.NET framework 1.1, MSDE).
> Regards
> Jarmo
|||Hi Hari,
Local policy does not allow to log in as aspnet:
"The local policy of this system does not permit you to logon interactively."
It is only permitted to log on as a batch job.
Regards
Jarmo
"Hari Prasad" wrote:

> Hi,
> Did you logged into your machine using 'mycomputer\ASPNET' ? If not login to
> the machine using 'mycomputer\ASPNET' and try
> connecting using OSQL and confirm.
> Thanks
> Hari
> MCDBA
>
|||Hi again,
I changed the policy to be able to log in.
When giving the command as mycomputer\aspnet user
osql -E -S mycomputer\myinstance
I get the same error message:
Login failed.
Regards
Jarmo
|||There is no need to log in as ASPNET account
Go to MSDN site and look in SQL SERVER 2000 SDK Documentation (it is valid
for MSDE)
There is explanation how to use ASP .NET applications with SQL Server
"jarmopy" <jarmo.pyorny@.luukku.com> wrote in message
news:5d70b654.0408152138.6ca4d0d8@.posting.google.c om...
> Hi all,
> I get the error message Login failed for user 'computername\ASPNET'
> when trying to log to MSDE 2000 SP 3 with .NET application.
> My computer is Windows 2000 + SP4 with latest security patches.
> I have tried to set the permissions to the database I am connecting
> (mydatabase) with script:
>
> sp_grantlogin 'mycomputer\ASPNET'
> go
> use mydatabase
> go
> sp_grantdbaccess 'mycomputer\ASPNET'
> go
> sp_addrolemember 'db_owner', 'mycomputer\ASPNET'
> go
> Still the error comes.
> Does anybody have ideas what to try next.
> PS. Software reinstall has been tried (.NET framework 1.1, MSDE).
> Regards
> Jarmo
|||Hi,
thanks for the answers.
This seems to be a problem only in one computer.
In other machines this is working OK.

Login failed for user 'abc'

When we get the error message stated in the subject , does it mean that the
password was incorrect ?
Trying to find out other possible reasons when you may get that message.
I do not believe one would get that message if the server is unavailable
right ? I believe the error in that case is more of a General Network Error
Please let me know
Thanks
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect
Or Login's name. Or Authentication issue.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect ?
> Trying to find out other possible reasons when you may get that message.
> I do not believe one would get that message if the server is unavailable
> right ? I believe the error in that case is more of a General Network
Error
> Please let me know
> Thanks
>
|||what do u mean authentication issue ? Login name is right..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> the
> Or Login's name. Or Authentication issue.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> the
> Error
>
|||Hassan
You can set up an authenication to Windows ONLY or Mixed (Windows/SQL
Server). If you have Windows Only and try to connect by using a login who
does not exist or exists only in SQL Server you will get an error.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23LN%231L8hFHA.3912@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> what do u mean authentication issue ? Login name is right..
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
that[vbcol=seagreen]
that[vbcol=seagreen]
message.[vbcol=seagreen]
unavailable
>

Login failed for user 'abc'

When we get the error message stated in the subject , does it mean that the
password was incorrect ?
Trying to find out other possible reasons when you may get that message.
I do not believe one would get that message if the server is unavailable
right ? I believe the error in that case is more of a General Network Error
Please let me know
Thanks> When we get the error message stated in the subject , does it mean that
the
> password was incorrect
Or Login's name. Or Authentication issue.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect ?
> Trying to find out other possible reasons when you may get that message.
> I do not believe one would get that message if the server is unavailable
> right ? I believe the error in that case is more of a General Network
Error
> Please let me know
> Thanks
>|||what do u mean authentication issue ? Login name is right..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> > When we get the error message stated in the subject , does it mean that
> the
> > password was incorrect
> Or Login's name. Or Authentication issue.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> > When we get the error message stated in the subject , does it mean that
> the
> > password was incorrect ?
> >
> > Trying to find out other possible reasons when you may get that message.
> >
> > I do not believe one would get that message if the server is unavailable
> > right ? I believe the error in that case is more of a General Network
> Error
> >
> > Please let me know
> >
> > Thanks
> >
> >
>|||Hassan
You can set up an authenication to Windows ONLY or Mixed (Windows/SQL
Server). If you have Windows Only and try to connect by using a login who
does not exist or exists only in SQL Server you will get an error.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23LN%231L8hFHA.3912@.tk2msftngp13.phx.gbl...
> what do u mean authentication issue ? Login name is right..
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> > > When we get the error message stated in the subject , does it mean
that
> > the
> > > password was incorrect
> >
> > Or Login's name. Or Authentication issue.
> >
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> > > When we get the error message stated in the subject , does it mean
that
> > the
> > > password was incorrect ?
> > >
> > > Trying to find out other possible reasons when you may get that
message.
> > >
> > > I do not believe one would get that message if the server is
unavailable
> > > right ? I believe the error in that case is more of a General Network
> > Error
> > >
> > > Please let me know
> > >
> > > Thanks
> > >
> > >
> >
> >
>

Login failed for user 'abc'

When we get the error message stated in the subject , does it mean that the
password was incorrect ?
Trying to find out other possible reasons when you may get that message.
I do not believe one would get that message if the server is unavailable
right ? I believe the error in that case is more of a General Network Error
Please let me know
Thanks> When we get the error message stated in the subject , does it mean that
the
> password was incorrect
Or Login's name. Or Authentication issue.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> When we get the error message stated in the subject , does it mean that
the
> password was incorrect ?
> Trying to find out other possible reasons when you may get that message.
> I do not believe one would get that message if the server is unavailable
> right ? I believe the error in that case is more of a General Network
Error
> Please let me know
> Thanks
>|||what do u mean authentication issue ? Login name is right..
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
> the
> Or Login's name. Or Authentication issue.
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:O0j%23Y33hFHA.2372@.TK2MSFTNGP14.phx.gbl...
> the
> Error
>|||Hassan
You can set up an authenication to Windows ONLY or Mixed (Windows/SQL
Server). If you have Windows Only and try to connect by using a login who
does not exist or exists only in SQL Server you will get an error.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23LN%231L8hFHA.3912@.tk2msftngp13.phx.gbl...
> what do u mean authentication issue ? Login name is right..
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23iS4563hFHA.572@.TK2MSFTNGP15.phx.gbl...
that[vbcol=seagreen]
that[vbcol=seagreen]
message.[vbcol=seagreen]
unavailable[vbcol=seagreen]
>sql

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
>.
>

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)'

Our QA guy just asked me for some help because he suddenly got the (dreaded)
"Login failed for user '(Null)'" message when connecting to the QA database
from his desktop.
There have been no (known) changes since he last used it a week, or two ago
and I've validated his login, Windows auth, ping from his bot to the DB
server, telnet to server 1433 and a few other things.
His password hasn't changed either.
Not sure what to do?Solved.
Non-domain local account and the password had expired.
Arggg!!! Why didn't Microsoft just say "Can't login", or "No Password", or
something.
"Jay" <nospam@.nospam.org> wrote in message
news:O9Wa$vUMIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Our QA guy just asked me for some help because he suddenly got the
> (dreaded) "Login failed for user '(Null)'" message when connecting to the
> QA database from his desktop.
> There have been no (known) changes since he last used it a week, or two
> ago and I've validated his login, Windows auth, ping from his bot to the
> DB server, telnet to server 1433 and a few other things.
> His password hasn't changed either.
> Not sure what to do?
>

Login failed for user '(Null)'

Our QA guy just asked me for some help because he suddenly got the (dreaded)
"Login failed for user '(Null)'" message when connecting to the QA database
from his desktop.
There have been no (known) changes since he last used it a week, or two ago
and I've validated his login, Windows auth, ping from his bot to the DB
server, telnet to server 1433 and a few other things.
His password hasn't changed either.
Not sure what to do?
Solved.
Non-domain local account and the password had expired.
Arggg!!! Why didn't Microsoft just say "Can't login", or "No Password", or
something.
"Jay" <nospam@.nospam.org> wrote in message
news:O9Wa$vUMIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Our QA guy just asked me for some help because he suddenly got the
> (dreaded) "Login failed for user '(Null)'" message when connecting to the
> QA database from his desktop.
> There have been no (known) changes since he last used it a week, or two
> ago and I've validated his login, Windows auth, ping from his bot to the
> DB server, telnet to server 1433 and a few other things.
> His password hasn't changed either.
> Not sure what to do?
>

Login failed for user '(Null)'

Our QA guy just asked me for some help because he suddenly got the (dreaded)
"Login failed for user '(Null)'" message when connecting to the QA database
from his desktop.
There have been no (known) changes since he last used it a week, or two ago
and I've validated his login, Windows auth, ping from his bot to the DB
server, telnet to server 1433 and a few other things.
His password hasn't changed either.
Not sure what to do?Solved.
Non-domain local account and the password had expired.
Arggg!!! Why didn't Microsoft just say "Can't login", or "No Password", or
something.
"Jay" <nospam@.nospam.org> wrote in message
news:O9Wa$vUMIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Our QA guy just asked me for some help because he suddenly got the
> (dreaded) "Login failed for user '(Null)'" message when connecting to the
> QA database from his desktop.
> There have been no (known) changes since he last used it a week, or two
> ago and I've validated his login, Windows auth, ping from his bot to the
> DB server, telnet to server 1433 and a few other things.
> His password hasn't changed either.
> Not sure what to do?
>

Login failed for user ''(null)''

Hi,

(First, I should explain that I am not sure whether this is the right part of the forum for this message. My apologies if I'm in the wrong place. If this is the case, could you please let me know where this post should be? Thank you.)

I have a vew that accesses data from a linked server. The view works properly in Query Analyzer but fails when run by a .Net application. The message returned is:

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

The linked server has the following attributes:

Server Type: SQL Server

Security: No local logins listed. Connections are made using the login's current security context.

Any help would be appreciated. Thank you.

Resolved. The problem was in two places: I had to remove Anonymous access from the directory in ISS (ISS/Directory/Properties/Directory Security/Edit) and change the login in the SQL Server service from Local Account to my login information (Start/Run/Services.msc/MSSQLSERVER/Log On/This Account). These changes allowed the link server to recognize and authenticate the login.

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

Please help I keep getting this message when I log on to my data base. Not sure what state 1 relates too

TITLE: Connect to Server

Cannot connect to <server_name>

ADDITIONAL INFORMATION:

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

BUTTONS:

OK

Server Name: <server~name>Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Dear testman,

Check if your sql service is running.

Also check you username/password.

http://msdn2.microsoft.com/en-us/library/ms366351.aspx

HTH,

Suprotim Agarwal

|||

Thanks for your reply.

I have tried: checking passwords and logins, deleting database from te server and re-installing (via helm editor) assigning new admins, switching off interrnet protection, calling sysadmin to check the state of the database server, rebooting my machine.

run out of ideas now

|||

Try to connect to the sql server by giving the port number in which sql listens.....

<ServerName>,<PortNumber> in the Sql server management studio (SSMS)

|||Yes tried this also |||

YOu will have to examine the SQL Server log (and turn on the auditing functionality) to find out what happens behind the scenes. As you already noticed is State 1 a general error state. The definite state can be found on the server logs. So make sure you turned on auditing on the server and login again. Afterwards send the error entry to the forums.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||If you use Windows Vista and SQL Server codename: Katmai, you must to run the Management Studio as administrator!
|||Haven't been able to get hold of the log yet as is remote webhost|||

Okay, this message means you are getting through to the server, but it does not recognize the login credentials your code is supplying. It would help to see the entire ConnectionString (with the actual UserName and Password stripped out). This will tell us a lot about how you're trying to connect.

I would also consult my whitepaper on connecting on my blog (www.betav.com/blog/billva)

|||That worked for me - I had the same problem! Right click the shortcut and select "Run as administrator".
|||Thanks for your help everyone. It was a web server administration problem it all worked when they allowed my connection.

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

Please help I keep getting this message when I log on to my data base. Not sure what state 1 relates too

TITLE: Connect to Server

Cannot connect to <server_name>

ADDITIONAL INFORMATION:

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

BUTTONS:

OK

Server Name: <server~name>Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Dear testman,

Check if your sql service is running.

Also check you username/password.

http://msdn2.microsoft.com/en-us/library/ms366351.aspx

HTH,

Suprotim Agarwal

|||

Thanks for your reply.

I have tried: checking passwords and logins, deleting database from te server and re-installing (via helm editor) assigning new admins, switching off interrnet protection, calling sysadmin to check the state of the database server, rebooting my machine.

run out of ideas now

|||

Try to connect to the sql server by giving the port number in which sql listens.....

<ServerName>,<PortNumber> in the Sql server management studio (SSMS)

|||Yes tried this also |||

YOu will have to examine the SQL Server log (and turn on the auditing functionality) to find out what happens behind the scenes. As you already noticed is State 1 a general error state. The definite state can be found on the server logs. So make sure you turned on auditing on the server and login again. Afterwards send the error entry to the forums.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||If you use Windows Vista and SQL Server codename: Katmai, you must to run the Management Studio as administrator!
|||Haven't been able to get hold of the log yet as is remote webhost|||

Okay, this message means you are getting through to the server, but it does not recognize the login credentials your code is supplying. It would help to see the entire ConnectionString (with the actual UserName and Password stripped out). This will tell us a lot about how you're trying to connect.

I would also consult my whitepaper on connecting on my blog (www.betav.com/blog/billva)

|||That worked for me - I had the same problem! Right click the shortcut and select "Run as administrator".
|||Thanks for your help everyone. It was a web server administration problem it all worked when they allowed my connection.sql

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

Please help I keep getting this message when I log on to my data base. Not sure what state 1 relates too

TITLE: Connect to Server

Cannot connect to <server_name>

ADDITIONAL INFORMATION:

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

BUTTONS:

OK

Server Name: <server~name>Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Dear testman,

Check if your sql service is running.

Also check you username/password.

http://msdn2.microsoft.com/en-us/library/ms366351.aspx

HTH,

Suprotim Agarwal

|||

Thanks for your reply.

I have tried: checking passwords and logins, deleting database from te server and re-installing (via helm editor) assigning new admins, switching off interrnet protection, calling sysadmin to check the state of the database server, rebooting my machine.

run out of ideas now

|||

Try to connect to the sql server by giving the port number in which sql listens.....

<ServerName>,<PortNumber> in the Sql server management studio (SSMS)

|||Yes tried this also |||

YOu will have to examine the SQL Server log (and turn on the auditing functionality) to find out what happens behind the scenes. As you already noticed is State 1 a general error state. The definite state can be found on the server logs. So make sure you turned on auditing on the server and login again. Afterwards send the error entry to the forums.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||If you use Windows Vista and SQL Server codename: Katmai, you must to run the Management Studio as administrator!
|||Haven't been able to get hold of the log yet as is remote webhost|||

Okay, this message means you are getting through to the server, but it does not recognize the login credentials your code is supplying. It would help to see the entire ConnectionString (with the actual UserName and Password stripped out). This will tell us a lot about how you're trying to connect.

I would also consult my whitepaper on connecting on my blog (www.betav.com/blog/billva)

|||That worked for me - I had the same problem! Right click the shortcut and select "Run as administrator".
|||Thanks for your help everyone. It was a web server administration problem it all worked when they allowed my connection.

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

Please help I keep getting this message when I log on to my data base. Not sure what state 1 relates too

TITLE: Connect to Server

Cannot connect to <server_name>

ADDITIONAL INFORMATION:

Login failed for user <user_name>. (Microsoft SQL Server, Error: 18456)

BUTTONS:

OK

Server Name: <server~name>Error Number: 18456
Severity: 14
State: 1
Line Number: 65536

Dear testman,

Check if your sql service is running.

Also check you username/password.

http://msdn2.microsoft.com/en-us/library/ms366351.aspx

HTH,

Suprotim Agarwal

|||

Thanks for your reply.

I have tried: checking passwords and logins, deleting database from te server and re-installing (via helm editor) assigning new admins, switching off interrnet protection, calling sysadmin to check the state of the database server, rebooting my machine.

run out of ideas now

|||

Try to connect to the sql server by giving the port number in which sql listens.....

<ServerName>,<PortNumber> in the Sql server management studio (SSMS)

|||Yes tried this also |||

YOu will have to examine the SQL Server log (and turn on the auditing functionality) to find out what happens behind the scenes. As you already noticed is State 1 a general error state. The definite state can be found on the server logs. So make sure you turned on auditing on the server and login again. Afterwards send the error entry to the forums.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||If you use Windows Vista and SQL Server codename: Katmai, you must to run the Management Studio as administrator!
|||Haven't been able to get hold of the log yet as is remote webhost|||

Okay, this message means you are getting through to the server, but it does not recognize the login credentials your code is supplying. It would help to see the entire ConnectionString (with the actual UserName and Password stripped out). This will tell us a lot about how you're trying to connect.

I would also consult my whitepaper on connecting on my blog (www.betav.com/blog/billva)

|||That worked for me - I had the same problem! Right click the shortcut and select "Run as administrator".
|||Thanks for your help everyone. It was a web server administration problem it all worked when they allowed my connection.