The first database that is ever built for a new installation of PHDwin must be created by a System Administrator. This creates additional System Databases required by PHDwin to manage user logins. As a result, creating the first database takes a bit longer than any subsequent databases.

To Log in and Create New Database

1.Double-click on the PHDwin icon on your desktop – This opens the login window. Note that your build version may be different from the one shown below.

2.Choose the server instance by clicking on the button to browse for a server/instance of SQL.

a.Note: If you did the bundled install, the name of the instance should be “PHDWIN”. If you did a custom install and did not name the instance during install, the default instance name should be “SQLEXPRESS”.

3.You can validate your login by either checking the box to use your Windows Authentication credentials (recommended) or by typing in the SQL Server Username and Password that was created for you.

4.If you are logging in to an instance of SQL with no PHDwin databases, type in the name of a new database next to the input box and click Create.

5.If you are logging in to an instance that already has PHDwin databases, choose <Add New Database> from the Database drop-down menu, type in the name, and click Create.

PHDwin Database Names

When creating a database through the PHDwin interface, spaces are converted to underscores. Also, when looking at the database through SQL Server Management Studio, notice that all databases begin with “Phd_”. This is how the application filters the list of available databases when opening an existing database.

SQL also has a few rules for naming of databases that you should be aware of when creating new PHDwin databases:

·names cannot contain any spaces – though these are automatically converted to underscores by PHDwin.

·names cannot contain any non-alphanumeric character.

·names should avoid using any @SQL reserved words.