connect to SQL database via an IP Address

Your SQL Server is installed as named instance, so first of all try connecting to your server using the following server name: IP Address\SQLEXPRESS.

When you install SQL Server as named instance it uses dynamic TCP/IP ports by default, so it is not possible to connect to it whitout specifying instance name (just IP address). If you need to connect to your server without using instance name you have to reconfigure your server to use static TCP port. To do it please perform the following:

  1. open SQL Server Configuration Manager;
  2. switch to the SQL Server Network Configuration | Protocols for SQLEXPRESS;
  3. double-click the TCP/IP protocol;
  4. select the Yes value in the Enabled field;
  5. switch to the IP Addresses tab;
  6. find the IPAll section;
  7. clear the TCP Dynamic Ports field in that section;
  8. specify the 1433 value in the TCP Port field:

Post a Comment

1 Comments

  1. Hard Rock Hotel & Casino TulsaHard Rock Tulsa
    Hard Rock Hotel & Casino Tulsa is the 1 1 토토 ultimate destination for 아시안부키 gaming and 카판 entertainment, featuring more than 2600 baoji titanium electronic 카심바 games, a popular music venue,

    ReplyDelete