Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Administration  Server roles in SQL Express

Author  Topic  heed Starting Member 3 Posts Posted - 2009-09-11 : 04:01:21 Hey, I'm trying to test my Azure project locally, and it tells me I need a database called 'DevelopmentStorageDb' on SQL express. What for I don't know, as the database my app uses is completely different, but I thought I would create it and see if it would run. I can connect fine to the express server in SSMS with windows authentication, but my user only has the 'public' server role, so I can't create any new databases. I can't add any roles to myself. I thought I would log on as the user 'sa', who has the role sysadmin, but the server won't allow SQL authentication, only windows. Of course I can't change this, as my user only has the 'public' role. My user account in windows is an administrator btw. So I can't create the DB myself, Visual Studio can't do it, and I'm not allowed to do it as another user... Where is the sudo command for windows? :) Any suggestions?