current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
stack overflow careers
Sign up ×
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them, it only takes a minute:
up vote 0 down vote favorite

I have installed instances of both SQL Express and SQL Developers edition. I have installed my customer DB on SQL Developers Edtion using LINQ to Entities. I migrated tfro SQL Express as I was having a problem with SQL Express and a n-tier application(3 projects).

I am ready to add in my membership provider (both membership and role provider) for my application but I want to be sure it is created using SQL Developers Edition. How do I create the provider?

Also, being such a newbie, I need help in creating the CONNECTION STRING for my ASPNETDB.mdb database.

Thanks in advance!

share|improve this question
    
here is a nice video you can reference as well which can explain how to create your membership provider hope this helps asp.net/web-forms/videos/how-do-i/… if you are looking to do something with Users/Groups there are some scripts that have to be run against the ASPNETDB.mdb I did this 8 months ago but wish i had those storedprocedures to paste for you to run.. setting it up is fairly easy too.. – MethodMan Jan 4 '12 at 18:50
    
Take a look at this link as well msdn.microsoft.com/en-us/library/ms229862(VS.80).aspx is any of this helping you..?? – MethodMan Jan 4 '12 at 19:05
    
I'm at work right now and this is a personal project -- hope to work on it tonight. If it takes some time to accomplish, as it appears, it may have to wait for the weekend. Many THANKS! – Susan Jan 4 '12 at 20:41
    
it doesn't take that much time actually.. if you have any issues please feel free to msg back here and I am sure that someone or myself would be more than happy to help you out.. – MethodMan Jan 4 '12 at 20:44
    
HI DJ ... I just looked at the tutorial on creating a custom membership provider, but I'm really uncertain about some of the steps (I'm such a newbie!) Would you be willing to schedule a time to chat? If so, when might you be available this weekend? – Susan Jan 7 '12 at 14:55

1 Answer 1

up vote 0 down vote accepted

if you want to use a Trusted Connection use something like this.. I would recommend porting these values to a web.config or app.config file too if I were in a .config file it would look something like this

<appSettings>
<add key="strConnectionString" value="Data Source=YourDomain\ServerName;
    Initial Catalog=yourDatabaseNameP;User ID=YourUser;Trusted_Connection=yes"/>
</appSettings>

// .NET DataProvider -- Trusted Connection  

using System.Data.SqlClient;

SqlConnection conn = new SqlConnection();
conn.ConnectionString = 
              "Data Source=ServerName;" + 
              "Initial Catalog=DataBaseName;" + 
              "Integrated Security=SSPI;"; 
conn.Open();

or 

// .NET DataProvider -- Standard Connection  

using System.Data.SqlClient;

SqlConnection conn = new SqlDbConnection();
conn.ConnectionString = 
              "Data Source=ServerName;" + 
              "Initial Catalog=DataBaseName;" + 
              "User id=UserName;" + 
              "Password=Secret;"; //change to fit your case
conn.Open();
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.