This is a setup issue of our application. The app gets installed into the
ProgramFiles-Dir and creates a subdir database there.
Structure:
programfiles\appdir\database

To the database-dir a backup is successfully copied and the onstaller tries
to do a restore, with the database files located in this database-dir.
Usually this is no problem, but on XP (maybe Vista and Win7 too) machines,
the restore fails. Why?

SQL2005 Express is used. The installer is INNO, the restore is issued using
DMO.

The same succeeds if the app is installed in the root folder, so there must
be a problem with rights for creating the database files in the users
directory?

TIA
Bernd

Bernd Maierhofer (bernd.maierhofer (AT) dato (DOT) at) writes:
What is the error message?

Which is the service account for SQL Server?

User's directory? I understood that you put the database in to
ProgramFilesDir?




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

use this (without error handling):

SQLServer := CreateOleObject('SQLDMO.SQLServer');
SQLServer.LoginSecure := True;
SQLServer.Connect(SQLServerName);
DB := CreateOleObject('SQLDMO.Database');
DB := SQLServer.Databases('master');
s := ExpandConstant('{app}') + '\Database\';
sSql := 'RESTORE DATABASE [nuts] FROM ' + 'DISK = N''' +
s + 'nuts_deploy.bak'' WITH FILE = 1, ' +
'MOVE N''nuts_data'' TO N''' + s + 'nuts.mdf'', ' +
'MOVE N''nuts_log'' TO N''' + s + 'nuts.ldf'', NOUNLOAD,
REPLACE, STATS = 10 ';
DB.ExecuteImmediate(ssql);

So I thought, the service account of SQLServer has access rights to the dir
where the user is allowed to copy files to.

Here it fails: \<ProgramFilesDir>\<appdir>\DataBase
Here it works: \<appdir>\DataBase

TIA Bernd

Bernd Maierhofer (bernd.maierhofer (AT) dato (DOT) at) writes:
I'm looking forward to seeing it.

Does this mean that you use LocalSystem? (I'm sorry, but it may help
if you answers the questions being asked.)

What do you mean "with admin rights". That you are logged into Windows
with administrator rights or something else?

I would have been less surprised if this had been issue on Vista, since
Vista do really want you to put application data in Program Files as
I understand, if I want to copy files into Program Files, I get a UAC
alert.

But maybe there are similar restrictions on XP.

Have you compared the Windows permissions on the two directories?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I do not know what the srevice account is - what I know is, that I used the
default values. I do a silent install using these settings:

start /wait setup.exe /qb /settings c:\all.ini

[Options]
ADDLOCAL=SQL_Engine,Client_Components,Connectivity
INSTANCENAME=MSSQLSERVER
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=1
RSAUTOSTART=1
SECURITYMODE=SQL
SAPWD=...
DISABLENETWORKPROTOCOLS=0
ADDUSERASADMIN=1

admin to the SQLServer.

Copying files was not the issue. Restoring the database was. LocalSystem
must not be forbidden to write to \<ProgramFilesDir>\<appdir>\DataBase, must
it?

TIA Bernd

Bernd Maierhofer (bernd.maierhofer (AT) dato (DOT) at) writes:
That may be Local System for SQL 2005, but I think you should verify
it.

I would not really expect so. Then again, I still have not seen the
error message.

And, oh, if the error is "Access is denied", this could also indicate the
files are there already, but open by another process.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx