Connecting to a SQL Server Database

Make sure that the computer running SQL Server is accessible and that the database you want to connect to is available.

To connect to a SQL Server database

1. Click FileNewData Connection.
2. In the Create Spatial Data Source dialog box, select Autodesk FDO Provider for SQL Server and click OK.

   The Connection Editor is displayed to the right of the Site Explorer.

3. Enter the server to connect to.
4. Do one of the following:
   • If the database is set up to recognize them, select Use Map Server Credentials.
   • If the database requires them, select Use The Following Credentials and enter the userID and password.
5. Select the data store from the list.
6. Click Test Connection.

   You should see a Successful Connection message.

   
7. On the Autodesk Infrastructure Studio toolbar, click Save to store this connection resource in the repository.