SQL Server Requirements

Supported SQL Server Versions

• SQL Server 2016 or later is recommended (matching the development environment).

Database Access

• The application connects using the MyCompany connection string in web.config.
• A dedicated SQL login or Windows account should be used with:
• db_owner (or equivalent) rights on the CONPROSOFT database. The hosting provider issued SQL credentials will be correctly provisioned.
• For application access always use the least privileged account. No broader rights than necessary.

Database Configuration

• Ensure the database collation and settings are compatible with the existing schema.
• Configure regular backups (see Backup Strategy and Frequency).
• Monitor:
• Index fragmentation
• Growth of data and log files
• Performance counters (CPU, IO) as appropriate

Schema Ownership in Shared Hosting

• Application objects are expected under the dbo schema.
• In this hosting environment, manual changes can default to host namespace ownership (currently conproso) when schema is not specified.
• Objects created as conproso.TableName instead of dbo.TableName may cause binding and runtime issues in the application.
• Always use explicit schema-qualified object names such as dbo.TableName in all scripts and manual SQL changes.

Any changes to the database server or migration to a new instance must include:

• Update to the MyCompany connection string.
• Validation of connectivity from the web server.
• Smoke testing core application functions afterwards.