|
Home > Archive > MS SQL Server > October 2006 > Linked server on a different domain
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Linked server on a different domain
|
|
|
| Hello,
I'm trying to link my SQL 2000 to a SQL 2005 in a different domain.
I use SQL authentication, and both are working on TCPIP port 1433.
It doesn't work, it says "Access denied or not existant Sql"...but the
credentials are right.
I'm connected through a VPN channel (CISCO client vpn connector) with
port 1433 (and udp 1434) open...I can use Excel or create an UDL
connected to 2005 and it works fine.
What it might be? The port is fixed. Do I need to open something else?
Thanx,
Bige
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi
I assume this is linking SQL 2000 from a SQL 2005 instance? Have you tried
to connect directly to this server using the credentials through Management
Studio?
If you can do that then you should be ok.
Check that you are using protocols that are enabled on the remote server.
What version are you running on each server?
John
"Bige" wrote:
> Hello,
>
> I'm trying to link my SQL 2000 to a SQL 2005 in a different domain.
>
> I use SQL authentication, and both are working on TCPIP port 1433.
>
> It doesn't work, it says "Access denied or not existant Sql"...but the
> credentials are right.
>
> I'm connected through a VPN channel (CISCO client vpn connector) with
> port 1433 (and udp 1434) open...I can use Excel or create an UDL
> connected to 2005 and it works fine.
>
> What it might be? The port is fixed. Do I need to open something else?
>
> Thanx,
> Bige
>
>
| |
| Hilary Cotter 2006-10-24, 6:38 pm |
| Have you tried pass through authentication? This is where you have two NT
accounts with the same account names and passwords in both domains? If you
use the security context of the one account it should work against the
server in the other domain.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bige" <ivan.pololi@interah.com> wrote in message
news:1161088887.857054.124880@h48g2000cwc.googlegroups.com...
> Hello,
>
> I'm trying to link my SQL 2000 to a SQL 2005 in a different domain.
>
> I use SQL authentication, and both are working on TCPIP port 1433.
>
> It doesn't work, it says "Access denied or not existant Sql"...but the
> credentials are right.
>
> I'm connected through a VPN channel (CISCO client vpn connector) with
> port 1433 (and udp 1434) open...I can use Excel or create an UDL
> connected to 2005 and it works fine.
>
> What it might be? The port is fixed. Do I need to open something else?
>
> Thanx,
> Bige
>
| |
|
| I'm connecting from SQL 2000 SP4 to SQL 2005 SP1 I guess...
I don't want to use NT accounts, I need to use SQL authentication.
About the ports are the same and both use protocol TCPIP....if I
connect a SQL 2000 to 2005
in the same domain with my SQL credentials it works.
The problem is when I try to connect from another network in VPN
mode...
Thanks for your help, I appreciate it.
Bige
Hilary Cotter ha scritto:
[color=darkred]
> Have you tried pass through authentication? This is where you have two NT
> accounts with the same account names and passwords in both domains? If you
> use the security context of the one account it should work against the
> server in the other domain.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
>
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
>
>
> "Bige" <ivan.pololi@interah.com> wrote in message
> news:1161088887.857054.124880@h48g2000cwc.googlegroups.com...
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi
Connecting with a SQL connection should not matter about the servers being
on different domains. Can you connect with Query Analyser, if you can, then
it would tend to imply that it was configuration of the linked server is the
most likely cause (have you run sp_addlinkedsrvlogin
?) If not you may want to
check out http://support.microsoft.com/kb/287932 and
http://support.microsoft.com/kb/306199/
With a VPN there may be delays introduced in the connection, so increasing
timeouts may be necessary, also check that you can access the server via an
IP address, if this works there may be a DNS issue.
John
"Bige" wrote:
> I'm connecting from SQL 2000 SP4 to SQL 2005 SP1 I guess...
>
> I don't want to use NT accounts, I need to use SQL authentication.
>
> About the ports are the same and both use protocol TCPIP....if I
> connect a SQL 2000 to 2005
> in the same domain with my SQL credentials it works.
>
> The problem is when I try to connect from another network in VPN
> mode...
>
> Thanks for your help, I appreciate it.
> Bige
>
> Hilary Cotter ha scritto:
>
>
>
| |
|
| Yes, I can connect using Query Analyser.
I created the linked server using EM; here it returns "SQL server not
existant" when I try to list tables or views...
I tried to change the timeout but didn't worked...and it is not a DNS
problem
About the microsoft kbs were not really helpful...any clues?
Thanx,
Bige
John Bell ha scritto:
[color=darkred]
> Hi
>
> Connecting with a SQL connection should not matter about the servers being
> on different domains. Can you connect with Query Analyser, if you can, then
> it would tend to imply that it was configuration of the linked server is the
> most likely cause (have you run sp_addlinkedsrvlogin
?) If not you may want to
> check out http://support.microsoft.com/kb/287932 and
> http://support.microsoft.com/kb/306199/
>
> With a VPN there may be delays introduced in the connection, so increasing
> timeouts may be necessary, also check that you can access the server via an
> IP address, if this works there may be a DNS issue.
>
> John
>
> "Bige" wrote:
>
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi
That implies it is the configuration of the linked server that may not be
working. Try using sp_addlinkedserver and sp_addlinkedsrvlogin
from Query
Analyser and if they don't give an error see if you try run a query using 4
part naming.
John
"Bige" wrote:
> Yes, I can connect using Query Analyser.
>
> I created the linked server using EM; here it returns "SQL server not
> existant" when I try to list tables or views...
>
> I tried to change the timeout but didn't worked...and it is not a DNS
> problem
>
> About the microsoft kbs were not really helpful...any clues?
>
> Thanx,
> Bige
>
> John Bell ha scritto:
>
>
>
| |
|
| Nothing, still the same behavior...I really think is something about
VPN but I don't know where to investigate more...
Bige
John Bell ha scritto:
[color=darkred]
> Hi
>
> That implies it is the configuration of the linked server that may not be
> working. Try using sp_addlinkedserver and sp_addlinkedsrvlogin
from Query
> Analyser and if they don't give an error see if you try run a query using 4
> part naming.
>
> John
>
> "Bige" wrote:
>
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi
Check that the ports are not being blocked, you may need to set a static
port if it being allocated dynamically (for instance if the instance is a
named instance). Try connecting with a IP address, use PING and TRACERT to
see if you can see the server, use telnet to see if you can connect to the
port. The following articles and links may help
http://support.microsoft.com/kb/287932
John
"Bige" wrote:
> Nothing, still the same behavior...I really think is something about
> VPN but I don't know where to investigate more...
>
> Bige
>
> John Bell ha scritto:
>
>
>
|
|
|
|
|