Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

back up and restore SQL Server 2008 DB on another server problem?

I'm moving SQL Server databases from one server to another. I don't think I can get direct access, but that might be a possibility. I did what I've done before in the same network, which was:

* backed up the database

* Transferred the backup

* Created a new blank database on the new server

* Restored the backup of the DB with the same name.

It says backup successful, but when I want to explore the tables in Sql Server Management Studio, it won't expand the database to show me the tables, etc.

Message is "The database [db name] is not accessible (ObjectExplorer)".

If I try to view properties, I get an error message with more info. It says,

"The server principal [my domain\username] is not able to acccess the database [DB name] under the current security context. (Microsoft SQL Server, Error: 916)

I believe it's because I have different accounts on the two computers, and they aren't on the same network. What can I do? Is there some way I can add permissions to the source database before backing it up or something? I'm not really a network or DB guy, but I am a developer so I can figure out a technical explanation if you have one.

Thanks in advance!

2 Answers

Relevance
  • 9 years ago

    I guess you are connecting to your server using SQL login

    Try to logon to server using Windows authentication

    Remove sql login for your database

    Re-add sql login for the database

    Or

    You should map old server sql login to new server sql login using a system stored procedure

  • lemmer
    Lv 4
    4 years ago

    In business enterprise supervisor, set the database for replication; then, in replication centers, use the wizard to decrease back the checklist up. besides the undemanding actuality that, all databases are stored as MDB information on your sq. set up itemizing via making use of default; you are going to be able to desire to only decrease back those up, and in case you ever crash the server, import them decrease back in a sparkling set up.

Still have questions? Get your answers by asking now.