SQL Server Express Connection Issue

• Jack C Wang

  Grasshopper

  Points: 11

  More actions

  October 21, 2009 at 6:52 am

  #212505

  Hi,

  I would appreciate if anyone can provide any suggestion to my simple issue. I was trying to set up SQL Server 2005 Express as a database server (connecting by a couple of computers). After many researches, I finally can connect to Express remotely from other computer via SSMS manually. However, if I was trying to connect it from my application. I got timeout error. In both approaches, I am using a new user account that I created on the server. Here is my connecting string:

  connstring="Server=EHRDBServer\SQLEXPRESS;database=EHRMS;UID=EHRApp;pwd=appsql;integrated security=true"

  I have gone through steps to set up Express to support remotely connection. I believe this must be a simple question and I just couldn't find the solution.

  Thanks for your times and comment.

  Jack Wang

• JacekO

  SSCertifiable

  Points: 6610

  More actions

  October 21, 2009 at 12:55 pm

  #1069060

  I think you have to remove 'integrated security=true' from your connection string.

  ---------------------------------------------
  [font="Verdana"]Nothing is impossible.
  It is just a matter of time and money.[/font]