how to create ASPNET user in SQL Server 2000

[anystudent]

Respected Members, I have a question, when out aspx page is trying to access the SQL Server 2000 database than before this do we have to craete a user with the name of ASPNET in SQL Server 2000, or without creating this paticular user(its the default user of ASP.NET account) our aspx pages can also access the SQL Server 2000,I have already SQL Server 2000 running in "SQL Server Authentication Mode" so while crating the user do I have to create it in "Windows Authentication" or "SQL Server Authentication", can you provide some link where I could find complete steps for craeting the ASPNET user.

[Michael Sync]

You dont need to create ASPNET user in SQL Server. You can just use Windows Authentication to access SQL Server but dont forget to impersonate. In Web.Config, put the following line. identity impersonate="false" -- modified at 2:18 Monday 9th July, 2007

[anystudent]

Thanks Michael, but I am working in SQL Server authentication mode and I want to continue working in SQL Server authentication mode than whats the solution.

[Michael Sync]

Well, you can connect to SQL Server with sa account while you are using SQL Server Authenticatin Mode. If you wanna add ASPNET account or any other local account to SQL Server, plz follow the steps 1. Go to User. 2. Click "new user" 3. There is one combobox or textbox with button at the top of "New User" dialog. 4. then chose the local user account (eg: ASPNET) from this list... Hope it helps.

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)