469,964 Members | 1,723 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

create aspnet user in Sql server 2005

Hi All,

Can anyone help me to create ASpNet user in Sql server 2005?
Oct 1 '06 #1
3 4932
KJones
1
Hi All,

Can anyone help me to create ASpNet user in Sql server 2005?

Did you ever get a response to this post? I am facing the same issue and would like to know how the ASPNET user should be created in SQLServer 2005. I created a User named ASPNET and associated it with a LOGIN name (PIC USERS) that I had created for an established windows user group. My developers are all members of the PIC USERS user group. But they still cannot connect to SQLServer with their ASP applications.
Dec 15 '06 #2
kenobewan
4,871 Expert 4TB
Microsoft SQL Server 2005 services accounts and passwords are linked to Microsoft Windows user accounts and passwords. Changes in one location may require changes in the other - Microsoft library 143746

Hope that this helps.
Dec 16 '06 #3
Actually, if I am understanding you correctly, kenobewan, SQL Server 2005 has the option of using Windows Authentication, SQL Server authentication or mixed mode. I use mixed mode which I believe is the default which accepts valid windows logon credentials as well as SQL Server Logins created specifically for the DB server. I find that using SQL Server login credentials is usually the preferred method in order to maintain scalability and portability so that your database installation is not dependent on the machine credentials. I don't understand why you would need an ASPNET user. The best way to connect to a database is to specify a connection string in which you can set the credentials to login with.

Thus I would create a user for your application "ASPNETAppDBUser" with a password you choose and give that the necessary database permissions. Then add that to the connection string you are calling in the web.config file and all should be good using that connection string to open connections.
Apr 25 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by SK | last post: by
reply views Thread by CESAR DE LA TORRE [MVP] | last post: by
16 posts views Thread by Mich | last post: by
2 posts views Thread by SpaceMarine | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.