Re: connection failure

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,

Login as a login Administartor and connect to SSMS. then execute the below
query to create a windows login into SQL Server.

CREATE LOGIN [Lyr\MattiasSchlipp] FROM WINDOWS
go
USE databasename
go
CREATE USER [Lyr\MattiasSchlipp] FOR LOGIN [Lyr\MattiasSchlipp]
go

After execution login again as the old os user into operating system and try
connecting to SSMS.

Thanks
Hari

"Mattias" <Mattias@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F120340-2D47-46FD-9B49-BF0439D7B8CD@xxxxxxxxxxxxxxxx
Hi

I have set up the set up the SQL Server 2005 developer, and thought it was
ok until trying to connect to the server via SQL Server Management studio,

I recive the below error.

hope anyone can help me out here.

Mattias

===================================

Login failed for user 'Lyr\Mattias Schlipp'. (.Net SqlClient Data
Provider)

------------------------------
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
Server Name: LYR
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.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()




.

Relevant Pages

  • error logging on SQL 2008
    ... I made a new installation of SQL 2008 on a Windows Server 2008, ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ... Boolean redirectedUserInstance) ...
    (microsoft.public.sqlserver.server)
  • Re: error logging on SQL 2008
    ... Administrators group as a Login in SQL server! ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
    (microsoft.public.sqlserver.server)
  • Re: How do I use sp_configure user instances enabled
    ... Message="Generating user instances in SQL Server is disabled. ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ... I have a running version of SQL SERVER Express on my system and whether I ...
    (microsoft.public.sqlserver.connect)
  • connection failure
    ... I have set up the set up the SQL Server 2005 developer, ... owningObject, SqlConnectionString connectionOptions, Int64 timerStart) ... owningObject, SqlConnectionString connectionOptions, String newPassword, ... Boolean redirectedUserInstance) ...
    (microsoft.public.sqlserver.setup)
  • Re: error logging on SQL 2008
    ... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
    (microsoft.public.sqlserver.server)