We are trying to connect this to our HR database and utilize it for card creation, I am having trouble connecting to it. I put in the name the server name and the database name and I get a could not connect error message.
Is there a special type of database I need to load?
Could not connect to [database]
a network-related or instance-specific error occurred while establishing a conection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and the SQL server is configured to allow remote connections.
Now my dba asked me if there was a specific database that Card Exchange was looking for. I couldn't find anything in the help file but I wanted confirmation that the database does not matter, and it can be any SQL server database not provided by Card Exchange.
Your SQL Server is not available to be connected, it can be due to:
1 - You didn't type the correct instance name, a usual definition example for SQL Server Express is \\PcName\SQLSERVEREXPRESS, the PcName is the sql server name itself and SQLSERVEREXPRESS is the instance name
2 - The Sql Server Browser is not enabled for that server
3 - The server firewall is blocking the connection
On my support PC I am using SQL Express too. Besides the name of the server and the database name, it is very important to know if the database you are connecting to allows external connections. In a lot of cases, the SQL Express is installed by the application that is using it and it also installs the database. In most cases you need to have at least a username and password for being able to connect, but it can also be that the database itself is protected for connections by external applications. As you can see in the screenshot, I am using a password to connect to the database.
To make sure that CardExchange® can connect to the database I would advice to install SQL Server Management Studio.
Download SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe depending if you want to use 32 or 64 bit.
After you have installed SQL Management Studio you need to make a connection to the SQL Server Express. If that does not work either, probably the rights of the database do not allow anything external.
Marcel Oosterhof Support Team
Simplicity means an easy to use interface even for complex solutions...