March 17, 2008 at 11:29 am
hi ,
plz tell me how can we connect from one server to another server .
March 17, 2008 at 11:59 am
Look up the topic "Linked Server" in the Books Online. That will get you started.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2008 at 12:28 pm
And the most important tip for using Linked Servers: SQL Logins are a whole lot easier to get working than NT Logins.
[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]
March 17, 2008 at 12:47 pm
Not disagreeing, but I'd say the biggest tip would be to find some other method because they become a glaring security hole. But, if you absolutely, positively have to communicate between servers, it's the way to go.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2008 at 1:03 pm
Not disagreeing either, but what aspects would you say were the "glaring hole" parts?
[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]
March 17, 2008 at 1:28 pm
Just that when you set up a linked server its available to every database and every user (that has the password, assuming you don't cache it in the connection, making it even worse). Scary stuff from a security standpoint.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2008 at 2:05 pm
As I recall, you can be pretty specific about which local logins get mapped to which remote users. And you can set the default to deny access unless a local user is defined in the access list.
[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]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply