I am havin a problem that is driving me crazy. I have an SBS 2011 server running just fine. on that server, SQL Express 2008 R2 is installed and running. I have a SQL instance setup for a maintenace program. the program is installed and running just fine on the server.
I have the firewall open on the server for the 1433 and 1434 ports.
TCP/IP is enabled in SQL Configuration and I have the option to allow remote connections turned on.
When I install the program on the workstations, I cannot connect to the SQL database. I use the same connection string as the server and it fails. when I try to use the ODBC tools to connect to the database on the server I get;
error 17, SQL server does not exist or access denied
I have double checked the firewalls, it does work from the server, i have even tried to connect with the sa account, no dice.
any help would be appreciated.