Post reply

Linked server is not connecting.

  • December 29, 2008 at 11:47 pm

    #129507

    Dear All

    Error in attachment:

    Please find attachment.

    I am making linked server connection with sql server2005 name as Raj1,

    here nic4260 is my windows userid under NIC domain.The Raj1 server is also in same domain and in LAN with my server named AjayG/Ajay.

    AjayG------>Raj1

    Error is in attachment,Login server properties in attachment.

    By sa user it is working.what permission is missing for windows account.

    Please tell me that linked server properties clearly in detail.

    Thx

    Thanks

  • December 30, 2008 at 12:48 am

    #918813

    Dear Friend!

    first check that the Raj1 1 is added as linked server if not then run sp_addlinkedserver 'server name'. and if it already exist then check user athentications on sql server and give the sysadmin to nic4260 and if this is exist then check his windows account and create windows account for this user.

    Regards,

    Yousaf Khan:)

    +923335797097

    Pakistan

  • December 30, 2008 at 12:56 am

    #918818

    If you are testing the Linked Server it is attempting to connect using your security Principal, not NT AUTHORITY\SYSTEM. So you either need to add your local login to the login mappings.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • December 30, 2008 at 2:01 am

    #918859

    Dear

    nic4260 has all sysadmin permissions,and it is already windows user,I have made a dummy user 'test' in Raj1 but it is still not connecting.

    Thx

    Thanks

  • December 30, 2008 at 7:02 am

    #919015

    You are specifying a remote login which is a sql account, you state that this is your domain account, this won't work.

    Given the method you are attempting to use you will need to setup a remote SQL login.

    Your use of the NT AUTHORITY\SYSTEM account is interesting, do you have SQL running under this account? Why not change the authentication model to use the current security context, remove the mapping above and change the NT AUTHORITY\SYSTEM account to an account that has access on the other machine (assuming that you are running this via a job).

    Currently the only way the linked server would work is if you are logging in using the NT AUTHORITY\SYSTEM account, which I very much doubt is the case, and that there is a remote SQL user that matches the account information that you have entered. If this is not the case then there can be no connections as you have specified that there be no security passed if it uses any other than the NT AUTHORITY\SYSTEM account.


    Shamless self promotion - read my blog http://sirsql.net

  • December 30, 2008 at 9:09 pm

    #919422

    Dear Nicho

    You are right...

    Thx

    Happy New Year

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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