Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 100
  • Last Modified:

Solar Winds can't see SQL Server Express

I'm trying to install an evaluation instance of Solar Winds to monitor my network.  I put SQL Server Express on a separate machine, in the same domain as the Solar Winds machine.  I installed SQL Server Express with the Basic installation, using all the defaults.

But now when I'm trying to configure Solar Winds, it can't see my SQL Server instance.  What am I missing?

Both machines are on the same subnet and belong to the same domain.  DNS is working.

Screen snaps are attached.SQL-Server-screen-snaps.pdf
0
Dwight Baer
Asked:
Dwight Baer
5 Solutions
 
gheistCommented:
localhost needs TCP
\\.\SQLEXPRESS uses local pipe
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's the SQL Browser service running?
0
 
Dwight BaerAuthor Commented:
Sorry I'm an absolute beginner with SQL Server:

Neither the SQL Server Agent nor the SQL Server Browser are running.

See the last page on the attached.

SQL-Server-screen-snaps-more.pdf
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The screenshot doesn't help.
SQL Server Agent doesn't work for SQL Express.
Start SQL Server Browser service and see if it helps.
0
 
Dwight BaerAuthor Commented:
Sorry gheist ... I didn't understand your answer.  

Are you saying that I need to install TCP - Is there something not installed in my server  environment?  If so ... In Server Manager, how would I install TCP?
0
 
Dwight BaerAuthor Commented:
Vitor ... I did manage to start the SQL Server Browser.  Then, in my Solar Winds VM, I cancelled out of the SolarWinds configuration Wizard and re-started it, in order to refresh it.  But it still doesn't see my SQL Server.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry, I just realized that you attached a set of screenshots and not a single one. You can use the "Insert Image" option to post a screenshot. It will be more easier for us to see the images.

Anyway, did you try to type the SQL Server instance name instead of expecting it to appear in the list?
0
 
ste5anSenior DeveloperCommented:
SQL Server Express does not listen to remote per default..
0
 
Dwight BaerAuthor Commented:
OK, progress:  I turned off the firewall on my SQL Server VM (SQL-VM), and now the Solar Winds VM (SW-VM) can see my instance of SQL Server.  Yeah!  But I don't know what user to use ... I don't remember setting up a user in the SQL Server Express "Basics - just the defaults" installation.

Sorry ... "Insert an image" needs a .jpg image I think, it doesn't access a screen-snap from my clipboard.  I've attached another pdf file.

No-SQL-User-error.pdf
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
So you had a FW issue. Now you have a login issue.
During the SQL Express installation, there was a step where you should add the necessary logins to the SQL instance. If you added none then you don't have any login to be used.
Did you provide the 'sa' password? If affirmative, then use the 'sa' credentials.
If negative, try to use Windows Authentication mode.
0
 
Dwight BaerAuthor Commented:
I've tried sa ... admin ... administrator ... sql-vm\administrator (which is what the "Success" screen said was the name of the SQL administrator.

I think I'm going to go ahead and install SQL Server Express on the same VM as where Solar Winds is.  Not ideal, but I'm sure I'll learn something.  I'll take a snapshot first.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I think I'm going to go ahead and install SQL Server Express on the same VM as where Solar Winds is.
Try to uninstall and reinstall again the SQL Express and be sure that when requesting for logins you add one that can be used later by Solar Winds.
0
 
Dwight BaerAuthor Commented:
I'm installing Solar Winds in the SQL Server machine.  Then off for the weekend.  Thanks for the help.  I'll let you know next week how it went.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Dwight, any feedback for us?
0
 
Dwight BaerAuthor Commented:
So sorry.

The problem was, SQL Server Express has to be installed on the same machine.  Once I put everything on the same machine, everything worked.  Thanks a lot for your help.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The problem was, SQL Server Express has to be installed on the same machine.
Looks like Solar Winds is trying to connect to local instance then. Will be good to know if this is the default behavior and if it can be changed by some kind of configuration set.
Anyway, you can close this question by selecting your last comment as solution.
0
 
Dwight BaerAuthor Commented:
Thanks a lot!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now