Groups | Blog | Home
all groups > sql server (microsoft) > september 2004 >

sql server (microsoft) : Basic MSDE Setup Question on Windows Server 2003



Jolly Student
9/14/2004 12:50:22 AM
Dear Colleagues:

This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).

Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is

included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.

So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.

First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.

I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.

My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that

the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.

Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.

Thanks,

Roger

Teddy Smith
9/14/2004 11:46:12 AM
If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.

Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database....

HTH.

[quoted text, click to view]

AddThis Social Bookmark Button