Scott Gutherie @ MS wrote a good article on how to create the ASPNETDB (enables membership, personalization, etc.) on MS SQL rather than SQL Express See weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx Enjoy /emoticons/tongue.gif Bruce DiscountASP.NET www.DiscountASP.NET
We have made a KB article for this process. See http://kb.discountasp.net/article.aspx?id=10413 Bruce DiscountASP.NET www.DiscountASP.NET
The above article help me finally succeed with the following example. Notice the <clear/> which was not mentioned but needed before I could connect. Also for some reason the Data Source I first had was sql2k502.discountasp.net/SQL2005 and I had to get rid of the /SQL2005 part of the address. The following connectionString example worked for me, of course some of your server and database name information will be differerent. <connectionStrings> <remove name="LocalSqlServer"/> <clear/> <add name="LocalSqlServer" connectionString="Data Source=sql2k502.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_215582_members;User ID=SQL2005_215582_members_user;Password=*********" providerName="System.Data.SqlClient"/> </connectionStrings>
