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

Hi !!
Does anybody know how can I solve this problem ?
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have this problem when I tryed to execute a select between two SQL server
from a Query Analyzer Client with windows NT credentials (the linked Server
has been seted up)
ThanksSetup impersonation on the linked server. That should solve your problem.
-Argenis
"Hernn Rado" <hernan_radovitzki@.hotmail.com> wrote in message
news:%230avXC%23LFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL
server
> from a Query Analyzer Client with windows NT credentials (the linked
Server
> has been seted up)
> Thanks
>|||see also
http://support.microsoft.com/?id=238477
reg
Knud
"Hernán Rado" wrote:

> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL serve
r
> from a Query Analyzer Client with windows NT credentials (the linked Serve
r
> has been seted up)
> Thanks
>
>

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

Hi !!
Does anybody know how can I solve this problem ?
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have this problem when I tryed to execute a select between two SQL server
from a Query Analyzer Client with windows NT credentials (the linked Server
has been seted up)
Thanks
Setup impersonation on the linked server. That should solve your problem.
-Argenis
"Hernn Rado" <hernan_radovitzki@.hotmail.com> wrote in message
news:%230avXC%23LFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL
server
> from a Query Analyzer Client with windows NT credentials (the linked
Server
> has been seted up)
> Thanks
>
|||see also
http://support.microsoft.com/?id=238477
reg
Knud
"Hernán Rado" wrote:

> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL server
> from a Query Analyzer Client with windows NT credentials (the linked Server
> has been seted up)
> Thanks
>
>

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

Hi !!
Does anybody know how can I solve this problem ?
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have this problem when I tryed to execute a select between two SQL server
from a Query Analyzer Client with windows NT credentials (the linked Server
has been seted up)
ThanksSetup impersonation on the linked server. That should solve your problem.
-Argenis
"Hernán Rado" <hernan_radovitzki@.hotmail.com> wrote in message
news:%230avXC%23LFHA.2580@.TK2MSFTNGP09.phx.gbl...
> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL
server
> from a Query Analyzer Client with windows NT credentials (the linked
Server
> has been seted up)
> Thanks
>|||see also
http://support.microsoft.com/?id=238477
reg
Knud
"Hernán Rado" wrote:
> Hi !!
>
> Does anybody know how can I solve this problem ?
> Server: Msg 18456, Level 14, State 1, Line 1
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> I have this problem when I tryed to execute a select between two SQL server
> from a Query Analyzer Client with windows NT credentials (the linked Server
> has been seted up)
> Thanks
>
>

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.

Login failed - Error Number: 18456 - Severity: 14 - State: 1

Hi.
After re-installing Windows Vista on my PC, I can no longer log on to my
local SQL Server 2005 (SP2) (even though my account name is the same for
Vista). I can not even connect with a new query, so I can not update user
information or anything like that. It gives me this error:
Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=18456&LinkId=20476[/url]
Server Name: thomas-pc
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean
enlistOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Ne wRegisteredServerForm.testConnection_Click(Object sender, EventArgs e)
Unfortunately the link provided above for more help takes me to a page that
does not exist.
I did try to uninstall the SQL Server 2005 and re-install it again but
without any difference.
I can connect to servers on other servers, but as I mentioned not my local
SQL server.
Thanks for your advise/help,
Thomas
Can you connect if you launch SSMS with "run as Administrator"? If so, add
your Windows login to the sysadmin role so that you don't need to run with
elevated privileges , except when managing services.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
> Hi.
> After re-installing Windows Vista on my PC, I can no longer log on to my
> local SQL Server 2005 (SP2) (even though my account name is the same for
> Vista). I can not even connect with a new query, so I can not update user
> information or anything like that. It gives me this error:
> Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
> --
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=18456&LinkId=20476[/url]
> --
> Server Name: thomas-pc
> Error Number: 18456
> Severity: 14
> State: 1
> Line Number: 65536
> --
> Program Location:
> at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj)
> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
> at System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean
> enlistOK)
> at
> System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo
> serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, SqlConnection owningObject)
> at System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String
> host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> at
> System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance)
> at
> System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity
> identity, SqlConnectionString connectionOptions, Object providerInfo,
> String
> newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
> at
> System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
> options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
> owningConnection)
> at
> System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection
> owningConnection, DbConnectionPoolGroup poolGroup)
> at
> System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
> owningConnection)
> at
> System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory)
> at System.Data.SqlClient.SqlConnection.Open()
> at
> Microsoft.SqlServer.Management.UI.ConnectionDlg.Ne wRegisteredServerForm.testConnection_Click(Object
> sender, EventArgs e)
> Unfortunately the link provided above for more help takes me to a page
> that
> does not exist.
> I did try to uninstall the SQL Server 2005 and re-install it again but
> without any difference.
> I can connect to servers on other servers, but as I mentioned not my local
> SQL server.
> Thanks for your advise/help,
> Thomas
|||Dan - You' da man !!! Thanks a lot. Yes, I could launch SSMS as
asministrator, and added my windows login and not everything's just fine.
I really appreciate your help and thank you once again.
Best regards and have a nice day,
Thomas
"Dan Guzman" wrote:

> Can you connect if you launch SSMS with "run as Administrator"? If so, add
> your Windows login to the sysadmin role so that you don't need to run with
> elevated privileges , except when managing services.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
> news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
>
|||I'm glad I was able to help you out, Thomas. IIRC, the SP2 install can also
add logins to the sysadmin role so you don't need to do it manually.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Vang" <ThomasVang@.discussions.microsoft.com> wrote in message
news:978F3942-1196-4598-865E-A7A68295A4CD@.microsoft.com...[vbcol=seagreen]
> Dan - You' da man !!! Thanks a lot. Yes, I could launch SSMS as
> asministrator, and added my windows login and not everything's just fine.
> I really appreciate your help and thank you once again.
> Best regards and have a nice day,
> Thomas
>
> "Dan Guzman" wrote:

Login failed - Error Number: 18456 - Severity: 14 - State: 1

Hi.
After re-installing Windows Vista on my PC, I can no longer log on to my
local SQL Server 2005 (SP2) (even though my account name is the same for
Vista). I can not even connect with a new query, so I can not update user
information or anything like that. It gives me this error:
Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
--
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
--
Server Name: thomas-pc
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
--
Program Location:
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.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.testConnection_Click(Object sender, EventArgs e)
Unfortunately the link provided above for more help takes me to a page that
does not exist.
I did try to uninstall the SQL Server 2005 and re-install it again but
without any difference.
I can connect to servers on other servers, but as I mentioned not my local
SQL server.
Thanks for your advise/help,
ThomasCan you connect if you launch SSMS with "run as Administrator"? If so, add
your Windows login to the sysadmin role so that you don't need to run with
elevated privileges , except when managing services.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
> Hi.
> After re-installing Windows Vista on my PC, I can no longer log on to my
> local SQL Server 2005 (SP2) (even though my account name is the same for
> Vista). I can not even connect with a new query, so I can not update user
> information or anything like that. It gives me this error:
> Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
> --
> Server Name: thomas-pc
> Error Number: 18456
> Severity: 14
> State: 1
> Line Number: 65536
> --
> Program Location:
> 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.AttemptOneLogin(ServerInfo
> serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, SqlConnection owningObject)
> at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
> host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> 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.CreateNonPooledConnection(DbConnection
> owningConnection, DbConnectionPoolGroup poolGroup)
> 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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.testConnection_Click(Object
> sender, EventArgs e)
> Unfortunately the link provided above for more help takes me to a page
> that
> does not exist.
> I did try to uninstall the SQL Server 2005 and re-install it again but
> without any difference.
> I can connect to servers on other servers, but as I mentioned not my local
> SQL server.
> Thanks for your advise/help,
> Thomas|||Dan - You' da man !!! Thanks a lot. Yes, I could launch SSMS as
asministrator, and added my windows login and not everything's just fine.
I really appreciate your help and thank you once again.
Best regards and have a nice day,
Thomas
"Dan Guzman" wrote:
> Can you connect if you launch SSMS with "run as Administrator"? If so, add
> your Windows login to the sysadmin role so that you don't need to run with
> elevated privileges , except when managing services.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
> news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
> > Hi.
> >
> > After re-installing Windows Vista on my PC, I can no longer log on to my
> > local SQL Server 2005 (SP2) (even though my account name is the same for
> > Vista). I can not even connect with a new query, so I can not update user
> > information or anything like that. It gives me this error:
> >
> > Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
> >
> > --
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
> >
> > --
> > Server Name: thomas-pc
> > Error Number: 18456
> > Severity: 14
> > State: 1
> > Line Number: 65536
> >
> > --
> > Program Location:
> >
> > 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.AttemptOneLogin(ServerInfo
> > serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> > timerExpire, SqlConnection owningObject)
> > at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
> > host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> > owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> > 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.CreateNonPooledConnection(DbConnection
> > owningConnection, DbConnectionPoolGroup poolGroup)
> > 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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.testConnection_Click(Object
> > sender, EventArgs e)
> >
> > Unfortunately the link provided above for more help takes me to a page
> > that
> > does not exist.
> > I did try to uninstall the SQL Server 2005 and re-install it again but
> > without any difference.
> > I can connect to servers on other servers, but as I mentioned not my local
> > SQL server.
> >
> > Thanks for your advise/help,
> > Thomas
>|||I'm glad I was able to help you out, Thomas. IIRC, the SP2 install can also
add logins to the sysadmin role so you don't need to do it manually.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Vang" <ThomasVang@.discussions.microsoft.com> wrote in message
news:978F3942-1196-4598-865E-A7A68295A4CD@.microsoft.com...
> Dan - You' da man !!! Thanks a lot. Yes, I could launch SSMS as
> asministrator, and added my windows login and not everything's just fine.
> I really appreciate your help and thank you once again.
> Best regards and have a nice day,
> Thomas
>
> "Dan Guzman" wrote:
>> Can you connect if you launch SSMS with "run as Administrator"? If so,
>> add
>> your Windows login to the sysadmin role so that you don't need to run
>> with
>> elevated privileges , except when managing services.
>>
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
>> news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
>> > Hi.
>> >
>> > After re-installing Windows Vista on my PC, I can no longer log on to
>> > my
>> > local SQL Server 2005 (SP2) (even though my account name is the same
>> > for
>> > Vista). I can not even connect with a new query, so I can not update
>> > user
>> > information or anything like that. It gives me this error:
>> >
>> > Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data
>> > Provider)
>> >
>> > --
>> > For help, click:
>> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
>> >
>> > --
>> > Server Name: thomas-pc
>> > Error Number: 18456
>> > Severity: 14
>> > State: 1
>> > Line Number: 65536
>> >
>> > --
>> > Program Location:
>> >
>> > 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.AttemptOneLogin(ServerInfo
>> > serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
>> > timerExpire, SqlConnection owningObject)
>> > at
>> > System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
>> > host, String newPassword, Boolean redirectedUserInstance, SqlConnection
>> > owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
>> > 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.CreateNonPooledConnection(DbConnection
>> > owningConnection, DbConnectionPoolGroup poolGroup)
>> > 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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.testConnection_Click(Object
>> > sender, EventArgs e)
>> >
>> > Unfortunately the link provided above for more help takes me to a page
>> > that
>> > does not exist.
>> > I did try to uninstall the SQL Server 2005 and re-install it again but
>> > without any difference.
>> > I can connect to servers on other servers, but as I mentioned not my
>> > local
>> > SQL server.
>> >
>> > Thanks for your advise/help,
>> > Thomas
>>|||Thanks Dan! This helped with me running into issues when trying to restart
my SQL Server 2005 Developer Edition instance on Vista Business and failing
due to authentication issues, even though I am an administrator on my
workstation.
Laurence
"Dan Guzman" wrote:
> Can you connect if you launch SSMS with "run as Administrator"? If so, add
> your Windows login to the sysadmin role so that you don't need to run with
> elevated privileges , except when managing services.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
> news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
> > Hi.
> >
> > After re-installing Windows Vista on my PC, I can no longer log on to my
> > local SQL Server 2005 (SP2) (even though my account name is the same for
> > Vista). I can not even connect with a new query, so I can not update user
> > information or anything like that. It gives me this error:
> >
> > Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
> >
> > --
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
> >
> > --
> > Server Name: thomas-pc
> > Error Number: 18456
> > Severity: 14
> > State: 1
> > Line Number: 65536
> >
> > --
> > Program Location:
> >
> > 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.AttemptOneLogin(ServerInfo
> > serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> > timerExpire, SqlConnection owningObject)
> > at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
> > host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> > owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> > 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.CreateNonPooledConnection(DbConnection
> > owningConnection, DbConnectionPoolGroup poolGroup)
> > 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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.testConnection_Click(Object
> > sender, EventArgs e)
> >
> > Unfortunately the link provided above for more help takes me to a page
> > that
> > does not exist.
> > I did try to uninstall the SQL Server 2005 and re-install it again but
> > without any difference.
> > I can connect to servers on other servers, but as I mentioned not my local
> > SQL server.
> >
> > Thanks for your advise/help,
> > Thomas
>

Login failed - Error Number: 18456 - Severity: 14 - State: 1

Hi.
After re-installing Windows Vista on my PC, I can no longer log on to my
local SQL Server 2005 (SP2) (even though my account name is the same for
Vista). I can not even connect with a new query, so I can not update user
information or anything like that. It gives me this error:
Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
For help, click:
http://go.microsoft.com/fwlink?Prod...56&LinkId=20476
Server Name: thomas-pc
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Program Location:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bjec
t
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.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentit
y
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpti
ons
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon
nection owningConnection, DbConnectionPoolGroup poolGroup)
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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.test
Connection_Click(Object sender, EventArgs e)
Unfortunately the link provided above for more help takes me to a page that
does not exist.
I did try to uninstall the SQL Server 2005 and re-install it again but
without any difference.
I can connect to servers on other servers, but as I mentioned not my local
SQL server.
Thanks for your advise/help,
ThomasCan you connect if you launch SSMS with "run as Administrator"? If so, add
your Windows login to the sysadmin role so that you don't need to run with
elevated privileges , except when managing services.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
> Hi.
> After re-installing Windows Vista on my PC, I can no longer log on to my
> local SQL Server 2005 (SP2) (even though my account name is the same for
> Vista). I can not even connect with a new query, so I can not update user
> information or anything like that. It gives me this error:
> Login failed for user 'Thomas-PC\Thomas'. (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?Prod...56&LinkId=20476
> --
> Server Name: thomas-pc
> Error Number: 18456
> Severity: 14
> State: 1
> Line Number: 65536
> --
> Program Location:
> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
> at
> System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bj
ect
> 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.AttemptOneLogin(ServerInfo
> serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, SqlConnection owningObject)
> at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
> host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> at
> System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance)
> at
> System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdent
ity
> identity, SqlConnectionString connectionOptions, Object providerInfo,
> String
> newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
> at
> System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOp
tions
> options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
> owningConnection)
> at
> System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbC
onnection
> owningConnection, DbConnectionPoolGroup poolGroup)
> 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.SqlServer.Management.UI.ConnectionDlg.NewRegisteredServerForm.te
stConnection_Click(Object
> sender, EventArgs e)
> Unfortunately the link provided above for more help takes me to a page
> that
> does not exist.
> I did try to uninstall the SQL Server 2005 and re-install it again but
> without any difference.
> I can connect to servers on other servers, but as I mentioned not my local
> SQL server.
> Thanks for your advise/help,
> Thomas|||Dan - You' da man !!! Thanks a lot. Yes, I could launch SSMS as
asministrator, and added my windows login and not everything's just fine.
I really appreciate your help and thank you once again.
Best regards and have a nice day,
Thomas
"Dan Guzman" wrote:

> Can you connect if you launch SSMS with "run as Administrator"? If so, ad
d
> your Windows login to the sysadmin role so that you don't need to run with
> elevated privileges , except when managing services.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Thomas Vang" <Thomas Vang@.discussions.microsoft.com> wrote in message
> news:6DD3607B-2A9B-4C69-BBBD-61ADA479D211@.microsoft.com...
>|||I'm glad I was able to help you out, Thomas. IIRC, the SP2 install can also
add logins to the sysadmin role so you don't need to do it manually.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Vang" <ThomasVang@.discussions.microsoft.com> wrote in message
news:978F3942-1196-4598-865E-A7A68295A4CD@.microsoft.com...[vbcol=seagreen]
> Dan - You' da man !!! Thanks a lot. Yes, I could launch SSMS as
> asministrator, and added my windows login and not everything's just fine.
> I really appreciate your help and thank you once again.
> Best regards and have a nice day,
> Thomas
>
> "Dan Guzman" wrote:
>

Login error: 18456, Severity: 14, State: 11.

Hi,
we did an clean install of MOSS2007 and SQL2005. Both on different servers.
Everything worked well and suddenly we are getting this error and MOSS2007
stops working. The second message in the error log is: 'Login failed for user
'Domain\user'.
If I put the user in the SysAdmin serverrole they are able to connect.
Strange thing is that this is also happening on our SP2003/SQL2000 servers.
But on these servers it's gone after an short period.
Someone any idea?
--
Robert Hartskeerl, MCTS, MCITPHi Robert
State 11 is "Login is valid, but server access failed." my guess is that the
default database is wrong or you don't have access to it. You could try
logging in as that user and use SQLCMD or osql to change the database you
connect to. sp_defaultdb can be used to change the default database.
John
"Robert Hartskeerl" wrote:
> Hi,
> we did an clean install of MOSS2007 and SQL2005. Both on different servers.
> Everything worked well and suddenly we are getting this error and MOSS2007
> stops working. The second message in the error log is: 'Login failed for user
> 'Domain\user'.
> If I put the user in the SysAdmin serverrole they are able to connect.
> Strange thing is that this is also happening on our SP2003/SQL2000 servers.
> But on these servers it's gone after an short period.
> Someone any idea?
> --
> Robert Hartskeerl, MCTS, MCITP|||Hello, Robert
Maybe one of following will help:
http://blogs.msdn.com/sql_protocols/archive/2007/06/18/connecting-to-sql-server-2005-on-vista-and-longhorn.aspx
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
Razvan Socol
SQL Server MVP|||Thanks for your response John.
We already solved this with the information on connect.microsoft.com.
We had created extra tcp enpoints for different users. What happens is that
SQL Server removes the public role from TCP-Connect. So while the other
applications that used the non-default endpoints only sa's are able to
connect to the default endpoint.
After adding TCP-Endpoint to the public role we can connect.
Robert Hartskeerl
--
Robert Hartskeerl, MCTS, MCITP
"John Bell" wrote:
> Hi Robert
> State 11 is "Login is valid, but server access failed." my guess is that the
> default database is wrong or you don't have access to it. You could try
> logging in as that user and use SQLCMD or osql to change the database you
> connect to. sp_defaultdb can be used to change the default database.
> John
>
> "Robert Hartskeerl" wrote:
> > Hi,
> >
> > we did an clean install of MOSS2007 and SQL2005. Both on different servers.
> > Everything worked well and suddenly we are getting this error and MOSS2007
> > stops working. The second message in the error log is: 'Login failed for user
> > 'Domain\user'.
> >
> > If I put the user in the SysAdmin serverrole they are able to connect.
> >
> > Strange thing is that this is also happening on our SP2003/SQL2000 servers.
> > But on these servers it's gone after an short period.
> >
> > Someone any idea?
> > --
> > Robert Hartskeerl, MCTS, MCITP

Logging Sql error to a table

CREATE PROCEDURE GetData
AS
SELECT * FROM Bogus
When I am executing above procedure I got following error.
Server: Msg 208, Level 16, State 1, Procedure GetData, Line 3
Invalid object name 'Bogus'.
I want to Insert above sql generated error message to a table from a
procedure (Ver.SQl 2000)
How can I do it ?You can't. Such errors are batch-aborting and need to be handled by the clie
nt application. Read the
error handling articles at www.sommarskog.se.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sha" <Sha@.discussions.microsoft.com> wrote in message
news:D0E50949-4A04-4DF3-AD58-D0140D3A3B87@.microsoft.com...
> CREATE PROCEDURE GetData
> AS
> SELECT * FROM Bogus
> When I am executing above procedure I got following error.
> Server: Msg 208, Level 16, State 1, Procedure GetData, Line 3
> Invalid object name 'Bogus'.
> I want to Insert above sql generated error message to a table from a
> procedure (Ver.SQl 2000)
> How can I do it ?
>

Logging Off Users

I am trying to setup a DB Maintanance Plan and am getting an Error 5070:
Database state cannot be changed while other users are using the database.
Does anyone know what microsoft sql command would be to log off all the
users. (Like Oralce command of shutdown immediate.)
Thanks.Joel,
If its SQL Server 2000, you can use:
ALTER DATABASE <databasename >
SET single_user WITH ROLLBACK IMMEDIATE
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Joel" <nowhere@.nowhere.com> wrote in message
news:%23BLYt86SDHA.2144@.TK2MSFTNGP11.phx.gbl...
> I am trying to setup a DB Maintanance Plan and am getting an Error 5070:
> Database state cannot be changed while other users are using the database.
> Does anyone know what microsoft sql command would be to log off all the
> users. (Like Oralce command of shutdown immediate.)
> Thanks.
>|||Thanks
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:OCNoaE7SDHA.2004@.TK2MSFTNGP11.phx.gbl...
> Joel,
> If its SQL Server 2000, you can use:
> ALTER DATABASE <databasename >
> SET single_user WITH ROLLBACK IMMEDIATE
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Joel" <nowhere@.nowhere.com> wrote in message
> news:%23BLYt86SDHA.2144@.TK2MSFTNGP11.phx.gbl...
> > I am trying to setup a DB Maintanance Plan and am getting an Error 5070:
> > Database state cannot be changed while other users are using the
database.
> >
> > Does anyone know what microsoft sql command would be to log off all the
> > users. (Like Oralce command of shutdown immediate.)
> >
> > Thanks.
> >
> >
>