1 2 3 Previous Next 37 Replies Latest reply on Nov 7, 2011 10:10 AM by David Hawkes

    Creating a linked server for the BMC BladeLogic

      Share This:

      I having an issue creating the Linked Server for BDSSA. Getting the following error

       

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

      The test connection to the linked server failed.

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

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

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

      Login failed for user 'bladelogic'.
      OLE DB provider "SQLNCLI10" for linked server "DB_SITE1_LINK" returned message "Invalid connection string attribute". (Microsoft SQL Server, Error: 18456)

      For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

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

      OK
      ------------------------------

       

      The account is right i can log into SQL using it.

        1 2 3 Previous Next