RE: Can't access Sql Server Express 2005

From: David Thielen <thielen@xxxxxxxxxxxxx>
Date: Thu, 8 Feb 2007 09:16:01 -0800

Output on system. It now doesn't even show the local system as having
SqlServer at all - but you can see from the second attempt to connect it's
there (wrong password but it's there):

C:\Documents and Settings\dave>TestSqlServer.exe
Testing Sql Server Enumeration
servers:
ARIEL; ; ; ;
COGSWORTH; ; ; ;
servers complete
create connection
open connection - WinXP-Portal
Error: System.Data.SqlClient.SqlException: An error has occurred while
establish
ing a connection to the server. When connecting to SQL Server 2005, this
failur
e may be caused by the fact that under the default settings SQL Server does
not
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not
open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception
, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boole
an& failoverDemandDone, String host, String failoverPartner, String
protocol, Sq
lInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt,
Boolean
trustServerCert, Boolean integratedSecurity, SqlConnection owningObject,
Boolean
aliasLookup)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword,
Bool
ean 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.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owning
Object)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
ownin
gObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at TestSqlServer.TestSqlServer.Main()
create connection
open connection - WinXP-Portal\SqlExpress
Error: System.Data.SqlClient.SqlException: Login failed for user 'sa'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception
, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlis
tOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword,
Bool
ean 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.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owning
Object)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
ownin
gObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at TestSqlServer.TestSqlServer.Main()
all done

C:\Documents and Settings\dave>

C:\Documents and Settings\dave>TestSqlServer.exe
Testing Sql Server Enumeration
servers:
ARIEL; ; ; ;
COGSWORTH; ; ; ;
servers complete
create connection
open connection - WinXP-Portal
Error: System.Data.SqlClient.SqlException: An error has occurred while
establish
ing a connection to the server. When connecting to SQL Server 2005, this
failur
e may be caused by the fact that under the default settings SQL Server does
not
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not
open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception
, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boole
an& failoverDemandDone, String host, String failoverPartner, String
protocol, Sq
lInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt,
Boolean
trustServerCert, Boolean integratedSecurity, SqlConnection owningObject,
Boolean
aliasLookup)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword,
Bool
ean 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.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owning
Object)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
ownin
gObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at TestSqlServer.TestSqlServer.Main()
create connection
open connection - WinXP-Portal\SqlExpress
Error: System.Data.SqlClient.SqlException: Login failed for user 'sa'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception
, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cm
dHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
Tds
ParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlis
tOK)
at
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnecti
on owningObject, SqlConnectionString connectionOptions, String newPassword,
Bool
ean 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.CreatePooledConnection(DbConn
ection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owning
Object)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection o
wningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
ownin
gObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection ow
ningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at TestSqlServer.TestSqlServer.Main()
all done

C:\Documents and Settings\dave>

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

.

Prev by Date: Re: 7031A Upgrading to SQL 2005 Course Setup
Next by Date: RE: Can't access Sql Server Express 2005
Previous by thread: Re: Can't access Sql Server Express 2005
Next by thread: RE: Can't access Sql Server Express 2005
Index(es):
- Date
- Thread

Relevant Pages

.NET 2.0 Upgrade Connection Problem
... However, if I recompile the app in .NET 2.0, the app returns a connection ... Boolean& failoverDemandDone, String host, String failoverPartner, String ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
(microsoft.public.sqlserver.connect)
Re: Unable to Locate Server
... >> Boolean& failoverDemandDone, String host, String failoverPartner, String ... >> owningObject, SqlConnectionString connectionOptions, String newPassword, ... >>> trying to make a remote database connection while you think your ...
(microsoft.public.sqlserver.setup)
MSDE and VDD 2005 conflict?
... Dim insertString As String = "INSERT INTO Guests (FirstName, ... Message="An error has occurred while establishing a connection to the ... useFailoverPartner, Boolean& failoverDemandDone, String host, String ... owningObject, SqlConnectionString connectionOptions, String newPassword, ...
(microsoft.public.dotnet.framework.aspnet)
problems connecting to local sqlexpress
... Nonetheless I still get an error connecting from within VS ... Boolean& failoverDemandDone, String host, String failoverPartner, String ... owningObject, SqlConnectionString connectionOptions, String newPassword, ... options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection ...
(microsoft.public.sqlserver.setup)
Login failed for user . The user is not associated with a trusted SQL Server connection.
... associated with a trusted SQL Server connection.] ... newPassword, Boolean redirectedUserInstance) +628 ... String newPassword, SqlConnection owningObject, Boolean ... arguments, SignatureStruct& sig, MethodAttributes methodAttributes, ...
(microsoft.public.dotnet.framework.aspnet)