Login failed for user 'DIEVECHNOLOGY\ASPNET'. URGENT !! [resolved]
VB Code:
connectionString = "Server=SQLOLEDB.1; Data Source=(local); " & _
"Database=WAPClinic; Trusted_Connection=yes"
i don't know why is this happen. previous can log in like normal. but suddenly giv me this kind of error. anyone help? quite urgent.
Re: Login failed for user 'DIEVECHNOLOGY\ASPNET'. URGENT !!
Since you haven't specified a Username and Password in your connectionstring the application is trying to connect to the database with default ASPNET user account of your machine.
This account obviously isn't setup as a user on the database.
So you either need to allow Windows Authentication in your SQL Server, or create a new Login (Username/Password) within SQL Server and then use that Username/Password in your connectionstring to connect to the database.