The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
SQL 2005 compatibility with remote clients
Posted: 09 Aug 07 2:00 PM
|
I'm looking for the documentation that says if SQL 2005 is supported on remote databases. I've seen the product compatibility guide and it doesn't explicitly say that SQL 2005 is not support on the remote client. We are currently running 6.26 with SQL 2000 database server. Most of our remote users currently use SQL 2000 on the remote client. They are requesting to upgrade to SQL 2005 because of other products that exist on their machines.
Any suggestions on how to handle this? Can I run MSDE on a machine that also has SQL 2000 installed on it? I do have 1 user who is running SQL 2005 as a remote client, and don't appear to have any issues, but I don't want to roll out an unsupported configuration.
Thanks for the response. |
|
|
|
Re: SQL 2005 compatibility with remote clients
Posted: 09 Aug 07 2:12 PM
|
| I am sure it will probably run ok with a few tweatks, however it is my understanding that official support for SQL EXpress (2005) for remotes is part of the 7.2 release. |
|
|
|
Re: SQL 2005 compatibility with remote clients
Posted: 09 Aug 07 8:08 PM
|
The only version of Slx that supports SQLExpress (2005) on remotes is 7.2.. and it's not out.. yet.
This is also true for Remote Office.
If you run it on anything under v7.2 you are not supported.
--
rjl |
|
|
|
Re: SQL 2005 compatibility with remote clients
Posted: 10 Aug 07 6:55 AM
|
Dan,
****If SLX database server = SQL Server 2005 and SLX version = 6.2.6****
-If your remote is MSDE 2000 - create the remote user database from a machine with SQL 2000 tools installed
-If your remote is 2005 - this will not work.
-You can only run MSDE 2000
****If SLX database server = SQL Server 2005 and SLX version = 7.2(when it becomes available)****
-If your remote is MSDE 2000 - create the remote user database from a machine with SQL 2000 tools installed
-If your remote is 2005 - create the remote user database from a machine with SQL 2005 tools installed
-You can run either MSDE 2000 or SQL 2005 Express
|
|
|
| |
|