SQL Server Enabling Remote Login

Hi Guys ,
It doesn't always click or remember exactly what needs to be done when struggling to connect from remote SQL Server Client .

With Very little to do, we can get this going .  See below and try it yourself ;)

On the Server start Management Studio and open a query window  , execute below code as follows :

use master ;
EXEC sp_configure 'remote admin connections', 1;
GO

RECONFIGURE
GO

Comments

Popular posts from this blog

SQL SERVER – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

SQL Server Builds Information

Using DBCA silent install and disabling automatic memory management