Home / server / Questions / 169021
In Process
agilenoob
Asked: 2010-08-11 12:20:54 +0800 CST

Spiceworks SQL Monitor cant authenticate

  • 772

I have SpiceWorks 4.7, installed and added the sql monitor extension to monitor our SQL servers. It does identify our sql servers correctly, but when I put the login information in it can't authenticate, with the following error message.

Authentication failed. Check the login and password, and ensure that the server is configured for remote connections.

I get the same result trying to use windows authentication.

WE do use an alternate port# could this be the problem?

monitoring sql performance-monitoring

1 Answers

  1. Try this two things:

    1. Make sure to enable allow remote connections on the target server.

    2. Make sure the firewall is opened to allow connections through your new port.

    3. Try to login using YourServerName,1433 as user name instead of only using YourServerName. (don't forget to change the port number 1433 with your port number.)

    Also make sure mixed mode authentication is on and TCP\IP is enabled on the target server. Good Luck

    • 0