I am working on a site for a friend which requires me to jump through some hoops. One of which is using a windows server that isn't mine and I don't have any direct control of.
I am installing a Web Calendar program that I picked up sourceforge, but am having some issues with the following error.
[quote]
Error:
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'SEBASTIAN\IUSR_SEBASTIAN'., SQL state 28000 in SQLConnect in E:\Inetpub\freefryroot\wc\includes\php-dbi.php on line 167 WebCalendar Error
Error connecting to database:
Unknown ODBC error
Error code 28000 is defined as
28000 Invalid authorization specification. The value specified for the argument UserName or the value specified for the argument Authentication violated restrictions defined by the data source.
Settings look like this:
database settings see notes above
db_type: odbc
db_host: freefry
db_login: <user>
db_password: <pass>
db_database: freefry
db_persistent: true
[/quote]
I am not that big into windows MSSQL/PHP/Web Development stuff. I try to stick to *nix and this is really throwing me for a loop.
The settings file comments say to set the db_host as the DSN which it is. I have the user and password in there but for obvious reasons they have been omited from this post.
Now, I don't know, does the server admin have to give some level of permisions to the IUSR_* account so that it has basic access to the MSSQL daemon?
If anyone has any experience with this problem it would help me quite a bit and I thank you in advance for your time reading and responding to this post.
~Dk
