Hi I'm a new user of Liberum, I have been struggling to start the installation. I'm running an SQL database (SQLEXPRESS 2005) with windows authentication, on a win 2008 R2 server (iis 7). When I launch setup.asp i get the below error....
Number: -2147467259 (0x80004005)Source: Microsoft OLE DB Provider for SQL ServerDescription: Cannot open database "HelpDesk" requested by the login. The login failed.--------------------------------------------------------------------------------
Any help/pointers would be greatly appreciated.
Regards and Thanks in advance
Try setting up a virtual folder under the IIS Web Site, set up an ODBC connection specifically for HelpDesk and enable anonymous access for a specific login. This is how I got it to work. Hope this helps...
Try setting up a virtual folder under the IIS Web Site, set up an ODBC connection specifically for HelpDesk and enable anonymous access for a specific login. This is how I got it to work.
Hope this helps...
is this server 64 bit by any chance?
I couldn't get it to work on 64 so I installed it on another server that was 32. I am using IIS 6. We have several apps that won't run on 64 so I assumed this one was in that category.
Yes the server is 2008 R2, 64 bit.
have you tried granting access through statements?
osql -E -S (local) paper writing
This had me stumped for awhile. Hope this helps anybody else w/ the problem about a Windows Server 2008 R2 setup. The previous post with looking at the statements permissions helped me. Essentially this is a permissions issue with the Application Pools and creating the temp .mdb file when an Access DB is used. Follow these directions about setting IIS 6.0 "like" permissions in IIS 7.5 or set them manually to the folder inside the Windows directory that for the App Pool(s) permissions when using tempory files. This worked for me.
http://learn.iis.net/page.aspx/563/using-classic-asp-with-microsoft-access-databases-on-iis-70-and-iis-75/
Article states it best and has pics and steps on how to configure using the IIS 7.5 MMC panel -
"This error indicates that the JET database engine cannot access the temporary directory for the Network Service user profile that uses the impersonated Application Pool identity. In this particular example, the Application Pool identity is configured to use the Network Service account and IIS is configured to load the user profile for the impersonated Application Pool identity. The error occurs because the impersonated Application Pool identity cannot access the temporary folder for the Network Service account. To resolve this specific issue, you can change the permissions on the %SystemDrive%\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp directory to allow read/write permission for the impersonated user, or you can configure IIS to not load the user profile, which will change the temporary folder that the JET database engine will use.
The configuration setting that governs whether the user profile is loaded for the Application Pool identity is loadUserProfile, which is set to false, by default. You can configure this setting by changing the value of the Load User Profile attribute in the Advanced Settings dialog box for an application pool"