July 24, 2014 at 8:48 am
I'm not a network guy at all and not the best at SQL to be honest. I'm setting up a new environment with an app server and a database server. I can remote from one to the other, I can ping from one to the other, I am behind an external firewall so I've disabled Windows Firewall on both. I've enabled remote connections on the SQL database, but when I try to connect through Management Studio from the app server to the database via IP or server name (e.g. xxx.xxx.x.x\SQLEXPRESS or servername\SQLEXPRESS I get a server not found or not accessible error. Any thoughts on what might be blocking me still?
July 24, 2014 at 8:57 am
Can you telnet to the database server from the app server on the port the SQL Server instant is listening on? It's also worth bearing in mind that this is a named instance so will communicate with the SQL Browser service (if it's running) to get the port this instance is listening on, which it does do over UDP port 1434.
July 24, 2014 at 9:02 am
The SQL Browser Service was off that seems to have been the issue thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply