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

[BryceGardner2]

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.

[AbhijeetKulkarni]

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'. 

[pragyasrivastava]

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

[BryceGardner2]

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.

[DiegoMCastellari]

Hi! 
We are having the same problem (some years after). When we try to run the tool "Create Utility Network", the error 1094 occurs.
We followed the steps detailed in this post: 
- create a user running the tool from ArcGIS Pro;

- connect to the db with this user and create the datasaet and polygon layer;

- run the tool to create the utility network

but without luck.

Before that, we tried creating the user from the db, with different roles and privileges, but no luck.

We are using ArcGIS Pro 3.2.2, SQL Server 2017 and ArcGIS Enterprise 11.2.
Is there something else we can try to create the utility network in the sde?