Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

unable to conncet remote instance Expand / Collapse
Author
Message
Posted Tuesday, May 26, 2009 1:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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









Post #723061
Posted Tuesday, May 26, 2009 10:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Post #723774
Posted Tuesday, May 26, 2009 11:40 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:41 PM
Points: 1,563, Visits: 2,615
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..?






Post #723796
Posted Thursday, May 28, 2009 9:32 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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.


Post #725172
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse