Database
Microsoft SQL Server
Integrates the Configu Orchestrator with Microsoft SQL Server.
- Name: Microsoft SQL Server
- Category: Database
Configuration
Configu needs to be authorized to access your Microsoft SQL Server database. Configu utilizes TypeORM under the hood to establish a connection with the database using data source options you need to supply.
.configu
Store Declaration
CLI Examples
CLI Examples
Upsert Command
Eval and Export Commands
Upsert Command
Eval and Export Commands
Common Errors and Solutions
Common Errors and Solutions
-
Connection Timeout Issues
- Solution: Verify that the host, port, and network configurations are correct. Increase
connectTimeout
in the configuration if needed.
- Solution: Verify that the host, port, and network configurations are correct. Increase
-
Authentication Failures
- Solution: Ensure the provided
username
andpassword
are correct, and the user has access to the specified database. Use a SQL client to verify credentials.
- Solution: Ensure the provided
-
Encryption Errors
- Solution: If your SQL Server instance enforces encryption, ensure the
encrypt
option is set totrue
. If not, set it tofalse
.
- Solution: If your SQL Server instance enforces encryption, ensure the
-
Permission Issues
- Solution: Verify that the user has
READ
andWRITE
access to the required database. Use the following SQL command to grant permissions:
- Solution: Verify that the user has
References
- Integration documentation: Microsoft SQL Server
- TypeORM documentation: MSSQL Data Source Options
-
Connection Issues
- Solution: Verify that the host, port, and encryption settings are correct. Make sure the database server is reachable from your application.
-
Authentication Failures
- Solution: Confirm the correctness of the provided
username
andpassword
. Ensure the user has appropriate access to the specified database. You can verify credentials by logging in using an SQL client tool.
- Solution: Confirm the correctness of the provided
-
Encryption Configuration Problems
- Solution: Check if the
encrypt
option is set correctly for your database setup. If SQL Server requires encrypted connections, ensure that encryption is enabled in the configuration.
- Solution: Check if the
-
Database Permissions Issues
- Solution: Ensure the user has
READ
andWRITE
access to the required table. Use the following SQL command to grant permissions:
- Solution: Ensure the user has
References
- Integration documentation: https://learn.microsoft.com/en-us/sql/sql-server
- TypeORM documentation: https://typeorm.io
Was this page helpful?