So I have been working on a few projects of late so explain why I haven't been blogging much, I know same old excuess well
well one of the problems I have been having is using the .net login system, but i have found the soution, create the database you want to use for your application database. next run
c:\windows\microsoft .net\framework\2.456\aspnet_sqlreg.exe
select the database server (don't forget if its an express server then you need to put the \SQLExpress after the host name of the machine the database is on unless its the local host then its just a . before the \. select the database you created and follow the wizard. afterward open your web.config and put these lines in the connectionStrings Section and your up and running.
then your up and running, Microsoft don't seem to have documented this hack and it took me a while to find it myself so I hope others find it useful and I will know where to find it when I need it ;)
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=home-srv04\SQLEXPRESS;Initial Catalog =commerce;Integrated Security=True"
providerName="System.Data.SqlClient" />
<add name="commerceConnectionString" connectionString="Data Source=Home-srv04\SQLExpress;Initial Catalog=commerce;Integrated Security=True"
providerName="System.Data.SqlClient" />
2 comments:
That's the kind of .NET pain I was enjoying the .NET evaluation team going though. :)
yeah but once you have got that little bit working what actually only took me about 2 hours to work out, everything else is done for you. roles membership security, even the login box and create user applets at done for you to intergrate into your page. think how much time that will save me coding long term. more than 2 hours i bet lol
Post a Comment