Re: XPe Toolset with SQL Express

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: SPS WSS SQL 2000 same machine
    ... that the MSSQL$SHAREPOINT SQL Service instance is not running. ... both are installed on the SQL Server Default instance. ... You MUST install WSS before SPS. ... However, when selecting the Database ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Offline application for reporting and collect data
    ... Build one user interface that points to either you SQL Server database (when ... Build custom synchronization routines to deal with 'data exchange / ... to install SQL server and restore the database backup in the system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Choosing a Windows Database
    ... It'll be the "Express" edition of SQL Server. ... will install it once and each app will then only basically have the db file ... to be copied/installed along with your app. ... >> some kind of relational database. ...
    (microsoft.public.vb.database)