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?
Solved! Go to 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
That worked.
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)
Yes, I can. I was able to change the connections via SQL Server Management
studio.