Robot framework - Connect SQL DB

1) To connect to DB, you need to check some below information

• SQL Server is running

• SQL Server does not exist or unavailable

• Remote connection is disabled for SQL instance

• Port is not added in the firewall exception list

• IP address of the instance is blocked

==> https://www.sqlserverlogexplorer.com/database-does-not-exist-access-denied/

2) Using DatabaseLibrary to connect DB

Connect to SQL

| Connect To Database | pyodbc| my_db | postgres | s3cr3t | tiger.foobar.com | 1433

Please make sure the information of dbapiModuleName (postgres or SQL) and its port

https://franz-see.github.io/Robotframework-Database-Library/api/0.5/DatabaseLibrary.html

How to check port used by SQL Server

Full Tutorial of Microsoft SQL Server Ports - Devart Blog

The default ports used by SQL Server

https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16