• Home
  • Cisco
  • Exchange
  • Linux
  • Navision
  • Network
  • Virtualization
  • Windows
  • About

    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.