September 18, 2008 at 12:44 am
hi,
select * into [srvr1].COMPANYNAME_report.rfp FROM srvr2.COMPANYNAME_REPORT.dbo.rfp
i m creating a table from srvr1 to srvr2 using linked server .
while setting PROPERTIES in linked server in SECURITY tab
its giving error acces to remote server is denied bcoz no logging maping exists.error: 7416
Properties
Local Login: t2\sqlman
Remote user : sa
Pwd : *****
shud i have sam pwd for "sa" at srvr2
Please guide
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 18, 2008 at 10:24 am
Take a look at this link I think this is your problem
September 18, 2008 at 12:49 pm
bhuvnesh.dogra (9/18/2008)
PropertiesLocal Login: t2\sqlman
Remote user : sa
Pwd : bootsys
shud i have sam pwd for "sa" at srvr2
Yes. And you should never post actual passwords for admin accounts on the web.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 18, 2008 at 10:48 pm
hi thanks for ur advice but this is not actually login and password ......i know its crime 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply