Solved

How do you correctly link two SQL Servers with Domain

Posted on 2007-03-19
3
188 Views
Last Modified: 2010-03-19
I need to know how to correctly link two SQL servers in this environment.

PC #1
SQL Server 2005 x64
Windows 2003 Server Ent ed (domain controller)
Mixed Mode Authentication

PC #2
SQL Server 2000 SP4
Windows 2003 Std Ed (member server)
Mixed Mode Authentication

What I need is to link the two servers together so users can query across the PC's.  I currently can query some from PC #1 to PC #2, but with limited results.   This is based on SQL authentication not Domain.   How do you set up the domain authentication to work correctly?
0
Comment
Question by:pamsauto
  • 2
3 Comments
 
LVL 10

Expert Comment

by:TAB8
ID: 18751544
Set up PC2 as a linked server on PC1 ...
http://msdn2.microsoft.com/en-us/library/aa213778(SQL.80).aspx 
also check ..
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332&Product=sql to setup the correct dtc security on PC1
0
 

Author Comment

by:pamsauto
ID: 18752014
Well we have all that done and I can do a query from the PC#1 to PC#2, but not from PC#2 to PC#1.  I am getting this error, which I can find very little about on the web.

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.  
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005:   ].

Any ideas on what to check?
0
 
LVL 10

Accepted Solution

by:
TAB8 earned 500 total points
ID: 18753475
You will have to set up a linkes server on PC#2 to PC#1 as well if you want to query both ways
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
create an aggregate function 9 36
How to construct an if else statement from existing code 6 21
Increment column based of a FK 8 23
Proper Case SQL Command 2 12
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

803 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