• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 536
  • Last Modified:

SQL 2005 securables cant see after restore to another server

After restoring a SQL 2005 database to another server using restore database master from disk=d:\master.bak with replace then using symantec exec 12.5 to restore rest of databases from tape all looks ok except that no user has any securables viewable . I log on as system admin or sa in sql managemnet studio express.
How can I restore the securables ?
0
harveygs
Asked:
harveygs
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
The logins are stored at the SERVER level and inside each database therefore you should get all the logins from old box transfered to the new box like Microsoft describes it below - just get those that you need not all:

How to transfer logins and passwords between instances of SQL Server

http://support.microsoft.com/kb/246133
0
 
harveygsAuthor Commented:
It seems that users can log on ok . I can see them listed under security in the main security section and under each database, But when double clicking on a user name there is no securables listed for them. The users are domain users or groups.
0
 
harveygsAuthor Commented:
ok no interest here.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now