Hi
Thanks for the reply
Normal user 'dev' has got dbcreator rights to perform the appropriate actions. See below;
CREATE LOGIN [dev] WITH PASSWORD=N'1', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'dev', @rolename = N'dbcreator'
GO
I login with the user account using sql authentication, try creating a database and it fails
Try if the following works for you
thanks