Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Microsoft SQL Browser Client [closed]

Tags:

sql

sql-server

Is there any free clients in which I can browse MS SQL Databases...?

like image 874
neolaser Avatar asked Mar 10 '11 22:03

neolaser


People also ask

Why is SQL Server Browser service disabled?

The service itself is disabled by default. In SQL Server Configuration Manager, go to Properties -> Service tab -> Start Mode = Automatic. Save this answer.

What happens if SQL Server Browser service is stopped?

If the SQL Server Browser service isn't running, you are still able to connect to SQL Server if you provide the correct port number or named pipe. For instance, you can connect to the default instance of SQL Server with TCP/IP if it's running on port 1433.

How do I stop SQL Server from auto closing?

In SQL Server Management Studio, you can right-click on each database, select “Properties”, and choose the “Options” tab. Set Auto Close to false and click OK.

How do I enable SQL Browser?

To start SQL Server Browser ServiceIn SQL Server Configuration Manager, in the navigation pane on the left, choose SQL Server Services. Right-click SQL Server Browser, and then choose Properties. On the Service tab of the SQL Server Browser dialog box, set the Start mode to Automatic.


2 Answers

Take a look at Microsoft SQL Server Management Studio Express

like image 67
Brandon Avatar answered Oct 24 '22 15:10

Brandon


Try HeidiSQL http://www.heidisql.com/ - it's open source and does both MSSQL and MySQL. It is very well featured.

(just a note as of Aug 2013 the author is working on MS Azure MSSQL access but it's not working yet)

like image 36
Robert Avatar answered Oct 24 '22 14:10

Robert