Two key points for installing sde9.3 for sqlserver

SDE has been installed for three hours, but it has never been successful. The prompt is:

[Mon May 14 20:43:50 2012] SDE schema object install not completed.

[Mon May 14 20:43:50 2012] Error installing/upgrading ArcSDE, error =-51

[Mon May 14 20:44:33 2012] Error creating version table. (-51)

[Mon May 14 20:44:33 2012] DBMS error code: 2760

Microsoft SQL native client: the specified schema name "SDE" does not exist, or you do not have permission to use this name.

 

Finally, experts help you to make it. Two key points:

(1) create a login name SDE in sqlserver. You do not have to create an SDE database.

Step: Create an SDE database first.

Create an SDE user. Set the default SDE database to an SDE database.

Delete the SDE database. (Note: Do not manually set the SDE user to the db_owner of the SDE database; otherwise, the SDE database cannot be deleted)

(2) When the wizard (post installation) creates an SDE database, the path of datafile and the path of logfile must be under the Data Directory of sqlserver

 

 

Default datafile path: C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data. MDF

Change to c: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data. MDF

 

Default logfile path: C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data. LDF

Change to c: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data. LDF

 

--------------------

The settings are correct.

 

Command:

Install, then Uninstall. Until Master it