Sage CRM

Anybody every seen this error in the Sage 100 (MAS 90) integration engine? 2012-10-30 10:02:14 - Could not connect to Sage CRM SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I can connect to the SQL server without issue using the same connection parameters from SQL Server Management Studio, but apparently Sage 100 cannot.

Just an update -- I opened a case with Sage yesterday, and they were stumped too. Have a call back from Steffan scheduled for today.

Is SQL on the same server as Sage 100? If not, did you connect from Management Studio on the 100 server or the SQL server?

SQL, CRM and Sage 100 are all on the same server. I disabled the firewall to be sure it wasn't something dumb like that.

When you connect from Management studio, does it connect using ""localhost"" or the actual server name? (SQL can be set to not allow connections via the network which actually ends up including connecting from the same machine using the machine name instead of localhost.) Is there an instance name or is SQL the default instance?

I'm using the server name in Management Studio to connect. It is a named instance -- just the default SQL Express Instance that comes with CRM 7.1.

Problem solved. I hate to admit this, but I don't know why it's working now when it wasn't working the other day. Weird.