> For the complete documentation index, see [llms.txt](https://learn.capstorm.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learn.capstorm.com/reference/main-tab/sqlserver-connection.md).

# SQL/Server Connection

Prior to running CopyStorm for the first time, create a fresh SQL/Server database.

## SQL/Server Connection String

The only difficult part when copying Salesforce to SQL/Server is constructing the connection string. Clicking on the Connection String Builder will open a form that, if you are running SQL/Server using a standard configuration, will construct a connection string for you.

The connection string can be verified by pressing the “Test SQLServer Connection” button.

The general form of a SQL/Server connection string is:

* `[server-name[\instance-name][:port-number]][;property=value]*`

If you would like to see more information regarding SQL/Server connection strings or are not familiar with Microsoft’s type 4 JDBC driver, these resources may help:

* <https://docs.microsoft.com/en-us/previous-versions/sql/legacy/ms378428(v=sql.90)>
* <http://www.connectionstrings.com/>