SQL Server Versions

[Vayse]

Hi
Anyone here have experience with SQL Server 2000 and 2005 on the same PC?
At the moment, there is SQL 2000 on the server. There is a live database and
a test database.
Now, I'd like to do some work with SQL 2005, and the new Access 2007. But
that live database will not be updated for a while yet. I'm guessing there
will be a problem if I install 2005 on the server. (probably wouldn't be
allowed anyway!)
I have SQL 2005 standard edition. Going to douel check, but I think I need
the Developer edition to just have a local install on my PC.
Has anyone found problems with their ADPs when working with 2 versions of
SQL server?
Are there any issues I should look out for?
Thanks
Diarmuid

 

[PBsoft]

Anyone here have experience with SQL Server 2000 and 2005 on the same

PC?

It's my situation.

I'm guessing there
will be a problem if I install 2005 on the server. (probably wouldn't
be allowed anyway!)

I hade no problem.

Has anyone found problems with their ADPs when working with 2 versions
of SQL server?

I', working with Access 2002 and Access 2003 ADPs connected to SQL 2000 and
SQL 2005 and found no particular problem.

Are there any issues I should look out for?

Obviosuly, at least one of them (SQL 2000 and SQL 2005) must be installed
as a named instance.
Anyway, you must use an external tool if you want to manipulate SQL Server
2005 views, stored procs, functions and tables: Access 2002 and Access 2003
cannot use the new object model exposed by SQL Server 2005.

Bye.

 

[Vayse]

Thanks. Looks like I should be ok.

It's my situation.


I hade no problem.


I', working with Access 2002 and Access 2003 ADPs connected to SQL 2000
and SQL 2005 and found no particular problem.


Obviosuly, at least one of them (SQL 2000 and SQL 2005) must be installed
as a named instance.
Anyway, you must use an external tool if you want to manipulate SQL Server
2005 views, stored procs, functions and tables: Access 2002 and Access
2003 cannot use the new object model exposed by SQL Server 2005.

Bye.

 

[Brendan Reynolds]

I had SQL Server 2000 and 2005 running on my PC for some time without any
problems. However, I recently ran into a problem with SQL Server 2000
Reporting Services. Having tried everything else I could think of, I
eventually decided to uninstall and re-install SQL Server 2000 Reporting
Services. I was able to un-install without any problem, but could not
re-install until I un-installed SQL Server 2005.

I haven't found any documentation describing any 'known issues' along these
lines, so perhaps it is not a common problem. I may have simply been
unlucky, and you may never encounter this problem. Good luck.