LFDS modify connection string

replied on November 18, 2019

You can do this via the "Modify Connection String" hyperlink (which you may already be aware of) where you can enter the SQL connection string.

I don't see the format specified but would assume it to follow something like the .NET Framework data provider detailed on here - https://www.connectionstrings.com/sqlconnection/ i.e.

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

1 0

replied on November 18, 2019

Thanks Nigel for reply but need specified format in order not face any problem.

0 0

replied on November 18, 2019

Hi Shiraj,

Why are you trying to update the connection string?

If you need to specify a new SQL Server/database name/credentials for the existing LFDS database database, do this instead:

Write down the licensing site name (in Nigel's screenshot it's "LFDS_DEV")
Select "Detach licensing site" -> This will take you to the original LFDS setup page.
Enter the same Licensing Site Name and new SQL Server/database name/credentials for your existing LFDS database.
Select "Attach" database rather than "Create".
This will reattach the LFDS database using a new connection string generated from those inputs.

You may need to modify the connection string for a different reason, like adding the "MultisubnetFailover=Yes" parameter for SQL Server Availability Groups. If so, the "Modify connection string" takes the standard SQL connection string format.

You can find examples here:

https://www.connectionstrings.com/sql-server/

Note that "Trusted Connection" means "Use Windows Authentication".

1 0

Question

Question

Replies

Sign in to reply to this post.