# Conn to MS SQL Express **URL:** \ **Category:** Classic Servoy\ **Created:** [August 4, 2008, 8:58am UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403 "2008-08-04T08:58:06Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [August 4, 2008, 8:58am UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/1 "2008-08-04T08:58:06Z")
Hi Folks Just playing with Servoy connecting to MS SQL for the first time (been using iA previously) and am having some connection difficulties. Here is my string: jdbc:jtds:sqlserver://HPSPAIN\SQLEXPRESS\Databases/tci\_excorr EDIT: Looks like my syntax was wrong - changed to: jdbc:jtds:sqlserver://HPSPAIN/SQLEXPRESS/Databases/tci\_excorr Was getting the ‘Unknown Server’ error, but now getting a connection time-out error? I’ve the TCIPP Port configured and the IPALL port set and active. What am I missing here? ---
**Author:** ![lvostinar](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lvostinar/32/5248_2.png) [@lvostinar](https://forum.servoy.com/u/lvostinar)\ **Post date:** [August 4, 2008, 2:22pm UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/2 "2008-08-04T14:22:18Z")
I connected to MS SQL Server Express edition using the url jdbc: sqlserver://localhost\SQLEXPRESS:1443;DatabaseName=mydb;SelectMethod=cursor . There were some changes that had to be done: download another jdbc driver and copy it to drivers directory ( in combo then select: com.microsoft.sqlserver.jdbc.SQLServerDriver); use sql authentication not windows one; enable tcp/ip protocol and configure port to 1443. This is some stuff I remember now, maybe I did others as well. Maybe these can give you a clue about what to do ? ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [August 4, 2008, 5:24pm UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/3 "2008-08-04T17:24:02Z")
> lvostinar: > I connected to MS SQL Server Express edition using the url jdbc: sqlserver://localhost\SQLEXPRESS:1443;DatabaseName=mydb;SelectMethod=cursor . There were some changes that had to be done: download another jdbc driver and copy it to drivers directory ( in combo then select: com.microsoft.sqlserver.jdbc.SQLServerDriver); use sql authentication not windows one; enable tcp/ip protocol and configure port to 1443. This is some stuff I remember now, maybe I did others as well. Maybe these can give you a clue about what to do ? Vostinar - thanks for that feedback I’m using windows authentication at the moment - but since the sql server is not running on the same PC I cant use localhost to connect. I think thats the problem. And I want to use the jTDC driver! Any other comments? ---
**Author:** ![lvostinar](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lvostinar/32/5248_2.png) [@lvostinar](https://forum.servoy.com/u/lvostinar)\ **Post date:** [August 5, 2008, 8:10am UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/4 "2008-08-05T08:10:56Z")
Ok, I tried with jtds driver in 4.0 and it was working using the url: jdbc:jtds:sqlserver://LAU:1443/mydb . Port is configured to 1443 ( not dynamic); TCP/IP enabled and sql authentication. ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [August 5, 2008, 12:33pm UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/5 "2008-08-05T12:33:31Z")
> lvostinar: > Ok, I tried with jtds driver in 4.0 and it was working using the url: jdbc:jtds:sqlserver://LAU:1443/mydb . Port is configured to 1443 ( not dynamic); TCP/IP enabled and sql authentication. Ivostinar I tried this: jdbc:jtds:sqlserver://HPSpain/SQLEXPRESS:1443/Databases/tci\_excorr which should be the equivalent of what your string does and get the same connection time-out! Is LAU the name of the PC on which your sqlserver is running or the name of your SQLServer? ---
**Author:** ![lvostinar](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lvostinar/32/5248_2.png) [@lvostinar](https://forum.servoy.com/u/lvostinar)\ **Post date:** [August 5, 2008, 12:57pm UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/6 "2008-08-05T12:57:57Z")
Lau is the name of the computer ( which is actually localhost); the catch was that SQLEXPRESS is not needed in the url even if i have sql server express 2005 , until I removed that string, it didn’t work. Also I think that sql authentication must be used ( if windows authentication a dll must be in the system path). ---
**Author:** ![Kahuna](https://avatars.discourse-cdn.com/v4/letter/k/8491ac/32.png) [@Kahuna](https://forum.servoy.com/u/Kahuna)\ **Post date:** [August 6, 2008, 9:44am UTC](https://forum.servoy.com/t/conn-to-ms-sql-express/9403/7 "2008-08-06T09:44:13Z")
> lvostinar: > Lau is the name of the computer ( which is actually localhost); the catch was that SQLEXPRESS is not needed in the url even if i have sql server express 2005 , until I removed that string, it didn’t work. Also I think that sql authentication must be used ( if windows authentication a dll must be in the system path). Ivostinar - thanks for all the feedback - still couldn’t get comm’s over the network - so for experimental purposes - I installed Servoy on the same PC as the SQL SERVER and got up and running instantly. I still need to work on getting networked access from Servoy but that can come later. At least I can start developing with a production-database ‘copy’ now and see what we can generate!