Advertisement
When I try to setup the microsoft SQL Monitor, after I click on one of my instances, I get the login window, after I check the “Use Windows Authentication” i get the following error:<\/p>\n
Authentication failed. Check the login and password, and ensure that the server is configured for remote connections<\/p>\n
My question is where do I check the login and password?<\/p>\n
Thank you.<\/p>\n
HL<\/p>","upvoteCount":2,"answerCount":9,"datePublished":"2010-01-15T11:43:27.000Z","author":{"@type":"Person","name":"hlondono","url":"https://community.spiceworks.com/u/hlondono"},"acceptedAnswer":{"@type":"Answer","text":"
Ok, I found the answer, when setting up spiceworks to run as a service, I did not specify any account to run the service, as a result the spicworks picked a local account and it did not have access to a lot of my network resources, including SQL server, to fix the problem I put in the right credential to run spiceworks as a service and restarted the server, problem solved.<\/p>\n
HL<\/p>","upvoteCount":2,"datePublished":"2010-01-15T13:10:55.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/7","author":{"@type":"Person","name":"hlondono","url":"https://community.spiceworks.com/u/hlondono"}},"suggestedAnswer":[{"@type":"Answer","text":"
When I try to setup the microsoft SQL Monitor, after I click on one of my instances, I get the login window, after I check the “Use Windows Authentication” i get the following error:<\/p>\n
Authentication failed. Check the login and password, and ensure that the server is configured for remote connections<\/p>\n
My question is where do I check the login and password?<\/p>\n
Thank you.<\/p>\n
HL<\/p>","upvoteCount":2,"datePublished":"2010-01-15T11:43:27.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/1","author":{"@type":"Person","name":"hlondono","url":"https://community.spiceworks.com/u/hlondono"}},{"@type":"Answer","text":"
On the SQL Server open ‘SQL Server Enterprise Manager’<\/p>\n
Expand the tree until you get to the SQL Server in question then right click on it and select properties.<\/p>\n
Click on the Connections tab, and check ‘Allow other SQL Servers to connect remotely to this SQL Server using RPC’<\/p>\n
regards,<\/p>","upvoteCount":0,"datePublished":"2010-01-15T11:54:36.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/2","author":{"@type":"Person","name":"larrycrutchfield9438","url":"https://community.spiceworks.com/u/larrycrutchfield9438"}},{"@type":"Answer","text":"
I don’t see that option, I am using MS SQL Server 2008<\/p>","upvoteCount":0,"datePublished":"2010-01-15T11:59:35.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/3","author":{"@type":"Person","name":"hlondono","url":"https://community.spiceworks.com/u/hlondono"}},{"@type":"Answer","text":"
Oh sorry, you needed login and password help.<\/p>\n
Open the Enterprise Manager on the SQL Server, and browse to the Remote Servers option under the Security folder.<\/p>\n
in the right hand window, right click on the server and left click Properties.<\/p>\n
Let me know if that helped.<\/p>\n
Regards,<\/p>","upvoteCount":0,"datePublished":"2010-01-15T12:02:23.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/4","author":{"@type":"Person","name":"larrycrutchfield9438","url":"https://community.spiceworks.com/u/larrycrutchfield9438"}},{"@type":"Answer","text":"
I have SQL 2000 and 2005. I know that 2008 changed dramatically, not sure how to configure it…sorry.<\/p>","upvoteCount":0,"datePublished":"2010-01-15T12:07:21.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/5","author":{"@type":"Person","name":"larrycrutchfield9438","url":"https://community.spiceworks.com/u/larrycrutchfield9438"}},{"@type":"Answer","text":"
Ok, got more info, I think the problem is in spiceworks and not the SQL server, I use the SQL management studio remotly so I’m sure that side is correct, but when I ran a trace on the SQL server, I see a falied login from ‘domain\\spiceserver1$’ user, which does not have access to SQL, is there any way that I can change spice works to use my login info instead of the spiceserver1 user?<\/p>","upvoteCount":0,"datePublished":"2010-01-15T12:18:57.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/6","author":{"@type":"Person","name":"hlondono","url":"https://community.spiceworks.com/u/hlondono"}},{"@type":"Answer","text":"
This is just what I needed. I was having the same problem. Thanks a ton!<\/p>","upvoteCount":0,"datePublished":"2011-04-07T12:38:41.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/8","author":{"@type":"Person","name":"jasonsimone1426","url":"https://community.spiceworks.com/u/jasonsimone1426"}},{"@type":"Answer","text":"
Excellent…I was wondering what I had missed. Cheers Ian<\/p>","upvoteCount":0,"datePublished":"2011-09-14T03:58:04.000Z","url":"https://community.spiceworks.com/t/microsoft-sql-monitor-authentication/39552/9","author":{"@type":"Person","name":"ian6866","url":"https://community.spiceworks.com/u/ian6866"}}]}}