|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Monday, January 30, 2012 6:00 AM
Points: 140,
Visits: 1,010
|
|
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
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Monday, January 30, 2012 6:00 AM
Points: 140,
Visits: 1,010
|
|
nobody has respond for this issue
please can any body respond experts
it is urgent
thanks
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Today @ 4:21 AM
Points: 1,371,
Visits: 2,300
|
|
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..?
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Wednesday, September 22, 2010 3:05 AM
Points: 83,
Visits: 172
|
|
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.
|
|
|
|