SQL Server Setup The file DDNSDATA backup.BAK found in the SQL Data directory contains all the SQL Server Database information. You must create a blank database named DDNSDATA within SQL Server, and then run a restore on DDNSDATA backup.BAK to configure the DDNSDATA database.
(A) Create and Restore Database (B) Create a Login User. (A) Create and Restore Database Right click on your local SQL Server and then create a new Database. Enter DDNSDATA as the database name and click the OK button. Restore the file DDNSDATA backup.BAK to the DDNSDATA database you just created. "DDNSDATA backup.BAK can be found in the SQL Data directory, that accompanied this package" On the Restore screen select the From Device option , and click the Select Devices button. Click the add button, and then browse for DDNSDATA backup.BAK click ok to both dialogs that appear then apply to restore the database. (B) Create a Login User Check to ensure SQL Server allows both Windows authentication and SQL authentication. right click on your local server and click properties. Select the security Tab , and ensure that the Authentication option is set to both SQL and Windows. "This step may require a restart of SQL Server" Add A Login user for the DDNSDATA database. expand the DDNSDATA database and right click on the user field. Then choose new Login User. Select the Database owner checkbox, and then select the login user <new>. Select the SQL Authentication option, and enter a password and User Name, Then select the DDNSDATA database. Click OK to continue. You will be prompted to confirm the password and told the new user does not have rights to the database. choose no when asked to continue without access to the database. After clicking no to the continue without access prompt. Select the DDNSDATA database, and also selct the db_owner checkbox. Click Ok to finish.