MSDE and Imaging

Can the MSDE be included within a base XP image without
issue. I know that putting SQL on an image is a no-no.
Just wanted to hear if the MSDE can be included on an
image.
"Ismael" <ismael.alfaro@.gametop.com> wrote in message
news:1fd501c4ff01$0edfe1a0$a501280a@.phx.gbl...
> Can the MSDE be included within a base XP image without
> issue. I know that putting SQL on an image is a no-no.
> Just wanted to hear if the MSDE can be included on an
> image.
I don't see an issue with that. I'd set the mssqlserver service to run as
'local system', in that way you won't need to be concerned with service
accounts, or SID issues.
Steve

MSDE 2000 Release A and Windows Installer

I am currently writing an installer for our product, which needs to incorporate MSDE 2000.
Previous versions of the MSDE install included merge modules (.msm files) that could be incorporated straight into a Windows Installer .msi file. However, the latest version (Release A) does not include the merge modules, and to top that, also states tha
t "Desktop Engine does not support nested installations. You must not call an .msi file from within another .msi file".
My questions are:
- How are we supposed to install MSDE when we are distributing .msi files? We need .msi functionality for other components of our install, so using a non-Windows Installer technology is not an option. Do we need to ask our users to install MSDE separat
ely (ouch)?
- Why did the merge modules disappear? I thought that these were the Microsoft-sanctioned method for installing runtime components...
- Are there any other options - we want to distribute a single file, and we really don't want to have to mix and match .msi and other setup technologies...
Marc Durdin
Software for Specialists
Hi Andy,
Thanks for the comment. However, this page is not up to date. It recommends using the merge modules... which are not supported any more by Microsoft (and are not even included in the latest release of MSDE). Any other suggestions?
Regards,
Marc

MSDE 2000 Release A - Query Analyzer included?

I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it
included, or only available with other SQL Server versions. If it is
included, then how do I install it? If not, can I download it from somewhere
else?
Hi
MSDE 2000 does not come with any of the tools like Query Analyzer or
Enterprise Manager.
You could download the evaluation edition of SQL Server 2000 and use those
tools for 120 days.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:41977C7A-205A-4CDA-AD56-843DF8779DE6@.microsoft.com...
>I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it
> included, or only available with other SQL Server versions. If it is
> included, then how do I install it? If not, can I download it from
> somewhere
> else?
>

MSDE 2000 Install - setup.ini

I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS

My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.

The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'

Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?

Being new to installing MSDE, are there any other parameters I have missed?

Ian

p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set upSolved the problem myself.
With Service Pack 3, msde has added a new parameter to the install = DISABLENETWORKPROTOCOLS. This parameter is defaulted to 1 which blocks remote access to the database. By adding the parameter with a value of 0 to the setup.ini file I can now connect from remote.
Ian

Originally posted by Ian Grant
I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS

My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.

The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'

Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?

Being new to installing MSDE, are there any other parameters I have missed?

Ian

p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set up

MSDE & SQL Server Agent

Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.
Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>

MSDE & SQL Server Agent

Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
--
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>

MSDE & SQL Server Agent

Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>