Usemssql

Follow the following steps to set up Flamingo4 using MS SQL server

SQL Server

1. Create a user (for example: flamingo)

2. Create a database owned by this user (for example, also named flamingo)

3. Run the following scripts (with the created user): create objects

Data

Constraints

Tomcat

4. Make sure you copy the sqljdbc4.jar to the <!TomcatDir>/lib dir

5. Setup the JNDI data source in the `GlobalNamingResources` in Tomcat server.xml as follows

<Resource name="jdbc/geo_viewer"
    auth="Container"
    type="javax.sql.DataSource"
    username="<<USERNAME>>"
    password="<<PASSWORD>>"
    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://<<HOST>>;database=<<DATABASE_NAME>>;integratedSecurity=false;"
    maxActive="40"
    validationQuery="select 1"
    timeBetweenEvictionRunsMillis="30000"
    minEvictableIdleTimeMillis="5000" />	

Make sure to add the `<Resource>` element as child of the already existing `<GlobalNamingResources>` element.

6. Because the persistence classes are not yet ready for MS-SQL server copy the file (and replace): [attachment:viewer-config-persistence.zip] in the dirs:

<!TomcatDir>/webapps/viewer/WEB-INF/lib BR <!TomcatDir>/webapps/viewer-admin/WEB-INF/lib BR

7. Restart tomcat