I finally got to the stage where I've installed the database and the Data Base Connector is installed and talking with SQL.
When tailoring the IIS I had trouble with the following stage; Click the "Documents" tab and click "Add". Enter each of these and place them in this exact order as shown. Delete index.html which is the default but not used. Click Apply. This had about 4 extra .asp files. I deleted these and matched it to the installation instructions, I've enabled parent paths. I'm getting to the point where when I go to http://your.webserver.com/hdesktest/setup.asp. and it shows 'Update Database', shows the logon box. Administrator (Which is the windows authenticated user) Shows Microsoft OLE DB Provider for SQL Server , error '80040e4d' Login failed for user 'administrator'. /hdesktest/setup.asp, line 112. When I log on with sa user account, this shows the error Microsoft OLE DB Provider for SQL Server , error '80040e37' Cannot find the object "tblConfig" because it does not exist or you do not have permissions. /hdesktest/setup.asp, line 408. When I try and change the sa account to dbOwner it doesn't let me apply it, but it is in the sysAdmin group, so I just can't understand where I'm going wrong and my brain is fried trying to work it all out. Thanks for reading this, sorry if I'm doing something stupid. Laura
Click the "Documents" tab and click "Add". Enter each of these and place them in this
exact order as shown. Delete index.html which is the default but not used. Click Apply.
This had about 4 extra .asp files. I deleted these and matched it to the installation instructions,
I've enabled parent paths.
I'm getting to the point where when I go to http://your.webserver.com/hdesktest/setup.asp. and it shows 'Update Database', shows the logon box. Administrator (Which is the windows authenticated user) Shows Microsoft OLE DB Provider for SQL Server , error '80040e4d' Login failed for user 'administrator'. /hdesktest/setup.asp, line 112. When I log on with sa user account, this shows the error Microsoft OLE DB Provider for SQL Server , error '80040e37' Cannot find the object "tblConfig" because it does not exist or you do not have permissions. /hdesktest/setup.asp, line 408. When I try and change the sa account to dbOwner it doesn't let me apply it, but it is in the sysAdmin group, so I just can't understand where I'm going wrong and my brain is fried trying to work it all out. Thanks for reading this, sorry if I'm doing something stupid. Laura
http://your.webserver.com/hdesktest/setup.asp.
and it shows 'Update Database', shows the logon box.
Administrator (Which is the windows authenticated user) Shows Microsoft OLE DB Provider for SQL Server , error '80040e4d' Login failed for user 'administrator'. /hdesktest/setup.asp, line 112.
When I log on with sa user account, this shows the error Microsoft OLE DB Provider for SQL Server , error '80040e37' Cannot find the object "tblConfig" because it does not exist or you do not have permissions. /hdesktest/setup.asp, line 408.
When I try and change the sa account to dbOwner it doesn't let me apply it, but it is in the sysAdmin group, so I just can't understand where I'm going wrong and my brain is fried trying to work it all out.
Thanks for reading this, sorry if I'm doing something stupid.
Laura
Sorry I found the answer to this in the old forums - if you havent ran the included SQL script to setup your tables, you will need to do that. This should add the tables you need.
Now I'm getting an SQL Query at the bottom of every page, saying SQL Query; SELECT uid from tblUsers WHER sid = 0
Could anyone tell me how to stop this displaying? It seems to have been since I re-ran the SQL scripts...
Thanks