SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 sql server problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

moonshine4
Starting Member

Egypt
1 Posts

Posted - 09/22/2013 :  16:38:40  Show Profile  Reply with Quote
hi everybody

I need a help in sql server problem please

i 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)

and

unable to connect report server wmi provider invalid namespace

I 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 studio


so I go to registry " regedit" and remove all containing "sql" in its name

and I reinstall sql server again , it's installed successfully
but the old problem is still exist.

i try to disable tcp/ip and via in sql server configuration manager
the 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 please

thanks in advance

James K
Flowing Fount of Yak Knowledge

3659 Posts

Posted - 09/22/2013 :  22:28:14  Show Profile  Reply with Quote
quote:
Originally posted by moonshine4

hi everybody

I need a help in sql server problem please

i 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)

and

unable to connect report server wmi provider invalid namespace

I 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 studio


so I go to registry " regedit" and remove all containing "sql" in its name

and I reinstall sql server again , it's installed successfully
but the old problem is still exist.

i try to disable tcp/ip and via in sql server configuration manager
the 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 please

thanks 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.aspx

If you are unable to connect even from SSMS, see if the service is running under services.msc.
Go to Top of Page

MarcPierre
Starting Member

USA
1 Posts

Posted - 10/23/2013 :  04:13:37  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000