Installing MSDE 2000 on Server with SQL 2005 Express

Can anybody help?

I have a Windows XP and 2003 server; we have installed SQL 2005 Express on it but have an application that installs MSDE 2000 to connect to an application. After the MSDE 2000 is installed we can no longer see the instance across the network. If we uninstall the SQL 2005 express version we can see the Instance in MSDE 2000.

Is there any compatibility issue with install MSDE 2000 after SQL 2005 has been installed.

Many Thanks in advance

David

In general, this should work. There are specific limitations, which I think are well spelled out in BOL. Here's a copy and paste; hopefully this will describe your issue:

In SQL Server 2000, the identification of the server connection endpoints was performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service. If you install SQL Server on a computer that is also running SQL Server 2000 or MSDE, you must ensure that SQL Server 2000 or MSDE is upgraded to Service Pack 3 (SP3) or later. Versions prior to SP3 do not properly share port 1434 and may not make your SQL Server instances available to requesting client applications. Although you can change the services startup order so that the SQL Server Browser service starts before SQL Server 2000 or MSDE, the recommended resolution is to update all older versions of SQL Server to the latest service pack.

When an instance of SQL Server 2000 is installed on the computer, if the SQL Server Browser is not running, the SQL Server 2000 listener service starts. If SQL Server Browser starts after the listener service, it waits 5 seconds for SQL Server 2000 to give up port 1434. If that does not occur, SQL Server Browser fails to start. To resolve this problem with versions of SQL Server 2000 prior to service pack 3, stop SQL Server 2000, start SQL Server Browser, then restart SQL Server 2000. The SQL Server 2000 listener service continues to attempt to start on port 1434, so the SQL Server 2000 instance should be upgraded to service pack 3 as soon as possible.

SQL Server 7.0 had no similar capabilities and has no conflicts with SQL Server Browser.

Installing MSDE 2000 on a system with SQL Express 2005

I noticed that when I install an app that uses MSDE 2000 on my system (which
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 lines before each entry, some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry, some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installing Microsoft SQL server management studio express broke my asp.net databases

Morning,

I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine.

I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.

Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work.

Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.

Description: An

unhandled exception occurred during the execution of the current web

request. Please review the stack trace for more information about the

error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.

I have posted a solution (that works for me) here.

And there are other solutions in that older post.

|||Simply set the user dafault database for the user to a database which is existing and accessible to him, either with the procedure sp_defaultdb or via the management Studio.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||It was working just fine till I installed the management studio though. What could that possibly be doing to muck with the permissions?

I checked and the user has the default database as master and it definately has access to it. None of the other solutions on this page worked either.

I am really really really unimpressed with this current situation, it is a terrible user experience.|||Make also sure that the database mentioned in the connection string (depending on your provider you are using, for .NET it should be "Initial Catalog" is existing and accessible to the user. if you didn′t configure the user extensivly just drop anbd recreate him. i don′t know which administrative tasks you did prior to this problem, but this should "reset" the settings. make also sure that the user is not in a group which has access denied in the database you are redirecting to. These right will be inherited to the user as restrictive right will always overwrite granted rights.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing Import/Export Wizard for SQL Express

Where do I install the necessary files to get the import/export wizard to show up in sql express management studio? I have tried installing the SP1 Toolkit, the advanced services etc but I cannot get it so that I can right click on a database and 'import data' or 'export data'

Thanks!

I am not sure but because Management studio express is for express database which does not support SSIS services and SQL agent which are used for export/import by wizard this option was removed from user interface.

Sorry

|||

It does not show up on the UI but I found it in this directory

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I think it comes with the Toolkit download

Tony

Installing Express toolkit

Hello

I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working.

Can anyone help with this?

hi,

if you are running on Vista, the problem could be related to privileges required running devenv.exe.. you can try what's reported here, even if not strictly related to BIDS ..

regards

|||

Hi

I am running XP Pro SP2.

|||

I discuss some solutions for the devenv.exe problem in my blog, check out this post.

Mike

Installing Express on box that already has Developer Edition

I'm not at all certain I need to install SQL Server 2005 Express Edition on
my box, but I thought I'd post this anyway.
I currently have SQL Server 2005 Developer Edition installed on my box and
am using it to develop a commercial website I hope to deploy within the next
six months. Meanwhile, I have at least one upcoming Windows Forms project
requiring a SQL Server database which will need to be deployed with the
project. Naturally, I will be including the .mdf file in the setup files fo
r
the project.
My questions are as follows:
1) Will I need to include a copy of the SQL Server 2005 EE on my setup disk
or can I get by with just distributing the .mdf file?
2) If the answer to question 1 is yes on including a copy of SSEE; do I need
to install SQL Server 2005 EE on my computer in order to include it with the
setup disk? I would want to be able to install my application and the
database as a single operation rather than forcing the end user to install
SQL Server first and then install the application.
3) If the answer to question 2 is yes, what problems, if any, will I
encounter trying to install SQL Server 2005 EE on a machine that already has
the Developer Edition installed?
Thanks for any and all help!
Allen"SQL Server Express can be redistributed (subject to agreement)". so, you
can bundle it with your application.
if you know for sure that your clients already have sqlexpress installed,
you can just include the *.mdf. this will make your deployment package much
smaller.
no, you do not need to install sqlexpress on your box in order to
redistribute it. typically, if you're an ISV and develop your app using a
valid visual studio, you should be good to redistribute.
there should be no prob installing sqlexpress on a box with dev edt.
-oj
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||"SQL Server Express can be redistributed (subject to agreement)". so, you
can bundle it with your application.
if you know for sure that your clients already have sqlexpress installed,
you can just include the *.mdf. this will make your deployment package much
smaller.
no, you do not need to install sqlexpress on your box in order to
redistribute it. typically, if you're an ISV and develop your app using a
valid visual studio, you should be good to redistribute.
there should be no prob installing sqlexpress on a box with dev edt.
-oj
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||Addition to the other reply.
You can install Sql Server2005 Express on the computer with SQL Server 2005
Developer Edition/Standard editon, or other editions. I have both (Developer
and Express Adv) installed on one of my boxex).
If your application uses SQL Server2005 Express's user instanace feature
(only available to Express edition, not other editions), then you want to
try it out on your development computer before shipping your app to client.
In this case, you need to have SQL Server 2005 Express available on your
computer.
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||Addition to the other reply.
You can install Sql Server2005 Express on the computer with SQL Server 2005
Developer Edition/Standard editon, or other editions. I have both (Developer
and Express Adv) installed on one of my boxex).
If your application uses SQL Server2005 Express's user instanace feature
(only available to Express edition, not other editions), then you want to
try it out on your development computer before shipping your app to client.
In this case, you need to have SQL Server 2005 Express available on your
computer.
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allensql

Installing Express on box that already has Developer Edition

I'm not at all certain I need to install SQL Server 2005 Express Edition on
my box, but I thought I'd post this anyway.
I currently have SQL Server 2005 Developer Edition installed on my box and
am using it to develop a commercial website I hope to deploy within the next
six months. Meanwhile, I have at least one upcoming Windows Forms project
requiring a SQL Server database which will need to be deployed with the
project. Naturally, I will be including the .mdf file in the setup files for
the project.
My questions are as follows:
1) Will I need to include a copy of the SQL Server 2005 EE on my setup disk
or can I get by with just distributing the .mdf file?
2) If the answer to question 1 is yes on including a copy of SSEE; do I need
to install SQL Server 2005 EE on my computer in order to include it with the
setup disk? I would want to be able to install my application and the
database as a single operation rather than forcing the end user to install
SQL Server first and then install the application.
3) If the answer to question 2 is yes, what problems, if any, will I
encounter trying to install SQL Server 2005 EE on a machine that already has
the Developer Edition installed?
Thanks for any and all help!
Allen"SQL Server Express can be redistributed (subject to agreement)". so, you
can bundle it with your application.
if you know for sure that your clients already have sqlexpress installed,
you can just include the *.mdf. this will make your deployment package much
smaller.
no, you do not need to install sqlexpress on your box in order to
redistribute it. typically, if you're an ISV and develop your app using a
valid visual studio, you should be good to redistribute.
there should be no prob installing sqlexpress on a box with dev edt.
--
-oj
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||Addition to the other reply.
You can install Sql Server2005 Express on the computer with SQL Server 2005
Developer Edition/Standard editon, or other editions. I have both (Developer
and Express Adv) installed on one of my boxex).
If your application uses SQL Server2005 Express's user instanace feature
(only available to Express edition, not other editions), then you want to
try it out on your development computer before shipping your app to client.
In this case, you need to have SQL Server 2005 Express available on your
computer.
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen

Installing Express Issue

I have just installed Sql Express

But one installed all I have available to me is

Sql Server Config Man

Sql Server Error reporting Usage

Surface area config

IDoes any one know how to get the other features like the databases and reporting installed

thanks for any help Sammy

YOu will have to install the advanced edition for that. The normal edition does not include the reporting Service nor any database administration surface like the Management Studio.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

sql

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

Installing and Uninstalling Express Edition

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

Hi,

Since my initial posting, I've been working on the command to uninstall a named instance of SQL Server 2005. I though it would help once I get my problem above solved, as it seems to be the next logical step.

It seems that from MSDN (http://support.microsoft.com/default.aspx/kb/909967), there isn't a way to automate this process neither. The command ARPWrapper.exe don't have (or I couldn't fine) parameter to specify the named instance I'm trying to remove. The switch "/REMOVE" just brings up a window letting user choose their instance to remove. Anyone knows if such a way exists?

As I've said before, I'm trying to package my .NET application with SQL Server 2005 Express Edition into one. So that users can install and uninstall from one place with minimal user intervention. It seems to be such a common task, but it's certainly not too intuitive.

William

|||I too want to have the ability to uninstall a named instance of SQL Server 2005 Express SP2 from the command prompt in silent mode? You were you able to find a solution?sql

Installing and Configuring Reporting Services using the Command Prompt

Hello, I have a question regarding installing SQL Express with Advanced Services from the command prompt. I am executing a .cmd file which has the following syntax:

start /wait setup.exe /qb INSTANCENAME=Tim ADDLOCAL=SQL_Engine,Connectivity,RS_Server,RS_Web_Interface SAPWD=1StrongPassword_2 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

Yet, after the installation when I run the Reporting Services configuration tool, none of the settings for Reporting Services are set. I would like to be able to install Reporting Services from the command prompt and have it use the default settings for creating a default website just like you can through the User Interface using the Setup.exe but cannot seem to figure out what I am missing in my .cmd file?

I would appreciate any help anyone can provide.

Tim

I suspect that you are wanting to deploy Reporting Services with your application.

If so, these resources may be helpful:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648

|||

Thanks Arnie, this is great!

Tim

Installing Agent Service

Hi,
I have just installed SQL Server 2005 Express Adv. which I expected to
have the Agent service.
How do I install the agent service and where can I get it from?
Thanks
hi,
WA wrote:
> Hi,
> I have just installed SQL Server 2005 Express Adv. which I expected to
> have the Agent service.
> How do I install the agent service and where can I get it from?
> Thanks
SQLExpress does not feature the SQL Server Agent, so jobs and alerts are not
available as well.. for scheduled "actions" you have to rely on the native
OS scheduler or third party schedulers..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply

Installed SQL Express and Now Front Page won't work.

A couple of weeks ago I installed SQL Express on a system that also has VS 2005, Front Page and other applications. Now the Front Page application can no longer connect to the web server and I keep getting a message:

Server error: Error 2 opening registry key "SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Ports\Port 80".

Has anyone else seen this error? Any suggestions on resolving this.

I did try a reinstall of Front Page and the error is still there.

John

Since the problem you're having is with FrontPage, you should ask the FrontPage experts. I'd suggest starting in the Office Newsgroups and if that doesn't sort it out, call the support organization.

I'm not aware of any changes made by SQL Express that would impact your permissions to that registry hive, it is likely just a coincidents that your FP problems started around the same time that you installed SQL Express.

Mike

|||

For anyone ever looking into a problem like this, the actual issue was a problem on the internet server side. The Front Page extensions had gotten messed up. The solution was to have the hosting provider reinstall the front page extensions on me web site (www.teaminfocenter.com) and that got things working again.

Thanks

John

Installed SQL Express and Now Front Page won't work.

A couple of weeks ago I installed SQL Express on a system that also has VS 2005, Front Page and other applications. Now the Front Page application can no longer connect to the web server and I keep getting a message:

Server error: Error 2 opening registry key "SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Ports\Port 80".

Has anyone else seen this error? Any suggestions on resolving this.

I did try a reinstall of Front Page and the error is still there.

John

Since the problem you're having is with FrontPage, you should ask the FrontPage experts. I'd suggest starting in the Office Newsgroups and if that doesn't sort it out, call the support organization.

I'm not aware of any changes made by SQL Express that would impact your permissions to that registry hive, it is likely just a coincidents that your FP problems started around the same time that you installed SQL Express.

Mike

|||

For anyone ever looking into a problem like this, the actual issue was a problem on the internet server side. The Front Page extensions had gotten messed up. The solution was to have the hosting provider reinstall the front page extensions on me web site (www.teaminfocenter.com) and that got things working again.

Thanks

John

Installation SQL Server 2005 Express Edition

My Installation failed for the SQL Server. Is it true that the SQL Server is running only in Windows XP Prof with Service Pack 2.

Thanks!

Hi,

That is correct. The software requirements have been explicitly mentioned as Windows XP Service Pack 2 on the download page here.

Regards,
Vikram

Installation SQL 2005 Express from a network

Does anyone know of the procedure, steps that need to be followed to allow installing SQL 2005 Express from a network? Since SQL 2005 express requires .NET 2 and the MSI engine 3.1 and MDAC 2.8 it is a real problem pushing it from a network such as active directory using an AIP (Administrator Installation Point).

Perhaps these will help:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://www.devx.com/dbzone/Article/31648

As far as I am aware, there is no direct support for Enterprise use of SQL Express, including push installations. Think about it. Why would a company go to much trouble (and expense) creating an advanced tool to allow you to use a free product.

SQL Express is not positioned as an Enterprise product.

|||Thank you Arnie we will check out that article. Yea I know but we have corp. customers who want to deply SQL Express to workstations from the network and not use pull so we are trying to please them.

Installation Question - Service account

Hi All,

We are upgrading from Sql Server Express to SQl Server 2005. As part of the installation process, it is not asking us to specify a service account for various services, and we are not sure what to specify. (This was handled automatically with Express). Any ideas?

Thanks.

Claude.

Hi All,

There was a typo in my original post, it should have read:

We are upgrading from Sql Server Express to SQl Server 2005. As part of the installation process, it is NOW asking us to specify a service account for various services, and we are not sure what to specify. (This was handled automatically with Express). Any ideas?

Thanks.

Claude.

|||

Hi Claude,

This service account specifies under what account is this SQL Server instance running.

If your instance might be querying some domain resource, you can specify a domain account. Or you can just select the System Account.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!

installation problem-SQL server 2005 Express Edition

While installing SQL server 2005 Express edition following message is encountered every time I have tried. My system(PC) meets all the pre-requisites.

TITLE: Microsoft SQL Server 2005 Setup

setup.exe - Unable to Locate Component.

"This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem"

Failed to load SqlSpars.dll

I had tried to install lot of time. Also I had followed all the steps to manually uninstall the software. And again tried to install it.
Still I am getting same error message.

Am I installing correct installatoin file?

or something else is required to be installed/configured as pre-requisites.

Hi Vikash,

Did you ever get this fixed? I am now having the same problem with katmai.

What OS were you installing on? I am on Windows Server 2003, running on Virtual PC.

Thanks

Jamie

|||

Hi Jamie,

I have got a fix. I had installed another file.

Filename was "SQL Server 2005 Express Edition with Advanced Services SP2" and its size is 256MB.

I was using windows XP SE.

Thanks

vikash