install CE on same server with MSDE instances
-
Is it ok to install SQL Server CE on the same server that already 2 instances of MSDE as well as some other applications? There is enough space, I just wondered if there are any other issues with running these together on the same server. Thanks!
-
Please correct me if I am wrong, but my understanding is that SQL Server CE installs on a Pocket PC device, it is not a server based product.
-
There is software to be installed on the pocket pc's, but my understanding is SQL Server CE Server Tools will install on the server.
-
I think that is there for if you are wanting to do replication or remote data access. If you are doing replication, then Merge replication is what is recommended between SQL Server and SQL Server CE, MSDE does not support merge replication as a publisher.
Here is something on the install process I found in the help file (sqlce.chm)
Installing SQL Server CE on an IIS System
Microsoft® SQL Server™ 2000 Windows® CE Edition 2.0 (SQL Server CE) Server Tools are required for applications that use SQL Server CE connectivity. If you use replication or remote data access (RDA), you must install SQL Server CE Server Tools on the computer running Microsoft Internet Information Services (IIS). Replication requires the SQL Server CE Server Tools installer appropriate for the service pack that SQL Server is running. SQL Server CE ships with two installers: Sqlce20sql2ksp1.exe (SQL Server Service Pack 1) and Sqlce20sql2ksp2.exe (SQL Server Service Pack 2). If the instance of SQL Server is running a service pack later than Service Pack 2, download an updated SQL Server CE Server Tools installer from this Microsoft Web site.
SQL Server CE Server Tools Setup installs the SQL Server CE Server Agent (Sscesa20.dll) and the SQL Server CE Replication Provider (Sscerp20.dll) in \Program Files\Microsoft SQL Server CE 2.0\Server and additional SQL Server replication components in \Program Files\Microsoft SQL Server\80\Com.
To set up SQL Server CE on the computer running IIS if you are using Microsoft Visual Studio® .NET
- From Windows Explorer on the computer running IIS, navigate to the source files for SQL Server CE, and then double-click sqlce20sql2ksp1.exe or sqlce20sql2ksp2.exe. These files are installed in \Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000.
To set up SQL Server CE on the computer running IIS if you are using Microsoft eMbedded Visual Tools
- From Windows Explorer, navigate to the source files for SQL Server CE, and then double-click setup.exe.
- When prompted, click Server Tools. If the computer running IIS also has SQL Server Service Pack 1 or Service Pack 2 installed, the appropriate Server Tools installation file is installed. If the computer running IIS does not have SQL Server installed, the installation file that corresponds to SQL Server Service Pack 1 (Sqlce20sql2ksp1.exe) is installed.
Note You can also obtain the Server Tools installer (Sqlce20sql2ksp1.exe and Sqlce20sql2ksp2.exe) from an existing development system. SQL Server CE Setup installs the files in \Program Files\Microsoft SQL Server CE 2.0\Redist\Server.
SQL Server CE Connectivity Management Utility
At the end of the setup process, the SQL Server CE Server Tools installer optionally launches the SQL Server CE Virtual Directory Creation Wizard, a component of the SQL Server CE Connectivity Management utility. For more information about the SQL Server CE Connectivity Management utility, see Configuring Security for Connectivity.
Support for Multilingual Environments
SQL Server CE Server Tools includes localized Microsoft Data Access Components (MDAC) files that affect how setup screens and error messages are displayed. The language of SQL Server CE Setup determines the language of the MDAC software in SQL Server CE Server Tools. For other language-related issues, see Ensuring Proper ANSI to Unicode Conversions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply