For some reason, now I cannot connect to my SQL Server 2008 server remotely. I can login locally, but I get Error 1326 that I cannot connect to the server. SQL Browser is running, firewall ports were opened (I used the script given in Microsoft support link and verified on the server), TCP/IP, named pipes, and shared memory are enabled.
Any idea why I still cannot access it? I'm trying to connect from my laptop over a workstation.
Thanks.
Best Answer
By default, SQL Server will only allow the local connections. You'll have to run the Surface Area Configurator tool to open it up to allow the remote connections as well.
[edited later]
I stand corrected. SAC is gone with SQl Server 2008.
More details at the SQL Server Configuration Manager page in MSDN.