Can't Able To Install SQL Server CE Server Tool On SQL Server 2000 SP 4
Jun 27, 2007
Hello
I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.
Hi I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue. Help me please.
I have installed "SQL Server 2000 SP 4" to SQL server and it is running fine.
But when i install the "SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4", i get below error: "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail.
By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file.
Hi I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error "SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue. Help me please.
I have a dedicated server running SQL Server 2000 on Windows 2003. Can I install SQL Server 2005 express so that I can run sites developed with VWD Express. I still have the sites that need to use the sql 2000 server. Thanks
Hello ,i am an asp.net developer my pc has sql server 2005 already and now my company use sql server 2000I think 2005 is very easy to use but some of 2000 that I don't know so can I install 2000 in the same machine with 2005 ?thanks for your kindness.Kate
I am new to this sql server thing.And for last couple of days i m trying to figure out whether we can install sql server 2000 ent edition in a server after installing or upgrading sql server 2005 from (sql server 2000) . As sql server 2005 is know to exist side by side with earlier sql server versions .
And coming to the problem which i m facing is , I have installed sql server 2005 ent in windows 2000 server in which sql server 2000 is residing.Later when i observerd i realised that actually i have upgraded 2000 to sql 2005 server (which i hav done after consulting many people).As a result few of the client systems which were running sql server personal edition were unable to access their data from the database.For temporary relief i have installed sql server 2005 express edition plus management studio in the client systems . The doubts which i am having are
1) what happens if i uninstall sql server 2005 2) Is it possible to install sql server 2000 ent edition now to work along with sql server 2005
thanks in advance .....waiting for your quick replies ..any idea's
I've tried to install sql 2000 server but it fails everytime at the end of the installation, here's the log...
What am I doing wrong here?
I have several databases running on my laptop oracle(8i,9i), mysql, postgres. But the database which i expected to install with it's easy gui setup fails everytime...
The error part I'm posting here, you can check the attachment for full sqlstp.log.
22:24:40 Process Exit Code: (-1) 22:25:08 Setup failed to configure the server. Refer to the server error logs and C:WINNTsqlstp.log for more information. 22:25:08 Action CleanUpInstall: 22:25:08 C:WINNTTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLAgent$NICK2K 22:25:08 Process Exit Code: (1060) The specified service does not exist as an installed service.
Hi all,I need to gain access to a remote SQL Server 2000 storing my data.The remote SQL machine can only be accessed via an internet connection,that is - it is not part of my network.I know Enterprise Manager can do the job, but EM only comes bundled inMS SQL Server, which is not installed on the client machine.Please let me know which other (preferably free) tools can performsuch remote access.Thanks,Gilad Haimov
Can I install, Enterprise Manager for SQL Server 7 and SQL Server 2000 on the same PC? Do I need 2 versions of the Enterprise Manager or can I administer a SQL Server 7 database from the SQL Server 2000 Enterprise Manager?
Is it possible to install SQL Server 7.0 on a box which currently running SQL Server 2000 and keeping both version running in the same time?? I have a cot product need to run on SQL Server 7.0. Just wonder if I can install SQL SErver 7.0 on the box and run parallelly with SQL Server 2000.
Hi, I 've re-install SQL Server 2000 SP3 just to change password And while installation I got an error that the instillation fails the message as the following:" setup Failed to configure the server, refer to the server error logs and setup error logs for more information. "
Hi, I have to install SQL Server 2000 on NT (don't know the version yet)...and I am fairly new to this. Please point to some online documentation for the install or if anybody has created their own documentation which they would like to share that would be great.
I am try to install SQL Server 2000 on XP OS, but every time it showing only client version can be install to your current oprating system. Is there any patch or service pack to intstall SQL Server 2000 on XP SP2 based system?
I already had MSDE installed on my laptop and I was trying to load the Client Tools. I stopped the MSDE service, then tried to install the Client Tools from the SQL Server 2000 Standard Edition (Personal Edition) CD. Near the end of the install, I received an error telling me that the C:Program FilesCommon FilesMicrosoft SharedSQL Debuggingsqldbg.dll file was in use and it would not complete the install.
So, I removed the MSDE thru Add/Remove programs, rebooted, then tried to install SQL Server 2000 Std Ed (Personal Ed) and the Client Tools from the CD. Same error message. I used My Computer to try to go to that folder and see the sqldbg.dll file, but when I try to open the folder it tells me "Access is denied".
Obviously, something is using this file, but I'm not sure where to go from here. Any suggestions?
I am facing a familiar issue, with a slight variance in the situation. I have already spent hours googling for a solution, so along with the problem I'll highlight what I have already tried to remedy it.
Problem -------- I am trying to install SQL Server 2000 Dev. Edition on my Win XP SP1 platform. I did a default instance installation. I am able to start up the server and keep it up.
Issue ----- On opening the Enterprise Manager I get the error, "SQLDMO.DLL not registered, re-run SQL Server setup etc."
Next I navigated to <install dir>Microsoft SQL Server80ToolsBinn and executed regsvr32 sqldmo.dll and I get the following error, "LoadLibrary("sqldmo.dll") failed - Invalid Access to Memory Location"
Comments ---------- I have verified that all the relevant dlls are present in the above and <...>system32 folders. I have also created an alias for the server using the client network utility.
There was a time when I had installed SQL Server 2000 previously and I did manage to get it to work, even the sqldmo.dll registeration bit. But uninstalled it subsequently as I was having space issues.
Since then I have installed various XP hotfixes and security fixes, except for Win XP SP2
I'm trying to remember how to install the SQL 2000 client tools onto a SQL 2005 server. There are a couple of bizarre steps that will allow this to happen, but I can't for the life of me remember what comes after the unicycle down the stairs with the umbrella stand of machetes.
Can anybody remember the magic, or do I resort to using VPC to kludge the install until I can find my clay tablets again?
I'm trying to install Service Pack 4 to our default instance of SQL Server 2000 with SP3a, on a Windows 2003 Server, which also has a named instance of SQL Server 2005 on it and a named instance of SQL Server 2000 with SP4.
The installation appears to be running just fine, but MUCH too quickly. The last window appears stating something along the lines of 'Updating Active X components'. I'm expecting the scripts to run to update my system stored procedures, etc., but that never occurs. The installer just quits.
No errors in the Windows logs, nor in SQL, and no C:WindowsSQLSP.log file.
I tried the installation again, but this time used a different copy of the service pack 4 installer, with the same results, and again no SQLSP.log file.
Since I was going to remove the named instance of SQL Server 2000 anyway, I verified that my SP4 installer was good by uninstalling the named instance of SQL Server (the one with SP4 already), reinstalling a named instance of SQL Server 2000, and reapplying SP4 to this named instance. Everything went flawlessly.
I then tried reapplying SP4 to the default instance of SQL Server 2000, and this time a SQLSP.log file was finally generated. In the error log, the last entries are:
19:10:03 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1SQLDBR~1.EXE sqldbreg2.exe -RegServer 19:10:04 An error occurred while setting the registry value for: SoftwareMicrosoftMSSQLServerMSSQLServer 19:10:04 Could not restore AuditLevel registry key 19:10:04 Action CleanUpInstall: 19:10:04 Installation Failed.
I confirmed that the service accounts that are running SQL Server both have local administrative access to the server (which may or may not matter), and that they are both sysadmin, so I don't think it's a permissions issue to the registry. I've also verified that the account I was using to run the SP installation also has local admin access on that box.
So, I compared my HKLMSoftwareMicrosoftMSSQLServerMSSQLServer registry entry from our production server to the one on the test server, I see that our test server's entry is completely empty. On production there are numerous subkeys, such as CurrentVersion and RPCNetLib.
I'm planning on copying the registry entries from production to test. Should this be sufficient, or are there other things I should look out for?
We have a suite of applications which go through the full product life cycle and I was wondering which SQL Server edition should be installed in every each environment from Proof of Concept -> Dev -> -> UAT -> Systest...
Production is straight forward but I am just not sure about all the other environments.
We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting, analysis services. We do not want to disturb the existing sql 2000 setup.
I heard that reporting services are instance unaware application. Please let us know If I can install the sql 2005 on 2000 server.
How to install replication component for SQL server 2000 sp4? I would like to replicate datas between SQL2K and SQL CE 2.0/3.0 I update SQL server 2000 sp4 as the following sequence: (1) install replication component for SQL server 2000 sp4 (2) install update package of SQL2000.MSDE-KB884525-SP4-x86-ENU.exe (3) install update package of SQL2000-KB884525-SP4-x86-ENU.exe (4) install update package of SQL2000.AS-KB884525-SP4-x86-ENU.exe After that, I would like to add replication in the property page. But it failed and I was informed that €œI should cancel the registration of this SQL 2000 instance since it is a virtual instance such as . or local. I should register a real instance with local machine€™s name€?. What€™s wrong with it? B.T.W: (1)I install SQL server 2000 in virtual PC with XP/SP2. (2) IIS is not installed on the virtual machine.
