Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
linked server setup
Going from server1 to server 2 is much easier. You can just create a sql server login on server 2, give it the appropriate rights. Then on server 1 create a linked server and then on the security tab select the option for be made using this security context and use the sql server login that...- allware
- Post #6
- Forum: Microsoft SQL Server: Setup and Administration
-
linked server setup
I solved this situation myself a few days ago, sorry for not posting the answer sooner. I did not have to change my server to sql authentication. Here is what I did. I created a system DSN connection to my server(server1) on t remote server (server2). I then changed server2 service account...- allware
- Post #5
- Forum: Microsoft SQL Server: Setup and Administration
-
linked server setup
Just wanted to add a little more to the description to help make sure my question is as clear as possible. User will log call stored procedure on Server 2 being authentication with a SQL Server login, the stored procedure needs to then make a call to Server 1 which is NT Authentication only.- allware
- Post #2
- Forum: Microsoft SQL Server: Setup and Administration
-
linked server setup
I have 2 sql servers that I need to link together. Server 1 has the following details: Windows Authentication Only NT Domain (cannot upgrade to Active Directory at this time) SQL Server 2000 Server 2 has the following details Mixed Authentication Active Directory SQL Server 2000 I am need...- allware
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Setup and Administration
