Server Install - Automatic vs. Manual SQL Setup

Questions, answers, and tips about the installation and configuration of DraftLogic Electrical

Server Install - Automatic vs. Manual SQL Setup

Postby forumadmin » Tue Sep 11, 2012 11:16 am

The DraftLogic Electrical Server installation package will attempt to install and set up SQL Server Express 2005 if the person executing the install selected ‘Yes’ to that option as asked early in the Server full install. If there is a pre-existing SQL Server, our databases can be attached to any flavor of SQL 2005/8/10.

SQL Auto Install Easy Way

When the installing person says ‘Yes’ to having SQL set up for them, four tasks are attempted by our DraftLogic Electrical Server full install:
A) call the included Microsoft SQL Server Express 2005 set up (the install provided by Microsoft is included inside our install package),
B) set up the SQL with a DRAFTLOGIC instance having a ‘sa’ full privilege SQL user and our database password ‘DrLGC*73df#1’ for that user, and
C) configure the ‘DraftLogic Electrical/Server/Config/ConfigDB.UDL’ file to have the correct SQL Server name, login, password, and point to DL-Config as the destination database.
D) copy the DraftLogic Electrical databases into the SQL ‘Data’ subdirectory and attach them to the SQL Server; this last part may happen after a restart, if so I believe the login on the restart needs to be the same user name that did the initial part of the install in order for this to complete.

This works as desired the vast majority of the time when there is no SQL server pre-existing on the workstation.

Pre-Existing SQL Likely Prevents Auto Install – Need to Manually Configure Databases

When the Microsoft SQL install package finds an existing SQL Server, it won’t run. In certain conditions the DraftLogic Electrical Server full install can still set up the DRAFTLOGIC instance with desired SQL user & database attachment. Often, however, the person running the full install will need to:
1) manually copy the DraftLogic Electrical database files from the ‘DraftLogic Electrical/Server/Databases’ subdirectory to the SQL ‘Data’ subdirectory (buried in Microsoft SQL folders in Program Files (x86)),
2) attach the three databases to the DRAFTLOGIC SQL instance or other desired instance using SQL Management Studio Express (free download from Microsoft) or similar database management software; we provide a SQL script to do this for you,
3) verify that within SQL there is the needed ‘sa’ user with our password having full rights to the three DraftLogic Electrical databases (users and permissions for databases are also set within SQL Management Studio Express), and
4) set up the ConfigDB.UDL and successfully ‘Test Connection’ therein.

I am pretty sure whomever desires to do all this needs to have local admin rights to the machine and I think they might also have to run the SQL Management Studio Express as administrator.

Note we have the database files and a script to perform the attachment in the ‘DraftLogic Electrical/Server/Databases’ folder.

Deciding Whether to Attempt SQL Auto Install or Just Do Manual Configuration

So a couple of things we can do to perhaps get through a ‘pre-existing SQL’ situation in the future—first and foremost, find out if the user needs/wants any pre-existing SQL. I say this as Microsoft bundles a SQL Server Express and Compact installation into many of its products, the Visual C++ and VB installations for example. If the user doesn’t need nor want those potentially interfering SQL products, uninstall them before running the DraftLogic Electrical Server full install—regardless of whether the user knows of any SQL or not, check the add/remove programs for any SQL that may have snuck onto the workstation so you can know in advance if there is something that might complicate the Server installation process.

If the user wants/needs any of the pre-existing SQL, you can try to run the DraftLogic Electrical Server full install and say ‘Yes’ to have it try setting things up. Be prepared, however, to check all four facets of the required SQL work if a test run of the ‘DraftLogic Electrical Project Library’ results in a Trouble Report instead of happily opening up the Project Library dialog. Note the Trouble Report will be very specific about where it failed to connect, read all the comments included in the Trouble Report by scrolling down to find out how far the attempted connection got. See the four manual steps above for what needs to be done when you either decide to just do the database side manually (i.e. to prevent any risk to existing SQL services) or the DraftLogic Electrical Server full install fails to do all it needs to.

We recommend not attempting the auto install where there is a pre-existing SQL either known or even suspected to be in use—go straight to the manual configuration method.
forumadmin
Site Admin
 
Posts: 87
Joined: Fri Sep 11, 2009 5:46 am

Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest

cron