I am a newbie.
I recently installed SQL Server 2008 on my server.
When I try to login, it does not show me any server when in Browse (see below)
What could be wrong?
Please let me know.
Asked
Active
Viewed 64 times
3 Answers
2
Check that the SQL Server Browser service is running on the server, and that your instances are also running.
MartW
- 1,305
- 10
- 15
0
Kindly Restart your server and make sure that your sql server services are running, also your instance services are running.
You can check that in SQL Server Configuration Manager.
Shaikh Farooque
- 101
- 2
-
Hi, I restarted the server and I still do not see anything in SQL Server Configuration Manager. What could be wrong? – meetpd May 31 '12 at 10:56
-
you must have stopped services in you SQL Server Configuration Manager other wise you have not installed SQL server on your server. – Shaikh Farooque May 31 '12 at 10:58
-
Just to let you know that when I click SQL Server Services in SQL Configuration Manager, I do not see anything there. What could be the issue? – meetpd May 31 '12 at 10:59
-
Which version of SQL server you have installed? – Shaikh Farooque May 31 '12 at 11:02
-
SQL Server 2008 – meetpd May 31 '12 at 11:02
-
It is not installed on your server. – Shaikh Farooque May 31 '12 at 11:03
-
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/11980/discussion-between-meetpd-and-shaikh-farooque) – meetpd May 31 '12 at 11:04
0
I installed SQL Server 2008 R2 Mangement Studio with Management Tools and that solved my problem.
(en_sql_server_2008_r2_express_with_management_tools_x86.iso)
meetpd
- 115
- 4
-
Probably that solved it because it will (if properly checked in setup) start your SQL Server Browser service, like CodeByMoonlight suggests. This is something to watch if installing/uninstalling instances of MSSQL, setup may turn on/off the Server Browser. – Gomibushi Jun 01 '12 at 12:34