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.

You can have a look at this

Sql Server connection Fix

Hope that helps 

yes i have seen that but is there an alternate way instead subsonic.