By David Wiseman (Administrator)published 02 Mar 2009
My Rating:
Vote
Rating:
Not Rated
Views:3172

ScriptBuilder - SQL Server 2005/2005 Express Support

ScriptBuilder will work with SQL Server 2005/2005 Express instead of SQL Server 2000/MSDE. Installation for SQL Server 2005 is essentially the same for 2000/MSDE, but there are some changes that you should be aware of.  By Default, SQL Server 2005 Express installs with an instance name of SQLEXPRESS rather than installing as a default instance.  The installation of ScriptBuilder assumes a local, default instance of SQL Server is available to connect to, so you will need to modify the connection string during the database installation and the first time you load ScriptBuilder.
e.g.
From
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=(local)
To
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=(local)\SQLEXPRESS

You can also build your connection strings visually if you prefer by clicking the modify button when it prompts you for a connection string during the database installation or the first time you load ScriptBuilder:

Data Link Dialog 
 






Script Builder