This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Add new repository SQL error

I've got a new instance of 5.9.2 installed and I'm trying to add a repository, when I click save I get the following error:

A database error occurred. The error was: message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user ''., sqlstate: 28000, code: 18456, var_info: -Could not create the MetaStore repository.

In ControlPoint MetaStore.cfg I have the following: 

ConnectionString=Driver={ODBC Driver 17 for SQL Server};Server=sql;Initial Catalog=ControlPointMetaStore;Integrated Security=SSPI;

The MetaStore service is running as the user who has full access to the ControlPointMetaStore database - do I need to do something else to get the credentials to work?

Parents
  • 0

    Not entirely sure why, but changing my connection string to this format worked for me (found a similar format while scouring IDOL admin help!)

    Driver={ODBC Driver 17 for SQL Server};Server=sql;Database=ControlPointMetaStore;TRUSTED_CONNECTION=yes

Reply
  • 0

    Not entirely sure why, but changing my connection string to this format worked for me (found a similar format while scouring IDOL admin help!)

    Driver={ODBC Driver 17 for SQL Server};Server=sql;Database=ControlPointMetaStore;TRUSTED_CONNECTION=yes

Children
  • 0 in reply to 

    In CP 5.9.4 onwards we bundle the newer ODBC Driver for SQL Server with ControlPoint and also update the connection to :

    Driver={ODBC Driver 17 for SQL Server};App=ControlPoint;Server=<SERVERNAME>;Database=ControlPointMetaStore;Trusted_Connection=yes