MENU

Information Access

UMKC Information Services Information Access

Connection Information


Server: KC-CSRV-MSSQL1.kc.umkc.edu
Port: 1433
Version: 2008

Server: KC-CSRV-MSSQL2.kc.umkc.edu
Port: 1433
Version: 2008




Resource

Microsoft SQL Server FAQ

What is a Microsoft SQL Server database
    Microsoft Corporation is the software provider of the SQL Server Relational Database Management System (RDMBS). It is a very robust and solid option for storing and accessing data. Here at UMKC we have many RDBMS solutions including Oracle, MySQL, and FileMaker also available.
What version of SQL Server does UMKC have installed
    We have a number of servers with version 2008 as well as version 2012 installed.
We have a project which requires one or more database(s). Is a SQL Server database the best option for what we need
    There are many reasons why a given project will be best served by, or might require a SQL Server database. If the project is larger in scope and/or requires a lot of data transfers or reporting of data which resides on another SQL Server database, then SQL Server may be the best option. A big reason to use Microsoft SQL Server is that it is very well integrated into a Windows server environment. It is best to contact the Information Systems (IS) department so that we can discuss your project in detail and determine the best option together. We may even suggest that another database option might be better suited to the needs of your project.
We have determined that our department has a need for a SQL Server database. Who do I contact for that We received an email about our new SQL Server database. What do I do now
    You probably received information that you are now able to access a certain SQL Server database using your SSO credentials (or others) along with a more generically named account for accessing the database from another application. If you are working with a third party software vendor, then they will need the credentials of the generic account so that they can create the database objects that their software will need. Otherwise, contact the IS department or whoever you are working on the project with for the next steps.