MS SQL Server 2005 and Remote Access
Need to access your SQL server from another computer?
Configuration in SQL Server Management Studio
Click “All Programs” –> Click “Microsoft SQL Server 2005” –> click “Microsoft SQL Server Management Studio”.
Log in to SQL Server 2005 with windows authentication or sa user.
Highlight the server and right click “Properties”.
Highlight “Security” –> Under âServer authentication”, choose “SQL Server and Windows authentication mode”.
Highlight “Connections” –> Under “Remote server connections”, choose “Allow remote connections to this server”.
Configuration in SQL Server Surface Area Configuration
Click “All Programs” –> Click “Microsoft SQL Server 2005” –> click “Configuration Tools” –> click “SQL Server 2005 Surface Area Configuration”.
Click “Surface Area Configuration for Services and Connections” -> click “MSSQLSERVER” –> click “Database engine” –> click “Remote connections” -> Under “Local and remote connections”, choose “Using TCP/IP only” or other protocols.
Remember the “SQL server browser” service. It it ussed when connected from the outside.
