Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Help needed on SQLServer , Error 18456

    Hi All,

    I have tried accessing a remote database in one of by stored procs using linked servers and also using OpenDataSource method.
    In both the cases , I am getting login failed error.

    Following is the stored proc :

    CREATE PROCEDURE TEST AS

    SELECT *
    FROM OPENDATASOURCE(
    'SQLOLEDB',
    'Data Source=blrkec3432s;User ID=xyz;Password=xyz').LMC.dbo.STATE
    GO


    It works fine if the userid is 'sa'

    Could anyone please tell me the reason for this.

    Thanks,
    Shanthi

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Resolution from SQLMAG link
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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