Issue with Microsoft SQL Server template

[ealcaniz]

Hi there, I got a problem with SQL server template

http://docs.cacti.net/usertemplate:host ... :sqlserver

I imported template, modified password sql sentence and run in the servers. I added script with same password and install "yum install php-mssql", but there is not graphics pull out.

I can telnet port 1433 into servers that I am monitoring, means ports are open.

any idea?

in cacti.log file I don't find an error.

[nuzzy]

did you run the query on the SQL server to add the cactiuser?

[ealcaniz]

yes

/* SQL 2005/2008 */
USE [master]
GO
CREATE LOGIN [cactistats] WITH PASSWORD=N'CHANGEME', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'cactistats', @rolename = N'processadmin'
GO
CREATE USER [cactistats] FOR LOGIN [cactistats] WITH DEFAULT_SCHEMA=[dbo]
GO
GRANT SELECT ON [sys].[dm_os_performance_counters] TO [cactistats]
GO

I changed password in CHANGEME and put the same in the script ss_win_mssql.php