Post reply

Connecting a SQL server instance

  • April 5, 2012 at 7:00 am

    #254451

    Am having two systems, SYS1 and SYS2, both system have sqlservers installed on them with same name 'SQLEXPRESS', my problem is,

    System SYS1 has a public ip address, but SYS2 does'nt ,

    but i want to access database installed on SYS2 via SYS1, bcoz SYS1

    has been assigned the public ip,

    here is the connection string which i am using to connect:

    //<ip address>:1433/SQLEXPRESS this will access Database in SYS1

    but which connection string should i use to access Database on SYS2

  • April 5, 2012 at 7:37 am

    #1469498

    You could use either the server name of the IP address.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • April 5, 2012 at 7:44 am

    #1469512

    there are 3 ways to do this. the best depends on what exactly you are trying to get from server 2.

    1. add server 2 as a linked server on server 1 and query server 2 - not good if the database on server 2 has nothing to do with server 1

    2. get remote access (VNC or some other method) and query server 2 from ssms (or some other program)

    3. get another external ip and assign it to server 2.

    if you give more details we may be able to point you in the right direction.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply