I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type:Error
Event Source:SQLISPackage
Event Category:None
Event ID:12550
Date:4/3/2006
Time:11:30:12 AM
User:IPC\Administrator
Computer:SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProv ider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.Transf erData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type:Error
> Event Source:SQLISPackage
> Event Category:None
> Event ID:12550
> Date:4/3/2006
> Time:11:30:12 AM
> User:IPC\Administrator
> Computer:SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProv ider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.Transf erData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask. TransferObjectsTask.TransferDatabasesUsingSMOTrans fer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Showing posts with label receiving. Show all posts
Showing posts with label receiving. Show all posts
Tuesday, March 20, 2012
Copy Database Wizard
I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 2000
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you do
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Copy Database Wizard
I am receiving the following error when attempting to copy a SQL Server 2000
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Transf
erDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 20
00
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you d
o
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Tran
sferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
database to SQL Server 2005 using copy database wizard.
When I use copy database wizard on the PUBS database the transfer is
successful.
ERROR:
Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 4/3/2006
Time: 11:30:12 AM
User: IPC\Administrator
Computer: SQLSERV
Description:
Event Name: OnError
Message: ERROR : errorCode=-1073548784 description=Executing the query
"EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
" failed with the following error: "'webapp' is not a valid login or you do
not have permission.". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.
helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at
Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at
Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Transf
erDatabasesUsingSMOTransfer()
Operator: IPC\Administrator
Source Name: IPC-DB_SQLSERV_Transfer Objects Task
Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
Start Time: 4/3/2006 11:30:12 AM
End Time: 4/3/2006 11:30:12 AM
Data Code: 0
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Just by reading the error, it looks like there is an issue with the webapp
login, which could be related to the security context (your permissions)
Do you have full permissions?
"Terry" wrote:
> I am receiving the following error when attempting to copy a SQL Server 20
00
> database to SQL Server 2005 using copy database wizard.
> When I use copy database wizard on the PUBS database the transfer is
> successful.
>
> ERROR:
> Event Type: Error
> Event Source: SQLISPackage
> Event Category: None
> Event ID: 12550
> Date: 4/3/2006
> Time: 11:30:12 AM
> User: IPC\Administrator
> Computer: SQLSERV
> Description:
> Event Name: OnError
> Message: ERROR : errorCode=-1073548784 description=Executing the query
> "EXEC dbo.sp_grantdbaccess @.loginame = N'webapp', @.name_in_db = N'webapp'
> " failed with the following error: "'webapp' is not a valid login or you d
o
> not have permission.". Possible failure reasons: Problems with the query,
> "ResultSet" property not set correctly, parameters not set correctly, or
> connection not established correctly.
> helpFile= helpContext=0
> idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
> StackTrace: at
> Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
> at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
> at
> Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.Tran
sferDatabasesUsingSMOTransfer()
> Operator: IPC\Administrator
> Source Name: IPC-DB_SQLSERV_Transfer Objects Task
> Source ID: {8C9DDAF1-33A1-4FE0-A062-96D4185442B2}
> Execution ID: {B0E899B3-B153-4B2D-8904-8D3137759A41}
> Start Time: 4/3/2006 11:30:12 AM
> End Time: 4/3/2006 11:30:12 AM
> Data Code: 0
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Monday, March 19, 2012
Copy database from one server to a different server
Hi
I am trying to copy a database from one server to another using copy database wizard. However, in the process, I am receiving the following error message : 'Your Sql Server Service is running under the local system account. You need to change your sql server Service account to have the rights to copy files over the network.'
I have no idea how to handle this. Any help is greatly appreciated. Thanks in advance.Hi
You may want to check out alternative methods:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
The service account seems can be found either the services applet or
Enterprise Manager.
John
"John" <john_si100@.yahoo.com> wrote in message
news:05CD7ACF-B765-468A-B9FD-BA501C286A89@.microsoft.com...
> Hi,
> I am trying to copy a database from one server to another using copy
database wizard. However, in the process, I am receiving the following error
message : 'Your Sql Server Service is running under the local system
account. You need to change your sql server Service account to have the
rights to copy files over the network.'
> I have no idea how to handle this. Any help is greatly appreciated. Thanks
in advance.|||Create a domain login for SQL Server... THen using SQL Enterprise Manager
right click your server-> Properties->Security and set the login and
password that you have just created...
Then give that NT login permissions on the appropriate files to do the copy
and you are done.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <john_si100@.yahoo.com> wrote in message
news:05CD7ACF-B765-468A-B9FD-BA501C286A89@.microsoft.com...
> Hi,
> I am trying to copy a database from one server to another using copy
database wizard. However, in the process, I am receiving the following error
message : 'Your Sql Server Service is running under the local system
account. You need to change your sql server Service account to have the
rights to copy files over the network.'
> I have no idea how to handle this. Any help is greatly appreciated. Thanks
in advance.
I am trying to copy a database from one server to another using copy database wizard. However, in the process, I am receiving the following error message : 'Your Sql Server Service is running under the local system account. You need to change your sql server Service account to have the rights to copy files over the network.'
I have no idea how to handle this. Any help is greatly appreciated. Thanks in advance.Hi
You may want to check out alternative methods:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
The service account seems can be found either the services applet or
Enterprise Manager.
John
"John" <john_si100@.yahoo.com> wrote in message
news:05CD7ACF-B765-468A-B9FD-BA501C286A89@.microsoft.com...
> Hi,
> I am trying to copy a database from one server to another using copy
database wizard. However, in the process, I am receiving the following error
message : 'Your Sql Server Service is running under the local system
account. You need to change your sql server Service account to have the
rights to copy files over the network.'
> I have no idea how to handle this. Any help is greatly appreciated. Thanks
in advance.|||Create a domain login for SQL Server... THen using SQL Enterprise Manager
right click your server-> Properties->Security and set the login and
password that you have just created...
Then give that NT login permissions on the appropriate files to do the copy
and you are done.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <john_si100@.yahoo.com> wrote in message
news:05CD7ACF-B765-468A-B9FD-BA501C286A89@.microsoft.com...
> Hi,
> I am trying to copy a database from one server to another using copy
database wizard. However, in the process, I am receiving the following error
message : 'Your Sql Server Service is running under the local system
account. You need to change your sql server Service account to have the
rights to copy files over the network.'
> I have no idea how to handle this. Any help is greatly appreciated. Thanks
in advance.
Subscribe to:
Posts (Atom)