SiteMinder Logs Data Source : unexpected error in database interface. Error code - 1063

[Anon Anon]

I'm seeing this error when trying to connect to a MSSQL 2012 Data Base using Policy Server version R12.52 on RHL. My system_odbc_ini looks like this:

[SiteMinder Logs Data Source]

Driver=/opt/CA/siteminder/odbc/lib/NSsqls27.so

Description=DataDirect 7.1 SQL Server Wire Protocol

Database=SiteMinder Audit Logs

Address=IP, 1433

QuotedId=No

AnsiNPW=No

DMCleanup=2

 

I also have to proper user name and password, so I'm not really sure why is this error coming up. Any ideas?

[Ujwol]

Can you please clarify when do you see this error ?

 

• Do you see this error while performing "Test Connection" in the Data-->Audit Logs tab in the "Policy server Management Console" ? Or,
• Do you see this during normal operation of Policy Server ?
• Are you able to connect to the Sql Server instance using any other external SQL client from the Policy server machine ?

 

Please confirm,

[Anon Anon]

Ujwol,

Thanks for the taking the time to answer this question. I will answer your troubleshooting questions below:

 

• Do you see this error while performing "Test Connection" in the Data-->Audit Logs tab in the "Policy server Management Console" ?
  • Answer: Yes This is exactly where I'm seeing this issue.
• Do you see this during normal operation of Policy Server ?
  • Answer: No
• Are you able to connect to the Sql Server instance using any other external SQL client from the Policy server machine ?
  • Answer: I have not tried that yet

[Anon Anon]

Ujwol.

Thanks for answering this question.

 

Yes, I'm seeing this error when I try to use "Test Connection" from the smconsole.

[Karmeng]

Hi

Did you provide the correct ip address? The snippet of system_odbc.ini don't have the ip address so just curious.

 

Did you run the sm_mssql_logs.sql to SQL server database? (<Policy server install path>\db\SQL)

[Anon Anon]

I've provided the right IP address and port. The issue is still not resolved.

[Julien_Nitot]

Hello,

 

What is the name of the Data source that you are referencing in the Policy Server Management console ? "SiteMinder Logs Data Source" ? It should be the exact name as the one that you provided in your system_obbc.ini.

Are you able to telnet the IP, port of the SQLServer box from your Redhat policy server ?

Does the user/password used are correct ?

Are you sure of the Database name ? "SiteMinder Audit Logs" seems a bit long and strange for me as a database name for SQLServer.

Hope it helps,

Julien.

[Karmeng]

Hi,

 

If Test Connection at smconsole didn't work, it means something wrong on the configuration of database. Have you used any third party  tool to connect the database: SiteMinder Audit Logs?

 

SQL Server Performance Tuning and Database Development | Toad

 

Did you get to connect to the database with third party database tool?

 

Kar Meng

[Anon Anon]

Karmeng,

Just an update. I've been able to login with MS SQL Management Studio with no issues. I'm starting to think that maybe a local account is needed to allow connectivity from the policy server to the sql database.

 

Currently the database is configured to allow windows authentication. Can windows authentication be used to connect to an mssql database from a linux server?

[Karmeng]

Hi,

The local account is worth to try. In policy server management console -> Data tab -> Audut logs, the user name and password used to connect to SQL need to be able to login in MS SQL Management Studio

[Ujwol]

Hi,

 

Just to confirm, are you saying that MS Sql Server services are running under Network Service Account and if changing that to Local Service Account would help ?

=> If this is what you are asking then NO, it doesn't matter which under which account the service runs.

 

What matters is if you have configured "Sql Server Authentication" for your database or not.

If you have configured only "Windows Authentication" for your database and don't have any other USERS using "Sql Server Authentication" then you will NOT be able to communicate with this server from Policy Server.

If you haven't already created a Sql User please create one by logging into Sql Server Management Studio --> Security --> Logins --> New Login as below , and use this credentials to connect to the audit database form Policy Server

 

 

 

Hope this helps,

Ujwol

[Anon Anon]

Ujwol,

Thanks for the detailed answer, your answer validates my initial thought. Basically a SQL account will be needed to connect from the Policy Server to the MSSQL database.

[Ujwol]

No worries. Let us know how it goes and don't forget to mark the thread as resolved if you are able to get past the issue using Sql authentication.

 

Cheers,

Ujwol

[Anon Anon]

Ujwol,

Thanks for the input, I have been able to connect to the SQL audit store using a local account. 

[Ujwol]

Hi ,

 

That's a great news.

Thanks for taking time and updating us on the result.

 

May I also request you to mark this query as resolved/answered?

 

Cheers,

Ujwol