I'm trying to create a all-in-one installation package for my application which make use of the SQL 2005 Express edition. It seems that there's no way to roll my application MSI installation with the database engine, the only ways around this problem is to use a bootstrap exe to launch the sql setup before or after my main application's MSI. This works fine during installation and I have modified the original .NET framework bootstrapper to do just that.
The problem comes when uninstalling my application. Since the uninstall process is all done through the MSI engine, how would I take the sql instance with me during my application's uninstall? Since the sql engine is also based on MSI technology, I won't be able to do that during the removal step of my application's MSI, right? Any one know any "clean" ways around that? Besides not letting users uninstall my application directly from Add/Remove program and force them to call another exe simular to my installation bootstrap?
I'm considering to use 3rd party tools like InstallShields, but even them are recommending people to stay with the MSI technology which is where the problem is. I'm running out of ideas really fast...
I am having a major issue installing SQL Server 2000 through InstallShield using the three merge modules sent with it (and available on the SQL Server CD) Being:
SQLBASE SQLSVR SQLSVR_RES
The install builds fine and runs right upto the end of the copying, where it pauses for a few seconds and comes back with a dialog saying
Product: SQL Object Installer -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
SQL Object Installer being the package I created
So I do this, only to find the following error log:
2004-01-08 09:58:40.65 server Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)
2004-01-08 09:58:40.67 server Copyright (C) 1988-2000 Microsoft Corporation. 2004-01-08 09:58:40.67 server All rights reserved. 2004-01-08 09:58:40.67 server Server Process ID is 1588. 2004-01-08 09:58:40.67 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'. 2004-01-08 09:58:40.68 server SQL Server is starting at priority class 'normal'(1 CPU detected). 2004-01-08 09:58:40.76 server SQL Server configured for thread mode processing. 2004-01-08 09:58:40.78 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks. 2004-01-08 09:58:40.98 spid3 Warning ****************** 2004-01-08 09:58:40.98 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2004-01-08 09:58:41.01 spid3 Starting up database 'master'. 2004-01-08 09:58:41.54 server Using 'SSNETLIB.DLL' version '8.0.534'. 2004-01-08 09:58:41.54 spid5 Starting up database 'model'. 2004-01-08 09:58:41.59 spid3 Server name is 'GROUPNETVISTA2'. 2004-01-08 09:58:41.59 spid3 Skipping startup of clean database id 5 2004-01-08 09:58:41.60 spid3 Skipping startup of clean database id 6 2004-01-08 09:58:41.60 spid3 Starting up database 'msdb'. 2004-01-08 09:58:41.84 spid5 Clearing tempdb database. 2004-01-08 09:58:42.10 server SQL server listening on 10.171.1.205: 1433. 2004-01-08 09:58:42.10 server SQL server listening on 127.0.0.1: 1433. 2004-01-08 09:58:42.60 spid5 Starting up database 'tempdb'. 2004-01-08 09:58:42.73 spid3 Recovery complete. 2004-01-08 09:58:42.73 spid3 SQL global counter collection task is created. 2004-01-08 09:58:42.74 spid3 Warning: override, autoexec procedures skipped. 2004-01-08 09:58:47.17 server SQL server listening on TCP, Shared Memory, Named Pipes. 2004-01-08 09:58:47.17 server SQL Server is ready for client connections 2004-01-08 09:58:56.67 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
I am stumped, I am not really the greatest with SQL Server so I don't really know where to start, the SCM line at the bottom of the errorlog doesn't tell me much as I can't see what would be sending the 'stop' request?
Could this be a permissions thing. I have set myself as the administrator on the machine and do have quite a few rights. The machine does not already have SQL Server on it as it is a fresh image of Windows 2000 (also tried on XP wth same result)
Any help on this would be most appreciated as all around me are stumped too.
Recently I have installed Visual Studion Team System 2008 Development Edition in my sytem. Along with this, MS-SQL Server aand MSSQL Server Compact Edition is also installed. I need to install the SQL Server 2005 in my system.
In such a scenario, does the Compact Edition is required? Can I uninstall them and install Sql Server 2005 only? If I uninstall anything, would it cause any problems for the .Net programs to work?
i installed sql server 2005 express by running SQLEXPR_ADV.EXE....now i can not uninstall it because the exe created a temp file to unpack the install files....of course those files are cleaned up after install or whenever i cleaned up the temp files on my pc.....so how do i uninstall?
While uninstalling Reporting Services (Septembre CTP) I get the error message "SQL Server Setup failed to retrieve the SSL Certificate Name". Here a portion of the log. We get the same error on a second machine while installing the official release of SQL Server 2005 Developper Edition. Any suggestion?
I tried to execute SQL Server Express Setup through InstallShield Script and it says that i required Admin Privilege. I checked and i have an Adnming privilegers.
Here is the Script. And the check says that i am an admin.
if ( Is(USER_ADMINISTRATOR, "") = TRUE) then MessageBoxEx("Admin...","Install",SEVERE); else MessageBoxEx("Non Admin...","Install",SEVERE); endif;
setuppath = "C:\Program Files\dir\Setup.exe"; sqlcmd = "ADDLOCAL=ALL"; LaunchAppAndWait(setuppath,sqlcmd,LAAW_OPTION_WAIT); if(LAAW_PARAMETERS.nLaunchResult != 0) then MessageBoxEx("Fail to install SQL Server Express...","Install",SEVERE); endif;
I have to uninstall Sql Express because of a problem that arose after I tried to make a connection from VS2008 Server Explorer to SqlExpress ( connection strings run from C3 code worked fine). I began getting weird errors and the issue has not been resolved after a long thread I ran in this forum.
It turns out there are plenty of dire warnings on the web and MSDN not to do this or that before you tried to uninstall. To tell you the truth I have uninstalled Sql Express in the past quite a few times but every time you fight new challenges and it is difficult to learn from experiecne. I have always done it headlong without considering consequences, eventually this bulldozed approach worked every time but there is a chance that with the .NET getting more complicated this time I may get in trouble.
I am referring to this article on MSDN: before you uninstalled Sql Express:
which is awfully unclear. It seems it recommends uninstalling ALL versions of .NET from 2.0 on.
These are versions on my Vista machine:
v1.0.3705, v1.1.4322, v2.0.50727, v3 .0, v3.5
Do I have to uninstall any? I don't think I've done it before.
Now, those .NET versions I listed above are just folders in my WindowsMicrosoft.NETFramework directory. When I try to open Turn Windows features On & Off I can see only .NET 3.0 Framework, nothing else. Not even .NET 3.5!
Hi, While building a vista 64 Ultimate machine recently, I temporarily installed the express edition toolkit with visual studio 2005. I have since uninstalled sql, and reinstalled the 64-bit developer edition. However it appears the toolkit did not uninstall completely - now when I try to install workstation components, bol, etc. It says that the upgrade is blocked. Hard as it is to believe that an express install can block a developer edition install, it does. I've tried reinstalling the ee toolkit, as any client/management tools are better than none - but this fails, saying that the components are already on the machine!! sheesh! It doesn't give an option to uninstall.
Has anyone got any ideas. I've uninstalled *everything* sql related, reinstalled with sp2 twice. I can see and create databases using visual studios server explorer, but this does not give any management options. Does anyone know how I can remove whatever registry entries are fouling up this installation?
I installed MS Express 2005 a few years ago and now I want to uninstall it and reinstall 2008. I played with 2005 but never used it for anything but now I need to get serious about it because my job is requiring it. I installed 2005 express compenents like SQL server, VB, C, ect... When I go to my programs and try to add/remove any of the 2005 express components the uninstall 'install' just hangs. I choose the option to uninstall the component (not reinstall or repair) but no matter what I try it hangs. After it hangs if I try to uninstall another component it says cannot perform the task because another install process is running. I even let the uninstall sit for 45 minutes to see if it would finish but the process is not using any CPU and the progress bar does not move so it is truly hung. I briefly tried an uninstaller but it crashed too. Any clues on what to do next or what I should try to clean my machine so I can install express 2008? Thanks.
Please tell me what I am missing here. I've got an XP Pro machine with SQL Server Express running and a laptop with XP running the Management Studio Express. This is on my home network which is wireless. I can't see any databases on the XP Pro machine from the laptop. Is there something besides just installing SQL Server that I need to do? I've checked forums, documentation and co-workers but no luck. Thanks in advance
I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases.
However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed.
I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".
The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.
As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.
I have installed SQL Server Express on a Windows XP Professional workstation. The installation instructions that I was following said that I had to have .NET Framework 2.0 installed. The instructions said that I should uninstall any versions before I tried to install 2.0. My computer already has version 2.0 and version 3.0 installed, so I did not remove anything.
My problem is that now that I have SQL Express installed I cannot seem to connect to anything. I was specifically trying to convert an Access database to SQL Server format, and I keep getting a "connection failed" error. I don't seem to have any way to start SQL Express. Does it have to be started or is it running by default? What am I doing wrong?
I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem.
A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out).
Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind.
Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next.
The next dialog box appears with the heading "Existing components". The three check boxes are grayed out. So I click the Details button and the following is presented on screen:
Name: Microsoft SQL Server 2005 (SQLEXPRESS) Allowed Action: Maintain (Action is only available from Add or Remove Programs) Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
Name: Microsoft SQL Server 2005 Reporting Services (SQLEXPRESS) Allowed Action: Maintain (Action is only available from Add or Remove Programs) Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
Name: Microsoft SQL Server 2005 Tools Allowed Action: Maintain (Action is only available from Add or Remove Programs) Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
It has been pointed out that the following services should have been stopped prior to removal.
SQL Server Active Directory Helper SQL Server Browser SQL Server FullTest Search (SQLEXPRESS) SQL Server Reporting Services (SQLEXPRESS)
Surely this should be managed by the Add/Remove process!
I was able to successfully re-install the program as long as I created a new instance.
What should be the correct process to remove SQL Server Express and if necessary how do I remove services if they do not get deleted?
I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases.
However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed.
I am working on Win2K Pro & had SQL Server 2005 Express & SQL Server Management Studio installed. The SQL Server name was MerverSQLEXPRESS. Due to some unavoidable reasons, I had to repair (& not re-install) Win2K but after doing so, I found that I am not able to connect to the database server. I uninstalled all the components related to SQL Server 2005 Express (like Management Studio, Support Files, BOL etc.) from my m/c & then restarted my m/c.
After doing so, I first re-installed SQL Server 2005 Express & other related components (I intended to install SQL Server 2005 Management Studio after installing SQL Server 2005 Express). While installing SQL Server 2005 Express, all the steps get executed successfully except for the last one which happens to be SQL Server Database Services. At this point, I get the following error:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
The problem is after I click the OK button, I am not even given the option to change the instance name! The Status message corresponding to SQL Server Database Services just says Setup failed. Refer to the Setup log for details. Finally, when I click the Next button, the next dialog finishes the Setup (showing the Finish button).
Now how do I overcome this problem? Please note that the Authentication mode I am using is Windows Authentication.
Someone please suggest me a concrete solution. It's driving me nuts! My receding hairline is getting further receded!
Lastly, please note that, as far as possible, I would like to keep the instance name as MerverSQLEXPRESS only.
I have a problem installing SQL express from a CD, it installs fine but the installation wizard does not load automatically, so I have tried to setup manually through Add and Remove programs.
But when I get pass System configuration check menu, i do not get the Registration info menu, it goes straight to SQL server express setup and then to another server express setup menu (it skips 3 menu pages) it should have MSML5 components such as SQL setup files, SQL native client, SQL VSS writer etc but it is completely empty. Then I get the finish screen.
However, when I uninstall SQL express, I see the MSML screen with all the components listed before it uninstalls.
I hope this makes sense and I hope someone can help.
to install sql server express 2005, do i have to install the windows installer 3.0. when i run the setup, after extracting the files, there is a message displaying such that to continue installation, you need to install the windows installer 3.0.
I have a problem when installing SQL Server Express Advanced Edition
It crash when installing Database Services, the log file contains this message
.....
<Func Name='GetSkuIt'> GetServiceUserGroup failed for SQLEXPRESS, 5 Error Code: 0x80070534 (1332) Windows Error Text: Le mappage entre les noms de compte et les ID de sécurité n'a pas été effectué. Source File Name: sqlcasqlcax.cpp Compiler Timestamp: Fri Feb 9 22:35:05 2007 Function Name: SetInstanceProperty Source Line Number: 1223
Error Code: 1332 MSI (s) (E0!E8) [10:34:39:288]: Produit : Microsoft SQL Server 2005 -- Erreur 29528. Le programme d'installation a rencontré une erreur inattendue pendant Définition des propriétés internes. L'erreur est : Erreur irrécupérable lors de l'installation.
Erreur 29528. Le programme d'installation a rencontré une erreur inattendue pendant Définition des propriétés internes. L'erreur est : Erreur irrécupérable lors de l'installation.
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='203'> Fin de l'action 10:34:39 : SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Valeur renvoyée : 3. Fin de l'action 10:34:39 : INSTALL. Valeur renvoyée : 3. .......
I've Successfully Installed Visual Web Developer Express Edition but when i tried to install SQL Server 2005 Express Edition I get this message: TITLE: Microsoft SQL Server 2005 Setup ------------------------------
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
------------------------------
so i downloaded the Visual Studio Auto-Uninstall and everything goes well until i accept the Agreement then i get this: <?xml-stylesheet type="text/xsl" href="C:DOCUME~1SamLOCALS~1TempIXP000.TMPissues.xslt"?> <Issues><Issue><Name>Uninstall Visual Studio components</Name><Id>{BB69B4AB-619E-487f-B0C2-5ACD1AE5A9A0}</Id><Description>You have Visual Studio 2005 components installed.</Description><AffectedProducts>Visual Studio 2005 components from editions but RTM such as: Express, Standard, Professional, Team System, WinFX Runtime Components, etc..</AffectedProducts><DetailsUrlId>Href_{BB69B4AB-619E-487f-B0C2-5ACD1AE5A9A0}</DetailsUrlId><HaveFix>1</HaveFix><Severity>low</Severity></Issue></Issues> samtylr
Downloaded the program and followed the instructions (as vague as they are) the only thing I see to execute is the configuration tools. I am certain I have missed something. Can anyone assist?
I just want to confirm that I can just install it on top of what I already I have.
About 2 months ago, I installed Visual Studio 2005, full edition (not express).
I can't remember what I did regarding SQL... whether I installed anything or not.
On my PC at the moment, in the Control Panel ---> "add/remove programs" section, I have :-
Microsoft SQL Server 2005 Size 197,00MB Microsoft SQL Server 2005 Mobile [ENU] Developer Tools Size 6,95MB Microsoft SQL Server Native Client Size 4,16MB Microsoft SQL Server Setup Support Files (English) Size 20,60MB Microsoft SQL Server VSS Writer Size 0,66MB
From my start menu --> All Programs, the only SQL program is "Microsoft SQL Server 2005", and this just has one sub-menu to "configuration tools". I cannot see a link to any SQL server, so I don't think I have it installed.
Should I uninstall the 5 programs listed above first ? Or can I just install SQL Server 2005 Express on top of what I already have ?
I'm new to programming and I've got to develop a db for a uni project. However after downloading SQL Server 2005 express ed, I found that I could not find the command prompt to start writing scripts (black and white DOS screem). I only have the configuration tool option in my menu (within that server configuration manager, error & usage reporting and server surface area config).
How do I get started with creating my database, please help....................
I'm I not looking in the right place for the console (command prompt to run scripts) or have I not downloaded the right stuff.
When I try to Install SQL Server expres edition I keep on getting this error: http://www.fambouman.com/SQLError.JPG
I'am running Windows SBS 2003 fully updated via windows update.. When I go to the URL mentioned in the error I get an error and the browser redirects to microsoft search.
Anybody know how I can setup SQL Expres ? I need it for dotnetnuke to run.
I'm new to SQL Server (and databases in general) so I don't know what question to ask. I'll just be explicit about what I want to see.
What I need is SQL Server Express to install silently embedded in my application's installation (The user may already have SQL Server Express installed).
Once this is complete, in the SQL Server Configuration Manager under SQL Server 2005 Network Configuration, there should be an entry: Protocols for SONICI with Shared Memory, Named Pipes, and TCP/IP all set to Enabled.
When logging into SQL Server Management Studio there should be a choice for COMPUTERNAMESONICI and there should be a new folder Program FilesMicrosoft SQL ServerMSSQL$SONICI.
Here's what my installer launches from the command prompt: SQLEXPR32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SONICI SQLAUTOSTART=1
It doesn't work. And if I remove the /qn and run it, I get the message: "Microsoft SQL Server 2005 Setup was unable to install on your computer."
The log file reads: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
I have no clue what is wrong and I can't find any helpful information on the web.
I'm completely frustrated in trying to install this product, I've checke the following from the error file
MSI (s) (20:CC) [20:59:45:951]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90BootstrapMSIRefCount 3: 5 MSI (s) (20:CC) [20:59:45:951]: Product: Microsoft SQL Server Setup Support Files (English) -- Error 1402. Could not open key: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90BootstrapMSIRefCount. System error 5. Verify that you have sufficient access to that key, or contact your support personnel.
