• 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