Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with MSSQL Server.
Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on
go to the marked icon in the image below, referring to “New Connection”.
Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the
MSSQL Server image.
Step 3: On the following image, place the required information:
Connection Name - Define the name of your new connection.
DBMS Driver - Allows you to define the driver that’ll be used, by default it’s Native SRV PDO,
Native SRV ,
MSSQL Server ou ODBC.
Test Connection - Validates the connection and informs if it was successful or not.
Server/Host (Name or IP) -Inform the server IP or name where the database is installed.
Database Name - Enter the MySQL database instance name.
Username - Enter a valid database user name. If you are connecting with a remote database
server, check if the database user has remote access.
Password - Enter the valid password.
For more details on configuring the connection of the database click on Advanced
Decimal Separator - Select the type of separator, between coma and period.
Persistent Connection - Persistent connections are connections that don’t close after running
Use the schema before the table name - Allows the use of schemas before the table names.
Filter - Clicking on this tab, the following page will appear:
Show - Allows to show Tables, Views, System Tables and Procedures.
Searches - Allows to define which tables and owners will be shown.
Step 4: Always test your connection before saving, if the message “Connection Success” appears, then
save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password,
Database and Server/Host.