What to do when my database does not connect?
The first step is to verify the database type you are using. On G-Electrical, there are 3 available types: LocalDB, MDB e SQL Server.
In case you database is LocalDB, you should check the folder address onthe database connection pop up on G-Electrical. To check this out, launch G-Electrical, from G-Electrical Ribbon > GE Manage > Connection with Database... Check if the database type is LocalDB. Then, check if the address points to the “dados” and “qccfg” folders.
First of all, launch G-Electrical > Go to GE Manage > Connection with Database... and check if the database type “MDB” is selected. Then, check if the address points to the “dados” and “qccfg” folders.
After this, check the compatibility of the office package. If your DraftSight is 64 bits, your office package shall be too. The same applies to 32 bits version.
If your database is a SQL Server type, begin checking if the computer running the G-Electrical is communicating with the computer of the SQL instance (server).
If the computers are communicating with each other, launch G-Electrical, go to GE Manage > Connection with Database... and check if the database type “SQL Server” is selected and if the settings are equal to the ones on SQL Management Studio.
In case all the information is right, launch the SQL Management Studio with the G-Electrical database and check out if the instance is running. If it is, it will appear as shown below.
Click to expand the “database”, then click to expand the content of the reffered database. Check if there are any content inside this folder.
Check if it was connected with the SQL Server authentication. If not, give it a try and restart the instance.
In case it is not running, fill in the server information and click on connect.
Launch the app.
On SQL Server services, check if the SQL instance are running. If not, right click and start it. If the start option is not available, right click > properties > Services > Initial mode: Automatic. Then, restart the instance.
Adding to this, we could go to “SQL Server Network settings”. in (InstanceName) protocols, check if all the 3 protocols are enabled. If not, enable them all and then restart the instance.
After that, launch SQL Management Studio again and try to connect to the instance. Then, try to connect to the database on G-Electrical.