Post reply

Registering sqlserver instance

  • July 23, 2010 at 10:02 am

    #223676

    I have management studio installed on my machine and I have registered all the servers on my company domain. So if I wanted to work on some of the servers which are not in our company domain. I wanted to add these servers to my manage ment studio.

    How can I do this?

    Thanks.

  • July 23, 2010 at 10:51 am

    #1197629

    If there is no trust between the domains, you will not be able to use Windows Authentication for registering the server. Use SQL Server Authentication to register those servers in SSMS

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • July 23, 2010 at 10:55 am

    #1197635

    it all comes down to connectivity.

    for example, if a server is exposed to the internet, you can connect by IPAddress-comma-port instead of machine name: ie 209.191.122.70,1433 and then use a SQL username and password.

    if it's on a private network accross town or across the globe, you probably need a VPN connection to get you onto their network, and then you could use either server or IP accross the VPN to connect with SSMS.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 23, 2010 at 12:18 pm

    #1197671

    Thanks for your help.

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

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