ArcSDE installation: "Bad Login User" error solution [Zhuan]

ArcSDE installation: "Bad Login User" error Solution

The password is too short. OK.
The first SDE user text box on the create spatial database page is filled with

The Database Password, not the database name. I thought the database name was set

An error occurs when the database cannot be automatically created in SDE. Warning: Parameter

"Temp" not found in defaults file!
Warning: Setting temp to "C"
ESRI ArcSDE Server Setup Utility Tue Dec 08 11:40:14 2009
------------------------------------------------------------

----
Creating ArcSDE schema .....
Error: insufficient permissions (-25 ).
Error: SDE release install not completed. Check

Sdehome \ etc \ sde_setup.log for more details.

Yes. The password is not the database name!
-----------------------------------------

[Add this page to favorites] [print] [it168 Knowledge Base]
When you connect to ArcSDE through arccatalog, ArcIMS, or other clients

The following error message is displayed: "Bad Login User"
Cause
This error occurs in one of the following cases:
1. The entered user or password is incorrect.
2. Enter an incorrect ArcSDE instance.
3. When ArcSDE and SQL Server are connected through system verification, ArcSDE and arccatalog

Different accounts are used.
4. When ArcSDE and SQL Server are connected through system verification in a level-3 connection

The account does not have the logon permission.
Solution
1. Ensure that you enter the correct user name and password
2. ensure the correctness of the ArcSDE instance
3. Use the same account
4. grant specific logon permissions to users.
To install the ArcSDE server, follow these steps:
A. Switch to start Panel> Control Panel> Administrative Tools> Local Security Policy
B. Open the Local Security Policy and select user permission settings on the left panel.
C. Right-click and view the attributes that allow "Log on locally" on the right panel.
D. Add the user to be connected

---------------------------------------------------------
Create the default SDE service category 14:35:03 read 97 comments 0 font size: Large

Medium and small
---------------------------
Createsdeusersqlserver
---------------------------
Sqlstate: 42000
Nativeerror: 15007
'Sde'
---------------------------
OK
---------------------------

The error message in the official document is:
Cause
The SDE login cannot be created with a simple password such

As 'sde' due to the new password policy of SQL Server 2005.

This new password policy requires logins to have strong

Passwords that include at least eight characters. These

Policies require that the password has des at least one

Number, letter and special character.

When using the ArcSDE post-Installation Wizard, the SDE Login

Is created with the password policy enforcement already

Enabled.

Solution:
I. Change the password a little longer;
2. In the SQL Server database, choose security> Login Name> right-click the corresponding login name and attributes-

-> General tab on the pop-up page --> deselect the check box before "enforce password policy.
In addition, before creating a spatial database, create a user's SDE and set the password.

For SDE, so that the configuration can be successful after one next operation.

 

After restoring the SDE database in the sqlserver database, run the following statement:

Use SDE
Go
Sp_change_users_login 'Update _ one', 'sde', 'sde'

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

Since SQL Server 2005 was launched after arcsde9.1

Recommended version for Server installation is SQL Server 2000. If you want to install SQL Server

2005 for relational databases, arcsde9.1 must be patched with SP1 for installation and configuration.

It is fully supported after arcsde9.2.

The procedure is as follows:

1. Install SQL Server 2005

RunProgram: Sqlserver2005_ssmsee.msi

Install msxml6.msi,. NET Framework 2.0 (

Download from the Microsoft Site download center)

2. Run arcgis9.1 \ ArcSDE

Windows \ arcsdesqlserver \ setup.exe

3. Patch ArcSDE 1

Http://support.esri.com/index.cf... = 19 & metaid = 1099

Download

1) Run sde91-genpatch-sql-win.EXE

2) Start cmd

Run sdegdbrepairmssql.exe

Command statement: e: \ installation document \ sdegdbrepairmssql-O repair-u Sde-

P SDE

Complete

4. Start ArcSDE for SQL Server Post Installation

Follow the Wizard to install and configure.

1) Create an SDE database, SDE user, and password

2) Select the data logical structure of Sde

3) Authorization

4) Verify the software (. ECP file)

5) Create and start a service

Test successful:

Sdemon-o status-I esri_sde

You can see that the connection status is accepting connections.