SQLEXPR32.EXE Vs SQLEXPR_ADV.exe
Sep 24, 2007
For a program written in VB .net 05...
We are upgrading our customers from MSDE to SQL Express 2005 (SQLEXPR32.EXE - not the advanced services version). However, I accidently via PCAnywhere installed the advanced version (SQLEXPR_ADV.exe); and, to make things more interesting, we want to change the name of the Server Instance from the default of SQLExpress.
I have asked in this newsgroup before, and was told that if the Advanced Services are not used, then it does not matter that it was installed on a computer without IIS. It will simply function the same as SQL Express 2005. I presume that is correct (and seems to be by experience).
Question 1) To install a new named instance, I have to run the .EXE over again. What happens if I run SQLEXPR32.EXE for a new instance when I have already run SQLEXPR_ADV.exe for the existing instance of SQLExpress? Which should I use for the new instance when I really want SQLEXPR32.EXE installed?
Question 2) Additionally, I understand how to remove an SQL instance, but how do you remove the program itself, ie SQL Express with Advanced Services? Either version of SQL Express only seems to allow you to remove instances, not the program itself.
Question 3) Does SQL Express with Advanced Servies install additional programs to manage the SQL, or does it give extra features that can be used in programing, or both?
Thanks
Bob
View 1 Replies
Nov 22, 2007
Hi everyone,
I can't figure out what this problem may be:
At my application I'm installing sqlexpr32.exe by doing this:
Code Block
System.Diagnostics.Process proc1 = System.Diagnostics.Process.Start(
Environment.ExpandEnvironmentVariables("%SQLHome%")+ @" sqlexpr32.exe", "/norebootchk /qb reboot=ReallySuppress addlocal=all " + "instancename=SQLEXPRESS SQLAUTOSTART=1");
proc1.WaitForExit();
proc1.Close();
when I do this for the first time the sql setup runs but gives me an error saying that the file sqlncli.msi (Native Client) was not found
but if I go to the temp directory the msi is there..
when I run the app for the second time the sqlexpr32.exe detects the Native Client setup file and does the installation perfectly..
What could it be? Some thread issues?
Thanx in advance
View 1 Replies
View Related
Nov 21, 2007
Hi everyone,
I can't uninstall the sqlexpr32.exe from command line.
I read somewhere that I could do it by typing 'start /wait <drive:>sqlexpr32.exe /qb REMOVE=ALL INSTANCENAME=SQLEXPRESS'
but when I do that it extracts the support files to install the sqlexpress but it is already installed.
I'd like to remove it programmaticaly so if I knew the command line to uninstall sqlexpr32.exe, my problem will be solved.
Thanx in advance
View 6 Replies
View Related
Sep 24, 2007
I installed SQL Express (SQLEXPR32.EXE, not with advance services) and choose to install all components, and got the following message (the machine is Pentium 4, 2.4 GHz CPU, 512MB Ram, 100 gig drive)
Minimum hardware requirement (warning)
T he 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 looked at the SQL Books Online, and don€™t see where this system does not meet recommended hardware requirements. Any ideas what is going on? It seems to work ok.
Thanks,
Bob
View 6 Replies
View Related
May 1, 2008
I have installed Client part of SQL Server Managment Studio on my local desk top to connect to my servers.
Question is that is it better to replace it with SQL Express Advanced? What is the difference between these two?
Canada DBA
View 3 Replies
View Related
Aug 9, 2006
Does the _adv version of the .exe file support all the same command line switches as the basic version? Or is there an easy way to include reporting services on the basic one without going up to the _adv one?
View 1 Replies
View Related
May 17, 2006
Running SQLEXPR_ADV.EXE against Windows XP SP0 causes the setup to exit gracefully with a message indicating the the right service pack is not installed.
However, running SQLEXPR_ADV.EXE against Windows XP SP1 does not exit and continues to install. Then, when you try to run a script against the installation, you get the message:
[Microsoft][ODBC SQL Server Driver][DBMSLPCN][SQL Server does not exist or access denied].
This will become very problematic when installing SQL Server Express as the database for small installations.
The setup really needs to be updated to look for all the system requirements that it can detect. Evidently it can detect the Service Packs. The Wise Installer is not able to script that requirements unless there is some way to make the Windows Installer look for it that is not documented.
Pat
View 3 Replies
View Related
Mar 24, 2007
Hi there,
I have Vista Ultimate and have installed IIS. I downloaded and installed - sucessfully - on a XP Pro (SP2) version, however when I try and install on Vista Ultimate, the installation wizard warns me that IIS is not installed, or running.
I am in the proccess of migrating to Vista and SQL server 2000 is not compatible with Vista. (or so the installation warns me).
I would prefer to use SQL Server 2000 as I know that the data import and export facilities work fine.
When I tried to import data from a remote server, I connected fine, but cannot see how to import a full database and tables to my local server. I need this for my web development as most of the sites I work on use MS SQL Server.
Any help with this will be greatly appreciated.
Thanks
Hans
View 3 Replies
View Related
Oct 30, 2007
I assume the answer to my question is yes, but just in case...
Is the SQLEXPR_ADV.EXE adapted to install appropriately on both 32-bit and 64-bit target systems?
Thanks in advance.
View 1 Replies
View Related
Jun 5, 2007
I'm trying to install SQL EXPRESS but I get this error message:
The SQL Server Configuration Checker cannot be executed due to WMI configuration on machine NDXT23ARC Error:2147749902(0x8004100e). What can I do?
View 1 Replies
View Related
Mar 12, 2007
Can anyone tell me why I can't find Reporting Services when I try to install SQL Server Express with Advanced Services?
Thanks...
View 4 Replies
View Related