SQL install problem

[jrf]

I cannot get my ms sql 7 to install to any drive but c: for both program and data. Any attempt to load the program to my E: drive that has lots of room and the data to G: with is a mirrored raid drive fails due to "unable to open c:\mssql7\data\log" which seems to be hard wired in the installation program. Plus, I cannot seem to find any documentation on moving the data once installed. I know this can be done, just can't find the documents.

Thanks

 

[Karpi]

Hello,

I don't know from these difficulties, just enter you're Path in the Setup-Screen and all will run.

You cann install a database wherever you want. You can choose a path for the database and the log-file. You can also move the database to another path during a restore of a backed-up database.

HTH
Karpi
<fluctuat nec mergitur>

 

[jrf]

Sorry, Kari, but that's not it. Now matter what drive\directory I propose to the setup program the setup fails because it cannot copy files into &quot;c:\mssql7\data&quot; which is apparently hard wired into the install program. The install up to that point works properly with the files placed where I wanted them. Interestingly enough, all new databases are created in c:\mssql7\data, I am not asked where to put them, and when I go to expand them into other drives, sql7 does not offer the option of picking the raid drives! Just skips right over them, goes straight from C: to H: Wow. Oracle is starting to look good.

 

[TomSark]

When you are installing, what are the security credentials of your account?

Also, are you using an off-the shelf installation of SQL Server? Has SQL Server ever been installed on that machine before?

BTW... Oracle is many, many times more difficult to install than SQL Server. Tom Davis
tdavis@sark.com

http://www.sarkdallas.com