I have a server with 2 SQL Server instances (SQL 2000 and SQL 2005).
I can not connect to SQL 2005 but can connect to SQL 2000 from outside my network.
I've checked all the settings you mentioned:Remot e Connections Allowed, all protocols enabled,TCP/IP and Named Pipes connections allowed.
The thing I suspect is the sql server name as it's xxx.xxx.xx.xx/sqlserver2
while the SQL 2000 name is xxx.xxx.xx.xx only. Do you connect currently to your server with a backslash in the name?Can you tell me if I'm missing something?
I can not connect to SQL 2005 but can connect to SQL 2000 from outside my network.
I've checked all the settings you mentioned:Remot e Connections Allowed, all protocols enabled,TCP/IP and Named Pipes connections allowed.
The thing I suspect is the sql server name as it's xxx.xxx.xx.xx/sqlserver2
while the SQL 2000 name is xxx.xxx.xx.xx only. Do you connect currently to your server with a backslash in the name?Can you tell me if I'm missing something?
Comment