0

I can log in to the server and connect to the instance of SSMS in the server but I can't connect to the same instance from other servers using ssms. how can I fix this?

1
  • What error are you getting? What user are you using to connect to the SQL Server instance from SSMS on the host server and what user are you using to connect from SSMS on the other servers? How is security set up for this (these) user (users)? Jun 3, 2014 at 12:24

1 Answer 1

2

Start by making sure that your Firewall isn't blocking incoming connections to port 1433 (if this is a default instance installation). Check both the Windows Firewall and also the settings on your network firewall ( if you have one configured ).

Also make sure that remote connections are enabled to the SQL server (in SSMS, right click the instance -> Properties -> Connections -> Allow Remote Connections to this server)

Not the answer you're looking for? Browse other questions tagged or ask your own question.