Unable connect to SQL server 2008

• noth50

  Newbie

  Points: 3

  More actions

  June 6, 2015 at 5:39 am

  #318756

  I have a c# project with SQL Server 2008 R2 and the project runs with no problem in local and I publish it to the server Win2008 R2. But the project doesn't work and can't connect to the server with no error. All the database setting check and I enabled TCP/IP setting and etc. But still not worked. I think the problem is with connection string that is below.

  When pages going to connect to the database, nothing happend in browser and browser stick in loading mode (waiting for respond).

  Connection String In My Computer

  public static string ConnectionString = "Data Source =(Local);Initial Catalog=Bulk;Integrated Security=True;Timeout=0;Max Pool Size=5000;";

  Connection String In Windows Server

  public static string ConnectionString = "Data Source=My Ip Windows Server,1433;Network Library=DBMSSOCN;Initial Catalog=Bulk;User ID=administrator;Password=My Windows Login Pass;Timeout=0;Max Pool Size=5000;";

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  June 7, 2015 at 10:32 am

  #1803544

  did you do any test connectivity ? does it work?

  Thanks.