We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

Search found 11 matches

Go to advanced search

by Michael D
Wed Nov 14, 2012 10:32 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hi Mihai:

That relies on the SQLBrowse service to be running, which is the issue I'm having: when it's not running, I can't start it in a timely manner. I guess I'll just explain the issue to the end user if a prior SQL Server or SQLExpress installation is detected.

Thanks for your help,
Michael
by Michael D
Tue Nov 13, 2012 5:57 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hi Mihai:

I renamed the first call to LaunchFileAsAdmin_1 :
/RunAsAdmin sc config SQLBrowser start= auto
and moved it to be an InitEvent for the FolderDlg instead of for the SQLConnectionDlg , hoping that by the time the latter dialog appears, the InitEvent for the former will have completed. It ...
by Michael D
Tue Nov 13, 2012 4:27 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hello Mihai:

I tried it and it still fails. I changed the Condition for both the config and the start commands from 1 to AI_INSTALL, and now I can see that they're both getting executed. The SQLBrowser service is eventually getting started, but the installer doesn't wait for the commands to finish ...
by Michael D
Tue Nov 13, 2012 3:26 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hi Mihai:

My apologies for being so dense. Service names are case sensitive? OK, I'll change the name and give it a whirl.

Thanks.
by Michael D
Mon Nov 12, 2012 5:05 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hi Mihai:

Everything DOES work as expected when run from a CMD prompt, and your example is identical to the one I included in my post. I think it might be a timing issue and that the installer is continuing before the service is finished being enabled and started. Would you please reread the ...
by Michael D
Tue Nov 06, 2012 8:33 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Well good, Mihai, 'cause I got more. :D

Creating the database from a backup after installing SQLExpress 2008 works great, but now I'm looking at installing when the user already has one of the SQL 2008 versions installed. One of my test VMs has that situation, but the SQLBrowse service isn't ...
by Michael D
Mon Nov 05, 2012 11:01 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Thanks, Mihai!

This worked for me:

Code: Select all

cacls "[TempFolder]CRMgr" /t /e /c /p Everyone:f
I appreciate your assistance.
by Michael D
Fri Nov 02, 2012 3:23 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hi Daniel:

Well, I thought it was solved. Turns out that it only works sometimes, and always works if I delete the application (but not the support apps) and run it a second time. I found out that the first time I run it, the rights I gave to the TemporaryFolder don't always get applied, but they ...
by Michael D
Wed Oct 31, 2012 2:49 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Thanks, Daniel.

I got it working by creating my own folder under the Target Computer -> Windows Volume -> Temporary folder in the Files and Folders resource. Then I put my DB backup and SQL script in there and gave Everyone rights to the new subfolder. That's all it took.

I appreciate your help!
by Michael D
Tue Oct 30, 2012 3:42 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

Re: SQLCMD custom action problems

Hey Daniel:

Thanks for your quick reply. I just tried your recommended fix and it looks like it's real close now. The script did indeed run, but from the error message I received, I think that it's running after the temporary files have been deleted. Here are the contents of the sqllog.txt file ...
by Michael D
Mon Oct 29, 2012 11:33 pm
Forum: Building Installers
Topic: SQLCMD custom action problems
Replies: 18
Views: 22526
 
Jump to post

SQLCMD custom action problems

Ive been fighting with a custom action for more than a week and am really in need of some guidance. I'm trying to run a LaunchFileFromProperty custom action to install an SQL database from a backup. Here's what the custom action's command looks like:
"[RESULT_PROPERTY_SQLCMD_SEARCH]" -E -S "[SERVER ...

Go to advanced search