March 28, 2008 at 5:05 am
Hoi,
I have made a connection with my database, but if I look in my website I get a error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'BUSO\IUSR_WEBSERVER'.
/login.asp, line 8
How can I lost this problem. I work with the windows authentication for login.
Thanks,
Dirk
(Sorry, my english is not so good)
March 28, 2008 at 6:27 am
If the web server is a different server than the SQL Server, then you can't. IUSR is a local account on the web server. When you get to the SQL Server, that account doesn't mean anything. There are several ways you can handle this.
1) If you are in a domain, use a domain account for the Anonymous logon to the web site. A system administrator should be able to help you set this up. Give that domain account the appropriate rights in SQL Server. [recommended]
2) Create an IUSR account on the SQL Server. Synchronize the password between the two servers. You will also have to go into IIS and everywhere IUSR is used, tell IIS not to synchronize the password. [not recommended]
3) Use a SQL Server based login. [preferred over #2, but not as good as #1]
K. Brian Kelley
@kbriankelley
March 28, 2008 at 7:27 am
Thank you for your comment.
The sql server and my IIS are on one machine. How can I configure a new account in sql server and give these primmisions
Thanks folks
March 28, 2008 at 7:58 am
In this case you'll need to add the login to SQL Server. If you're using SQL Server Management Studio, connect to your local server, expand the Security folder and right-click on the Logins folder. Choose New Login and when the dialog window comes up, enter BUSO\IUSR_WEBSERVER as the login name. You can then give that login the appropriate rights within the database by clicking on User Mapping, and putting a checkbox by the database the login needs access to. Once you do so, the database roles for that database will become available. These are the default database roles. You probably want to tailor your database security to something more stringent than any of these roles, but that's a different conversation.
K. Brian Kelley
@kbriankelley
March 28, 2008 at 8:24 am
thank you very much
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply