Search code examples
sql-serverssmsssms-2017sqlbrowser

I cannot find SQL Server browser

I have installed SQL SERVER 17.

I'm trying to connect to a remote Database and I was not able to do so. After research, I found out that it requires the SQL Server Browser service to be started but I couldn't find the service in the SQL Server Configuration Manager

SQL Server Configuration Manager I also tried searching for missing SQL Browser Service. So, I tried reinstalling the SSMS but I couldn't find any option to select for SQL Browser. Also, I don't have the sqlbrowser.exe file at location 'C:\Program Files (x86)\Microsoft SQL Server\90\Shared\'. So, I guess it wasn't installed from the start.

sqlsever.exe not found

Any solution, on how to install the service?

EDIT 1 : This is the error message on the SSMS: SSMS Error Message

I have verified and made sure that the username and password is correct.

EDIT 2 : I tried to turn of my firewall and then connect with the server. But, I still got the same error. So, I tried to reinstall the complete SQL SERVER. During the installation, I selected the custom mode and selected the SQL Server Browser to be automatic. So, now I have it working. enter image description here

Now, still having my firewall disabled, I tried connecting to the SERVER, but still I got the same error. Now the question is why am I getting this error?

Final EDIT : Sorry for all the trouble but I have posted the answer to the problem, Thanks.

Solution

  • really sorry for the trouble.

    And the problem was a slash ( \ ).

    I spent couple of hours trying to figure out what's wrong with the connection and all that time I used SERVER / INSTANCENAME and everything else was perfect... and suddenly when I was searching online someone had made a same mistake and I looked at my hostname and it was wrong. It should be SERVER \ INSTANCENAME with a backslash ( \ ).