XPe Toolset with SQL Express

[DPM]

Can anyone tell me what I need to do to install the XPe database with SQL
Express (2005, SP1)? I've installed SQL, it appears to be running, but the
XPe SP1 database installer cannot find it.

Any suggestions?

 

[Andy Allred [MS]]

Check out this article from our XPe blog called "Using SQL 2005 Express
with the XP Embedded Database":
http://blogs.msdn.com/embedded/archive/2006/01/05/509705.aspx

 

[DPM]

Andy,

Well, I already installed SQL 2005 Express. Is it possible to change the
instance name after installation? I didn't see any obvious way to do it.

Thanks for your help.

Regards,
Dean

 

[Andy Allred [MS]]

I know that when you install a second instance of SQL on the machine it
will have a new instance name.

However, i don't know if you can install a second instance of SQL 2005
Express if it detects another but you could try installing a second
instance. Otherwise i think you might have to uninstall and then re-install.

Sorry, i hope the first method works for you.

 

[DPM]

Andy,

I uninstalled and reinstalled, and it seems to work OK.

Thanks for your help.

Regards,
Dean

 

[DPM]

Well, not so fast.

Although I managed to install the SP1 database with no errors, the tools
report that they cannot log on to the database because either the database
is open in exclusive mode or they're not authorised.

Are there some additional settings I need to adjust in SQL Express? What
sort of logon do I need? "Network service" is the default; do I need
another?

I should note that I'm hosting this on Vista RC1.

Thanks for your help.

Regards,
Dean

 

[Andy Allred [MS]]

This is Vista security preventing your account from connecting to the
database. Try logging in as the Administrator (not just a user in the
admin group). Disabling LUA would probably also enable that but i'm not
proposing you do that since that feature is enabled for a reason.

We need to propagate some information to the community wrt hosting XPe
on Vista, it's definitely supported but since the OS is so locked down,
the process of enabling the end to end developer scenario on Vista is no
longer as simple as it was on previous OS'. I believe someone may be
working on a stored procedure for the database to set the permissions
such that Vista will allow authorized users access to the DB without
having to tweak the OS.

I'll ping the PMs and try to get something on our blog next week or asap.

 

[Andy Allred [MS]]

BTW, could you start another thread on Vista hosting XPe tools/db? It
will bring the subject to the top and also make it more visible to more
of the community, making it easier to educate and socialize some of the
changes i'm going to propose to enable this scenario you're trying.

Thanks