# SQL Server Express 2005 connection

**URL:** <https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171>\
**Category:** Archived Topics\
**Created:** [December 28, 2006, 7:11pm UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171 "2006-12-28T19:11:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [December 28, 2006, 7:11pm UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171/1 "2006-12-28T19:11:13Z")

</div>

If you use the [Express](http://www.microsoft.com/sql/editions/express/) (free) version of SQL Server 2005 you need to add the following connection string:

‘instance=SQLEXPRESS;’ under “Extra Connection Properties” of the FPMI Gateway datasource connection.

If you get an error message that the instance doesn’t exist on the database server check the following:

Make sure that named pipes and TCP/IP protocols are enabled:

Start / Programs / SQL Server 2005 / Computer Manager  
Open “Server Network Configuration”  
Highlight “Protocols for SQLEXPRESS”  
Right-click the Tcp node and make sure it is enabled (click “Enable” if it is available)

Start the SQL Browser service:  
Start / Run… / type “NET START SQLBROWSER” without the quotes and hit OK

taken from [here](http://www.aspfaq.com/sql2005/show.asp?id=3)

---

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [December 28, 2006, 7:16pm UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171/2 "2006-12-28T19:16:04Z")

</div>

Also consider allowing SQL Server and Windows authentication for database access instead of the default Windows authentication.

Verify that the “SQL Server Browser” and (possibly) the “SQL Server Active Directory Helper” services are running.

Details can be found [here](http://www.inductiveautomation.com/forum/viewtopic.php?p=1742)

This authentication is only relevant to the service running FactorySQL or FactoryPMI - it does not relate to your users security credentials.

---

<div class="post-metadata">

**Author:** ![bluefrog](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\
**Post date:** [June 11, 2010, 7:28am UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171/3 "2010-06-11T07:28:57Z")

</div>

hi, I started learning Factory PMI just two days age. Everything was fine until I try to connect to MS SQL 2005 Express Edition that is installed in the same computer with FactoryPMI. I did everything according to your post but I still got the error message. The error message is here…

Datasource ‘test’ FAIL (next test in 8 seconds)  
Message: (hide details)

I/O Error: DB server closed connection.

Details:  
SQLException  
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2277)  
net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:599)  
net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:331)  
net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)  
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)  
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)  
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)  
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)  
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)  
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)  
com.inductiveautomation.factorypmi.gateway.db.DatasourceManager$DSInfo.runTest(DatasourceManager.java:631)  
com.inductiveautomation.factorypmi.gateway.db.DatasourceManager$FaultedDatasourceRetryer.run(DatasourceManager.java:468)  
java.lang.Thread.run(Unknown Source)

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [June 11, 2010, 3:25pm UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171/4 "2010-06-11T15:25:10Z")

</div>

Try adding`ssl=request `to the extra connection parameters for that connection.

---

<div class="post-metadata">

**Author:** ![bluefrog](https://avatars.discourse-cdn.com/v4/letter/b/a6a055/32.png) [@bluefrog](https://forum.inductiveautomation.com/u/bluefrog)\
**Post date:** [June 15, 2010, 1:38am UTC](https://forum.inductiveautomation.com/t/sql-server-express-2005-connection/171/5 "2010-06-15T01:38:02Z")

</div>

Thanks a lot. I can solve my problem with your help. Thank you so much. 😃😃
