Deploying MSDE and VB

hi,

I have vb app that uses a SQL Server database.

I have already created the package for installation but still need to install MSDE and set it up without user intervention?

Ie. I want the MSDE to install with the server and database name I want to, and then run the create_database.sql file to create the tables and stored procedures.

Can I destribute MSDE freely?

any links or suggestions would be appreciated.

Thanx

Hi,

The company I work for, Red Gate Software, sells a product that lets you package a SQL Server (including MSDE) database or database update. One of the common uses of this is to allow you to create a database with no user intervention.

You can try it out for free for 2 weeks from http://www.red-gate.com/sql/sql_packager.htm

Hope that this helps,

Simon

Hi,

Sorry re-reading your post I think I mis-understood your question. SQL Packager does the bit that you've already done.

MSDE is freely distributable.

Simon

Thank you Simon, for your input, appreciate it.

Hi,

I have this line in my Inno Setup script



This should create a database with Nexus as name right?

But when I run it, I get the "Strong SA Password required error: Setup will now exit" error. Am I missing a parameter?

any help is appreciated

hi all,
this is the new line i use for the parameters, it installs without errors, but when I go to the server agent in the system tray, it's empty? and when I click on refresh services, I get error 6, "Error The handle is invalid."


any ideas?

ok,

its installing the sql agent now, but there is no service running, but when I type
DOMAIN\Nexus into the server box, it starts the service?

Any idea how to get this done automaticly?

I have no experience in these things, but in order to start a service, you can use "net start [service name]" in the command line - so if you find the VB.NET equivalent for the classic ASP WScript.Shell you can use it and execute such net start command.

thanx Shadow, I am at work now, this is for another project, will post again if I struggle.

I have started the service, using
net start MSSQL$Nexus, but I still can't get the SQL Agent to use the default server name, ie, I have to type in 127.0.0.1\Nexus everytime I want the service to run the server properly.

Any ideas?

sorry buddy I'm newbie in this area - you know much more than me - I just hope someone more vetern in these issues would pop here!