SQL Server access - login fails

[Rajya]

Hi

I am using SQL Server 2000 with ASP.NET (in VS.NET).
How do I implement login / access to the database server?

As I am developing on W2k, I am using Trusted Connection & have created a new Login in SQl Server (\Logins) for the user MYPC/ASPNET.

Its working on my dev machine, but when I copied the entire Solution to another W2k dev machine, login failed even after I created a Login for the ..\ASPNET user in SQL Server.

I know what I am doing is not the right way - how do I configure it all between ASP.NET & SQL Server?

TIA

 

[levyuk]

You might want to have a look at ASP.net 2 Beta. There are much easier ways of creating logins with ASP.net 2 Beta. I know it's only in beta right now but it should be released soon, or so I read somewhere.

 

[Rajya]

Thanks for the ASP.NET 2 Beta info - where can I obtain a copy?

Meanwhile, I stumbled across this article - basically, it confirmed as to what I had been implementing so long -

HOW TO: Configure SQL Server Security for .NET Applications (
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B815154)

Thanks

 

[levyuk]

This is where you can download Visual Web Developer 2005 Beta 2
http://lab.msdn.microsoft.com/express/vwd/

You will need to download the .net framework 2.0 for it to work. Although it might get installed when you install VWD

And here are some nice tutorials on getting started.
http://beta.asp.net/guidedtour2/default.aspx