Creating a new data source

You use the Create New Datasource page to create new data sources. Each data source corresponds to a Microsoft SQL Server database that you have created.

Before you create a data source in Server Admin, you must create an empty Microsoft SQL Server database and a SQL Server database user that has database administrator rights and 'bulk insert' rights. Ensure that the user has at least the fixed server role 'bulkadmin' assigned. Members of the bulkadmin role are allowed to execute the BULK INSERT statement, which is used when you create data sources, but they still must have the INSERT permission on the tables on which they wish to insert data.

To access the Create New Datasource page, click Create New on the Datasources page.

To create a new data source:

Enter a name with which to identify the data source in the Datasource name field.
In the Server field, enter the IP address of the machine on which SQL Server is located, followed by the port number that was specified in the TCP/IP pipes connection during initial setup of SQL Server. The IP address and port number must be separated by a comma and a space, for example 192.168.152.208, 1433. The port number is 1433 by default.
Enter the name of the SQL Server database that corresponds to the data source in the Database field.
Enter the user name and password of the SQL Server user you have created in the Username and Password fields.

Select the Show password check box if you want the password to be displayed as you type it, or clear this check box if you want it to be obscured.
Click Create. The data source is created, the appropriate tables are created within the SQL Server database and you return to the Data sources page, where a card appears for the new data source.

If the SQL Server database is not empty, you are asked to specify a different database.