SQL Server access - login fails

Rajya

Member
Joined
Apr 15, 2005
Messages
22
Location
Calcutta, India
Programming Experience
1-3
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

Well-known member
Joined
Jun 7, 2004
Messages
313
Location
Wales, UK
Programming Experience
3-5
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.
 
Top Bottom