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
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
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 RelatedRunning 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
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
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.
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?
Can anyone tell me why I can't find Reporting Services when I try to install SQL Server Express with Advanced Services?
Thanks...