Fix Error 20599 Cannot Open SQL Server | Error 599 Attempting To Access DataSource

When you use a DSN to connect to a database, you may receive an 0x80004005 error message or   Error 20599 - Cannot open SQL Server or Error 599 or An error has occurred on the server in attempting to access datasource

This can occur when you have installed Crystal Reports 8. This is a known issue that occurs when IIS or any other application creates and attempts to use a System DSN after the installation of Crystal Reports 8. For more information, see the following Crystal Decisions Knowledge Base article:

http://support.crystaldecisions.net/library/kbase/articles/c2007581.asp

What this mean is  Crystal Reports was the culprit.  What gripes everyone is that Seagate didn't include this fix in version 8.5 if it was a known problem in 8!

The Crystal Reports installation modifies the permissions for the HKEY_LOCAL_MACHINE\Software\ODBC\odbc.ini registry key and its subkeys. The Everyone group's permissions are changed from Special Access to Full Control.

When you create a new System DSN, it does not inherit the Windows NT default permissions, or the new permissions created by the Crystal Reports 8 installation. Instead, the sub key for the new DSN receives permissions for two user groups:

• Local Machine\Administrators -- Full Control
• SYSTEM -- Full Control

Only the permissions for Administrators are set, and no permissions are set for the Everyone group. Therefore, only users with Administrator rights can access the System DSN.

Solution:

You can Google for the software scr8_webregfix.exe  run to fix this issue.

If you are not able to get that file, (just as I cant) you can follow the steps below:

• Open regedt32 (Start-->Run, then type regedt32) (for windows vista and windows 7, press Windows Key + R to get the run prompt)
• Go to  hkey_classes_root \ typelib \ 000204ef-0000-0000-c000-00000000046 \ 6.0 \ 9\ win32
• With that key selected Go to Security---->Permissions (for Windows vista and Windows 7, Right click that value and choose permissions)
• Give or Add yourself and/or local admins (hopefully you are a local admin)  FULL CONTROL for the above Key

And if you are running Windows Vista or Windows 7, make sure you are running the regedt32 as administrator.

Solution 2: Refer This site and read the English version of the article.

More Details About The Error For Your Information:

The Scr8_webregfix.exe update resets all existing permissions in the HKEY_LOCAL_MACHINE\Software\ODBC\odbc.ini registry key (and all of its subkeys) to the Windows NT default permissions. It also resets sections of the HKEY_CLASSES_ROOT\Interface and HKEY_CLASSES_ROOT\Typelib subkeys to the Windows NT default values. Any new and existing System ODBC DSNs now inherit the Windows NT default permissions.

Version 8.0.0.84 requires that the Everyone group is set to Full Control and cannot connect to a System DSN by using a Special Access (default) registry permission level. The updated P2sodbc.dll file (version 8.0.0.85) is required to connect to a System DSN by using the Windows NT default registry permissions. (For example, the Everyone group is set to Special Access.)

The P2sodbc.dll issue also applies when version 8.0.0.84 is distributed to computers that do not have Crystal Reports installed (for example, as part of an application previewing a Crystal Report). For more information, see the following Crystal Decisions Knowledge Base article:

http://support.crystaldecisions.net/library/kbase/articles/c2007612.asp

This fix also resolves the following SQL Server error messages if the System DSN has been set after Crystal Reports was installed:

• Infinite logon to the database
• Error 20599 - Cannot open SQL Server
• Error 599
• Error - An error has occurred on the server in attempting to access datasource

For more information, see the following Crystal Decisions Knowledge Base articles:

http://support.crystaldecisions.net/library/kbase/articles/c2007612.asp
http://support.crystaldecisions.net/library/kbase/articles/c2007701.asp

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

266621  PRB: Error "Library Not Registered" with Crystal Reports 8.0

268553  PRB: Visual Studio Installation Problems Occur If Crystal Reports 8 Is Installed

See also the following Crystal Decisions Web sites:

http://support.crystaldecisions.net/homepage/
http://support.crystaldecisions.net/communityCS/FilesAndUpdates/P2sodbc8.zip.asp