I just intalled sql server 2005 on a windows 2008 64 bit server.
everything looks OK. It's using windows authentication.
I can connect to the server from management studio locally. But I cannot connect to this sql server from other sql server remotely.
I got an error:
cannot connect to the sql server:
A network-related or instance-specific error occurred while establishing a ... The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL ...
I checked the sql server browser is running, remote connection is enabled. Tcp/IP protocal is enabled.
The service account has access to the sql server.
What could be wrong?
I have no problem to connect to other sql server on our network.