Connecting SQL Server on Different Port using Management Studio

We have installed two instances on one of server and while connecting from management studio default instance was getting connected as it was configured to run on 1433.

But another instance was configured to run on 1533 port and it was not getting connected from management studio so followed below steps to resolve it.

Step 1) Open Management Studio

( in Server Name specify instance name ,port no)

e.g. 127.0.0.1:1533

 

Step 2)

 

That’s All

 

Prashant Deshpande

 

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s