Hi, SQL Express is not supported here but you can use the Attach feature to bring a SQL Express DB on-line. First requirement will be for you to add SQL Server 2005 or 2008 to your account. Once you do the connection string for your account will be listed in the SQL Server Control Panel area. Then in your web.config replace your local DB with the remote string provided. If after you add a SQL Server account you still have trouble repost if you need more help. Salute, Mark Technical Evangelist for DiscountASP.NET http://www.iis7test.com/webcasts/ http://weblogs.asp.net/markwisecarver/ http://blogs.windowsclient.net/wisecarver/default.aspx (Microsoft IT Usability http://msitusability.multiply.com/)
Hi Mark Thank you for the response. Yes I understand that SQL Express is not supported and this is what makes it such a mystery to me. I have added SQL Server2008 to my account, uploadeddata from my PC and can connect to the account via my local machine app. via a connection stringin my web.config file. So, I have already set up as you suggested, and still the same 'The connection name 'LocalSqlServer' was not found' I do appreciate your assistance. Thank You very much for your time Patrick
Hi, OK..You don't have to change the wording in that section. Just update your web.config connection area so it looks like this, but with your accounts actual info:
Hi All</o> After many hours of searching and study I remain baffled by this error message. Can anyone please help shed some light for me please.</o> *****************************</o> Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty. Source Error: </o><profile></o> <providers></o> <add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/></o></providers></o> </profile></o> </o> Source File: C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\machine.config </o> </o> *******************************</o> The app I?m trying to make happen works fine on my PC, this error is coming from my service provider.</o> I developed the app using VWD with SQLEXPRESS version 2008.</o> I?m running from a file directory where discountAsp.net's machine is IIS7 which I know nothing about (unfortunately)</o> Mydiscountasp.net has given me a connection string that works from my local PC Any help will be appreciated
Still the problem is not solved. I adding in the appsettings and connectionstrings the Clear and remove name="LocalSqlServer". Still the error is shown like before. Is there some idea what I can do? Thank you for your time