March 20, 2008 at 12:38 pm
I'm trying to create a linked server on a SQL Server 2005 instance. The target server is a SQL Server 2000 instance.
Provider: Microsoft OLE DB Provider for SQL Server
Product Name: SQL
Data Source: server1\instance1
Security: connections made without security context
I'm getting the following error. Note, I can connect successfully to the targer instance from SSMS using Windows auth.
Here is the error I'm getting:
The OLE DB provider "SQLNCLI" for lnked server "TEST" reported an error. Authentication failed.
Cannot initialize the data source object for OLE DB provider "SQLNCLI" for linked server "TEST". OLE DB provider "SQLNCLI" for linked server "TEST" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)
Any bright ideas? 😉
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 20, 2008 at 12:56 pm
I see this issue reported before on this site: http://www.sqlservercentral.com/Forums/Topic353977-146-1.aspx
Does Kerberos auth. need to be enabled for this to work?
I don't want to use SQL Auth. in the linked server.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 20, 2008 at 1:20 pm
I got it to work through scripting!
EXEC sp_addlinkedserver 'targetServer\targetInstance, N'SQL Server';
GO
Is there a bug in the GUI in SSMS for linked-server creation??
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply