and getting a Remote Connection working.
Remote Access Part 1 ODBC Remote Connections Configuration
Remote Access Part 2 Allow the remote Connections
.. during the install, then the setting should be OK and you will not need to perform the setting change described here.
Another thing to check is the property screen within SQL Server Management Studio Express. Right-Click on the Server name in the Object Explorer screen, and select Properties. Then select the Connections (1a) section. Ensure that “Allow remote connections to this server” is checked [x]. 1b
Expand the Services and Applications tree, and then the SQL Server
configuration Manager. Select the SQL Server 2005 Services and ensure that both the SQL Server and the SQL Server Browser are running. If not, then you will not connect!
If you have changed any network configuration settings for the SQL Server, it should be stopped and restarted. In the above screenshot, you can simply right-click the SQL Server and select ReStart. This may not work if you do not have sufficient rights.
it back on after testing.
Also, see if you can access the Server using the Windows Explorer/My Network Places/…..
The files you need to add to the Exceptions list in your Firewall settings on your Server are: sqlservr.exe and sqlbrowser.exe Maybe I should have placed this first in the list of things to check, but hey, you are a programmer right? And the Server IS running, right?
- SQL Connection String with IP Addressing
Lets assume that the IP Address for your Server is 192.168.1.30
that SQL Server is now listening on that IP at Port 1411
You want to connect to the database NorthWind
The connection UserName with SQL Authentication is Fredand Fred’s password is pa$$wordThe connection string you would build would look like…“192.168.1.30,1411”,NorthWind,Fred,pa$$wordNote the IP address,port is enclosed in double quotes because of the embedded comma.
Authentication ModeIf you want to use Mixed Mode Authentication, (so you can logon with a SQL username and password i.e. the sa logon) then you may need to reset the Authentication mode. By default, whilst installing Windows Authentication mode is set.For this you need the SQL Server Management Studio Express installed. It may already be on your menu…To get the Studio Express from Microsoft, the MS download link is…(about
43 Megs)(This requires MSXML 6.0 which may already be on Windows machine if you have recent updates.Once Studio Express is installed, only then can we switch on the MixedMode connections to the database…Start StudioExpress, right-click the Server in the left hand pane, and select properties to get this screen..Set the Server Authentication as shown above.That should be all that is needed, apart from a Stop and restart of the service.If whilst installing, Windows Authentication mode only was set, you now need to enable the sa user. This user was created during the install, but was set to disabled.Open a New Query window (button just above the Object Explorer left side) and enter the below sql commands.. but of course replace the <password> shown here with a strong password of your own. Make sure it can be found/remembered when needed.ALTER
LOGIN sa ENABLE ;GOALTER
LOGIN sa WITH PASSWORD = ‘<password>’ ;GO============================================That should get you up and running.John Griffiths