Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server Express Connection Issue Expand / Collapse
Posted Wednesday, October 21, 2009 6:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 25, 2010 12:03 PM
Points: 1, Visits: 10

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
Post #806446
Posted Wednesday, October 21, 2009 12:55 PM


Group: General Forum Members
Last Login: Tuesday, March 29, 2011 2:59 PM
Points: 473, Visits: 606
I think you have to remove 'integrated security=true' from your connection string.

Nothing is impossible.
It is just a matter of time and money.
Post #806733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse