Tuesday, March 20, 2012

Problems with Linked servers between sql 2000 and sql 2005

Dear all

I have created linked server object between a sql 2000 and sql 2005 database. i have the latest mdacs installed and all the services enabled on both sides.

But when i try and run a sql statement on the sql 2000 side i get this error:

[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.

If i try and run a sql statment on the sql server 2005 side the procedure works.

Has anyone experienced the same problem?Any advice?

Thank you so much for the help.

Dan

What is the SQL Statement that works/doesn't work?

Do any other queries work on the SQL 2000 server when executed from the SQL 2005 server?

|||

Also, if you can you post:

1 - Any errors that you see in the error log

2 - The commands that you used to create the linked server

3 - What type of authentication are you using? Integrated auth?

You may also want to take a look at this blog posting: http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx. It's describes the scenario using sql2k5 servers but there is a lot of info that applies to sql2k as well.

Thanks,

Il-Sung.

|||

The select statement i used is just a simple one:

Select * from MyLink.MyDatabase.dbo.Table1

This is working now. It had to do with the way sql server 05 was setup.

But i have a different problem.

When i place the select statement in a simple insert trigger that has nothing in except for the select statement the trigger just blocks and does not execute. It stalls to a lock. The trigger is placed on a table at the sql 2000 server.

Any suggestions as to why this might not work?

Sincerely

Dan

|||

Hi, Dan

This indicates your insert trigger fails to execute, normally, due to the rwo to be inserted did not pass all constraints check such as primary keys, unique indeex, foregin keys, etc...

Hence, I suggest you take a look at your table schema and double check. If you still face problem, please post your question to SQL Engine forumn where experts can help you very quick.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1

Good Luck!

Ming.

No comments:

Post a Comment