I have a strange problem here. I have my development computer with IIS
installed, and we have a SQL server as well on a windows 2000 server. both
are members of a domain. I have restricted access to my web app using NTFS
ACL's and have disabled anonymous logon and enabled windows authentication.
So when a user logons on to a computer and they use there web browser, they
are not prompted to logon to the intranet web app I am building. All seems
to work except for Database Access. When any user logs onto my development
computer, they have no trouble getting database access (which is located on
another computer), but when they log into any other computer, they do not
have database access. in my code, I specify the connection string to use
trusted connections so it uses there current credentials. When a user is
logged into another computer and views a page that access's the database I
get the error, "NT AUTHORITY\ANONYMOUS LOGON DENIED" however, the user is
logged on, and if I display there logon with this command :
User.Identity.Name
it definitly shows the user is logged on the web site with there curent
credintials. Am I missing something here in the code? here is my code by the
way( not that the code is the problem because I am not really doing
anything, just trying to connect)
SqlConnection conPubs = new
SqlConnection("Trusted_connection=yes;Server=mysql server;Database=mydatabase");
SqlCommand cmdSql;
SqlDataReader dtrUsers;
cmdSql = new SqlCommand("SELECT * FROM Users, conPubs);
conPubs.Open();
dtrUsers = cmdSql.ExecuteReader();
