Unable to conenct to MS SQL SERVER EXPRESS 2008 R

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

Unable to conenct to MS SQL SERVER EXPRESS 2008 R

Author

Topic

korssane
Posting Yak Master

104 Posts

Posted - 2011-04-19 : 15:56:56

Hi All,

Every thing was working fine before i install the coldfusion 9 on my machine.
since that i am unable to connect to my data base engine via MS SQL studio manager or even through the command prompt

Any help or anybody went throgh this ?

Thansk

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-19 : 16:01:47

1. Check if SQL Server service is running via the SQL Server Configuration Manager or the Services control panel.
2. Post the error messages you're getting when you attempt to log in.
3. Contact Adobe customer support either way and see if they can help.
4. Try uninstalling ColdFusion and see if that fixes it.

korssane
Posting Yak Master

104 Posts

Posted - 2011-04-19 : 16:10:20

hi thanks for the quick reply.
i have done everything you mentionned before even uninstalling coldfusion but still getting the following message:

===================================

Cannot connect to D000690\SQLEXPRESS.

===================================

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) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
Error Number: 2
Severity: 20
State: 0

------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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.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(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
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 Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

any help ?

thanks

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-19 : 16:16:52

Are you trying to connect with named pipes or TCP/IP?

In SQL Configuration Manager, look under Network Configuration, then Protocols for your SQLEXPRESS instance. Make sure Named Pipes and TCP/IP are both enabled. If you have to re-enable either of them, you'll need to restart your SQL Server service.

korssane
Posting Yak Master

104 Posts

Posted - 2011-04-19 : 16:26:02

hi ,

Both protocols and service are running expect the agent one whichis normal coz this is not supported in the express version. both TCP/IP , namedpipeare enabled and . i tried to connect using TCP/IP or namedpipes but still geting the same error./
i have restarted the server and the whole machine machine..still same thing

wiered..

Athoughts ?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-04-19 : 16:40:15

Try customer support for Adobe and Microsoft. You could try this beforehand, just in case they can't help:

1. Stop all the SQL Server services.
2. Copy your user database and log files (NOT master, model, or msdb) to a safe location. You want .MDF and .LDF (and .NDF if any) files.
3. Uninstall and reinstall SQLExpress. Make sure you can connect.
4. Attach the database files. You can try with the original files (they should still be in the original folder), or try attaching the copies.

Make sure that no SQL services are running before you copy the files, otherwise you could corrupt the databases. Don't worry about preserving the system databases, they'll get overwritten anyway.

korssane
Posting Yak Master

104 Posts

Posted - 2011-04-19 : 16:42:22

works thanks

follow the link :

http://serverfault.com/questions/11745/i-cannot-connect-to-my-local-sql-server-2008

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources