Sunday, April 11, 2010

SQL Server remote connecting problem

Issue: can't connect to sql server,

fix:
open the port http://support.microsoft.com/kb/968872
or http://support.microsoft.com/kb/914277
enable the remote connection in the properties using management studio
enable tcp/ip in configure manager

to add user
use management studio -> security

No comments: