unable to conncet remote instance

Question

Post reply

unable to conncet remote instance

sivark1

SSCrazy

Points: 2654
More actions
May 26, 2009 at 1:31 am

#131935

Hi experts,
when ever i tried to access remote instance
iam getting the following error
can not connect (instance name)
instance failure(System.data)
iam using sqlserver dev edition
pls give the solution to fix this issue
Thanks in advance
November 29, 2016 at 4:31 am

This was removed by the editor as SPAM
April 23, 2017 at 6:40 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sivark1 SSCrazy Points: 2654 More actions · Answer 1

nobody has respond for this issue

please can any body respond experts

it is urgent

thanks

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

sivark1 (5/26/2009)
when ever i tried to access remote instance
iam getting the following error
can not connect (instance name)
instance failure(System.data)
iam using sqlserver dev edition
pls give the solution to fix this issue

Your are having SQL Server 2005 on both the servers.?

Have you enabled "Allow Remote Access" option ..?

Do you have a Firewall installed..?, If yes, Have you opened the port for SQL Server..?

manolomalaga SSCommitted Points: 1697 More actions · Answer 3

Hi, if you have firewalls inside your network or dynamic port assigment in you SQL server instance configuration, you could try to activate pipe connections and try to connect again.