Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Access to SQLCRS database from crystal reports

Hello

I am trying to create custom reports for ipcc express enhanced through crystal reports.  I cannot connect to the crssql database.  I have created a new account on the IPCC server that will be used for accessing the database, and put it into the administrators group.

When i try and access the database through crystal reports OLE DB (ADO) > Microsoft OLE DB Provider for SQL Server I receive an error "login Failed, not associated with a trusted SQL server connection"

I have SQL configured as windows authentication, because when i used mixed mode it caused an error with historical reports.

Can someone help me out with the proper process for providing access to the crssql database?

Thanks

6 REPLIES
Community Member

Re: Access to SQLCRS database from crystal reports

The problem with mixed-mode authentication was corrected in 7.0(1) SR4.

When I connecting through Crystal Reports, I first created a user on the UCCX server, then granted it access to the db_cra database. Needed to specify the full path to the database in the server field [server-name]\CRSSQL and the login and password that I created. Under database I specified db_cra.

The custom reporting guide states to use the 'Integrated Security' option, but I was not able to connect that way.

Tom

Community Member

Re: Access to SQLCRS database from crystal reports

Hi Tom

When you created an account on UCCX did you create it as a windows account or an SQL account?  I am planning to move to UCCX 7 in the near future but unfortunately doesn't help me with creating custom reports on our current version.

Thanks

Community Member

Re: Access to SQLCRS database from crystal reports

I created a windows account then gave it rights to the SQL database.

Tom

Community Member

Re: Access to SQLCRS database from crystal reports

Hi Tom,

"The problem with mixed-mode authentication was corrected in 7.0(1) SR4" <- what was corrected here? we are now able to see mixed mode authentication after SR4?

Thanks!

-JT-

Community Member

Re: Access to SQLCRS database from crystal reports

Hi,

Can you check if you have TCP and Named pipes in the trusted connections for SQL client and server both?

It could be the issue here.

Let us know how it goes.

Thanks,

Daljeet

Community Member

Re: Access to SQLCRS database from crystal reports

Thanks for the reply's guys they have been great.  Sorry for the delayed post i was away for the last week.

tjugoretz- How did you assign access to the SQL: database through for the new windows user account?  I want to make sure i get this right.

Thanks

600
Views
0
Helpful
6
Replies
CreatePlease to create content