Sql Server on Premise as Data Source No longer available

It appears that the process for connecting database sources like SQL Server (on-premises) and RDS to Amazon Q Business has changed. Instead of having direct access to connect these data sources, you now need to request access first.

When you try to add SQL Server or RDS as a data source in the Amazon Q Business console, you'll see a "Request Access" button instead of a "Connect" button. This indicates that either your AWS account doesn't currently have the necessary permissions to use these data source connectors, or the connectors might be in a preview or limited availability phase.

To proceed with adding SQL Server or RDS as a data source to Amazon Q Business, you should:

1. Click on the "Request Access" button when you see it in the Amazon Q Business console.
2. This will direct you to an AWS contact form.
3. Fill out the form to request access to the SQL Server or RDS connector for Amazon Q Business.
4. Wait for a response from AWS support with further instructions.

In the meantime, ensure you've completed the prerequisites for connecting Amazon Q Business to Microsoft SQL Server:

• Create an Amazon Q Business application
• Create a retriever and add an index
• Create an IAM role for your data source
• Store your SQL Server authentication credentials in AWS Secrets Manager

Once you receive approval and instructions from AWS support, you should be able to proceed with connecting your SQL Server or RDS database to Amazon Q Business.
Sources
Amazon Q Business Data Sources How to Request Access | AWS re:Post
Connecting RDS to Amazon Q Business | AWS re:Post
Prerequisites for connecting Amazon Q Business to Microsoft SQL Server - Amazon Q Business

The SQL Server (on-premises) and RDS SQL connectors are deprecated. Below is the alternative approach to access your SQL data:

• Create a backup of your SQL tables
• Store the backup in Amazon S3
• Utilize the Amazon S3 connector to access your data in Amazon Q Business