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.
Author |
Topic |
moonshine4
Starting Member
1 Post |
Posted - 2013-09-22 : 16:38:40
|
hi everybodyI need a help in sql server problem pleasei faced with the following problems in sql server :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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) andunable to connect report server wmi provider invalid namespaceI cannot solve it so i remove sql server and try to setup it again but every time I setup it didn't setup sql server management studioso I go to registry " regedit" and remove all containing "sql" in its nameand I reinstall sql server again , it's installed successfullybut the old problem is still exist.i try to disable tcp/ip and via in sql server configuration managerthe sql server service is stopped an when I try to start it it show the following error:sql server service the request faild or the service didn't respond in a timely fashion I need help as soon as you can pleasethanks in advance |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-09-22 : 22:28:14
|
quote: Originally posted by moonshine4 hi everybodyI need a help in sql server problem pleasei faced with the following problems in sql server :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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) andunable to connect report server wmi provider invalid namespaceI cannot solve it so i remove sql server and try to setup it again but every time I setup it didn't setup sql server management studioso I go to registry " regedit" and remove all containing "sql" in its nameand I reinstall sql server again , it's installed successfullybut the old problem is still exist.i try to disable tcp/ip and via in sql server configuration managerthe sql server service is stopped an when I try to start it it show the following error:sql server service the request faild or the service didn't respond in a timely fashion I need help as soon as you can pleasethanks in advance
See if you can connect to SQL Server from SQL Server Management Studio (SSMS) on the same computer where you installed the server. If installed, SSMS should be in the Microsoft SQL Server program group.If you are able to successfully connect, then follow the steps listed in this article to diagnose the problem and solve it. http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspxIf you are unable to connect even from SSMS, see if the service is running under services.msc. |
|
|
MarcPierre
Starting Member
1 Post |
Posted - 2013-10-23 : 04:13:37
|
Verify if the instance name is correct and SQL server port is by default 1433. You also need to make sure that the system firewall setting is not blocking the SQL server port. http://www.cmserversdirect.com/Marc Pierre |
|
|
|
|
|