the web front-end for your database

SQL Server Connectivity

Microsoft SQL Server connectivity will be the easiest to setup because most servers and workstations will already have all the components installed to connect to any of the current Microsoft SQL server versions.

Likely the hardest thing will be to find out the {server}\{service} name for the SQL server that you are interested in connecting to.  Some examples will be provided below.

Driver Installation

All current server and workstation versions of Microsoft Windows should have the necessary drivers preinstalled.

Database Connections

The instructions below are for SQL server installs that are using the standard protocols and ports.  If your DBA or Network Admin have choosen alternate settings then you will need to talk to them to figure out how to connect to the server.   Default setups for SQL server use the following settings:

  • Protocols: Named Pipes or TCP/IP
  • Port: 1433

SQL Server Authentication Required

To connect to SQL Server you need to use SQL Server Authentication and so your SQL Server must be setup in "Mixed Mode" to permit SQL Server Authentication based connections.

For details on setting up SQL Server Authentication please see:

Default Instances

If you are connecting to a default instance of SQL server installed on a server or workstation, then you can simply use the name of the server itself.  So if the server is named "Fred", then you simply need to enter the name "Fred".  If you are not able to use the server name then you could also use the IP address.  The IP address might be used if the server is hosted at a remote site or in an area where name resolution is not setup or reliable.

Named Instances

A named instance of SQLServer would be accessed by specifying the servername followed by a slash followed by the name of the instance.   For example an instance named "HR" on a server named "Fred" would be accessed by "Fred\HR"

SQL Server Express

A default install of SQL Server Express will be installed as a special instance usually named as "SQLExpress".  To access a instance of SQL Server Express on the local computer you will specify a server name of ".\SQLExpress".  If the express instance is hosted on a server named "Fred", then you would enter "Fred\SQLExpress".

Trouble Shooting

  • Can't connect via Windows Authentication
    The connection to SQL server must be made via SQL Server Authentication.  Once the connection has been established then users will be able to login to dbFront with their windows credentials and access the database.  For more details see above.

Next Step

The next step would be to proceed to connecting to a database and starting the setup of a web application.

Content you want the user to see goes here.
close