Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 931
  • Last Modified:

SQL Server simple DB copy - getting error on security role

Hi,

I am just trying to perform a simple copy of a database on SQL server 2008.  I am using the Copy DB Wizard that you get when you right click on the database name - tools - copy database.  I have done this many times before, but am starting to now get an error on the execution part.

I believe the problem is to do with security roles, but am now stuck on how to fix this.

The full error log is below, but it is the following 2 lines that are the problem (I think).  Any help on what I need to do to sort this out is much appreciated


OnError,PADA-INV-PC-10,NT AUTHORITY\NETWORK SERVICE,PADA-INV-SRV-1_PADA_INV_PADA-INV-PC-10_Transfer Objects Task,{0E43B433-D410-4057-9BB6-7A84C21DFCD7},{CED981AA-4761-4848-991C-34A865D66292},09/05/2011 11:27:35,09/05/2011 11:27:35,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "sys.sp_addrolemember @rolename = N'NestRole', @mem..." failed with the following error: "The role 'NestRole' does not exist in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


OnError,PADA-INV-PC-10,NT AUTHORITY\NETWORK SERVICE,CDW_PADA-INV-SRV-1_PADA_INV_PADA-INV-PC-10_6,{C0D59B1D-8E7C-4C79-9CE8-2E704B9D36A5},{CED981AA-4761-4848-991C-34A865D66292},09/05/2011 11:27:35,09/05/2011 11:27:35,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "sys.sp_addrolemember @rolename = N'NestRole', @mem..." failed with the following error: "The role 'NestRole' does not exist in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Background:  I have a number of different database on the server I am copying this to and they should use the same security roles as the database (SecMaster_UAT) has.  All used to work fine, but I can't seem to understand what I need to change in order to make this work

Full error log attached



CDW-PADA-INV-SRV-1-PADA-INV-PADA.txt
0
wobbled
Asked:
wobbled
1 Solution
 
kamindaCommented:
Are you using the sa login to do this? If not try to use it there is a widely reported issue with this as I can remember.
0
 
wobbledAuthor Commented:
I am using the sa logins on both the source and destination servers
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure the User have access to destination server to create database (db_creator) permission.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
GSGDBACommented:
Add new database role as NestRole on the copying database.
0
 
wobbledAuthor Commented:
thanks for all the replies. The solution turned out to be a reboot of the sql server. I tried everything and much more before boucing the box.
0
 
wobbledAuthor Commented:
I have accepted this as the answer to the thread as the above comments did not actually fix the issue.  Bouncing the SQL box cleared the issues
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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