<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Security</title><link>http://forums.asp.net/25.aspx</link><description>All about ASP.NET security (authentication, authorization, membership, roles, etc.) and the Login controls. &lt;a href="http://aspadvice.com/SignUp/list.aspx?l=24&amp;c=17" target="_blank"&gt;Email List&lt;/a&gt;</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP1 (Build: 20510.895)</generator><item><title>Re: Create membership db on a remote server...</title><link>http://forums.asp.net/thread/2490860.aspx</link><pubDate>Tue, 15 Jul 2008 14:49:23 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2490860</guid><dc:creator>alexey_kay</dc:creator><slash:comments>0</slash:comments><comments>http://forums.asp.net/thread/2490860.aspx</comments><wfw:commentRss>http://forums.asp.net/commentrss.aspx?SectionID=25&amp;PostID=2490860</wfw:commentRss><description>&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;&amp;nbsp;I had to connect to a remote server so was not sure how to do that. Thanks for the article - great help! At first was not able to run the Aspnet_regsql.exe&amp;nbsp;(I have discovered that I have SQL server on my work laptop!!!) remotely, only to realize that I was behind the firewall. So I contacted them, and they allowed my ip to connect, after that it was all sweeeeeeeeet. &lt;/p&gt;
&lt;p&gt;With a bit&amp;nbsp;of playing around it&amp;nbsp;all worked out. Thanks for your help, trully.&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp; &amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;remove name=&amp;quot;LocalSqlServer&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name=&amp;quot;LocalSqlServer&amp;quot; connectionString=&amp;quot;Data Source=mssql1.openhost.net.nz;Initial Catalog=mydb;User ID=****;Password=****;&amp;quot;&amp;nbsp; providerName=&amp;quot;System.Data.SqlClient&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;br /&gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Cheers,&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;Alexi&lt;/p&gt;</description></item><item><title>Re: Create membership db on a remote server...</title><link>http://forums.asp.net/thread/2486428.aspx</link><pubDate>Sun, 13 Jul 2008 17:19:08 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2486428</guid><dc:creator>guru_sarkar</dc:creator><slash:comments>0</slash:comments><comments>http://forums.asp.net/thread/2486428.aspx</comments><wfw:commentRss>http://forums.asp.net/commentrss.aspx?SectionID=25&amp;PostID=2486428</wfw:commentRss><description>&lt;p&gt;did you actually have all tables for membership in your database ? &lt;/p&gt;&lt;p&gt;if not are you planning to use default aspnet membership schema ?? if yes .. check this how to do that .. http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx&lt;/p&gt;&lt;p&gt;if not do let know exactly what and how you are tyring to setup membership&amp;nbsp;&lt;/p&gt;</description></item><item><title>Create membership db on a remote server...</title><link>http://forums.asp.net/thread/2486335.aspx</link><pubDate>Sun, 13 Jul 2008 15:03:45 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2486335</guid><dc:creator>alexey_kay</dc:creator><slash:comments>0</slash:comments><comments>http://forums.asp.net/thread/2486335.aspx</comments><wfw:commentRss>http://forums.asp.net/commentrss.aspx?SectionID=25&amp;PostID=2486335</wfw:commentRss><description>&lt;p&gt;Hi, &lt;/p&gt;
&lt;p&gt;I&amp;#39;ve got my website working on my computer alright, at the stage of publishing it, but I can&amp;#39;t figure out how to create all the tables for memberships. I&amp;#39;ve turned off default membership connection, managed to write a connection string for the db that&amp;#39;s&amp;nbsp;got my custom tables, all is working fine... &lt;/p&gt;
&lt;p&gt;&amp;nbsp; &amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name=&amp;quot;mydbConnectionString&amp;quot; connectionString=&amp;quot;Data Source=mssql1.openhost.net.nz;Initial Catalog=mydb;User ID=****;Password=****;&amp;quot;&amp;nbsp; providerName=&amp;quot;System.Data.SqlClient&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;remove name=&amp;quot;LocalSqlServer&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;but need to enable membership and that&amp;#39;s just not working without the tables, esp. that I have allowAnonymous=&amp;quot;true&amp;quot;....&lt;/p&gt;
&lt;p&gt;I&amp;#39;m sure it&amp;#39;s pretty common, but would someone please point me to the right direction? I have access to MySQL&amp;nbsp;and Microsoft SQL Servers...&lt;/p&gt;
&lt;p&gt;Much appreciated,&lt;/p&gt;
&lt;p&gt;&amp;nbsp;Alexi&lt;/p&gt;</description></item></channel></rss>