Results 1 to 3 of 3

Thread: Database Access

  1. #1
    Join Date
    Dec 2006
    Location
    Mumbai, India
    Posts
    2

    Question Unanswered: Database Access

    Dear All,

    I Have two SQL Server ABC and XYZ and i have changed the SA password of both the servers.

    I have added link server on the both the servers.

    When i execute a link server query in a SQL Query Analyser on either server it works, but when i use the same query in a job, then it fails.

    So anyone can help in the above problem.

    Regards,
    Vinayak

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    The sql server service accout needs to be granted authority
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2006
    Location
    Mumbai, India
    Posts
    2

    Smile

    Hello,

    Can u help me in the same.........

Posting Permissions

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