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 |
|
saran_d28
Starting Member
36 Posts |
 Posted - 2011-06-02 : 09:45:05
|
| Hi,I am new to SQL 2005.I am not able to connect the remote server from my local machine. I am using SSMS only. I can able to connect the same server using IP address. Only my issue if i give the servername(Machinename) Instead of IP address its not connecting.Error Message is:"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)"I am able to connect the same server using the ip address.Please help me to solve the issueThanks in advance |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-06-02 : 10:27:15
|
| make sure that Named Pipes status is ENABLED, for this click on start ---->SQL Server 2008 or 2005 --->Configuration Manager ---> SQL Server Network Configuration ---> Protocol for **** ---> on right side right click on Named Pipes--------------------------http://connectsql.blogspot.com/ |
 |
|
|
saran_d28
Starting Member
36 Posts |
Posted - 2011-06-03 : 06:39:16
|
| Thanks for your reply.Named pipes protocol is enabled in server. But still same issue.SQL browser service is running.Using the default port 1433allow 1433 port and sqlserver.exe and sqlbrowser.exe in windows firewall.Pleae help me resolve the issue |
|
|
|
retrocat
Starting Member
2 Posts |
Posted - 2011-06-03 : 09:18:44
|
| Open SQL Server Configuration Manager. Expand SQL Native Client Configuration. Right click Aliases and create a new alias using tcp as Protocol, the IP address of your SQL Server as Server and the server name as Alias Name. Now you should be able to connect using the server name. |
|
|
|
saran_d28
Starting Member
36 Posts |
Posted - 2011-06-09 : 09:40:30
|
| I created the Alias also. still the same issue |
|
|
|
|
|
|
Unable to connect remote server from SSMS