- After the project has been successfully set up, find the Solution Explorer and right click on Shared Data Sources and choose Add New Data Source
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/271-1-1024x605.png)
- In the Shared Data Source Properties window, enter “Streamline” as the Name and choose Microsoft SQL Server for the Type
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/272-1024x743.png)
- Next, click on the Build button to create the data source
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/273-1024x743.png)
- In the Connection Properties window, enter your county’s SQL Server IP Address in the Server Name field (do NOT click on Refresh)
- Question – How do I know my county’s SQL Server IP Address for PROD and non PROD databases?
- Answer – Please contact CalMHSA to get this information
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/274-950x1024.png)
- Enter the user name and password for the SQL Server account previously requested from Streamline
- If the user name and password are correct, click on the Select or enter a database name field will display the list of databases that are available based on the permissions of the SQL Server user account
- Enter the user name and password for the SQL Server account previously requested from Streamline
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/275-1024x307.png)
- Click Test Connection to verify the connection is successful and click OK.
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/276-1024x948.png)
- In the Credentials window, you should see the user name and password in the Use this user name and password prompt to avoid re-entering the user name and password when previewing data. Click OK.
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/277-1024x744.png)
- Upon completion, there should be a new datasource called rds
![](https://2023.calmhsa.org/wp-content/uploads/2023/12/278-1024x583.png)