Hello Derek,

Thank you for responding.

The error I described below is occuring during the installation of
SC53 so I would not have a web.config file to work with as of yet.

Regarding giving the remote Sql Server machine access to the local
asp.net account, I am not sure I understand why this is necessary
and if I would want to do that. If the sql login I provide during
the installation has the permissions of a database administrator, it
should have the rights to attach or restore a database. Plus, the
local machine where SC53 is being installed has no special
permissions assigned to the physical directory of the SQL Server
database in regard to the aspnet account.

Does the local aspnet account perform something unusual on the
physical directory of the sql server database?

Also, I am installing SC on a pc with Win2003 and a remote server of
using Sql Server 2000. Any compatibility issues here?

As always, thank you for your assistance.
cak

--- In sitecore@yahoogroups.com, "Derek Roberti" <dr@...> wrote:
>
> Is your web.config set up as follows?
>
>
>
> ... .
>
> <sitecore database="SqlServer">
>
> ...
>
> <connections serverMode="File">
>
> <sc.include
> file="/App_Config/$(database)/$(serverMode)Connections.config" />
>
> </connections>
>
>
>
> If so, I'm guessing that you need to give your local asp.net
account
> permissions on your remote machine. Sitecore needs to log in to
that
> machine to create a connection to the mdf file.
>
>
>
> If you have the nodes set as follows and it still isn't working,
let me
> know:
>
>
>
> <sitecore database="SqlServer">
>
> ...
>
> <connections serverMode="Server">
>
> <sc.include
> file="/App_Config/$(database)/$(serverMode)Connections.config" />
>
> </connections>
>
>
>
> Derek
>
> ________________________________
>
> From: sitecore@yahoogroups.com [mailto:sitecore@yahoogroups.com] On
> Behalf Of clykopp
> Sent: Monday, September 18, 2006 8:27 AM
> To: sitecore@yahoogroups.com
> Subject: [sitecore] SC53 installed with SQL Server on differnt PC
>
>
>
> Has anyone tried installing Sitecore 5.3 RC with the SQL Database
> Server installed on a different PC?
>
> When trying to do this, I consistently get the error
message "Error
> 27552. Error creating database Master. Server: Microsoft Sql
Server
> {name of server}. Cannot create file "C:\program files\microsoft
sql
> server\mssql\data\Master.mdf" becasue it already exists. (5170)"
>
> I got this same error message with the beta releases.
>
> The login ID has been given "System Administrator" rights so
> permissions should not be the issue.
>
> Any thoughts?
> cak
>