Page 1 of 1
Headscratcher on running scripts...
Posted: Wed Jan 10, 2007 10:15 am
by Earl
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.
Posted: Wed Jan 10, 2007 10:18 am
by jimo
Delete the username 'sa' just to make sure it is using Windows Authentication.
Posted: Wed Jan 10, 2007 10:40 am
by Earl
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.
Posted: Wed Jan 10, 2007 4:39 pm
by MichaelNesmith
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!