Custom membership provider - help needed

[Guest]

I've been trying to use this "custom membership provider" stuff for several
days, and am totally lost.

I am building an ASP.NET (vb) application on a laptop. Then I copy the
files to a Win 2003 Server machine.

Just for testing I created a BLANK SQL Server 2000 database on the server
(its only purpose it to try out using the membership stuff). I ran the
aspnet_regsql thing and it created a bunch of tables and stored procedures
without errors. I added one tiny table with one field to make sure my
Enterprise Manager on my laptop could access the database. All fine.

Questions:

1. How to open the "ASP.NET configuration" on the **server**? When I open
it from Visual Studio it opens it on my laptop.

2. At this point I am so frustrated. Is there some way to **play** with
this ASP.NET configuration thing on the server while giving it COMPLETE AND
FULL PERMISSIONS to the database? I don't care if someone can hack my
system. It doesn't matter at all if someone can hose the server.

TIA

 

[PeterKellner]

Questions:

1. How to open the "ASP.NET configuration" on the **server**? When I open
it from Visual Studio it opens it on my laptop.

You need to make the Membership's server connection point at your
server, not your laptop. If you look at your machine.config, it has
all the default definitions for how membership ties to sqlserver.

The short answer, is add this to your web.config file with your
connection.

<connectionStrings>
<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data
Source=YOURSERVER;Initial Catalog=CAT;Persist Security Info=True;User
ID=whatever;Password=whateverpassword"
providerName="System.Data.SqlClient" />

2. At this point I am so frustrated. Is there some way to **play** with
this ASP.NET configuration thing on the server while giving it COMPLETE AND
FULL PERMISSIONS to the database? I don't care if someone can hack my
system. It doesn't matter at all if someone can hose the server.

not exactly sure what you have in mind here. Sorry.

TIA

Peter Kellner
http://peterkellner.net