<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
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.<br />
How can I restore the securables ?
</div>
</div>


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 ?

SQL 2005 securables cant see  after restore to another server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.