Re: Vista hosting XPe tools/db

Matt,

I chose your second option, and here's what I got:

C:\XPe>setp

C:\XPe>cscript setsqlperms.vbs vista-64 dpm
Microsoft (R) Windows Script Host Version 5.7
Copyright (C) Microsoft Corporation. All rights reserved.

SetSQLPerms.vbs: Grants sysadmin permissions to a specified user on a SQL
server
..
C:\XPe\setsqlperms.vbs(9, 20) Microsoft VBScript runtime error: ActiveX
component can't create object: 'SQLDMO.SQLServer'

C:\XPe>

Now, the SQL server instance name is "MSSQLSERVER" Should the object be
"'SQLDMO.MSSQLSERVER'"?

Regards,
Dean

"Matt Kellner [MS]" <mattkell@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%234LEtaG$GHA.4464@xxxxxxxxxxxxxxxxxxxxxxx
Just a clarification: This script requires that you run it under the
CScript
host. If you haven't changed your default script host to CScript, you can
do that with the following command: cscript //H:CScript

Alternatively, you can run setsqlperms.vbs script as follows: cscript
setsqlperms.vbs ComputerName UserName

--
Matt Kellner
SDET, Microsoft Windows XP Embedded Test Team

This posting is provided "AS IS" with no warranties, and confers no
rights.
"Matt Kellner [MS]" <mattkell@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eIgMtPG$GHA.1224@xxxxxxxxxxxxxxxxxxxxxxx
Hi there. We did some research into this issue and have come up with
what
we believe is a decent workaround. Here is a short VBScript that you
can
run (as Administrator) on your machine, that should grant the proper
permissions to your SQL database in order for your tools to connect
properly in Vista.

To use this script, copy the following script code to a file and save it
as "savesqlperms.vbs" . Then run the script as Administrator on the
machine hosting the database.

=== BEGIN SCRIPT CODE ===
Option Explicit

WScript.StdOut.WriteLine "SetSQLPerms.vbs: Grants sysadmin permissions
to
a specified user on a SQL server."
If WScript.Arguments.Count < 2 Then
WScript.StdOut.WriteLine "Usage: setsqlperms.vbs ComputerName UserName"
WScript.Quit()
End If

Dim g_oSQLServer : Set g_oSQLServer = CreateObject("SQLDMO.SQLServer")
g_oSQLServer.LoginTimeout = 30
g_oSQLServer.LoginSecure = True
g_oSQLServer.Connect Trim(WScript.Arguments(0))
g_oSQLServer.ExecuteImmediate("EXEC sp_grantlogin '" &
Trim(WScript.Arguments(1)) & "'")
g_oSQLServer.ExecuteImmediate("EXEC sp_addsrvrolemember '" &
Trim(WScript.Arguments(1)) & "', 'sysadmin'")
g_oSQLServer.Close
Set g_oSQLServer = Nothing

WScript.StdOut.WriteLine "Done."
=== END SCRIPT CODE ===

The usage is as follows: setsqlperms.vbs ComputerName UserName
For example: setsqlperms MyComputer MYDOMAIN\Matt

Once you run this script, you should be able to access your database
properly without having to disable UAC or login as Administrator.

Please let us know how this works for you. :)

--
Matt Kellner
SDET, Microsoft Windows XP Embedded Test Team

This posting is provided "AS IS" with no warranties, and confers no
rights.
"DPM" <dm@xxxxxxxx> wrote in message
news:%23JzRtkC$GHA.3352@xxxxxxxxxxxxxxxxxxxxxxx
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: General Printing Issues (Default Printer)(Excel)(Outlook)
    ... printer script and see if the settings will stick. ... rights on the machine. ... Microsoft Windows Script Host Version 5.7 ... Copyright Microsoft Corporation. ...
    (microsoft.public.windows.vista.print_fax_scan)
  • Re: Vista hosting XPe tools/db
    ... here's an alternative script using the Microsoft ADO as ... opposed to the SQL DMO - this should allow this script to work ... Microsoft Windows XP Embedded Test Team ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windowsxp.embedded)
  • RE: Languagesettings.
    ... Just to confirm you can make the same database call from two different web ... servers going to the exact same database/table and one machine gives the ... Thank you for choosing Microsoft ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.inetserver.iis)
  • Re: Entourage Identity Crisis?
    ... I ran the script, but it failed to execute completely. ... It generates the error message: ... saved database was saved in a more updated version. ... Microsoft does not update each application every time an update is released. ...
    (microsoft.public.mac.office.entourage)
  • RE: iisreset not working
    ... Do the sites connect to a database? ... Do you get the same behavior if you use iisreset /noforce? ... Thank you for choosing Microsoft ... This posting is provided “AS IS” with no warranties, and confers no rights. ...
    (microsoft.public.inetserver.iis)