Installing && Uninstalling SQL Server Express With Installshield
Dec 10, 2007
Hi
I am trying to install SQL Server Express from command line, without much success. For install, I am using:
Setup /qb INSTANCENAME=SQLEXPRESS ADDLOCAL=SQL_Engine,Connectivity,SAPWD=xxxxxxx
This installs, but SA does not seem to have SA privileges.
I try to uninstall,
Setup /qb REMOVE=ALL INSTANCENAME=SQLEXPRESS
This does not uninstall, even with a reboot.
I have 2005 client tools installed on my machine as well.
Any suggestions?
Thanks
Jim
View 2 Replies
ADVERTISEMENT
May 19, 2006
Is it possible to install SQL2005 Express via InstallShield??
Has anyone had any experience doing this?
Any suggestions or recommendations??
Thanks
View 6 Replies
View Related
May 6, 2007
Hi guys,
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...
Thanks in advance!
William
View 1 Replies
View Related
Jan 8, 2004
Hi all,
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.
Thanks in advance.
Mark.
View 1 Replies
View Related
May 16, 2008
Hi,
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?
Please respond asap.
Thanks for any help.
meeram.
View 1 Replies
View Related
Dec 7, 2006
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?
View 5 Replies
View Related
Nov 22, 2005
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?
View 1 Replies
View Related
Apr 12, 2006
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;
What could be the possible reson for failr?
-timir
View 1 Replies
View Related
Apr 21, 2008
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:
http://msdn2.microsoft.com/en-us/library/ms143365.aspx
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!
Also there is this frightening link:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.server&tid=0187b017-4ea2-4b32-aa28-6f6778d6b47b&mid=925c9341-fcc3-4678-ba53-80f30ee7aa28&cat=en_US_671e06d0-f20d-4bb3-9c6a-42c825ddb1dc&lang=en&cr=US&sloc=&p=1
Any comments will be appreciated.
Thanks.
View 3 Replies
View Related
Oct 23, 2007
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?
Thanks,
mk17
View 1 Replies
View Related
Jun 4, 2008
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.
View 1 Replies
View Related
Aug 17, 2006
I had a problem with the install so I planned to uninstall everything and reinstall SQL EXPRESS, instead I'm stuck.
Pasted below is actual uninstall log. Thanks in advance
Microsoft SQL Server 2005 Setup beginning at Thu Aug 17 21:44:16 2006
Process ID : 2336
D:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/7/17 21:44:16
Complete: LoadResourcesAction at: 2006/7/17 21:44:16, returned true
Running: ParseBootstrapOptionsAction at: 2006/7/17 21:44:16
Loaded DLL:D:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/7/17 21:44:16, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50
1717
Running: ValidateWinNTAction at: 2006/7/17 21:44:16
Complete: ValidateWinNTAction at: 2006/7/17 21:44:16, returned true
Running: ValidateMinOSAction at: 2006/7/17 21:44:16
Complete: ValidateMinOSAction at: 2006/7/17 21:44:16, returned true
Running: PerformSCCAction at: 2006/7/17 21:44:16
Complete: PerformSCCAction at: 2006/7/17 21:44:16, returned true
Running: ActivateLoggingAction at: 2006/7/17 21:44:16
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02B5CFC4Unable to proceed with setup, there was a command line parsing error. : 1717
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2336"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 1717
View 2 Replies
View Related
Feb 14, 2007
Hi
I have installed SQL Server Express 2005 on my machine.
I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.
Can these 2 Editions coexist with each other, or any troubles you think might encounter?
Thanks
View 5 Replies
View Related
Jul 9, 2007
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
View 2 Replies
View Related
Sep 24, 2006
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.
Could I have downloaded the wrong package?
View 6 Replies
View Related
Dec 7, 2006
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.
View 8 Replies
View Related
Aug 20, 2007
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?
View 10 Replies
View Related
Sep 27, 2006
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?
TIA
Steve
View 7 Replies
View Related
Sep 24, 2006
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.
Could I have downloaded the wrong package?
View 1 Replies
View Related
Dec 8, 2006
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.
View 3 Replies
View Related
Jan 30, 2007
Hello,
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.
Thanks.
View 1 Replies
View Related
Sep 23, 2007
hi friends!!!
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.
is it so?
regards.,
sekar
View 3 Replies
View Related
Mar 22, 2007
Hi All,
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.
.......
Can someone help me ?
Thx
View 2 Replies
View Related
Aug 7, 2006
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
View 3 Replies
View Related
Jun 15, 2006
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?
Many thanks!!
View 3 Replies
View Related
May 9, 2006
Hello,
Can I install SQL Express on Windows 2003 server which also has SQL Server 2000?
I already have .NET 2.0 Framework installed.
Should I download the full version of SSE?
Thanks
Frank
View 3 Replies
View Related
Mar 17, 2007
Hello,
I'd like to install SQL Server 2005 Express.
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 ?
Thanks for your advice.
Ian.
View 1 Replies
View Related
Mar 7, 2006
Hi All,
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.
I need help urgently!!!
Thanks, in advance
View 4 Replies
View Related
Jun 15, 2006
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.
Thanks in advance
View 4 Replies
View Related
Sep 26, 2007
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.
View 1 Replies
View Related
Mar 2, 2008
Hi all,
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.
Any advice would be GREATLY appreciated
Cheers
Norman
View 6 Replies
View Related
Dec 1, 2005
help i'm having serious problems installing sql server express and quite at a loss.
View 9 Replies
View Related
Jun 14, 2006
Hi
I recently purchased a copy of Visual Studio 2005 & to my surprise there was a sql Server Express.
My Question is
Do i need to download any more components for this ?
Are Enterprise manager or Query Analyzer part of Sql Server Express?
Ani
View 3 Replies
View Related
