I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008.
It's been a while since I tried the last time (because I gave up on this problem) so I may don't remember correctly everything I made in the past.
What I have done in a nutshell: export/import IIS config and ODBC config and moved the db.
My ODBC connection seems to run fine because the setup tool says so and I can access the SQL server via MS-SQL Server Management Studio by selecting the SQL server.
The Authentication is Windows-Authentication using the Administrator.
However I can not connect using vbscript (?). Opening the website via http gives me an error on these lines:
var conn = Server.CreateObject("ADODB.Connection"); conn.Open("DSN=xxx");
I got the message that the db could not be found or it has no rights.
Now I checked again and it says error "trying to login" (Maybe I translated it wrong, error message is german.).
I have the hypothesis that the IIS process has no rights to access the MSSQL DB and I read that I have to grant the site in IIS administrator rights.
Can this be the cause of the problem and then how can I grant it (website or process...) more rights?