Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

ODBC error occurs when re-creating SQL database using initDB.bat tool

    • Updated:
    • 20 May 2014
    • Product/Version:
    • InterScan Web Security Suite 3.1 Windows
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary
When you re-create the SQL database of InterScan Web Security Suite (IWSS) 3.1 for Windows using the initDB.bat tool, the following error occurs:
ODBC Error…Server does not exist or access denied.”
ODBC error when running initDB.bat tool
Details
Public
The error occurs when the password for database user authentication has not been supplied. The InitDB.bat tool needs to access the ODBC data source connector for the IWSS SQL database instance, and ODBC requires a password.
To resolve the issue:
  1. On the IWSS server, access the Data Source (ODBC) by clicking Start > Administrative Tools > Data Source (ODBC).
  2. In the Data Source (ODBC) window, go to the System DSN tab. You will see dsniwss3, the ODBC data source connector to the IWSS SQL database instance.
  3. Select dnsiwss3 and click Configure.
  4. Leave the default entries as is on the first page and then click Next.
  5. In the next window which shows the authentication settings, input the 'sa' SQL user account password and then click Next.
  6. Click Next on the succeeding pages until you reach "Finish".
  7. Run the following command:
    initDb.bat <user> <password> <iwss database instance> -f
    This output will appear:
    [NOTICE]: If you already have an old "iwss3" database in the server
    [192.255.255.255\iwss ],this program will delete this database, and create a new one from scratch!
    Do you want to continue(y|n): y
    1.Creating DSN for database creation...
    2.Deleting possible pre - existed database...
    3.Creating database ...
    4.Creating tables ...
    5.Creating procedures ...
    6.Inserting default values ...
    7.Creating default cleanup job
    Database for IWSS3.1 Windows has been successfully created and initialized!
If the issue persists, contact Trend Micro Technical Support.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1099720
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.