Windows – SQL Server 2008 R2 – Cannot Connect Remotely (Error 1326)

remotesql-server-2008-r2windows 7windows-server-2008-r2

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.

Beginning in SQL Server 2008, the Surface Area Configuration tool has been removed. The features of the Surface Area Configuration tool that control SQL Server behavior have been replaced and greatly enhanced in the Policy-Based Management feature. [...]

The connectivity management features of the Surface Area Configuration tool are available by using the Configuration Manager tool. For more information about this tool, see SQL Server Configuration Manager.

More details at the SQL Server Configuration Manager page in MSDN.

Related Question