Solved

Linked Server Question

Posted on 2007-12-05
5
148 Views
Last Modified: 2010-03-19
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
Comment
Question by:PeterErhard
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:imitchie
ID: 20417247
Are you using Query Analyzer?
0
 

Author Comment

by:PeterErhard
ID: 20417263
No, when creating a linked server through Management Studio in SQL 2005.
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20417351
I am fascinated! Where is it in there so that I may look? I have only used T-SQL to link servers..
0
 

Author Comment

by:PeterErhard
ID: 20417373
Under Server Objects / Linked Servers
0
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20417415
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to use TOP 1 in a T-SQL sub-query? 14 45
TSQL mapping detailed records to group records 9 52
Help  needed 3 25
Loops and updating in SQL Query 9 29
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question