WiX issue with executing SqlScript at the remote DB

Question

0.00/5 (No votes)

See more:

Hi there,

Executing SqlScript at the remote DB causes an error:

Failed to connect to SQL database. (-2147467259 myDB1)

The SqlScript is the following:

<sql:SqlString 
Id='UpdateSomething1' 
SqlDb='myDB1' 
ExecuteOnInstall='yes' 
User='SQLUser'
ContinueOnError='no' 
ExecuteOnReinstall='no' 
ExecuteOnUninstall='no' 
Sequence='26'
SQL='[SqlString]'/>

where the Db is:

<sql:SqlDatabase 
Id='myDB1' 
Database='myDB1' 
Server='[DATABASE_SERVER]' 
CreateOnInstall='yes' 
DropOnInstall='no' 
DropOnUninstall='no' 
ContinueOnError='no'/>

and the user is:

<util:User 
Id="SQLUser" 
Name="myUserName1" 
Password="password1"/>

The problem does not occur with the local DB. We extracted more specific error message from the IP traffic (the actual error that the remote MSSQL server throws):

Can not open database "myDb1" requested by the login. The login failed. <remote machine name> Login failed for user <user name>

Thank you for any help and information.

Max

Posted 15-Jul-10 3:39am

Zaver.max

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Phil Sayers · Answer 1 · 2010-12-20T04:13:00

Hit this myself this week.

msiexec.exe (the windows installer process) runs as the localsystem account (SYSTEM). Typically SYSTEM does not have network access (your remote db).

You'll have to do some work with custom actions and scheduling to get your sql scripts to run under a windows account that has network access (typically the user account that launched the installer)