Error 001904: SDE or DBMS admin user cannot create a utility network

4270
12
05-22-2018 01:45 PM
BryceGardner2
New Contributor III

I am trying to learn about Utility Network and keep getting this error.

I first tried with my OS authenticated user. No dice, should've read closer.

Then I tried with our SDE user that I set up as the geodatabase owner. No dice.

I asked our DBA to create an user in SQL that is database authenticated for this specific purpose. No dice. I feel like I'm stuck.

0 Kudos
12 Replies
AbhijeetKulkarni
Occasional Contributor

Hi Pragya,

The connection you used in 'create utility network' seems to be DBMS level user.(FrankTstSrv(1).sde in your case, which seems same in create database user meaning its DBMS user connection) Please create connection using user 'ps' which you created in previous steps. Create feature dataset and service area FC using 'ps' user and then pass those as parameters to 'create Utility Network'. 

0 Kudos
pragyasrivastava
New Contributor III

Okay got it! It worked!!! Thanks so much!

0 Kudos
BryceGardner2
New Contributor III

I got it to work! Four months later...

Does anyone know if it is the case that the schema cannot be owned by SDE?

I wasn't able to create the utility network on a database with an SDE owned schema, but using the same configuration I was able to create the utility network on a database with a DBO owned schema.

0 Kudos