unable to connect on all instances on remote machine

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Connecting » unable to connect on all instances on remote...

unable to connect on all instances on remote machine

Rate Topic

Display Mode

Topic Options

Author

Message

SQLing

Posted Friday, December 14, 2012 8:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, March 02, 2013 1:14 PM
Points: 2, Visits: 31

Hi, I have a virtual network with machine DC (AD DC), Machine A and Machine B all on the same Domain.
On A I am running SSMS and I have 2 instance of SQL Server A1 and A2 and I can connect to both just fine. On the other machine B on the network I have another 2 instances of SQL Server B1 and B2. From A I can connect to B1 but not B2 and cant figure out why. Server services are running, browser is running,
SQLCMD -L on A shows
Server:
(local)
A1
A2
B1
B2

SQLCMD -L on B shows
Server:
(local)
B1
B2

I have read through numerous forums and nothing works. Any ideas?

Post #1396860

SQLing

Posted Sunday, December 30, 2012 5:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, March 02, 2013 1:14 PM
Points: 2, Visits: 31

I had to turn off firewall on B to allow the connection.

Post #1401275

« Prev Topic | Next Topic »

Permissions