troubleshooting Question

ODBC SQL Server Driver SQL Server Invalid object name 'SyUser' - Windows 7 64-bit, 32-bit Deltek FMS failure connecting to SQL Server server-based data.

Avatar of heteronymous
heteronymous asked on
Tax / Financial SoftwareMicrosoft SQL Server 2005Windows 7
5 Comments2 Solutions3807 ViewsLast Modified:
Have one machine at a location running Windows 7 Pro 64-bit and it's running Deltek FMS  just fine. Deltek FMS also calls some part(s) of itself "Wind2" - and uses MS FoxPro Visual locally and connects to a SQL server instance on a server (2008 SBS).

I'm trying to now get it working on a new Win 7 Pro (64-bit) PC and (after first installing dotnet 1.1 per http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_programs/how-to-install-net-framework-11-in-windows-7-64/eb1e6232-e874-432e-ab43-17660e25e43d ) as required by this app.

Everything installs fine. As mentioned above, this is a network server, local (client app) install (of Deltek client) type setup.
The installer is run from the mapped drive with the Deltek install, per the instructions (which err on the rather vague side).

When launching Deltek, the error is:

An error occurred attempting to communicate to the database server:
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'SyUser'

I manually duplicated the ODBC settings via Windows\SysWOW64\odbcad32.exe
based on the settings from the working install on the other Win7 workstation (also 64-bit)
and still get the same error.

The SQL driver definition is to use a SQL-server based login, the Client Config (Network Library Configuration) is set correctly to Servershortname\Deltek and is set to and specifies to "change the default database" to FMS_Companyname

and still the error (above) persists.

Any help welcome, TIA !
ASKER CERTIFIED SOLUTION
Daniel_PL
DB Expert/Architect
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros