April 2, 2003 at 7:18 am
I had to reinstall IIS because out of nowhere I was getting a Server Application Error on my local Win2000 Prof box when trying to connect to a SQL2000 database in the webbrowser using ASP.
Now the previous error is gone but now the SQL permissions do not allow the IUSR account to access the database. I have checked all the permissions in SQL and all appears to be ok.
Now what? I still get a login error in the browser for SQL!!!!!!!!
Alex Polajenko
Alex Polajenko
April 2, 2003 at 7:35 am
Try sp_grantlogin 'NT AUTHORITY\ANONYMOUS LOGON' to access your SQL Server and assign proper permissions to it.
April 2, 2003 at 7:39 am
quote:
Try sp_grantlogin 'NT AUTHORITY\ANONYMOUS LOGON' to access your SQL Server and assign proper permissions to it.
yes thanks that is what I did and it works.
Alex Polajenko
Alex Polajenko
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply