December 29, 2008 at 11:47 pm
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
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
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
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
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.
December 30, 2008 at 9:09 pm
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