SQL 2005 securables cant see  after restore to another server

Posted on 2011-04-19
Last Modified: 2012-05-11
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 ?
Question by:harveygs
    LVL 39

    Accepted Solution

    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
    LVL 1

    Author Comment

    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.
    LVL 1

    Author Comment

    ok no interest here.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now