I was trying to move my oracle database to SQL Server. The first thing I need to do is to create a database user. Here are the steps:
1. You need to enable SQL Server Authentication. The default of 2008 server is Windows Authentication. Restart SQL Server after making the change.
2. From SQL Server Management Studio, create a login and make sure uncheck asking user to change password and password will not expire.
3. Still in SQL Server Management Studio, select your database and add a new schema and a new user with the login you just created. Set the new schema as the default schema for your new user and give the new user dbowner permission role.
4. When preparing your url in Grails, remove the port number since it will not work with it.