ArticlesArticles Most Popular ArticlesMost Popular Articles
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon 2020 Official Holidays & Support Schedule
DrillDown Icon IMPORTANT: End of Life of SHA1 on Windows Server 2003
DrillDown Icon IMPORTANT: Supported Operating Systems
DrillDown Icon PLEASE READ: Our Update Server IPs Have Changed
DrillDown Icon Support
DrillDown Icon modusGate for Microsoft Azure
DrillDown Icon modusCloud
DrillDown Icon Alleviating Spam – Best Practices
DrillDown Icon directQuarantine Technical Information
DrillDown Icon modusMail & modusGate Technical Information
DrillDown Icon Other Product Technical Information
DrillDown Icon VOP Radius
DrillDown Icon Release Information and Patches
DrillDown Icon Troubleshooting
DrillDown Icon Error codes and messages
DrillDown Icon Invalid Packet Processing
DrillDown Icon SQL Server does not exist or access denied
DrillDown Icon “Access check: This user is defined to use a profile and none has been found! [User name: XXX] [0].
DrillDown Icon Arithmetic overflow error converting expression to data type int
DrillDown Icon The service type is missing!
DrillDown Icon Cannot create a remote manager connection point. RPC error 1762.
DrillDown Icon No Password
DrillDown Icon Error: ***1058: The service cannot be started, either because it is disabled or because it has no enabled devices associated..
DrillDown Icon class CAccessCheck : We got zero (0) as numeric value, this MAY be a problem!
DrillDown Icon Problems and Solutions
DrillDown Icon Configuration Assistance
DrillDown Icon Tools approved by Vircom
DrillDown Icon Third Party Products
DrillDown Icon VOPCOM
DrillDown Icon Professional Services
DrillDown Icon Newsletters
  Email This ArticlePrint PreviewPrint Current Article/Category and All Sub-Articles/Categories
Radius: ODBC Error: State:08001, Msg:[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

Problem: Either users do not authenticate or accounting packets are not recorded in the accounting database. And, the error log shows the following error:

(Debug   :02612) 10/1/2004 17:43:46 ** ODBC (0) ACCESS IDENTIFICATION ** (len=125)
(Error   :02732) 10/1/2004 17:44:03 ODBC Error: State:08001, Msg:[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
(Debug   :02732) 10/1/2004 17:44:03 ODBC Error: Env=Ok,Connect=Ok,State=Error
(Error   :02732) 10/1/2004 17:44:03 ODBC Error: State:08003, Msg:[Microsoft][ODBC Driver Manager] Connection not open
(Debug   :02732) 10/1/2004 17:44:03 Radius ODBC Connection Error: DataSource VoIPRadius

Cause(s) : This is an ODBC error returned either from the ODBC Driver or Microsoft SQL. VOP Radius is reporting rather than generating the error. A list of possible causes includes the following:

* MS SQL Server down
* The wrong MS SQL Server specified under the ODBC Driver
* The credentials to connect to the database are wrong in either VOP Radius or the ODBC Driver.

Modified 10/1/2004
Article ID: 644