MSSQL has two logical layers of security. The term login refers to the account at the server level. The term user refers to the account that lives inside the database. When you restore a database from one server to another server you effectively sever the mapping between the server-level login and the database-level users.
All databases have a single owner that is assigned to a server-level login. That special owner login is mapped to the a special database user called dbo. The owner login account and password is the primary administrative account for your database.
You may need to reestablish the mappings between the server-level logins and the database users in order for the new database to be accessible.
Your new server-level logins are found in your Rackspace Cloud control panel under your MSSQL 2008 Database.
To manage your MSSQL database, you'll first need to login to the online manager (myLittleAdmin).
For additional login to user mappings that are not the special owner account you can use the following command:
ALTER USER [123456_olduser] WITH LOGIN = [123456_newlogin]
ALTER AUTHORIZATION ON Database::[123456_database] TO [123456_login]
© 2011-2013 Rackspace US, Inc.
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License