When creating a build script, within the script are generated the following:
CREATE USER [crmUser] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]
GO
CREATE USER [NT AUTHORITY\NETWORK SERVICE] FOR LOGIN [NT AUTHORITY\NETWORK SERVICE] WITH DEFAULT_SCHEMA=[dbo]
GRANT CONNECT TO [NT AUTHORITY\NETWORK SERVICE]
GO
Does anyone know why this user crmUser is created
Also why is a NT Authority\Network Service user being created
Thanks
P R W.
What is the account crmUser
RoggA
My *Guess* is that you have [NT Authority\Network Service] as a user in your model database, so when your designdb database is created from a copy of model it'll pick this up.
Presumably crmUser would be the same issue.
Look at the instance of SQL Server you're using for DesignDB and see if this is the case. Otherwise they could easily have come in if you used import script or import existing database...