Re: XPe Toolset with SQL Express

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

Check out the Embedded team blog: http://blogs.msdn.com/embedded/
This posting is provided "AS IS" with no warranties, and confers no rights.



DPM wrote:
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

"DPM" <dm@xxxxxxxx> wrote in message
news:u6fHMAc%23GHA.4464@xxxxxxxxxxxxxxxxxxxxxxx
Andy,

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

Thanks for your help.

Regards,
Dean

"Andy Allred [MS]" <andyall@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:e90%23$2T%23GHA.1220@xxxxxxxxxxxxxxxxxxxxxxx
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.

----
Andy

Check out the Embedded team blog: http://blogs.msdn.com/embedded/
This posting is provided "AS IS" with no warranties, and confers no
rights.

DPM wrote:
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]" <andyall@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uTU77RR%23GHA.1168@xxxxxxxxxxxxxxxxxxxxxxx

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

----
Andy

Check out the Embedded team blog: http://blogs.msdn.com/embedded/
This posting is provided "AS IS" with no warranties, and confers no

rights.

DPM wrote:

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?





.

Relevant Pages

  • Re: Vista hosting XPe tools/db
    ... permissions to your SQL database in order for your tools to connect properly ... on Vista, it's definitely supported but since the OS is so locked down, ... Although I managed to install the SP1 database with no errors, ...
    (microsoft.public.windowsxp.embedded)
  • Re: XPe Toolset with SQL Express
    ... Check out the Embedded team blog: http://blogs.msdn.com/embedded/ ... 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. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Vista Program Files Folder Problem - Issue 1
    ... Vista does not permit saving data files to the Program Files folder. ... I have been using a MS Access 2000 database for quite some time. ... The installation process is done with a msi file. ...
    (microsoft.public.windows.vista.security)
  • Vista hosting XPe tools/db
    ... This is Vista security preventing your account from connecting to the ... working on a stored procedure for the database to set the permissions ... Check out the Embedded team blog: http://blogs.msdn.com/embedded/ ... Although I managed to install the SP1 database with no errors, ...
    (microsoft.public.windowsxp.embedded)
  • Re: Guide Me
    ... I was not thinking of working in two access versions, only my home machine is Vista, but the machine the DB and MDE will be on are XP. ... Ae you talking about a wide area network here, or you just your typical office LAN? ... Access works even when you don't split the database (you ...
    (microsoft.public.access.gettingstarted)