create aspnet user in Sql server 2005

[AlaQunaibi]

Hi All,

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

[KJones]

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.

[kenobewan]

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.

[sephoratrading]

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.