Create a user for SQL Server 2008?
sql-server-2008
Solution
In SQL Server, users are different to logins.
To create a user for a database, you first have to create a login for the server using the `create login` syntax
Problem
I'm using this code to create a new user. ``` /****** Object: User [primebox] ******/ IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'primebox') CREATE USER [primebox] FOR LOGIN [primebox] WITH DEFAULT_SCHEMA=[primebox] GO ``` and I got the following error when I try to create this specific user. Msg 15007, Level 16, State 1, Line 1 'primebox' is not a valid login or you do not have permission. The part that I don't understand is, I can create others users but this one in particular looks invalid I tried to rename my database and got this error Unable to rename primeboxs. (ObjectExplorer) Rename failed for Database 'primebox'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030) My guess is that the problem is the database name... but I got the code from another database (I'm creating a 'wanna be' backup) with the same user and database names. So I'm in a corner here... Any help will be a LOT appreciated =) PS: My computer name is box, windows 7. Using SQL Server 2008