MSDE setup problems

I am attempting to install SharePoint Services (with
MSDE) using all standard/default options. The WSS setup
appears to proceed normally until it attempts to
configure the MSDE. This portion of the WSS setup fails
and I receive the following error message:
MICROSFOT SQL SERVER DESKTOP ENGINE
Setup failed to configure the server. Refer to the server
error logs and setup error logs for more information.
Not sure where to find these two logs are located or why
the MSDE setup failed.
Any help resolving this problem will be appreciated.
Jim
hi Jim,
<anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
> I am attempting to install SharePoint Services (with
> MSDE) using all standard/default options. The WSS setup
> appears to proceed normally until it attempts to
> configure the MSDE. This portion of the WSS setup fails
> and I receive the following error message:
> MICROSFOT SQL SERVER DESKTOP ENGINE
> Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
> Not sure where to find these two logs are located or why
> the MSDE setup failed.
> Any help resolving this problem will be appreciated.
> Jim
please have a look at
http://support.microsoft.com/default...99&Product=sql
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
|||Thanks Andrea. This is just the KB article that I was
looking for.
Jim

>--Original Message--
>hi Jim,
><anonymous@.discussions.microsoft.com> ha scritto nel
messaggio[vbcol=seagreen]
>news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
server[vbcol=seagreen]
why
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816499&Product=sql
>hth
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>
|||I have the same problem. However, after using the
solutions mentioned in that KB, I still got the same
error " Setup failed to configure the server".
Choi

>--Original Message--
>hi Jim,
><anonymous@.discussions.microsoft.com> ha scritto nel
messaggio[vbcol=seagreen]
>news:ecbf01c43d3c$230fb2e0$a401280a@.phx.gbl...
server
>please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;816499&Product=sql
>hth
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://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
>.
>

MSDE password change for "sa"

Hello,
If I can get into the default instance of MSDE using a Windows
account (trusted connection) using 'osql -E' is it possible for me to
change the 'sa' SQL account if I don't know the current password? The
Windows account is a domain admin and local box admin if that matters.
Also, can anyone point me to a Q article that will give me a step
by step on how to upgrade from MSDE to SQL so I can get past this 2GB
limitation?
If anyone can answer these I am definitely buying beers!!
Thanks,
Dan
If you can login as an admin on the box and the
builtin\administrators group login was not removed or
modified, you will be logged in as a member of the sysadmins
server role. As a sysadmin, you can execute the following to
change the sa password:
sp_password NULL, 'NewSaPassword', 'sa'
Upgrading to SQL Server isn't too bad. Run the SQL Server
installation CD. You will be asked if you want to upgrade
your existing instance or install a new one. Choose to
upgrade.
For more detailed steps on upgrading, you can refer to the
SQL Server Books Online topic:
How to perform an edition upgrade within SQL Server 2000
(Setup)
http://msdn.microsoft.com/library/en...stall_1d7y.asp
-Sue
On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
Kennedy) wrote:

>Hello,
> If I can get into the default instance of MSDE using a Windows
>account (trusted connection) using 'osql -E' is it possible for me to
>change the 'sa' SQL account if I don't know the current password? The
>Windows account is a domain admin and local box admin if that matters.
> Also, can anyone point me to a Q article that will give me a step
>by step on how to upgrade from MSDE to SQL so I can get past this 2GB
>limitation?
>If anyone can answer these I am definitely buying beers!!
>Thanks,
>Dan
|||But the current "sa" password isn't blank... will that statement still
work? I login to the machine as a local admin and connect via the
osql statement as the same ID as I logon to the machine with.
Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9plg@.4ax.com>. ..[vbcol=seagreen]
> If you can login as an admin on the box and the
> builtin\administrators group login was not removed or
> modified, you will be logged in as a member of the sysadmins
> server role. As a sysadmin, you can execute the following to
> change the sa password:
> sp_password NULL, 'NewSaPassword', 'sa'
> Upgrading to SQL Server isn't too bad. Run the SQL Server
> installation CD. You will be asked if you want to upgrade
> your existing instance or install a new one. Choose to
> upgrade.
> For more detailed steps on upgrading, you can refer to the
> SQL Server Books Online topic:
> How to perform an edition upgrade within SQL Server 2000
> (Setup)
> http://msdn.microsoft.com/library/en...stall_1d7y.asp
> -Sue
> On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
> Kennedy) wrote:
|||Yes...it will still work. That's what you would use to reset any
password when you are logged in as a sysadmin. Just pass null for the
old password. It doesn't mean the password is null. It means you
aren't supplying the old password.
-Sue
On 16 Jun 2004 11:26:10 -0700, dankennedy24@.hotmail.com (Dan Kennedy)
wrote:
[vbcol=seagreen]
>But the current "sa" password isn't blank... will that statement still
>work? I login to the machine as a local admin and connect via the
>osql statement as the same ID as I logon to the machine with.
>Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9plg@.4ax.com>. ..

MSDE password change for "sa"

Hello,
If I can get into the default instance of MSDE using a Windows
account (trusted connection) using 'osql -E' is it possible for me to
change the 'sa' SQL account if I don't know the current password? The
Windows account is a domain admin and local box admin if that matters.
Also, can anyone point me to a Q article that will give me a step
by step on how to upgrade from MSDE to SQL so I can get past this 2GB
limitation?
If anyone can answer these I am definitely buying beers!!
Thanks,
DanIf you can login as an admin on the box and the
builtin\administrators group login was not removed or
modified, you will be logged in as a member of the sysadmins
server role. As a sysadmin, you can execute the following to
change the sa password:
sp_password NULL, 'NewSaPassword', 'sa'
Upgrading to SQL Server isn't too bad. Run the SQL Server
installation CD. You will be asked if you want to upgrade
your existing instance or install a new one. Choose to
upgrade.
For more detailed steps on upgrading, you can refer to the
SQL Server Books Online topic:
How to perform an edition upgrade within SQL Server 2000
(Setup)
http://msdn.microsoft.com/library/en-us/howtosql/ht_install_1d7y.asp
-Sue
On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
Kennedy) wrote:
>Hello,
> If I can get into the default instance of MSDE using a Windows
>account (trusted connection) using 'osql -E' is it possible for me to
>change the 'sa' SQL account if I don't know the current password? The
>Windows account is a domain admin and local box admin if that matters.
> Also, can anyone point me to a Q article that will give me a step
>by step on how to upgrade from MSDE to SQL so I can get past this 2GB
>limitation?
>If anyone can answer these I am definitely buying beers!!
>Thanks,
>Dan|||But the current "sa" password isn't blank... will that statement still
work? I login to the machine as a local admin and connect via the
osql statement as the same ID as I logon to the machine with.
Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9plg@.4ax.com>...
> If you can login as an admin on the box and the
> builtin\administrators group login was not removed or
> modified, you will be logged in as a member of the sysadmins
> server role. As a sysadmin, you can execute the following to
> change the sa password:
> sp_password NULL, 'NewSaPassword', 'sa'
> Upgrading to SQL Server isn't too bad. Run the SQL Server
> installation CD. You will be asked if you want to upgrade
> your existing instance or install a new one. Choose to
> upgrade.
> For more detailed steps on upgrading, you can refer to the
> SQL Server Books Online topic:
> How to perform an edition upgrade within SQL Server 2000
> (Setup)
> http://msdn.microsoft.com/library/en-us/howtosql/ht_install_1d7y.asp
> -Sue
> On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
> Kennedy) wrote:
> >Hello,
> > If I can get into the default instance of MSDE using a Windows
> >account (trusted connection) using 'osql -E' is it possible for me to
> >change the 'sa' SQL account if I don't know the current password? The
> >Windows account is a domain admin and local box admin if that matters.
> > Also, can anyone point me to a Q article that will give me a step
> >by step on how to upgrade from MSDE to SQL so I can get past this 2GB
> >limitation?
> >
> >If anyone can answer these I am definitely buying beers!!
> >
> >Thanks,
> >Dan|||Yes...it will still work. That's what you would use to reset any
password when you are logged in as a sysadmin. Just pass null for the
old password. It doesn't mean the password is null. It means you
aren't supplying the old password.
-Sue
On 16 Jun 2004 11:26:10 -0700, dankennedy24@.hotmail.com (Dan Kennedy)
wrote:
>But the current "sa" password isn't blank... will that statement still
>work? I login to the machine as a local admin and connect via the
>osql statement as the same ID as I logon to the machine with.
>Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9plg@.4ax.com>...
>> If you can login as an admin on the box and the
>> builtin\administrators group login was not removed or
>> modified, you will be logged in as a member of the sysadmins
>> server role. As a sysadmin, you can execute the following to
>> change the sa password:
>> sp_password NULL, 'NewSaPassword', 'sa'
>> Upgrading to SQL Server isn't too bad. Run the SQL Server
>> installation CD. You will be asked if you want to upgrade
>> your existing instance or install a new one. Choose to
>> upgrade.
>> For more detailed steps on upgrading, you can refer to the
>> SQL Server Books Online topic:
>> How to perform an edition upgrade within SQL Server 2000
>> (Setup)
>> http://msdn.microsoft.com/library/en-us/howtosql/ht_install_1d7y.asp
>> -Sue
>> On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
>> Kennedy) wrote:
>> >Hello,
>> > If I can get into the default instance of MSDE using a Windows
>> >account (trusted connection) using 'osql -E' is it possible for me to
>> >change the 'sa' SQL account if I don't know the current password? The
>> >Windows account is a domain admin and local box admin if that matters.
>> > Also, can anyone point me to a Q article that will give me a step
>> >by step on how to upgrade from MSDE to SQL so I can get past this 2GB
>> >limitation?
>> >
>> >If anyone can answer these I am definitely buying beers!!
>> >
>> >Thanks,
>> >Dan

MSDE password change for "sa"

Hello,
If I can get into the default instance of MSDE using a Windows
account (trusted connection) using 'osql -E' is it possible for me to
change the 'sa' SQL account if I don't know the current password? The
Windows account is a domain admin and local box admin if that matters.
Also, can anyone point me to a Q article that will give me a step
by step on how to upgrade from MSDE to SQL so I can get past this 2GB
limitation?
If anyone can answer these I am definitely buying beers!!
Thanks,
DanIf you can login as an admin on the box and the
builtin\administrators group login was not removed or
modified, you will be logged in as a member of the sysadmins
server role. As a sysadmin, you can execute the following to
change the sa password:
sp_password NULL, 'NewSaPassword', 'sa'
Upgrading to SQL Server isn't too bad. Run the SQL Server
installation CD. You will be asked if you want to upgrade
your existing instance or install a new one. Choose to
upgrade.
For more detailed steps on upgrading, you can refer to the
SQL Server Books Online topic:
How to perform an edition upgrade within SQL Server 2000
(Setup)
http://msdn.microsoft.com/library/e...nstall_1d7y.asp
-Sue
On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
Kennedy) wrote:

>Hello,
> If I can get into the default instance of MSDE using a Windows
>account (trusted connection) using 'osql -E' is it possible for me to
>change the 'sa' SQL account if I don't know the current password? The
>Windows account is a domain admin and local box admin if that matters.
> Also, can anyone point me to a Q article that will give me a step
>by step on how to upgrade from MSDE to SQL so I can get past this 2GB
>limitation?
>If anyone can answer these I am definitely buying beers!!
>Thanks,
>Dan|||But the current "sa" password isn't blank... will that statement still
work? I login to the machine as a local admin and connect via the
osql statement as the same ID as I logon to the machine with.
Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<np8vc0p2v2lfj8ke5mm0vf6f8vmrfg9p
lg@.4ax.com>...[vbcol=seagreen]
> If you can login as an admin on the box and the
> builtin\administrators group login was not removed or
> modified, you will be logged in as a member of the sysadmins
> server role. As a sysadmin, you can execute the following to
> change the sa password:
> sp_password NULL, 'NewSaPassword', 'sa'
> Upgrading to SQL Server isn't too bad. Run the SQL Server
> installation CD. You will be asked if you want to upgrade
> your existing instance or install a new one. Choose to
> upgrade.
> For more detailed steps on upgrading, you can refer to the
> SQL Server Books Online topic:
> How to perform an edition upgrade within SQL Server 2000
> (Setup)
> http://msdn.microsoft.com/library/e...nstall_1d7y.asp
> -Sue
> On 15 Jun 2004 17:41:11 -0700, dankennedy24@.hotmail.com (Dan
> Kennedy) wrote:
>|||Yes...it will still work. That's what you would use to reset any
password when you are logged in as a sysadmin. Just pass null for the
old password. It doesn't mean the password is null. It means you
aren't supplying the old password.
-Sue
On 16 Jun 2004 11:26:10 -0700, dankennedy24@.hotmail.com (Dan Kennedy)
wrote:
[vbcol=seagreen]
>But the current "sa" password isn't blank... will that statement still
>work? I login to the machine as a local admin and connect via the
>osql statement as the same ID as I logon to the machine with.
>Sue Hoegemeier <Sue_H@.nomail.please> wrote in message news:<np8vc0p2v2lfj8k
e5mm0vf6f8vmrfg9plg@.4ax.com>...

MSDE ON WINDOWS XP - Unable to determine system default collation.

Please help Me,
I need Install MSDE2000 On Windows XP, but this message is show in the proces
Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.Are you running Windows XP Pro or Home?|||Please help Me,

I need Install MSDE2000 On Windows XP PRO, but this message is show in the proces

Product: Microsoft SQL Server Desktop Engine -- Unable to determine system default collation.|||Have you tried to logon with a user with administrator privileges?|||Originally posted by Dynatoz
Have you tried to logon with a user with administrator privileges?

Yes, I using the Administrator Acount

MSDE no show in server explorer

I have installed default instance of SQLServer 2005 DE on Windows Server 2003 host. I also installed a named instance of MSDE rel A. I can connect to the MSDE instance from Management Studio but it does not appear in the list of servers when I try to add the connection in VS2005 server explorer. What am I doing wrong?

- Dick

Anybody?

I can connect to the named MSDE instance (now upgraded to SP4) with management studio and osql, but it does not appear in the server list in VS2005 studio explorer, or in the OS ODBC DataSources utility.

The log shows the MSDE instance is listening on shared memory. I cannot configure it for named pipes because I can only see the default SS2K5 instance in SQL Server Configuration Manager.

All contributions massively appreciated.

|||

MSDE instances listening only on shared memory generally do not show up in the list boxes you mention.

You can configure the MSDE to listen on named pipes (or TCP) through the Server Network Utility.

|||

Thanks Peter

That cracked it. Here's what I did:

- I ran Microsoft SQL Server\80\Tools\binn\SVRNETCN.exe and enabled Named Pipes and TCP/IP

- restarted the server instance but it did not fix it.

- rebooted the machine, got various system errors e.g. reporting services could not connect to db. There was a conflict on port 1433.

- re-ran Server Network Configuration utility, set TCP/IP port to 0. (Bit confused by this, I thought MSDE sp 3 sorted out port sharing issue ...? I havn't tried a remote connection yet)

- Ran SQL Configuration Manager and created np aliases for both the default and named instances.

- rebooted and everything fixed. Able to create a System DSN. MSDE instance did not appear in server list when I tried to add a new a connection in VS2005 server explorer, but I was able to type in the server name and connect ok.

As a general observation I have to say I am not a member of SQL Server 2005 fan club yet. It promises simplicity, but delivers frustration.

MSDE newbie question: contents of default databases

Having installed MSDE and connected to it, it seems there are several
default databases already:
master
model
msdb
tempdb
Are these intended to be for any specific use?
How do I get a list of the tables that are in these databases?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:ureI8NzQEHA.1624@.TK2MSFTNGP09.phx.gbl...
> Having installed MSDE and connected to it, it seems there are several
> default databases already:
> master
> model
> msdb
> tempdb
> Are these intended to be for any specific use?
> How do I get a list of the tables that are in these databases?
in order to limit distribution size, MSDE only ships with system database
you do not have to touch =;-D
these databases are relatated to MSDE itself and are not user database...
if you like some sample database, you can install the Northwind and Pubs
demo databases from
http://www.microsoft.com/downloads/d...DisplayLang=en
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

MSDE login problem

Hi all,

I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to use
with it.

I did install it with it's default options and now i'd like to administer it
with Web Data Administrator but it keeps telling me that i should enable SQL
Server Authentication.

So i tried debugging the question creating an .udl file and trying to test
various authentication methods:
- Integrated Windows authentication works fine
- SQL Server authentication (when i try logging in using user 'sa' with the
password i've set keeps telling me that user 'sa' is not associated with a
trusted SQL Server connection.

How do i solve this puzzle? Tried googling (and reading some faqs) but
didn't come up with anything useful.

Unfortunately the Web Data Administrator doesn't allow using integrated NT
authentication. :-(

Thank You,
LorenzoCheck out MSKB 321698:

https://mvp.support.microsoft.com/d...kb;en-us;321698

--
Hope this helps.

Dan Guzman
SQL Server MVP

--------
SQL FAQ links (courtesy Neil Pike):

http://www.ntfaq.com/Articles/Index...epartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--------

"Lorenzo Bolognini" <lorenzo@.mysurname.net> wrote in message
news:jNaYa.42647$cl3.1359277@.news2.tin.it...
> Hi all,
> I have bought Visual C# .NET 2003 Standard and downloaded the MSDE to
use
> with it.
> I did install it with it's default options and now i'd like to
administer it
> with Web Data Administrator but it keeps telling me that i should
enable SQL
> Server Authentication.
> So i tried debugging the question creating an .udl file and trying to
test
> various authentication methods:
> - Integrated Windows authentication works fine
> - SQL Server authentication (when i try logging in using user 'sa'
with the
> password i've set keeps telling me that user 'sa' is not associated
with a
> trusted SQL Server connection.
> How do i solve this puzzle? Tried googling (and reading some faqs) but
> didn't come up with anything useful.
> Unfortunately the Web Data Administrator doesn't allow using
integrated NT
> authentication. :-(
> Thank You,
> Lorenzo|||"Dan Guzman" <danguzman@.nospam-earthlink.net> ha scritto nel messaggio
news:p_hYa.241$BC2.47@.newsread2.news.atl.earthlink .net...
> Check out MSKB 321698:

Thank you very much Dan.

Lorenzo

MSDE Installation Parameters

When installing MSDE What is the cmd parameters for enable a TCPIP
connection on a port that is not default. Is this possible.
Thanks
hi Robert,
"Robert Barnett" <rlbcomp@.att.net> ha scritto nel messaggio
news:d5741a07.0404260740.55e21773@.posting.google.c om...
> When installing MSDE What is the cmd parameters for enable a TCPIP
> connection on a port that is not default. Is this possible.
... MSDE 1.0 installer did, but MSDE 2000 setup does not provide this
functionality..
you can only enable/disable network protocols, but you can not specify which
protocol and/or which port..
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
|||Is there a way to do this though the Deployment kit, in
that I have to deploy MSDE automatically on over 1000 systems,
Thanks
Robert[vbcol=seagreen]
>--Original Message--
>hi Robert,
>"Robert Barnett" <rlbcomp@.att.net> ha scritto nel messaggio
>news:d5741a07.0404260740.55e21773@.posting.google. com...
enable a TCPIP
>... MSDE 1.0 installer did, but MSDE 2000 setup does not
provide this
>functionality..
>you can only enable/disable network protocols, but you can
not specify which
>protocol and/or which port..
>--
>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
>.
>
|||hi Robert,
"Robert Barnett" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:478901c42bc6$177f8a90$a001280a@.phx.gbl...
> Is there a way to do this though the Deployment kit, in
> that I have to deploy MSDE automatically on over 1000 systems,
really no idea...
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

msde INSTALLATION

Hi

I am trying to install the MSDE.
I followed the steps on this page http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1
on running the setup I get a message showing that the following instance is not valid and it doesn't install the MSDE.

Could somebody help me.

AkshatOK. what's your computer's name?
what command line are you specifying, exactly?|||Thanx for the message.
Computer Name=Akshat

Setup SAPWD=hello SecurityMode=SQL

These are mentioned on the webpage for installation so I just followed them.

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Akshat

MSDE Installation

How do I set the SQLServerAgent service on automatically when I run the
installation? By default, the MSSQLServer service is set as automatic, but
the SQLServerAgent is Manual
hi Roy,
"Roy" <Roy@.discussions.microsoft.com> ha scritto nel messaggio
news:C42372B4-330B-4418-89E4-2F167D703AB8@.microsoft.com...
> How do I set the SQLServerAgent service on automatically when I run the
> installation? By default, the MSSQLServer service is set as automatic, but
> the SQLServerAgent is Manual
actually there's no way to set this at install time
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply