I been trying to connect to my main Solarwinds server with the swql studio. I setup an individual windows account in Solarwinds with my company’s AD. I keep getting a connection error unable to connect to information service. An error occurred when verifying for the message. I checked and stopped and restated the Solarwinds information service and Solarwinds information service 3. It still will not connect from my laptop to the server or on the local Solarwinds server.

Super old I know, but I was getting the same message. As it turns out, I was trying to connect management studio to the server the database was on. Since the studio is making all requests through a web service I was able to connect by doing the following:

1. Connect to the machine which has the Tools on it NOT the database server (the name of the management studio is very misleading.)

2. Make sure your account has access to run things as admin3. Connect to NPM Website add your account to the users (Even if you are already in a group, add your AD account specifically) If your in the Admin group, just add your account with all the same permissions. 4. From your local machine make sure you can telnet into the box with the NPM tools. Ping does not matter as you cannot specify port. *Note* when you run the telnet test, you do not have to login. If you get a response on that port, you are good to go.

5. Connect SWSQL Management studio using AD

Resolution steps: Issue on step 1 -> make sure machine allows remote connections, and you are granted access to the box with local admin rights. Issue on step 2 -> previous answer will fix any issues on step 2Issue on step 3 -> If you cannot add users, or add all permissions to a user you are not in the admin group and need to be added. Issue on step 4 -> If you do not get a response from the box check you are added to the machine, make sure RDC is enabled, and port 17777 is open and communicatingIssue on step 5 -> Go back to 1-4

If screen shots on any steps are required. @ me and I will be happy to help. *Note* if you are a DBA, Database Engineer, or someone working exclusively in SQL this is NOT management studio. If you have access to the SQL server itself this can be a great tool for exposing properties etc but for raw view of the data, its better to use SQL server. One example / reason i can give off the top of my head. SWQL studio does NOT know that a NodesData table exists. SQL Server does. So if you are looking for a great property / node mapping view SWQL is awesome, if your looking for a deep dive use SQL Server (or whatever your RDBMS management studio is)

Actions

More Like This

Incoming Links

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 130,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining.