Re: Linked server connection using Windows Authentication
This is a discussion on Re: Linked server connection using Windows Authentication within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Apparently Windows Authentication with Linked Servers doesn't work with SQL Server 7.0 "Mike Stuart" <mstuart@gates.com> wrote in message news:03c701c341a0$b5285d00$a301280a@phx.gbl... ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:15 PM
| ||||
| ||||
 Re: Linked server connection using Windows Authentication Apparently Windows Authentication with Linked Servers doesn't work with SQL Server 7.0 "Mike Stuart" <mstuart@gates.com> wrote in message news:03c701c341a0$b5285d00$a301280a@phx.gbl... > I'm trying to create a linked server connection from a > SQL 7.0 (SQL70) server on DomainA to a SQL 2000 (SQL2K) > server on DomainB. I belong to a global group in DomainA > that is in the local admin group of the server in DomainB > hosting SQL2K, and therefore am also in SQL2K's > BUILTIN\Administrators group, and have 'sa' rights. > > I can get my connection to work if I authenticate to an > existing SQL login on SQL2K, but I get a variety of error > messages when I try to connect using Windows > authentication. I've even tried using an ODBC provider > string in 'sp_addlinkedserver' and also tried using an > existing DSN connection in the string. > > Any ideas? > > Thanks in advance, > > Mike Stuart >      |
 |
« odbc SPEC
|
ODBC drivers »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 12:11 AM.
