Thanks for everyones help!

Thanks, so i should no problem with having the name of the 2008 instance being the machine name when I'm done?

Thanks Befother and Mark,

I too followed an earlier post to delete the distmdl.mdf and distmdl.ldf files and ran into issues installing SQL Server 2005 SP2 Update (KB948109).

I copied...

Opening up the default ports 1433 or 1434 works for me.

SSMfana,

I turned off the firewall on my Windows XP box running SQL Server 2005 and I'll now able to create a linked server to it from SQL 2000 no matter...

SSMfana,

Are both your SQL 2005 boxes on a domain? What OS are they running?

The 2005 box that I'm successfully able to link to happens to be a server that...

That article is for issues creating linked servers from 2005 to 2000, not 2000 to 2005.

I just tried changing the box that didn't work to log in with the built in system account.

It didn't fix the problem for me, but at least it's working for...

I set up another SQL Server 2005 box identical software version as my other box and I'm able to create a link server from my SQL Server 2000 to this...

Hi Samuel,

I did what you said (trying to connect to SQL 2005 thru query analyzer on my sql 2000 box using SQL Server authentication), and I get the following error...

Hi SSMMana,

I haven't gotten an answer for this yet.

The reason I had asked this question is that I have a SQL Server 2000 Reporting Server box that currently pulls most...

bump

Hi Jason,

I have remote connections enabled (TCP/IP).

So you have no problem creating a linked server on SQL 2000 linking to SQL 2005?

I read the suggested article, not sure that it...