Error while connecting to database : The Official Microsoft ASP.NET Forums

Reply

rajbipul

Member

12 Points

Error while connecting to database

Mar 04, 2009 07:25 AM|LINK

This is the error what I got while accessing the database.

ERROR: Trying to execute generate

Error Message: System.Data.SqlClient.SqlException: A network-related or
instance-specific error occurred while establishing a connection to SQL
Server. The server was not found or was not accessible. Verify that the
instance name is correct and that SQL Server is configured to 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(TdsParserStateObjec
t 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.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.CreatePooledConnection(DbConnec
tion owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)

at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)

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 SubSonic.SqlDataProvider.CreateConnection(String newConnectionString)
in C:\SubSonic 2.0.3\src\SubSonic\DataProviders\SqlDataProvider.cs:line 21

at SubSonic.SqlDataProvider.CreateConnection() in C:\SubSonic
2.0.3\src\SubSonic\DataProviders\SqlDataProvider.cs:line 15

at SubSonic.AutomaticConnectionScope..ctor(DataProvider provider) in
C:\SubSonic 2.0.3\src\SubSonic\Sql Tools\Connection.cs:line 160

at SubSonic.SqlDataProvider.GetReader(QueryCommand qry) in C:\SubSonic
2.0.3\src\SubSonic\DataProviders\SqlDataProvider.cs:line 114

at SubSonic.SqlDataProvider.GetTableNameList() in C:\SubSonic
2.0.3\src\SubSonic\DataProviders\SqlDataProvider.cs:line 674

at SubSonic.DataService.GetTableNames(String providerName) in C:\SubSonic
2.0.3\src\SubSonic\DataProviders\DataService.cs:line 456

at SubCommander.Program.GenerateTables() in C:\SubSonic
2.0.3\src\SubCommander\Program.cs:line 829

at SubCommander.Program.GenerateAll() in C:\SubSonic
2.0.3\src\SubCommander\Program.cs:line 720

at SubCommander.Program.Main(String[] args) in C:\SubSonic
2.0.3\src\SubCommander\Program.cs:line 68

Please help me in this matter.