Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Red face Unanswered: Linking SQL Enterprise with Standard

    Hi all I am having a hard time linking two servers together one is
    GCSQL and the other is GCSQLTEST. I go to Server objects then right click then Link Server then I type in GCSQLTEST where it says link server. then click ok and I get an error message. what am I doing wrong, as you can see I am new at this. Can someone help please

  2. #2
    Join Date
    Mar 2009
    Location
    Australia
    Posts
    113
    What is the error message?

    Can GCSQL see GCSQLTEST on the network? (Can you ping it by name)

    Are you selecting SQL server as your server type or "Other data source"

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Yes I am selecting sql server as my server type

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by EngadaSQL
    What is the error message?

    Can GCSQL see GCSQLTEST on the network? (Can you ping it by name)

    Are you selecting SQL server as your server type or "Other data source"
    I was able to ping it successfully by name . and when I try to link this is the error message I get


    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    "The linked server has been created but failed a connection test. Do you want to keep the linked server?"

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    The OLE DB provider "SQLNCLI" for linked server "GCSQL" reported an error. Authentication failed.
    Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "GCSQL".
    OLE DB provider "SQLNCLI" for linked server "GCSQL" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)

    For help, click: Source: MSSQLServer ID: 7399 (SQL Server 09.00.3077) - Events And Errors Message Center: Message Details

    ------------------------------
    BUTTONS:

    &Yes
    &No
    ------------------------------

  5. #5
    Join Date
    Jun 2009
    Location
    CA, USA
    Posts
    59
    Make sure remote connections are enabled.
    And also try to connect from the source server using sql login and/or windows loging to remote server through Query window.
    MohammedU
    SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •