Check in "Programs and Features" you have SQL Native Client installed.
Its setup is located in "SolidWorks Downloads\...\prereqs\SQLNativeClient\sqlncli_2008_x64.msi"
When you open Electrical, even though it doesn't connect to a database, you can then go to Tools -> Application Settings -> Databases and enter a different server name and sql instance.
Also, when reinstalling SolidWorks Electrical, you have to be extremely careful and select whether you want to use an existing SQL instance or create a new one.
If you are still having issues, might be best to get someone who knows about Microsoft SQL to take a look.
Jonathan, check if the SQL Server service is running on your machine.
Right click on Computer and select Manage
On left hand side go to Services and Applications, then Services.
Scroll down to find SQL Server (TEW_SQLEXPRESS) and try manually starting it.
The SQL service is running but it is under a different name. I have an HMI programming software package that also uses SQL and the SQL service that is running is under the name of the HMI programming software. I am thinking that there should be another service running for the SolidWorks electrical or maybe there is a way to add the TEW user to the SQL service that is already running?
I would uninstall SOLIDWORKS Electrical and re-install using default settings. You should have a SQL service running titled TEW_SQLEXPRESS.
Also, you need to open ports TCP 1433 and UDP 1434 on your SQL Server.
I have uninstalled and reinstalled SolidWorks Electrical and I still have the same error message. I noticed that it did change the Hostname to a different SQL server but it is still not the correct one.
Please log in to https://customerportal.solidworks.com/
Click Knowledge Base, and search for S-069274, please use this tool to test your server connection.
All tests failed.
We're on a domain network and the firewall on the workstations are truned off. My colleague has the same workstation with the same SolidWorks package installed and the SolidWorks Electrical program loads on his with no errors.
Ah, that sounds like a difficult case to solve.
Thank you Stephen Burke.
I had a newer version of SQL Server that was installed by another software package that I use to program HMIs. I uninstalled the newer version of SQL Server and the HMI software, then intalled SolidWorks electrical, then I re-installed the HMI software. Everything is now working in harmony.
SolidWorks Electrical and the SQL Native Client mentioned above work with SQL Server 2008 and I had SQL Server 2008 R2 installed. After removing SQL Server 2008 R2 I was able to get SolidWorks to install and work correctly. Now that I have re-installed my HMI programming software my system is running with SQL Server 2008 R2 and SolidWorks Electrical seems like it is working correctly so far as I have not encountered any issues.
Retrieving data ...