• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

Linked Server Question

When creating a Linked Server, and you select SQL Server, you have to enter the Name of the SQL Server as the Name of the Linked Server. Is there someway around this, without having to click Other and specify the username & password in plain text in the Provider String textbox?

0
PeterErhard
Asked:
PeterErhard
  • 3
  • 2
1 Solution
 
imitchieCommented:
Are you using Query Analyzer?
0
 
PeterErhardAuthor Commented:
No, when creating a linked server through Management Studio in SQL 2005.
0
 
imitchieCommented:
I am fascinated! Where is it in there so that I may look? I have only used T-SQL to link servers..
0
 
PeterErhardAuthor Commented:
Under Server Objects / Linked Servers
0
 
imitchieCommented:
When I clicked on "New Linked Server", you type the "Linked Server" name.
Then Server Type should be SQL Server.
Then on the left, click on Security, and on the right, click Add.
The password is NOT in plain text!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now