Club site dependent on SQL Server? RSS

• • Reply
  

  EJM

  Member

  190 Points

  415 Posts

  Club site dependent on SQL Server?

  Oct 10, 2011 04:21 PM|LINK

  I have removed all the references to the SqlExpress in the web.config but as soon as take it off line the application breaks, ie login errors out with sql error.

  Thank you,

  EJM

  Software engineering is a team sport.
• • Reply
  

  Rajneesh Ver...

  All-Star

  38354 Points

  6989 Posts

  Re: Club site dependent on SQL Server?

  Oct 10, 2011 04:24 PM|LINK

  EJM

  I have removed all the references to the SqlExpress in the web.config but as soon as take it off line the application breaks, ie login errors out with sql error.

  May be they r using Sqldatasource in designer code?

  Rajneesh Verma's Blog
  www.rajneeshverma.com
  Keep Forums Clean || Use Alert Moderators.
• • Reply
  

  EJM

  Member

  190 Points

  415 Posts

  Re: Club site dependent on SQL Server?

  Oct 10, 2011 04:45 PM|LINK

  Rajneesh Verma

  May be they r using Sqldatasource in designer code?

  Thaks for your reply. I have looked at all the datasource declarations in my project and all look like this:

  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ClubSiteDB %>".... where the connection string is pointing to the webconfig's property, which is like this:

  <add name="ClubSiteDB" connectionString="Data Source=serverName;Initial Catalog=dataBaseName;User ID=****;Password=******;" providerName="System.Data.SqlClient"/>

  Thanks.

  EJM

  Software engineering is a team sport.
  • Edited by EJM on Oct 10, 2011 04:46 PM
• • Reply
  

  EJM

  Member

  190 Points

  415 Posts

  Re: Club site dependent on SQL Server?

  Oct 13, 2011 03:14 PM|LINK

  No one has any other suggestions?

  Software engineering is a team sport.
• • Reply
  

  aabruzzese

  Contributor

  2806 Points

  759 Posts

  Re: Club site dependent on SQL Server?

  Oct 24, 2011 04:07 PM|LINK

  From what I remember you would have to change your Connection string so you would no longer point to SQL Express but to a full blown SQL server.

  Should not be too difficult to tweak.

   

  AngeloA
• • Reply
  

  EJM

  Member

  190 Points

  415 Posts

  Re: Club site dependent on SQL Server?

  Dec 29, 2011 06:26 PM|LINK

  I forgot I had this posting. I figured out what was the issue. Missing this line in my web.confing.

  <remove name="LocalSqlServer"/>
  <add name="LocalSqlServer" connectionString="Data Source=,server name.;Initial Catalog=Club;User ID=<userid>;Password=<password>;" providerName="System.Data.SqlClient"/>

  Software engineering is a team sport.
  • Marked as answer by EJM on Dec 29, 2011 06:27 PM