niall29

what is wrong with this: Public strConn As String = "Data Source=Igloo;uid=Domain\User;pwd=password;Database=dbName;" Public Conn As New SqlConnection(strConn) every time it fails

Thanks. Now am I right in saying if I want to make a connection to a SQL server to pull a query I would just put the Username and password into the SQL connection string then. Instead of using SSPI because I dont want to give users rights to the Server

Ok Thanks I have found the problem with your help, So hopefully with your help again I will get a solution. I have impersonation ="true" userName ="Domain\ReportReader" password= "password" I thought it would keep the users ID until the page opened and then impersonate the user "ReportReader" but it takes the ID as soon as it opens hence why it never likes the ID no matter who logs in because ReportReader is not a member of the "IISGroup" Please can you help me to work round this.

I have impersonation on. Can you also tell me If I put: <allow roles="Domain\iisusers" /> <deny users ="*" /> Why does it give me the login in Msgbox but if I remove the <deny users ="*" /> or change it to <deny users ="?" /> it goes straight to the web page no matter if you are in the iisusers group or not.

Yes I did remove the " <deny users = "?" " and it didn't help

This is part of web.config file: <authorization> <allow roles="Domain\iisusers" /> <deny users ="?" /> </authorization> I tried changing the "?" to a "*" but when I do it gives me a log in form which I do not want.

No it's not a silly question but Yes I have it on. So thats not it

Hi I have a problem which I am sure somebody will think is a very easy question but I am having alot of trouble with it. I have created an intranet site and also a group in my Active directory called "issusers" and have written in my web.config file "allow roles =domain\iisusers" and I have only put 3 people in the list but my site is opening for everybody in the domain. Please can somebody hel pme understand what Im doing wrong. Thanks in advance

Incase any one else runs into this problem I think I finally found the answer after a week of looking. You can look up the answer at: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q247/9/31.ASP&NoWebContent=1

I must apologise for coming back with a problem but this time I think I can explain it alot better. I have my IIS set up Not to allow anonymous logon. I have authentication = windows and Impersonate = true in my web config I am using Integrated Security = SSPI in my SQL connection but my problem is if I use the computer that is the IIS and open the Web page then any comboboxes (which are filled from a SQL table) populate and everything goes great.and if I remain signed into the IIS and go to another computer in the same Domain and open the web page it still works perfectly but if I sign out of the IIS and open the page, none of the comboboxes populate and if I press the Search button which should connect to the DB I get a Login Failed for user NT Authority\ANONYMOUS LOGON error. I have done alot of searching on the net to try and find a fix for this. but have had no luck although alot of people seem to have run into the same problem. Please can anyone help me with this.