Reusing a SQLServer installation



Christophe Bousquet
07-09-2005, 10:26 PM
Hello All,

I'm trying to install an XPE/TD on a computer where there's already a
SQL Server 2000 (Dev Ed) installed.
The "Database setup" step of the installation process fails with the
message "MSDE/SQLS...blah...required...blah...".

My SQLS is set to Windows authentication, and I'm able to connect with
Entreprise Manager and Query Analyser.

Just in case, after reading the documentation I checked that there is no
personal certificate (nope)...
The host is a W2K workstation, the SQLS listens over named pipe or
TCP/IP socket.

Any hint greatly appreciated, even if it's "RTFM KBxxxxx" :-)


Best regards
Christophe Bousquet
Bio-Rad Site de Strasbourg
Bio-Rad Laboratories
christophe dot bousquet at bio-rad dot com

KM
07-09-2005, 10:26 PM
Christophe,

Are you sure it failed on the database setup, not on database engine setup? You basically don't need to install database engine and
can stick with the SQL Server 2000.

XPe Toolkit should work with Windows or mixed-mode authentication mode.

With regards to the certificate, please read and follow this doc page:
http://msdn.microsoft.com/library/en-us/xpehelp/html/xeconTheDevelopmentToolsFailToConnectToSQLServerMSDE.asp

Look for more errors during the install:
http://msdn.microsoft.com/library/en-us/xpehelp/html/xeerrErrorMessages.asp

--
Regards,
KM, BSquare Corp.


> Hello All,
>
> I'm trying to install an XPE/TD on a computer where there's already a
> SQL Server 2000 (Dev Ed) installed.
> The "Database setup" step of the installation process fails with the
> message "MSDE/SQLS...blah...required...blah...".
>
> My SQLS is set to Windows authentication, and I'm able to connect with
> Entreprise Manager and Query Analyser.
>
> Just in case, after reading the documentation I checked that there is no
> personal certificate (nope)...
> The host is a W2K workstation, the SQLS listens over named pipe or
> TCP/IP socket.
>
> Any hint greatly appreciated, even if it's "RTFM KBxxxxx" :-)
>
>
> Best regards
> Christophe Bousquet
> Bio-Rad Site de Strasbourg
> Bio-Rad Laboratories
> christophe dot bousquet at bio-rad dot com

Christophe Bousquet
07-09-2005, 10:26 PM
> Are you sure it failed on the database setup, not on database engine
> setup? You basically don't need to install database engine and
> can stick with the SQL Server 2000.

Yep, "database setup", not engine setup 'cause I'm precisely trying to
re-use an existing SQL/S installation.

I already have a TD up'n'running on another computer, with the default
MSDE installed, but here I have a nice SQLS that I would like to use.

There's a dialog saying "Checking database engine status" and
"status : determining version"
and after about 10 secondes it ends with :

"The Microsoft Data Engine (MSDE) or SQL Server version 2000 or later is
required to be installed and running in order to install, modify, or
remove this product."


I already read the 2 links you pointed but many thanks anyway.

I'll continue poking it tomorrow (it's almost 9 PM here :-\
I wonder what credential is used by the setup to connect to the server ?


Thanks again,

Best regards
Christophe Bousquet
Bio-Rad Site de Strasbourg
Bio-Rad Laboratories
christophe dot bousquet at bio-rad dot com

KM
07-09-2005, 10:26 PM
Christophe,

I haven't seen that error. Sorry, can't be of much help here.

I assume MSSQLServer service is up and running on the same machine you are trying to install the database on, right? Otherwise you
wouldn't be able to use Enterprise Manager to connect to the server.

The credentials are used from the logged user (this is why Windows authentication is required). Make sure the user you are logged
under has Admin privileges..
Otherwise, make sure the user id matches login id with enough rights to manage the server (create databases, etc.):
http://msdn.microsoft.com/library/en-us/xpehelp/html/xeurfSQLServerLoginID.asp

Also, try to switch to SQL Server and Windows Authentication on the SQL/S.

--
Regards,
KM, BSquare Corp.


> > Are you sure it failed on the database setup, not on database engine
> > setup? You basically don't need to install database engine and
> > can stick with the SQL Server 2000.
>
> Yep, "database setup", not engine setup 'cause I'm precisely trying to
> re-use an existing SQL/S installation.
>
> I already have a TD up'n'running on another computer, with the default
> MSDE installed, but here I have a nice SQLS that I would like to use.
>
> There's a dialog saying "Checking database engine status" and
> "status : determining version"
> and after about 10 secondes it ends with :
>
> "The Microsoft Data Engine (MSDE) or SQL Server version 2000 or later is
> required to be installed and running in order to install, modify, or
> remove this product."
>
>
> I already read the 2 links you pointed but many thanks anyway.
>
> I'll continue poking it tomorrow (it's almost 9 PM here :-\
> I wonder what credential is used by the setup to connect to the server ?
>
>
> Thanks again,
>
> Best regards
> Christophe Bousquet
> Bio-Rad Site de Strasbourg
> Bio-Rad Laboratories
> christophe dot bousquet at bio-rad dot com
>
>
>

Christophe Bousquet
07-09-2005, 10:26 PM
I'm answering my own question, just in case someone else run into the
same problem (but I doubt it)

My problem seems to be connected to the fact that my SQL Server is a
named instance, i.e. not MSSQLSERVER but MSSQL$xxxx

On second thought, and given the fact that there is nothing configurable
in the "database setup" to access the SQL server engine this may seem
obvious, but "errare humanum est".



And while I'm at it, I can also share a second problem, just as obvious
as the first one (boy, do I look dumb!) : the folder where you install
the TD repository must be writable by the SQLServer service account.
If not, you will see an error message, microsoftisho-cryptic, telling
you that the setup failed because of a corrupted .ldf file at a location
not related to the installation (in my case it was
"E:\Windows Embedded Data" while i'm installing in "h:\XPEData" :-)

Hope this helps someone,


Best regards
Christophe
Bio-Rad Site de Strasbourg
Bio-Rad Laboratories
christophe dot bousquet at bio-rad dot com


Reusing a SQLServer installation