Headscratcher on running scripts...

Earl · Post by **Earl** » Wed Jan 10, 2007 10:15 am

I went back through the forum posts and found that running SQL Scripts is a common problem. I've got everything working properly on the install package -- except the SQL script which creates the objects. But this leaves me dead in the water. Is there any resource to go to on how to troubleshoot this issue as it seems very common? I'm using SQLExpress (created by IA), Windows Authentication, 'sa' for user, and no password. I've even tried the simplest of scripts to create a single table, to no avail.

jimo · Post by **jimo** » Wed Jan 10, 2007 10:18 am

Delete the username 'sa' just to make sure it is using Windows Authentication.

Earl · Post by **Earl** » Wed Jan 10, 2007 10:40 am

Thanks for traveling with me on this journey this morning Jim. I will do that. I also ran another test on a clean machine and found out something fascinating. My main dev machine has SQLEXPRESS SP2 installed (installed previously). On this machine, it creates the database but will nto run the script. On the clean machine, I have SQLEXPRESS SP1 installed. It created the database AND ran the (test) script. I'm going to give it a fullblown create tables, sprocs, inserts script now and see what happens.

MichaelNesmith · Post by **MichaelNesmith** » Wed Jan 10, 2007 4:39 pm

Also please try the new Alternate SQL Server plug-in on the Plug-Ins section of the forum, and let us know what happens with that one!