SQL Server

I have recently received some data of SiteMinder Policies to manipulate. At the moment, it is just raw text dump that I have to wade through and extract some meaning. Trevor has given me his understanding of the conceptual objects within the files. I have will draw up the relationships with Visio and after more analysis, it has been decided that we will try to read in all the policy data and place it into a database. I have installed MS Sql server and created a server using Windows Authentication. I plan to read everything using Java. Tim mentioned that there may be some issues connecting to the database due to the authentication method. I am trying to use the SQLServerDataSource to connect. I think it assumes SQL Server Authentication as the norm. According to the Internet, Windows Authentication is based on Kerberos, and the only software I could find that assists in connection with was the The DataDirect Connect for JDBC SQL Server driver. It wants money. I’ve recently changed the Sql server to allow for SQL Server Authentication. After playing around with it with the normal SQL Server Authentication method with a user/password model, I have no problems logging in and updating my database. I just had to make sure the user I created had permissions to modify, drop etc.

The only issue with doing this is ensuring my tables are dropped at the end of every operation. On start up, I have to decrypt my files, load them into the database for queries. After I'm done, everything has to be removed and returned to its encrypted state.