Monitoring SQL instances and using SQL based plugins

SQL Connectivity

Our production environment demonstrates that these plugins work with SQL Servers with tcp-ip connectivity and both Windows and Mixed (SQL) Authentication.

Named pipes (Instance) connectivity is supported as well.

Incase the PRTG probe and target servers are not in the same domain structure using SQL based authentication is the only viable solution:

In many cases you need to allow Mixed authentication and a create a SQL user:

The following instructs the needed actions:

Start Admin Command Line:

c:

cd C:\Program Files\Microsoft SQL Server\MSSQL11.VEEAMSQL2012\MSSQL\Binn

SQLCMD -S localhost\VEEAMSQL2012


Enter:

USE master
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO
CREATE LOGIN PRTGMonitor WITH PASSWORD='@PassW0rd1', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
EXEC sys.sp_addsrvrolemember 'PRTGMonitor','sysadmin'
GO
exit

Then Restart SQL Server Services....