PROBLEM:
Unable to connect to named instance via remote SQL Server Management Studio connection. When launching SQL Server Management Studio on the local SQL Server (SQL 2005 Server), it connects just fine. When attempting connection via remote client to the default instance (using port 1433), it connects fine with both SQL and Windows Authentication...but remote connection to the named instance fails, for both SQL and Windows authentication.
The fact that it connects to the default instance via remote connection rules out possible DNS issues; it seems like it's port related but everything is inside of our firewall and we do not have any Windows firewalls running on anything.
Note that we did try to setup the named instance to start using dynamic IP addresses via SQL Server Configuration Managment tool but even after stopping the default instance, changing the named instance to start on port 1433, starting the named instance back up successfully, remote connection still fails with Management Studio. No errors being reported in Event Viewer anywhere. We've even tried re-installing the named instance to no avail. Again, connecting to the default instance via Management Studio remotely works fine...it's just the named instance that fails.
Has anyone else run into this? Any suggestions or what to try next? Thanks in advance.
Unable to connect to named instance via remote SQL Server Management Studio connection. When launching SQL Server Management Studio on the local SQL Server (SQL 2005 Server), it connects just fine. When attempting connection via remote client to the default instance (using port 1433), it connects fine with both SQL and Windows Authentication...but remote connection to the named instance fails, for both SQL and Windows authentication.
The fact that it connects to the default instance via remote connection rules out possible DNS issues; it seems like it's port related but everything is inside of our firewall and we do not have any Windows firewalls running on anything.
Note that we did try to setup the named instance to start using dynamic IP addresses via SQL Server Configuration Managment tool but even after stopping the default instance, changing the named instance to start on port 1433, starting the named instance back up successfully, remote connection still fails with Management Studio. No errors being reported in Event Viewer anywhere. We've even tried re-installing the named instance to no avail. Again, connecting to the default instance via Management Studio remotely works fine...it's just the named instance that fails.
Has anyone else run into this? Any suggestions or what to try next? Thanks in advance.
