Configuring SQL Server Express 2005 For Remote Connections
SQL ServerThis is a reference guide to change the settings in SQL Express Server to allow remote conections. I found most of my information at http://www.datamasker.com/SSE2005_NetworkCfg.htm , and I will be trying to simplify what is said there.
- Configure SQL to use TCP/IP connections as well as local connections in the Surface Area Configuration Utility.
Select the Services and Connections section.
Under Database Engine -> Remote Connections choose to use local and remote connections (TCP/IP only or TCP/IP and named pipes). You can also do this in the SQL Server Configuration Manager tool under:
SQL Server 2005 Network Configuration -> Protocols for SQL Express - Now restart/start the SQL Server service.
- You now need to configure Windows Firewall (only if you have it running) to exempt SQL Server and SQL Server Browser. To do this you simply need to add sqlservr.exe and sqlbrowser.exe to the exceptions.
The files can be found at:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe.
You should have a successfully configured SQL Server, so start trying to connect to it remotely. If you are still having issues it may be necessary to restart the computer for all changes to take place.
Craig.
Add Comment
Query Analyzer Auto-Complete...Woot!
SQL ServerThis is something I've wanted for a very long time, but did not have the room in my budget to purchase a tool for.
A company called Red Gate (http://www.red-gate.com/products/SQL_Prompt/index.htm) has a nice piece of software that provides a whole bunch of features for SQL Server and looks to be very much worth its $195.00 price tag.
Apparently though, they released an older version of their tool for free that is still available here:
http://www.bustercollings.com/...
If you've been dreaming for autocomplete in Query Analyzer, then definitely check this thing out. It is a little annoying that it does have to make a seperate connection to the SQL Server to get the database metadata, but very quick and painless. And it makes it so easy to get all your tables / columns while you type.
Enjoy!
Mike.
Loading....