Missouri State offers database services to University unit, organization, course, and personal web sites hosted on central servers. Sites are provided on an individual Microsoft SQL Server database for use in their web site. This service must be requested as it is not enabled by default.

A web site with database services may make use of the database in two different ways:

• HTML forms which store their results in a database
  This method is the easiest way to use a database in a web site. See database forms for more information.
• Custom script programming
  Web developers with programming knowledge may use ASP, ASP.NET, or PHP pages to access their database. University units and organizations using Web Press may develop web pages that use scripting in application development web sites.

Database Services Management System

Web developers using database forms may visit the Database Services Management System to make changes to tables, export records to Microsoft Excel, clear all records or see database information such as connection strings.

Advanced Services

Web developers who need direct access to their database should use Microsoft SQL Server Management Studio Express. This software is installed in the open-access computer labs. It can also be downloaded, installed and run on computers that are members of the SGF or WP domain.

Specific information for connecting, such as server name, can be obtained from the Database Services Management System.

For computers located off campus (with Microsoft SQL Server Management Studio Express installed), run this command:  
runas /netonly /user:SGF\privateID "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\ssmsee.exe"
Replace PrivateID with your private id (ex. abc123). You'll also need to use VPN software when making a connection.