SQL Express logon and scripting

[tgarratt]

Hi everyone,

I'm having difficulty executing a script against my SQL Express server deployed by the installer.

Assuming the server exists, I would like InstallAware to create a database, then run a setup script against it. Whilst trying to debug it, all I can get from the script result variable is "ERROR". Enabling LOGGING to a file doesn't help, because none of the errors are dumped to the log file.

I think the problem lies in the Server name and Instance name. Bearing in mind I want to use the Default instance and Windows mode authentication. I have tried various combinations of all these details, namely:

Server: .\\SQLEXPRESS
Instance: (blank)
Database: Snax
User: (blank)
Password: (blank)
Variable: MYSCRIPT

All I want to happen at the moment is a database to be created on the server. I've read some other forum posts regarding this problem but no luck so far. I've also installed SQL Express Management Studio to check the results of any successful database creation and scripting.

The value of MYSCRIPT is always ERROR.

Any ideas?

Thanks, Tom

[Gizm0]

Should be:

Server: (local)
Instance: SQLEXPRESS

Don't forget to hit the Generate command line button, on the InstallAWARE SQL plugin..

[tgarratt]

Thanks gizmo, it worked perfectly! Just need to double check a few issues about instance...

Assuming we need an instance, how is the initial install supposed to work? I have been informed that a strong password is required for the sa account on the first install. From then on, instances can have their own username/password (but they're probably not required).

So... First install requires a strong password. An instance doesn't, even if it is the first install???

Can you please shed any light on how this is meant to work?

Thanks, Tom