Security

last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).
Back to discussions
Expand all | Collapse all

Generic SQL with MSSQL Instance

This thread has been viewed 4 times

  • 1.  Generic SQL with MSSQL Instance

    Posted Jun 23, 2016 04:27 AM

    Hi all

     

    I try to connect to a MSSQL Database with the "Generic SQL DB" Source. Unfortunately the SQL Server has an SQL-Instance with the name "BMS" and I can't add it to the connection information. Adding it to the Servername like "ip\BMS" doesn't work as well.

     

    Has anybody an idea?

     

    Regards

    Manuel



  • 2.  RE: Generic SQL with MSSQL Instance

    Posted Jun 23, 2016 04:29 PM

    So its not always just that simple as you found out. 

     

    FIrstly did you change the default driver on the PRIMATY tab to MSSQL?.... then it can depend a lot on how the underying MS-SQL DB is setup and configured. In the link below is an example of how I did a SQL connection to a BlackBerry MS-SQL DB.... hoefully this might give you a few pointers.....

     

    Tech Note: ClearPass Enterprise Mobility Management Integration V5 

     

    HTH



  • 3.  RE: Generic SQL with MSSQL Instance
    Best Answer

    Posted Jun 24, 2016 09:25 AM

    Hi danny

     

    That doesnt really help. but in the meantime I fixed the dynamic TCP port of the Named-Instance and use this directly. Works fine for me.

     

    Thanks & Regards

    Manuel