UWSDB Configuration
Description
UWSDB is a relational database which is a snapshot of the student data meant for Ad Hoc research. It is not meant to be a direct data source for high-demand, high-availability applications. (If you need data on a 24x7, high availability basis, please contact Data Management to discuss options.) It is hosted on the SQL 2005 server SDBSQLC1DB1.
Changes from siriussql:
Upgrade from SQL2000 to SQL2005
New system architecture that utilizes both mirroring and snapshots
SQL accounts eliminated, replaced by Managed NETID accounts
These pages describe the steps necessary for configuring either the Microsoft SQL Client Tools or Microsoft Access to access UWSDB, as well as providing some basic pointers to help you start using the UWSDB data source.
To continue, please select the client you
will be using to access UWSDB:
Other user resources
Security
Be sure to keep your systems secure. Both application security and operating system security must be addressed. Free automated and semi-automated security tools are available at the following sites:
Microsoft Windows:
Microsoft SQL Server:
Note: Failure to maintain up-to-date security on your SQL Server installation may cause UWSDB to refuse your connection.
Microsoft Office:
http://office.microsoft.com/officeupdate/
UW Computing:
http://www.washington.edu/computing/security/update.html
System Availability
Please note that UWSDB is basically now a 24x7 data source.
UWSDB is unavailable for use:
Usually
Usually
Note: snapshot is taken on a stable system mirror so may be retried every 10 minutes for up to four tries.
Troubleshooting / FAQ’s
Having trouble connecting to UWSDB? Check the list of questions below.
- I’m
having trouble connecting from off-campus.
What’s wrong?
- The
UWSDB does not support all forms of connection from off-campus. We recommend the Remote Desktop client
for off-campus access to UWSDB.
Office of Data Management
reptreq@u.washington.edu
Last revised: