August 11, 2003 at 1:41 pm
We moved our SQL Server from one NT 4.0 machine to another NT 4.0 machine, using sp_detach_db and sp_attach_db methodology. Now we cannot make a connection to a linked server which previously worked on the old machine, even after dropping it and adding it again as a linked server. Any suggestions?
August 12, 2003 at 6:54 am
So you did recreate the linked server in your new machine, what error message did you receive when you can't connect to it? What type of likned server are you try to setup? Any difference in SQL Server version and service pack between old and new servers?
August 12, 2003 at 7:03 am
Is it Sql to Sql or to Oracle? There are a mountain of things that we need to know to help trouble shoot it.
Wes
August 12, 2003 at 9:29 am
New machine is SQL SRV 7 SP4 and linked server is SQL SRV 2K. The link was fine before the migration. Now, we receive the error message that "OLEDB experienced problems" when attempting to use the same query. If I use an OpenRowset statement, I can get the data. Before, all I had to do was run a stored proc with the 4 part qualified name for linked server.
August 12, 2003 at 11:36 am
Can you post complete error message when query the linked sevrer with four part name?
Is the MDAC in same version on your old and new servers?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply