Invalid Connection String in SAP Business One

The answer lies within the exception message itself. The connection string that you are using to connect to the Business object server is wrongly configured. Check for each parameter, you will find something must be wrong and hence why you are receiving this error message.

Common Connection String Parameters

A typical SAP Business One connection string contains several critical parameters that must be correctly configured −

• Server − The SAP Business One server address
• CompanyDB − The company database name
• UserName − Valid SAP Business One username
• Password − Corresponding password
• DbServerType − Database server type (MSSQL2019, HANADB, etc.)

Example Connection String

Here's a properly formatted connection string example −

string connectionString = "Server=localhost; CompanyDB=SBODemoUS; UserName=manager; Password=manager; DbServerType=MSSQL2019;";

Troubleshooting Steps

To resolve the invalid connection string error, follow these steps −

1. Verify server address − Ensure the server name or IP address is correct and accessible
2. Check database name − Confirm the CompanyDB parameter matches an existing company database
3. Validate credentials − Test username and password through SAP Business One client
4. Confirm database type − Ensure DbServerType matches your actual database server version
5. Check syntax − Verify proper semicolon separation and no extra spaces

Common Mistakes

The most frequent connection string errors include −

• Missing or incorrect semicolons between parameters
• Wrong database server type specification
• Outdated or invalid user credentials
• Incorrect company database name casing

By systematically checking each parameter against your SAP Business One configuration, you can identify and resolve the connection string issue causing this error.