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?
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 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.
I have Windows Vista Home Premium, with Visual Studio 2005 installed, and SQL Server Express Edition installed. What I want to do is upgrade to SQL Server Express Edition SP2. I understand that I can install SP2 on top of SQL Server Express Edition. However, there are just a couple of areas that I'd like assurances on (have never used SQL Server):
1. Since all my work with SQL Server Express Edition SP2 will be done via the Visual Studio 2005 IDE, does that mean that I don't need to download and install SQL Server Management Studio Express? The Management Studio seems to be more for a standalone development environment. I just want to make sure about this.
2. Also, the information on the information page about Windows Vista issues with User Account Control is not specific to SQL Express Edition SP2. There's a lot of generic and, quite frankly, very abstract information that is hard to understand. For now I'm just planning to install SQL Server and leave it at that, unconfigured, in whatever state the install leaves it at. I am hoping against hope that I will be able to familiarize myself with SQL Server via the Microsoft Visual C# 2005 Step-by-Step book, which is why I'm upgrading to SQL Server Express Edition SP2 in the first place. I'll glean what I can about configuration in the SQL Server Express Edition SP2 docs, but what are the chances that I'll find anything that is specific to using the database soley with Visual Studio 2005? Perhaps I'll be pleasantly surprised. About the User Account control issues, are there are any articles that specifically discuss User Account control issues that are associated with SQL Server Express Edition SP2?
Sorry about the windage. I'm a little cranky after spending about 2 hours clicking from one link to another.
I am gettierror whle installing the SQL Server Express.
Product: Microsoft SQL Server 2005 Express Edition -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
I have Visual Web Developer 2005 Express edition and I wanted to install SQL Server 2005 Express edition.From this page, I have downloaded and installed 'Microsoft SQL Server 2005 Express Edition' and 'Microsoft SQL Server 2005 Express Edition with Advanced Services http://msdn.microsoft.com/vstudio/express/sql/download/After the installation, how should I access the SQL Server 2005 Express edition?Because the only thing listed in 'Start > All Programs > SQL Server 2005' is 'Configuration Tools'I was hoping that when I install SQL Server 2005 express edition, I would get all the menu that I get by installing SQL Server 2000.So after installing SQL Server 2005 Express edition, what should I be expection? Thanks
When I try to install SQL Server 2005 Express I find that after a short time it discontinues and say's "Installation not completed etc" on looking at the logs it say.s "Could not find IIS" do I need XP Pro to be able to install SQL Server Thanks in advance
I've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops. After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions. I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example. Thanks in advance for help any of you can suggest. Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006Process ID : 2036c:6645bd818fccc8ef0bad80e6a12f5bsetup.exe Version: 2005.90.1399.0Running: LoadResourcesAction at: 2006/1/5 23:48:6Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned trueRunning: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6Loaded DLL:c:6645bd818fccc8ef0bad80e6a12f5bxmlrw.dll Version:2.0.3604.0Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateWinNTAction at: 2006/1/5 23:48:8Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateMinOSAction at: 2006/1/5 23:48:8Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned trueRunning: PerformSCCAction at: 2006/1/5 23:48:8Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned trueRunning: ActivateLoggingAction at: 2006/1/5 23:48:8Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned trueRunning: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned trueAction "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.Running: PerformSCCAction2 at: 2006/1/5 23:48:8Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned trueRunning: PerformDotNetCheck at: 2006/1/5 23:48:9Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned trueRunning: ComponentUpdateAction at: 2006/1/5 23:48:9Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned trueRunning: DetectLocalBootstrapAction at: 2006/1/5 23:48:30Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned trueRunning: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30
I just got a new machine with Vista on it. It also came with SQL Server 2005 Express.
How do I install SQL Server Management Console on this machine? I do have an MSDN DVD with a Developer's Edition on it. Can I use this somehow? When I try to run the Tools setup.exe with SKUUPGRADE=1, it tells me there is nothing to upgrade.
Hi, if I install SQL Server Express with Advance Services on top of my existing SQL Server Express installation, will it wipe out my existing database in my current SQL Server Express installation ?
I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?
Here is the report from the install:
System Configuration Check
- WMI Service Requirement (Success)
Messages
WMI Service Requirement
Check Passed
- MSXML Requirement (Success)
Messages
MSXML Requirement
Check Passed
- Operating System Minimum Level Requirement (Success)
Messages
Operating System Minimum Level Requirement
Check Passed
- Operating System Service Pack Level Requirement. (Error)
MessagesOperating System Service Pack Level Requirement.
The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.
- SQL Server Edition Operating System Compatibility (Success)
Messages
SQL Server Edition Operating System Compatibility
Check Passed
- Minimum Hardware Requirement (Warning)
Messages
Minimum Hardware Requirement
The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.
I've been trying to install SQL Server Express 2005 on my machine at home (XP Pro). However, when I get done, I get the following error when I restart my computer (at the login screen): "Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall the re-run setup to correct this problem."
I have uninstalled and reinstalled a number of times, with always thesame result. I had Visual Studio Orcas Beta 2 installed, so I thought that might have had something to do with it. I uninstalled everything development related on the machine (including all versions of the .NET Framework), and am still getting the same error. I tried installing along with Visual Studio 2005 (since it can be installed through the VS installer), same error.
I haven't been able to find any helpful information on this error. It seems everyone else is seeing it when they try to open Management Studio or some other program, but I am seeing it on system start.
Anyone have any thoughts? I'd really like to get this working. Thanks.
I've been trying to install sql server 2005 express on my laptop with win xp pro. Unfortunately, I keep getting this error:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Mon Dec 24 09:46:52 2007
Machine : ANN_NGUYEN Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0024_ANN_NGUYEN_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : ANN_NGUYEN Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0024_ANN_NGUYEN_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : ANN_NGUYEN Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0024_ANN_NGUYEN_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : ANN_NGUYEN Product : MSXML 6.0 Parser (KB933579) Product Version : 6.10.1200.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0024_ANN_NGUYEN_MSXML6_1.log -------------------------------------------------------------------------------- Machine : ANN_NGUYEN Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : ANN_NGUYEN Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0024_ANN_NGUYEN_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted. Error Number : 29515 --------------------------------------------------------------------------------
Can you guys please send me some info how you fix this problem. Thanks in advance. -Mike
I was running the setup program and it popped up an error message:
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
I looked at ERRORLOG and it says:
2008-05-07 04:00:11.67 spid4s Starting up database 'msdb'. 2008-05-07 04:00:11.74 Server Error: 17190, Severity: 16, State: 1. 2008-05-07 04:00:11.74 Server FallBack certificate initialization failed with error code: 1. 2008-05-07 04:00:11.74 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
