Topics > SQL Connections > FAQ ID # 45

FAQ ID # 45
Last Update : 2015/10/20
Print this FAQ

Question / Issue
SQL Connections

Answer / Solution

TCP/IP port numbers required to communicate to SQL over a firewall.
http://support.microsoft.com/kb/287932

How to configure SQL Server to listen on a specific port
http://support.microsoft.com/kb/823938

Understanding MS SQL Server Named Instance Connections
http://www.compiledthoughts.com/2009/04/understanding-ms-sql-server-named.html

Normal naming conventions for SQL Server used in Connection Strings:
http://www.connectionstrings.com/sql-server-2008

  • SERVERNAME, e.g. "myserver"
  • SERVERNAME\INSTANCENAME, e.g. "myserver\workgroup"
  • SERVERNAME,portnumber, e.g. "myserver,1999" if using non-standard ports
  • SERVERNAME\INSTANCENAME,portnumber
    In each case, SERVERNAME can be replaced with the IP address, if the servername will not resolve or just as an alternative, e.g. 165.24.21.225\SQLExpress,1999

    SQL Server Troubleshooting and Support
    http://msdn.microsoft.com/en-us/sqlserver/bb895923.aspx

    Setting Up Windows Service Accounts
    http://msdn.microsoft.com/en-us/library/ms143504(v=SQL.105).aspx#Use_startup_accounts
    Scroll down to: Using Startup Accounts for SQL Server Services

    		•


    Direct Link to This FAQ
    http://kb.hogandata.com/?f=45

    Back to Top