I am having problems installing the Sql server compact 3.5 server tools beta 2 onto a Windows Vista 64 bit system. It keeps saying that either I don't have IIS installed, or I have IIS7 installed but don't have the "backward compatibility" components installed. Id so infact have IIS 7 installed, and I've installed all the IIS6 bits. There are no features named "backward compatibility", so I assumed the IIS6 bits were the right ones. Anyone get this to work? I thought I read somewhere that beta 2 doesn't support 64 bit yet - but now I can't find any mention of it.
I am having problems installing the SQL Server Compact Server Tools on my Vista laptop to allow me to connect my Mobile Device running SQL Server Compact directly to my SQL Server 2005 database through IIS.
I have done this successfully with an XP machine so I'm not sure if it is Vista problem or not.
I have installed SQL Server 2005 SP2. When I try to install the replication server tools (Sqlce30setupen.msi), in "System Configuration Check" window I get a failure on "SQL Server requirement" that says: "You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components" and the client components are full instaled in my computer.
I am using SQL Express 2005 server and sql compact edition for my PDA. For synchronization, which SQL Server 2005 Compact Edition Server Tools installation package do I use?
Is it Sqlce30setupen.msi or sql2kensp4.msi or sql2kensp3a.msi? I know for sql server 2005 its Sqlce30setupen.msi. Is it the same for the SQL Express 2005?
I have SQL Mobile 2005 server tools installed on my server and also my development PC. I started working with SQL Compact on a mobile application I'm developing so I downloaded the SQL Compact Server Tools and installed on my laptop and it added folders "syncSQL" to my "Program FilesSQL Mobile" folder. I used the configure web sync wizard to create a sync folder for SQL Compact and it added the file sqlcesa30.dll version 3.0.5300.0 to the new folder. The previous sync folders set up using SQL Mobile have version 3.0.5214.0 of the same file.
I then went to install the Compact Server Tools on my server (downloaded the file). When it was installing it asked if I wanted to repair or remove SQL Mobile Server Tools (it didn't do this on the laptop install). I selected "repair" and it apparently successfully installed. I checked the Program FilesSQL Mobile folder and there was no "syncSQL" folder. I created a new web sync folder and the version of sqlcesa30dll added is 3.0.5223.0.
My laptop is running XP Professional and the server is Server 2003. Both are running SQL Server 2005 SP2. It looks like it hasn't installed the server tools correctly on the server, what am I doing wrong? I'm also getting a lot of sync errors and wonder if it has something to do with Compact/Mobile incompatibility.
Some extra information: when I install the SQL Compact Server Tools on my XP Pro computer, the installer window title says "Microsoft SQL Server Compact Edition - English". When I run the same install file on Windows Server 2003 the window title is "Microsoft SQL Server 2005 Mobile SP1 [ENU] Server Tools". It seems to install different versions of the software depending on the operating system. Could someone from Microsoft please confirm that this is the case, and advise how I can get the correct SQL Compact Server Tools for my server.
I've got a big problem reinstalling the just released VS2005 Tools:
I've installed them, but then I've deinstalled them to first deinstall RC1 and install the just released RTM/W(?) of the runtime.
But since then I was not able to reinstall the VS2005 Tools: The installer just says, that a required program for the upgradepatch is missing or another version is installed.
I've also tried to reinstall SP1 of VS 2005, with the same result.
BTW, I just wanna mention, that it is very complex to look through the new released Compact Edition releases. For example for the runtime it is required that the english release is installed before another localized release. But the localized releases are not called "Language Packs" (what they are) and do not verify that the english version is already installed. Also I'm interested what the recommended installation order is for installing on a developer computer eg. in German. First the VS2005 Tools or the SDK or the runtime?
End Sub this code worked well. we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).
we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.
Why is this error happening and how can we resolve this?
BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.
When I try and download Sqlce30setupen.msi from the msdn site, I keep getting the install for the mobile tools. Can someone explain why this is happening. I am new to SQL compact and I am trying to go through the tutorial http://msdn2.microsoft.com/en-us/library/bb226707.aspx. This tutorial says the download should be for SQL Compact setup.
everything is ok for first run. but i leave the program relogin than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine. can anybody help me?
VS2005 ver 8.0.50727 SSCE31VSTools-ENU.exe loaded SSCE31SDK-ENU.msi loaded
machine 1 SQL 2005 loaded
machine 2 http://192.168.20.22/ssce/sqlcesa30.dll "Microsoft SQL Server Compact Edition Server Agent" looks fine
pocket pc side C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4
End Try ------------------------------------------------------------------------------ i added the following code to very beginning of my code too. that code lock my device
Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr
Login failed for user 'TOSHIBA-USERASPNET' I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer, not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do. last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
I have a question about a problem that I cannot seem to tackle. I have installed the following programs on Windows Vista:
- SQL Server 2005 - Visual Studio 2008 - SQL Server Compact Edition 3.5 - SQL Server Compact Edition 3.5 Server Tools
I want to do the following:
1. I want to create a SQL Server Compact Edition 3.5 database in the SQL Server Management Studio 2. I want my SQL Express server in SQL Server 2005 to be a distributor and publisher
About 1. In SQL Server Management Studio I cannot choose SQL Server Compact Edition 3.5 . ABout 2. I tried to setup my server to be a distrubutor by running a stored procedure with the following name: sp_adddistributor. I get the following error: This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Trying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there. I have uninstall all of the Sql Ce stuff and reinstalled it. So I'm missing some key link. What are the magic incantations to get to first base?
I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases.
To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect.
To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:Program FilesMicrosoft SQL Server Compact Editionv3.1".
Is there perhaps an additional step that I left out to complete the installation?
Might I need an upgrade to some other components? My Management Studio Version is:
- Microsoft SQL Server Management Studio Express 9.00.2047.00
Which tool can I use for structure editing of SQL Server Compact 3.5 databases? I'm installed SQL Server Compact 3.5. I have SQL Server Management Studio Express which was installed with SQL Server 2005 Express. Unfortunately this SSMS can create and open only 3.1 databases.
I am very new to SQL Compact. I am trying to create one database which can work on the desktop application and also on a pda application. I want to create the database but I am unable to start without Management Studio. Can you guide me to the right tools so that I can create database, view it and manage it use something like Management Studio Express.
Also one more question is if my database needs to be at both places on the desktop and on pda how can i synchronise them. PDA will take using c# application data from RFID scans and then i need to sync that database on the desktop so that reports and other info can be generated from the desktop c# application. How to do this?
Please can you guide me to any webcasts or labs so i can clarify my doubts about the design.
i tried to connect to a SQL Server Compact Database (version 3.5) with SQL Server Management Studio Express (Version 9.00.3042.00).
But i get the follwing error message (sorry, it's a german message):
..................................... Es kann keine Verbindung mit 'D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf' hergestellt werden.
Sie versuchen, auf eine ältere Version einer Datenbank von SQL Server Compact Edition zuzugreifen. Falls es sich um eine Datenbank von SQL Server CE 1.0 oder SQL Server CE 2.0 handelt, führen Sie 'upgrade.exe' aus. Falls es sich um eine Datenbank von SQL Server Compact Edition 3.0 oder höher handelt, führen Sie die Komprimierung und Reparatur aus. [ Db version = 3505053,Requested version = 3004180,File name = D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf ] (SQL Server Compact Edition ADO.NET Data Provider) .....................................
Is there a solution to manage Compact Databases in Version 3.5?
We are currently having a problem with a client running Vista business for a mobile application that uses SQLCE RDA with the Web Synchronization on IIS7.
I have run through the Configure Web Synchronization Wizard and it doesn't create a virtual directory. I manually create the virtual dir and point it to the new folder the Configure Web Synchronization Wizard created.
Browsing to the url "http://localhost/sqlce/sqlcesa30.dll" gives a valid test string.
Here is the ?diag response... SQL Server Mobile Server Agent Diagnostics 2007/03/20 15:39:49
General Information
Item Value
Server Name localhost
URL /sqlce/sqlcesa30.dll
Authentication Type Anonymous
Server Port 80
HTTPS off
Server Software Microsoft-IIS/7.0
Replication Allowed
RDA Allowed
Logging Level 3
Impersonation and Access Tests
Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile SUCCESS 0x0
SQL Server Mobile Modules Test
Module Status ErrorCode Version
SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0
SQLCESA30.DLL SUCCESS 0x0 3.0.5206.0
Reconciler Test
Reconciler Status ErrorCode
9.0 Database Reconciler SUCCESS 0x0
8.0 Database Reconciler SUCCESS 0x0
SQL Server Module Versions
Module Version
sqloledb.dll 6.0.6000.16386
9.0 replrec.dll 2005.90.3042.0
9.0 replprov.dll 2005.90.3042.0
9.0 msgprox.dll 2005.90.3042.0
8.0 replrec.dll 2000.80.2039.0
8.0 replprov.dll 2000.80.2039.0
8.0 msgprox.dll 2000.80.2039.0 When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLOLEDB ...
Which roughly translates to from the header file ...
#define SSCE_M_INCORRECTPROVIDERVERSION 29022 // The version of the Microsoft OLE DB Provider for SQL Server is not correct. Install MDAC 2.8 or later. [,,,Version,,]
When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLNCLI ...
HResult = -2147467259
Message = " [ 9 ]"
NativeError = 29022
numericErrorParameters = {9,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
A very similar error.
From this it seems that both SQLCE 2 and 3 seem to want MDAC 2.8+ drivers. The drivers installed with Vista for SQL Native client seem to be versioned 6.0.* and the required versioning would seem to need to be in line with MDAC 2.8.
Are there installable drivers to bump the versioning of SQLNCLI or SQLOLEDB upto MDAC 2.8+ levels?
Or is there an alternative that will make it possible to run SQLCE RDA apps with Vista as the SQLCE server (i.e. sqlcesa30.dll)?
Im trying to install the SQL Server Compact Tools in Windows Server 2008, but the installation program won´t let me continue since it says that I must install the IIS Backward Compatibility Tools. The problem is that I can´t find where I do that.
I know that Windows Server 2008 is not listed as a supported os for the server tools, but surely I must at least be able to install them?
Is there a way to use SSIS to copy data from a SQLServer CE database to a SQL Server 2005 database?
I have a database that has only been used on a mobile device, but now I want to use it among several devices, so I want to copy the structure and data to a SQL Server 2005 database and expand it's scope.
Hello, I am a SQL novice and I installed SQL Server Compact 3.5 and wanted SQL Server 2005 Express instead. I uninstalled the Compact version, but when I try to install Express, it still just installs the regular SQL Server 2005 Configuration tools. I have went so far as to uninstall all my Visual Studio Express apps and SDKs and even the .NET 3.5 framework, but it WILL NOT install the SQL Server 2005 Express. I am running 32-bit Windows Vista Home edition.
Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted.
I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.
I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.
I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.
The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).
One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.
I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?
After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.
"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"
Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??
I'm a bit confused about the editions. Will SQL Server Compact v3.1 be a successor of SQL Server Mobile v3.0 (but with desktop and mobile targets) or will the two editions coexist with SQL Server Mobile on Smart Devices and SQL Server Compact on desktop PCs?
I'm drawing this conclusion because the CTP & now also the RC1 of SQL Server Compact are only compiled for desktops (and I've also seen that the .NET library is compiled against .NET Framework 2.0 desktop edition). If I'm wrong, why are no smart device CABs provided?
My second question: Is the file format of SQL Server Mobile & Compact the same? Can I create a SDF file with the Compact Edition on the desktop, move it to the smart device and use it there with the "older" Mobile Edition? I'm asking, because we are starting a project where we need to create a SDF on the desktop, because of performance reasons.
I've been playing around with Microsoft SQL Server Compact Edition v3.1 as a posible replacement for the SQL Server CE 2.0 (can't remember exactly what the called it). Its working pretty well. I was able to connect to the database using the same recordset object, ADODB.RecordSet and connection object, ADOCE.Connection.3.1. However where I've run into trouble is when I try to compact the database. This code works on 2.0.
Hello, After installing SQL Server 2005, I get a message stating "You must use SQL Server 2005 management tools to connect to this server", while trying to connect to my localhost using SQL Server 2000 Enterprise Manager. Regards, junior
Hi, A quick Q for all the Sql Server 2000 beta testers out there. Does anyone know of any problems associated with using SS2000 Enterprise Manager with a SS7 backend running SP2? In particular, I'm keen to try out the Tsql debugger features, if they'll work with SS7.
Many thanks in advance, Jon Reade, Sql Server 7 DBA NEC Technologies (UK) Ltd Telford, Shropshire.
I want to load-balance my PDAs accessing my database to make a merge replication. As I have one server with the SQL Server Mobile Server Tools installed, can I configure some of these PDAs to use another server with SQL Server Mobile Server Tools to point on the same Database server? Is it going to work or will it generate problems?
