Step 1. Define a New SQL Server Database

The tutorial package will deploy the application files and data and set up a new SQL database. If your deployment is using tables in an existing database, you can skip Step 1.

To complete this step, you must have SQL Server Management Studio installed.

1.  Open SQL Server Management and connect to the database server service:

https://docs.lansa.com/14/en/lansa022/content/resources/images/lansa/step%201%20define%20a%20new%20sql%20server%20database1.png

     You'll need to use SQL Server Management Studio 17 (64bit) for the latest version of Visual LANSA. All the steps to be followed, are as shown here.

2.  Expand the Database group, so you are aware what database names have already been used.

https://docs.lansa.com/14/en/lansa022/content/resources/images/lansa/step%201%20define%20a%20new%20sql%20server%20database1_1.png

3.  Right click on Database and select New Database from the context menu.

4.  Enter any suitable name for the new database:

https://docs.lansa.com/14/en/lansa022/content/resources/images/lansa/step%201%20define%20a%20new%20sql%20server%20database1_2.png

5.  Click OK to create the new database, using the default configuration.

     Note: The Visual LANSA install configures the SQL Server database service, to use Integrated Windows Authentication.