Click to See Complete Forum and Search --> : Goin Nuts


Nate1
07-02-2007, 12:59 AM
Ive been trying to connect to a Database through the localhost for almost a week now, getting really frustrated, Ive read the readme files of both the MSDE and SQL Server. Installed both a number of times. Currently I have SQL Server 2000 installed with VS.NET 2003. I have the Database along with its tables showing up in the server explorer and enterprise manager, but the error has remained the same from the start:

Login failed for user 'Name\ASPNET'.

Ive looked at solutions for this over the net, and have made many changes with install settings and with User rights.

this is the connection string
Dim sConnectionString As String = "integrated security=SSPI;data source=NATHANCO-5AC28D;" _
& "initial catalog=Halloween;pwd=password"

Can someone please Help.