Connection to remote SQL Server

Status
Not open for further replies.
C

coolrox86

Junior Member level 1
Joined
Apr 8, 2010
Messages
18
Helped
0
Reputation
0
Reaction score
0
Trophy points
1,281
Location
Malaysia
Visit site
Activity points
1,430
Hello,

I am trying to connect my first PC to another second PC SQL Server. However, the following error occurs (see attachment file).

Does anyone has any idea on how this can happen and how to solve it?

For your info, I have gone to Server Properties of second PC, and set "Allow remote connections to this server". Next, I ping the IP address of second PC inside my first PC via cmd window.

Thanks in advance for any suggestion and help!:wink:

Regards,
coolrox
 

Attachments

  • SQL Server connection problem.jpg
    32.8 KB · Views: 185
Last edited:

You are using named pipes. Try mapping network drive from server. This makes sure you are using windows authentication to your server. Named pipes need windows authentication before they work. Can you ping with name? ping HANIF-PC ? If not put HANIF-PC to your hosts file. Make sure your computers are on same workgroup or domain.
 

Status
Not open for further replies.

Similar threads

Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…