Linked Servers (sql2000) of Windows2000 to Windows2003
-
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.
This error occurs when I try to use the linked servers of a Windows2000 Server to a Windows2003 Server. I use MSSQL2000 with mixed mode authentication.
I need to use:
Local Login: <domain>\<user>
Remote User: <sql user>
Remote Password: *******
-
I vaguely recall that there is an issue with cross-domain security authentication within Windows, ie it's a Windows issue rather than a SQL Server issue. Sorry I can't be more specific but it's an area to investigate.
-
If you are not crossing domains, the problem is somewhere else. Check that properties of the server allow remote connections. Check that the login you are using has enough rights. Are you using sql server to connect ?
If you are crossing domains you may need a trust.
-
Windows 2003 introduced some security constraints that screw up linked servers. It won't trust a Windows login that it can't verify with Kerberos, and it can't do that with Windows 2000. And if you have an older version of Active Directory that doesn't fully implement Kerberos, you may not get any linked server definitions to work with Windows logins.
Since you're running mixed authentication, try modifying the security settings of the linked servers to use a SQL login.
-
We solved the problem !!!
We inserted an alias in a
Client Network Utility on SERVER1 apointing to SERVER2 and is OK.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply