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.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
View 3 Replies
ADVERTISEMENT
Jun 27, 2007
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.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
View 1 Replies
View Related
Oct 24, 2007
Hi,
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.
Appreciate if anyone tell me the solution.
Thanks in advance.
Best regards,
Plane.
View 5 Replies
View Related
Jun 27, 2007
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.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
View 3 Replies
View Related
Mar 26, 2007
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
View 1 Replies
View Related
Apr 24, 2007
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
View 3 Replies
View Related
Jun 29, 2007
Hi
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
View 1 Replies
View Related
Jul 9, 2007
I need SQL server 2000 for one application and 2005 version for another.
Does SQL Server support multiple versions of software Install on the same windows server ?
View 12 Replies
View Related
Jan 31, 2006
Can someone tell me if I can use the Gui tools which come with SQL Server 2005 against 2000 databases ?
View 1 Replies
View Related
Mar 30, 2004
Can I install MS SQL Server 2000 on a Microsoft Server 2003 box?
Thanks.
View 4 Replies
View Related
May 25, 2003
People,
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.
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=cc345772-aNICK2K;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (recv()).
driver={sql server};server=cc345772-aNICK2K;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (recv()).
driver={sql server};server=cc345772-aNICK2K;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionRead (recv()).
SQL Server configuration failed.
################################################## #############################
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.
22:25:08 C:WINNTTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQL$NICK2K
22:25:08 Process Exit Code: (0)
22:25:08 StatsGenerate returned: 2
22:25:08 StatsGenerate (0x0,0x1,0xf00,0x300,1033,303,0x0,0x1,0,0,0
22:25:08 StatsGenerate -1,administrator)
22:25:08 Installation Failed.
I'm really kind of pissed off. What am I doing wrong?
Any help/advise would be appreciated!
Thanx,
Tarry
View 2 Replies
View Related
Jul 20, 2005
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
View 1 Replies
View Related
Jun 3, 2002
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?
Thank you for your assistance.
Regards,
Steve
View 2 Replies
View Related
Aug 12, 2002
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.
Thank you.
View 1 Replies
View Related
May 21, 2005
Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies
View Related
Feb 2, 2004
Hi Folks,
Can We install SQL Server 2000 Enetrprise Edition on Windows 2000 Professional , i tried but gives me an error.
Is there any turnaround or any SP needed. Pls let me know how can we install SQL server 2000 Enetrprise Edition on Win 2000 professional.
Thanks in Advance
Kumar
View 4 Replies
View Related
Nov 23, 2005
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. "
Any idea,
View 1 Replies
View Related
Feb 21, 2001
Hi
I'm geting the following error when trying to install SQL 2000 on a new server:
warning the server and client code pages do not match - some ansi cahracter mappings may not not be possible
any ideas??
Paul
View 2 Replies
View Related
Oct 5, 2004
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.
Thanks.
dollar
View 2 Replies
View Related
Jan 5, 2007
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?
View 1 Replies
View Related
Mar 18, 2004
I have XP Pro installed on my system,Can I install SQL server 2000 Interprise
View 11 Replies
View Related
Mar 1, 2004
I am trying to installing SQL Server 2000 Person edition on my notebook IBM X31. It hangs while installing.
The OS of the notebook is Window XP (SP1)
Can I ask how to solve this problem?
Thanks
View 3 Replies
View Related
Aug 3, 2007
I have a server which has SQL 2005 express edition supporting web application.
My question is Can I install SQl 2000 along with it ?
Are there any known issues. If yes, how to resolve them ?
Thanks
View 3 Replies
View Related
Feb 13, 2008
Does any one can tell me . how to install SQL server 2000 to Windows XP pro ?
View 1 Replies
View Related
Jul 1, 2004
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?
Thanks,
Chris
View 1 Replies
View Related
Sep 6, 2006
Hi All,
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
Any thoughts, anyone?????
View 1 Replies
View Related
Dec 27, 2007
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?
-PatP
View 5 Replies
View Related
Jul 25, 2007
Is it possible to install a 2000 instance on a 2005 server? Just install a named instance and install 2000 in a different directory?
View 5 Replies
View Related
Jul 20, 2007
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?
View 10 Replies
View Related
Jul 18, 2007
Hi,
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.
thanks
Lyn
View 3 Replies
View Related
Aug 17, 2006
Hi
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.
Sankar N
View 5 Replies
View Related
Sep 16, 2005
I am trying to install SQL Mobile Server Tools (beta 1) on my SQL
View 15 Replies
View Related
Jun 23, 2007
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.
View 1 Replies
View Related
