Altering SERVER_CONFIG parameters ArcSDE 10.2

[GeoffreyWest]

I have an ArcSDE connection that's accepting a maximum of 64 instances.  I would like to change it to 128.  I have followed the script from the resource center but receive the error below.  My inclination is that there was a 10.1 SDE instance installed previously.  We are using 10.2 now.   What's the best way to go about this?

[VinceAngelo · Accepted solution]

I never use SDO. Tech Support might be able to steer you to the right set of flags, but editing the SDE_server_config table might be your easier course of action:

USE SCData
go
UPDATE dbo.SDE_server_config
SET num_prop_value = 128
WHERE prop_name = 'CONNECTIONS'
go

- V

[GeoffreyWest]

That worked.

[AsrujitSengupta]

Can you connect using that "sa" user using SQL Server Management Studio or from ArcGIS Desktop?

Did you change the password in the command that Vince gave you as an example? ( -p)

[GeoffreyWest]

Yes, I can. I was able to change the connections via SQL Server Management

studio.