MS SQL Server - RE: 2005x64 to 2000x86 linked server question

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

RE: 2005x64 to 2000x86 linked server question - Update

Doownai

2006-10-24, 6:29 pm

I had mentioned in my previous post that I had created an alias to connect to
the SQL Server 2000.

I had created a SQL Server Native Configuration (32 bit) alias because that
is the one that allowed me to connect to the server using SSMS.

I was testing the connection with OSQL when it struck me to add another
alias of the same name under SQL Server Native Configuration.

I can now query the linked server. I am going to test this a little bit
more and if I satisfy myself, I shall come back and close this post.

Doownai

2006-10-24, 6:29 pm

Adding the alias has worked in all my affected environments

Sponsored Links