Linking Servers in SQL Management Studio

I forgot to mention that I am working with Microsoft SQL Server Management Studio to link the two databases. I don't want to do like most and leave out critical information by assuming everyone knows the extraneous details when describing the method of working with SQL databases.

To link to SQL Server (in my case, jn-svrdev1-vma7\sql2005), I did the following:

1. I expanded the Server Objects tab located in the Object Explorer of my database.
2. I then right-click Linked Servers and select New Linked Server.
3. Under Select a page, select General.
4. I select SQL Server
5. Type in jn-svrdev1-vma7\sql2005 in the Linked server textbox.
6. Under Select a page, select Security.
7. Select Be made using the login's current security context
8. Select Add button
9. Under Local login, select your user login id
10. Select OK

You should now be linked to this database.