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.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
rajbipul
Member
12 Points
19 Posts
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.
PassHours
Contributor
4322 Points
736 Posts
Re: Error while connecting to database
Mar 04, 2009 12:45 PM|LINK
You can have a look at this
Sql Server connection Fix
Hope that helps [Yes]
We make a living by what we get, but we make a life by what we give.
::: Winston Churchill :::
rajbipul
Member
12 Points
19 Posts
Re: Error while connecting to database
Mar 05, 2009 03:52 AM|LINK
yes i have seen that but is there an alternate way instead subsonic.