Https://docs.powershelluniversal.com/config/settings || appsettings.json || SQL SERVER

PowerShell Universal
1

hi

currently i try to setup the sql connection after the installation by changing the appsettings.json

to

“Plugins”: [
“SQL”
],
“Data”: {
“RepositoryPath”: “%ProgramData%\UniversalAutomation\Repository”,
“ConnectionString”: “Server=(localdb)\mssqllocaldb;Database=PSU;Trusted_Connection=True;”
}
}
or
to the server as self
but I after restart the services i see a .net Error

Description: The process was terminated due to an unhandled exception.
Exception Info: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 26 - Error Locating Server/Instance Specified)

any kind of help ?

2

Make sure that you escape the backslashes in your appsettings.json.

“Plugins”: [
“SQL”
],
“Data”: {
“RepositoryPath”: “%ProgramData%\\UniversalAutomation\\Repository”,
“ConnectionString”: “Server=(localdb)\\mssqllocaldb;Database=PSU;Trusted_Connection=True;”
}
}

Can you try that and see if it behaves differently?