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
 problem in connect between 2 system on network
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pooya1072
Starting Member

13 Posts

Posted - 11/28/2012 :  17:32:14  Show Profile  Reply with Quote
hi
i have 2 pc named PC1 and PC2 that connect with wired network.i installed SQL Server 2008 on both PC.(Instance Name :MSSQLServer)
on PC1 i create a new SQL Server Authentication User named :User1 by a password for example "12345".
now when i try to connect to PC1's instance server from PC2 by using the User1 login this error occure :

Cannot connect to PC1\MSSQLServer
Additional information
A connection was successfully established with the server , but
then an error occured during the login process .
(Provider : Named pipes provider , error : 0 - NO process is on the other end of the pipe )
(Microsoft SQL Server , error :233)

Edited by - pooya1072 on 11/28/2012 17:36:03

srimami
Posting Yak Master

160 Posts

Posted - 12/18/2012 :  04:18:35  Show Profile  Reply with Quote
Use linked server under security tab if they are on the same domain
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.08 seconds. Powered By: Snitz Forums 2000