Installing Multiple Instances of ASP.NET Application Services on ONE SQL Server Database

Hi,

I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.

Please help if you can.

Thanks,

Ezeibe

Seems not possilble in 1 databases, but should be able in different databases on 1 SQL instance. Just use aspnet_regsql.exe to create schema for membership in serveral database, and then connect to 1 database respectively in your applications.

Installing MSDE with VB application

Does anyone have any experience or knowledge what would be best way of installing msde with vb application
I created vb app with msde database , right now app uses sql server, iam planning to move sql database to msde and distribute that with vb app. What would be best approach for distributing and installing those files? Does vb package deployment will do the trick or I should acuire some professional setup program ??
Thanks
RobertRefer to MS website about recent updations on MSDE.

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 (VB.NET)

Hi,
I need to package and deploy my MSDE database with my application. How do I
do this? It needs to deploy, install, and I need to also install tables,
users, user rights and also possibly some sample data.
I can do an unattended install, but do I have to write a seperate program or
use osql/isql to run batch file/sql scripts to update the database?
Surely there's an automated method to "click-and-install"...?

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><
My friend, there is no elegant way to do this.
Microsoft offers merge modules that will handle the installation for you. You can then use a CustomAction to attach a database or run SQL statementts to create a database. This isn't recommended because now YOU become responsible for creating a patch file
to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.
What I have ended up doing is programmatically shelling out to call the setup.exe program that is included with MSDE. I have created a program that looks similar to the Visual Studio .NET install where users can first click on a link to launch the SQL Ser
ver 2000 MSDE install, then install my application.
Microsoft has also created a gimpy MSDE/.NET Framework bootstrapper, but it is far from being stable. I personally think it's a piece of junk and wouldn't recommend it. *Supposedly*, if the next version of Visual Studio EVER ships, a generic bootstrapper
is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.
I recommend shelling out to the setup.exe program provided with MSDE. Good luck.
Rob Reagan
"Liddle Feesh" wrote:

> Hi,
> I need to package and deploy my MSDE database with my application. How do I
> do this? It needs to deploy, install, and I need to also install tables,
> users, user rights and also possibly some sample data.
> I can do an unattended install, but do I have to write a seperate program or
> use osql/isql to run batch file/sql scripts to update the database?
> Surely there's an automated method to "click-and-install"...?
>
> --
> Liddle Feesh
> *fap fap fap fap*
> <>< <>< <>< <>< ><>
> <>< <>< <>< <>< <>< <><
>
>
|||Hi Rob,
I have been using the MSDE bootstrapper and have had quiet a few issues with it, like the installation just hangs many times, the MSDE instance needs to be reinstalled even if it is installed (a confirmed bug my Microsoft here), etc.. you mentioned you ar
e shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.
Thanks
dev
"Rob Reagan" wrote:

> My friend, there is no elegant way to do this.
> Microsoft offers merge modules that will handle the installation for you. You can then use a CustomAction to attach a database or run SQL statementts to create a database. This isn't recommended because now YOU become responsible for creating a patch fi
le to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.
> What I have ended up doing is programmatically shelling out to call the setup.exe program that is included with MSDE. I have created a program that looks similar to the Visual Studio .NET install where users can first click on a link to launch the SQL S
erver 2000 MSDE install, then install my application.
> Microsoft has also created a gimpy MSDE/.NET Framework bootstrapper, but it is far from being stable. I personally think it's a piece of junk and wouldn't recommend it. *Supposedly*, if the next version of Visual Studio EVER ships, a generic bootstrappe
r is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
> I recommend shelling out to the setup.exe program provided with MSDE. Good luck.
> Rob Reagan
> "Liddle Feesh" wrote:
|||Since I am using this as a remote database over the network, I'm setting DISABLENETWORKPROTOCOLS=0. I'm also setting the SAPWD, INSTANCENAME, and SECURITYMODE parameters.
Be forewarned that the MSDE installer is a great example of the half-baked software that Microsoft inflicts on the public. The uninstaller leaves garbage behind. While developing, you're going to have to do alot of removal of orphaned files and registry k
eys by hand before you can attempt a reinstall for the same named instance.
Be very careful when cleaning out your registry from orphaned MSDE keys. I zapped a few that I shouldn't have and was unable to reinstall MSDE, period. I've got to reformat my drive and reinstall Windows.
Rob
"dev_kh" wrote:

> Hi Rob,
> I have been using the MSDE bootstrapper and have had quiet a few issues with it, like the installation just hangs many times, the MSDE instance needs to be reinstalled even if it is installed (a confirmed bug my Microsoft here), etc.. you mentioned you
are shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.[vbcol=seagreen]
> Thanks
> dev
> "Rob Reagan" wrote:
file to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.[vbcol=seagreen]
Server 2000 MSDE install, then install my application.[vbcol=seagreen]
per is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
|||Oh My Goodness, I also had to manually delete the registry keys many times but no formatting so far. Thanks for your reply though. I was wondering more in lines with figuring out whether the MSDE installation went fine or not when you shell it out. Als
o do you do any logging of the MSDE installation..
Thanks again
"Rob Reagan" wrote:

> Since I am using this as a remote database over the network, I'm setting DISABLENETWORKPROTOCOLS=0. I'm also setting the SAPWD, INSTANCENAME, and SECURITYMODE parameters.
> Be forewarned that the MSDE installer is a great example of the half-baked software that Microsoft inflicts on the public. The uninstaller leaves garbage behind. While developing, you're going to have to do alot of removal of orphaned files and registry
keys by hand before you can attempt a reinstall for the same named instance.[vbcol=seagreen]
> Be very careful when cleaning out your registry from orphaned MSDE keys. I zapped a few that I shouldn't have and was unable to reinstall MSDE, period. I've got to reformat my drive and reinstall Windows.
> Rob
> "dev_kh" wrote:
u are shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.[vbcol=seagreen]
h file to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.[vbcol=seagreen]
QL Server 2000 MSDE install, then install my application.[vbcol=seagreen]
apper is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
|||I have had good luck shelling the setup.exe program. My only complaint there is that the uninstaller is so sloppy and leaves behind a bunch of keys and files. I do not log in my production program, only in my test environment. I have considered writing my
own custom uninstaller that shells to the windows uninstaller, then cleans up keys and files afterwards. The only disadvantage is that the user could bypass my customer uninstaller (accesible through the programs menu) and use the one in Add\Remove Progr
ams.
Rob
"dev_kh" wrote:

> Oh My Goodness, I also had to manually delete the registry keys many times but no formatting so far. Thanks for your reply though. I was wondering more in lines with figuring out whether the MSDE installation went fine or not when you shell it out. A
lso do you do any logging of the MSDE installation..[vbcol=seagreen]
> Thanks again
> "Rob Reagan" wrote:
ry keys by hand before you can attempt a reinstall for the same named instance.[vbcol=seagreen]
you are shelling out the exe yourself. I was just wondering what all parameters are you taking care of.. I mean In general what pointers/advise will you give to anyone who wants to do the same thing.[vbcol=seagreen]
tch file to patch the millions of security holes in MSDE. MSDE also uninstalls with your program under this scenario.[vbcol=seagreen]
SQL Server 2000 MSDE install, then install my application.[vbcol=seagreen]
trapper is supposed to be included that will allow chained .MSI installations. But until then, we're out of luck.[vbcol=seagreen]
|||Hi Rob,
Cheers for the reply (and the other guys too!) - I've heard Microsoft
released an MSDE Installer SDK in December 2003... might be worth a look
at?
It's pretty late and I've just got in - so I'll have to look at this
tomorrow!
cya later, chaps!

Liddle Feesh
*fap fap fap fap*
<>< <>< <>< <>< ><>
<>< <>< <>< <>< <>< <><

Installing MSDE

I have almost finished developing an application that uses MSDE. I want to
now deploy MSDE with my app. I have the original SQL Server 2000 CD that
contains the MSDE setup files.
I understand that there has been a major upgrade to MSDE 2000 and that I
should use some sevice pack files to install MSDE. Do I download this
service pack (sql2desk.exe?), extract the files in there and copy them over
the original files? Or do I need to install using the original CD and then
upgrade the installation with the service pack stuff?
TIA,
Paul
hi Paul,
"Paul McTeigue" <paul_mcteigue@.msn.com> ha scritto nel messaggio
news:ePVutaLIEHA.348@.tk2msftngp13.phx.gbl...
> I have almost finished developing an application that uses MSDE. I want to
> now deploy MSDE with my app. I have the original SQL Server 2000 CD that
> contains the MSDE setup files.
> I understand that there has been a major upgrade to MSDE 2000 and that I
> should use some sevice pack files to install MSDE. Do I download this
> service pack (sql2desk.exe?), extract the files in there and copy them
over
> the original files? Or do I need to install using the original CD and then
> upgrade the installation with the service pack stuff?
you only have to use and deploy the content of the new sql2desk.exe, updated
at service pack 3a level..
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

installing MSDE

here's the problems I'm having with MSDE:
I install MSDE SP3a with my application using InstallShield. The problem is that not everything is installed, because after I'm prompted for reboot, the database starts up, everything ok, right?
No, because when I run some scripts we have created to access the database, this dialog pops up like it needs to install more stuff for MSDE. It starts "configuring MSDE" and looks for the installer package and begins installing more stuff. What is it i
nstalling?
I'm guessing it has to do with some lines in the scripts that aren't quite supported or that require something that the standard distro doesn't install by default. Any ideas on tracking this down? Will this "installer" start when the line is executed in
my vb.net code or will it start when the vb.net code is started and it realizes it needs more stuff? Is there a way to install everything by default to avoid this?
Thanks,
Jacob
Here's some more information, I extracted this from the log, btw this is on a windows server 2k3:
Event Type:Warning
Event Source:MsiInstaller
Event Category:None
Event ID:1004
Date:6/18/2004
Time:11:42:16 AM
User:N/A
Computer:FUNKMACHINE
Description:
Detection of product '{E09B48B5-E141-427A-AB0C-D3605127224A}', feature 'SqlRun', component '{072BBB16-FE7A-405F-BBCC-54622D21CE3A}' failed. The resource 'HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\Service Manager\' does not exist.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Warning
Event Source:MsiInstaller
Event Category:None
Event ID:1001
Date:6/18/2004
Time:11:42:16 AM
User:N/A
Computer:FUNKMACHINE
Description:
Detection of product '{E09B48B5-E141-427A-AB0C-D3605127224A}', feature 'SqlRun' failed during request for component '{436D7A23-36BE-11D2-ACBB-0080C7FCBB84}'
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/18/2004
Time:11:42:26 AM
User:N/A
Computer:FUNKMACHINE
Description:
8128 :
Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: c0 1f 00 00 0a 00 00 00 à......
0008: 0c 00 00 00 46 00 55 00 ...F.U.
0010: 4e 00 4b 00 4d 00 41 00 N.K.M.A.
0018: 43 00 48 00 49 00 4e 00 C.H.I.N.
0020: 45 00 00 00 07 00 00 00 E......
0028: 6d 00 61 00 73 00 74 00 m.a.s.t.
0030: 65 00 72 00 00 00 e.r...
Event Type:Information
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/18/2004
Time:11:42:55 AM
User:N/A
Computer:FUNKMACHINE
Description:
17148 :
SQL Server is terminating due to 'stop' request from Service Control Manager.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: fc 42 00 00 0a 00 00 00 üB.....
0008: 0c 00 00 00 46 00 55 00 ...F.U.
0010: 4e 00 4b 00 4d 00 41 00 N.K.M.A.
0018: 43 00 48 00 49 00 4e 00 C.H.I.N.
0020: 45 00 00 00 07 00 00 00 E......
0028: 6d 00 61 00 73 00 74 00 m.a.s.t.
0030: 65 00 72 00 00 00 e.r...
Event Type:Information
Event Source:MsiInstaller
Event Category:None
Event ID:11728
Date:6/18/2004
Time:11:43:11 AM
User:N/A
Computer:FUNKMACHINE
Description:
Product: Microsoft SQL Server Desktop Engine -- Configuration completed successfully.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 45 30 39 42 34 38 42 {E09B48B
0008: 35 2d 45 31 34 31 2d 34 5-E141-4
0010: 32 37 41 2d 41 42 30 43 27A-AB0C
0018: 2d 44 33 36 30 35 31 32 -D360512
0020: 37 32 32 34 41 7d 7224A}
What is triggering the MSI installer? How can I prevent this from interrupting my code?
Thanks,
Jacob
"Jacob438" wrote:

> here's the problems I'm having with MSDE:
> I install MSDE SP3a with my application using InstallShield. The problem is that not everything is installed, because after I'm prompted for reboot, the database starts up, everything ok, right?
> No, because when I run some scripts we have created to access the database, this dialog pops up like it needs to install more stuff for MSDE. It starts "configuring MSDE" and looks for the installer package and begins installing more stuff. What is it
installing?
> I'm guessing it has to do with some lines in the scripts that aren't quite supported or that require something that the standard distro doesn't install by default. Any ideas on tracking this down? Will this "installer" start when the line is executed
in my vb.net code or will it start when the vb.net code is started and it realizes it needs more stuff? Is there a way to install everything by default to avoid this?
> Thanks,
> Jacob

Installing feature Pack components with an Application

Hi,

I have developed an application the uses SMO and RMO, now it is time to write the setup for it.

For the setup experience I want to be able to install my application on a clean copy of XP SP2 which has dotnet 2.0 already installed. As such I have downloaded the following from the Feature Pack for Sql 2005 (http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en):

msxml6.msi

sqlncli.msi

sqlserver2005_xmo.msi

Now I'm thinking that I need to launch these msi's from within my own application msi, however, I don't want any UI displayed and I want my own msi to include these msi's when it's calculating the cost of the install.

Is this the correct way to go about getting these components on to a clients machine, i.e. nested msi install, or is there a better way?

Does anyone know what command line args (msiexec) or other options I need to provide for a UI less install of the above?

FYI I'm using VS 2005 to author the install.

Thanks for your help

Graham

Infact, why aren't msm (merge modules) given anymore?

Graham

|||

To get a silent install, use the "\qn" flag for MSIExec. In order to 'chain' MSI installations, you'll need to create a setup.exe wrapper that will launch the MSIs in series.

Here's an example from VS.Net: http://www.microsoft.com/downloads/details.aspx?FamilyId=BF253CFD-1EFC-4FC5-BA7E-6A6F21403495&displaylang=en that installs the .NET Framework (hardcoded) then installs your MSI using a settings.ini file. It'll need to be changed to remove the hardcoded installation and then to perhaps iterate through the .ini file to install multiple MSIs.

In response to why we don't ship MSMs any more, it is because we can't service them. If we discover a security (or other) problem with one of the files in the redist packages, we can't issue a QFE for MSMs, but we can issue a QFE for the MSIs that we send out. So it's a servicibility issue.

Installing DSO ..

This summary is not available. Please click here to view the post.

Installing DSO ..

Hi,
I am in the process of creating/setting up cubes from an ERP application
(Axapta) across user machines. In some of the machines I noticed an error
message (which I believe) indicates DSO objects not being installed.
A quick look at SQL BOI gave me details of DSO library.
My query is - where can I get hold of this DSO library files?
Can someone let me know please. Many thanks in advance,
Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/
> My query is - where can I get hold of this DSO library files?
The DSO library is what Analysis Manager uses to build/manage OLAP
Databases. It should be installed when you install the client tools for
Analysis Services 2000. If there is something wrong with the
registration of the dll the default path is C:\Program Files\Common
Files\Microsoft Shared\DSO\msmddo80.dll. But as far as I know there is
no re-distributable version of this library. The users would need to be
OLAP Administrators to use it anyway.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell|||Hi,
You may try to copy the following files
msmddo.dll
msmddo80.dll
msmdint.dll
msmdnet.dll
You could register these com objects by using regsvr32.exe. for example:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DSO\msmddo.dll"
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: Darren Gosbell <xxx@.xxx.com>
>Subject: Re: Installing DSO ..
>Date: Tue, 25 Oct 2005 10:20:56 +1000
>Message-ID: <MPG.1dc825762779a60598976e@.news.microsoft.com>
>References: <89CCB5B6-1AE5-4C63-B3D3-37FA2953C0B3@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-15"
>Content-Transfer-Encoding: 7bit
>User-Agent: MicroPlanet-Gravity/2.60.2060
>Newsgroups: microsoft.public.sqlserver.datawarehouse
>NNTP-Posting-Host: cpe-61-9-145-77.vic.bigpond.net.au 61.9.145.77
>Lines: 1
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.datawarehouse:2370
>X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
>
>The DSO library is what Analysis Manager uses to build/manage OLAP
>Databases. It should be installed when you install the client tools for
>Analysis Services 2000. If there is something wrong with the
>registration of the dll the default path is C:\Program Files\Common
>Files\Microsoft Shared\DSO\msmddo80.dll. But as far as I know there is
>no re-distributable version of this library. The users would need to be
>OLAP Administrators to use it anyway.
>
>--
>Regards
>Darren Gosbell [MCSD]
><dgosbell_at_yahoo_dot_com>
>Blog: http://www.geekswithblogs.net/darrengosbell
>

installing custom master?

If I am installing MSDE with my application, is there any way to include a
customized master.mdf? For example, I'd like to ship it preconfigured with
autostart procedures, extended stored procedures, etc. Or do I have to add
these with a script after the install?
Thanks for any suggestions.
hi Neil,
"Neil W" <neilw.nospam@.netlib.com> ha scritto nel messaggio
news:eMkAq2%23MEHA.3400@.TK2MSFTNGP09.phx.gbl...
> If I am installing MSDE with my application, is there any way to include a
> customized master.mdf? For example, I'd like to ship it preconfigured
with
> autostart procedures, extended stored procedures, etc. Or do I have to
add
> these with a script after the install?
please don't ... :-|
=;-D
the master database, as long as all system database is built with references
to all user's setting at installation time...
provide your own scripts and run them in order to achieve the desired
result...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

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 .NET Framework on a sql server

We have a DTS package which use .NET Exe as 'Execute Process Task'.
As this is a .NET application, it requires .NET Framework. Can we
install .NET Framework on a Production SQL Server.
What are other options?
Thanks a lot for the help.
PalsIf you want to run a .NET application, you have to install the framework. I
have had no problems having the framework on an SQL server. Be aware that
the ADO.NET components require that you update MDAC to at least 2.7 so that
may affect you.
Christian Smith
"DoNotReply" <palmskumar@.yahoo.com> wrote in message
news:31f15ba6.0402201342.13afff7@.posting.google.com...
> We have a DTS package which use .NET Exe as 'Execute Process Task'.
> As this is a .NET application, it requires .NET Framework. Can we
> install .NET Framework on a Production SQL Server.
> What are other options?
> Thanks a lot for the help.
> Pals

Installing .NET Framework on a sql server

We have a DTS package which use .NET Exe as 'Execute Process Task'.
As this is a .NET application, it requires .NET Framework. Can we
install .NET Framework on a Production SQL Server.
What are other options?
Thanks a lot for the help.
PalsIf you want to run a .NET application, you have to install the framework. I
have had no problems having the framework on an SQL server. Be aware that
the ADO.NET components require that you update MDAC to at least 2.7 so that
may affect you.
Christian Smith
"DoNotReply" <palmskumar@.yahoo.com> wrote in message
news:31f15ba6.0402201342.13afff7@.posting.google.com...
> We have a DTS package which use .NET Exe as 'Execute Process Task'.
> As this is a .NET application, it requires .NET Framework. Can we
> install .NET Framework on a Production SQL Server.
> What are other options?
> Thanks a lot for the help.
> Pals

Installer for an SQL database?

Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.
Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com
sql

Installer for an SQL database?

Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheil
d
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com

Installer for an SQL database?

Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
--
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
--
David Gugick
Imceda Software
www.imceda.com

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 Problems - sqlspars.dll

I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN CD
pack and cannot get past the initial Setup application.
Looking in the event log, I see the following error:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I just install the app onto a different SBS last week without any issues. I
just updated the machine with the latest Hotfixes from Windows Update.
Any info or troubleshooting suggestions would be appreciated.For those who are interested, a solution was found...
Article #840219 - connecting to SQL Server running on Win2k3
"Kevin D" <kevin@.threeriverstech.com> wrote in message
news:%23l$g442TFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN
CD
> pack and cannot get past the initial Setup application.
> Looking in the event log, I see the following error:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I just install the app onto a different SBS last week without any issues.
I
> just updated the machine with the latest Hotfixes from Windows Update.
> Any info or troubleshooting suggestions would be appreciated.
>

Installation problems

I have installed MSDE locally on Windows XP Pro, just for
testing SQL Server CE 2.0 on a PocketPC.
I know that one other application can create and access
data tables,
but osql does not work at all, except for the statement
osql -E -Q "SELECT * FROM syslogins"
I assume that 'Pubs' is a default database that is
supposed to be installed. How can I verify that?
hi Nils,
Nils wrote:
> I have installed MSDE locally on Windows XP Pro, just for
> testing SQL Server CE 2.0 on a PocketPC.
> I know that one other application can create and access
> data tables,
> but osql does not work at all, except for the statement
> osql -E -Q "SELECT * FROM syslogins"
what kind of error are you reported with?
if your login account has been granted database access to master database
and have read permission on system table (bad :D) you should be able to
query it, else you will be reported with something like
Server: Msg 230, Level 14, State 1, Line 1
SELECT permission denied on column 'password' of object 'syslogins',
database 'master', owner 'dbo'.

> I assume that 'Pubs' is a default database that is
> supposed to be installed. How can I verify that?
the Pubs and Northwind sample database are not installed by MSDE in order to
limit it's distribution size, so you have to download them separately at
http://msdn.microsoft.com/library/de...ionutility.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I found another useful hint by you: I will try that!
MSDE installs by default disabling network protocols to prevent external
mailcius attacks...
you have to manually enable them, bot at install time providing the
DISABLENETWORKPROTOCOLS=0
parameter to setup.exe boostrap installer and/or later using the Server
Network Utility (svrnet.cn.exe) to enable the desired/required network
protocol (usually TCP/IP)
Andrea Montanari (Microsoft MVP - SQL Server)
"Andrea Montanari" wrote:

> hi Nils,
> Nils wrote:
> what kind of error are you reported with?
> if your login account has been granted database access to master database
> and have read permission on system table (bad :D) you should be able to
> query it, else you will be reported with something like
> Server: Msg 230, Level 14, State 1, Line 1
> SELECT permission denied on column 'password' of object 'syslogins',
> database 'master', owner 'dbo'.
>
> the Pubs and Northwind sample database are not installed by MSDE in order to
> limit it's distribution size, so you have to download them separately at
> http://msdn.microsoft.com/library/de...ionutility.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>