Hi,
I am pretty new to asp.net programming, and I am running into some major problems.
I built a web form to accept basic information: Soc Sec, First Name, Last Name, etc.
From a book "Beginning ASP.net 3.5 in C# 2008" by Mathew Macdonald, I wrote some C# code to connect to a table I built in Sql 2005.
I have set up a drop down list to display the name of the patients in the table I built.
It is empty.
When I go to add a new patient, I get the error: "Error inserting record. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
Before I run the program I test the connection, and it passes.
"test connection succeeded"
When I go into my configurtation file and change the Integratted Security from SSPI to false, I get a different error.
The user is not associated with a trusted SQL Server connection.
Any suggestions?
Thanks
Paul