Posted by Erland Sommarskog on 08/08/06 22:15

Mike (mjorlando@campsystems.com) writes:
> Yes, the SQL Browser service is running. I restarted it just to make
> sure. Has there been updates to BOL since May 2006? That is the date
> of my SQL 2005 installation. I will download the latest, thanks,

Yes, there is a new version. (They come out once a quarter.) URL below.

I went back to your original post, and it appears that you have defined
alias which points to the IP Address on the machine with SQL 2000 and
SQL 2005 on. But it is not clear that you specifiec the instance name
in the alias definition. If you only use the IP address you will end up
at the default instance, which I understand is running SQL 2000.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Table structure and data transfer from SQL2000 to Access (.mdb)
• Prev in forum: Query Analyzer. What settings to see the data output again?
• Thread view: Re: Accessing SQL2005 as a Second Instance to SQL2000

[Reply to this message]