SkyServer.org - MySkyServer

MySkyServer is a small subset of the SDSS database that you can use for experimentation or to find out if you have all the necessary pieces in place to hold a larger copy. You will need a Windows Web server and a Microsoft SQL Server database server in order to install and run a personal SkyServer. Both of these can be the same physica server or be two different servers on a local network.

MyBestDR7 database

After the database is restored, create a login (SQL Server user, not Windows user) on that server for the user that the SkyServer Web interface will use to connect to the MyBestDR7 database. You can do this by opening the Security tab at the top level, right-clicking on Logins and selecting "New login...". Select SQL Server authentication for the user and create the userid and password that you will use in the last step below. Your SQL Server will need to be set up in Mixed Authentication Mode (SQL Server and Windows authentication).

In SQL Server Management Studio, open the MyBestDR7 tab, then open the Security tab, right-click on Users and select "New user" to create a user mapped to the login you just created, and set its default schema to "db_datareader".

Again, under the Security tab, open the Schemas tab. Right-click on Properties for the db_datareader schema, and then select Permissions from the menu on the left. Click on "Database permissions" on the right, and then select the entry for the user you created above. In the permissions listed below, click to turn on the following permissions: Select, Execute, Show Plan and View Definition. Click Ok to save all the changes.

SkyServer Web Interface

Once you follow all these steps, you should have a MySkyServer site that points to your own personal-sized subset of the SkyServer DR7 database.