Is there any free clients in which I can browse MS SQL Databases...?
The service itself is disabled by default. In SQL Server Configuration Manager, go to Properties -> Service tab -> Start Mode = Automatic. Save this answer.
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.
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.
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.
Take a look at Microsoft SQL Server Management Studio Express
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With