04-09-2012 09:55 AM
We are currently using 7.2.2 (on SQL 2000) planning to upgrade to 7.5.4 (SQL 2005). Our first step is to upgrade to SQL 2005 which we are currently testing. Two "Network" users (our DBA/Admin and another admin) are getting in without issue but 3 other testing users (one admin) are all getting the following error:
"Database login failed: SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]"
And during Data Link setup for the failing users, the following error is generated:
"Unable to initialize data dictionary"
Searches on Google, SLX Knowledgebase and SLX Community have not offered any clear insights on how best to proceed. I was curious if anyone could offer any direction. We hopefully will be calling Sage later today (Invoice payment delays!)
04-09-2012 11:57 AM
Did you modify the link in the Connection Manager? Make sure you're using the Native Client driver, and sometimes the client machines will need the SQL Native Client installed on it also.
04-09-2012 12:12 PM
You ohave to make sure the correct SQL Native Client drivers are setup on both sides (Server and client apps).
Check this blog post:
04-09-2012 12:57 PM
04-09-2012 01:10 PM
04-10-2012 04:09 AM
04-10-2012 06:36 AM
It turns out that we simply had to create an alias to the Server\Instance on each Network Client using cliconfg (SQL Server Client Network Utility). Our testing described in an earlier post had done this for us behind the scenes but creating the alias, which I had remembered seeing in this SLXDeveloper Post,didn't require any testing or secure passwords. Since someone else had the same problem with the same fix I suspect this issue is not necessarily specific to our environment but my guess is that the alias helps point to the specific instance rather than the default instance (which works fine without an alias).