Hello,

When trying to connect to my SQL Server Express 2008, I get the following
error:
Cannot connect to (local)

Error Number: 2
Severity: 20
State: 0

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.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject)
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.SqlStudio.Explorer. ObjectExplorerService.ValidateConnection(UIConnect ionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()


How can I fix this error?

I remember that, when running setup, I choose 'Network' in stead of 'Local
System'. Could this cause the error? How can I change that?

Could you please help me to fix this?

Many thanks and greetings,

Michel

Michel Vanderbeke (michel.vanderbeke (AT) skynet (DOT) be) writes:
There are a number of things that can be wrong, but I shot from the hip
and say that you should try to specify "(local)\SQLEXPRESS" as the server,
since by default SQL Express is installed as a named instance with the
name SQLEXPRESS.

If that does not cut it, you need to give more details:
o What is your connection string?
o Is the client program running on the same machine as SQL Server?
o Can you connect with SQL Server Management Studio? SQLCMD?
o Etc.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hello,

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> schreef in bericht
news:Xns9D5FF09AA775DYazorman (AT) 127 (DOT) 0.0.1...
It is with SQL Server Management Studio that I can not get a connection!

Many thanks for your response,

Michel

Michel Vanderbeke (michel.vanderbeke (AT) skynet (DOT) be) writes:
So did it help by specifying .\SQLEXPRESS for the instance name?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hello,

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> schreef in bericht
news:Xns9D60F05C1E721Yazorman (AT) 127 (DOT) 0.0.1...

Yes! That did the trick!

Thank you very much,

Michel