.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

errorCode=-1073548784

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

 

I am transfering a database from sql server 2000 to sql server 2005 using copy database wizard.

I have this error coming up error

Error: ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'Test\username', @name_in_db = N'username' " failed with the following error: "The login already has an account under a different user name.". 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()

 

How do i handle this error...looked online but didn't find right answers...

 

Please let me know




View Complete Post


More Related Resource Links

errorCode=-1073573417 description=No connection manager is specified.

  
Hi again,It's me once again trying to migrate a dabatabase from SQL 2000 to SQL 2008 x64. During the migration of one of my databases I get the following error:OnError,LISSQLTEST3,SQLServices,LISSQLTEST2_LISSQLTEST3_Transfer Objects Task,{3CF1D4C8-28CB-4B82-B405-A261E0A173BE},{221EA3F0-32E2-412D-BFDE-76AD1D1715A0},16/08/2009 11:53:07,16/08/2009 11:53:07,0,0x,ERROR : errorCode=-1073573417 description=No connection manager is specified. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}StackTrace:    at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()   at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()OnError,LISSQLTEST3,SQLServices,CDW_LISSQLTEST2_LISSQLTEST3_15(atashtiot),{E47ED1C2-0D25-48D2-9B4F-14A5DAF96F0A},{221EA3F0-32E2-412D-BFDE-76AD1D1715A0},16/08/2009 11:53:07,16/08/2009 11:53:07,0,0x,ERROR : errorCode=-1073573417 description=No connection manager is specified. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}StackTrace:    at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()   at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsi

Rebuild Index Error -1073548784

  

I am getting the following error on Rebuild Index Maintenance Task.

"Executing the query "ALTER INDEX [PK_cartrige] ON [dbo..." failed with the following error: "A severe error occurred on the current command.  The results, if any, should be discarded.
A severe error occurred on the current command.  The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly."

Where can i find more details on troubleshooting this error and find more details on the error. It seems to be a persistant problem since sql server 2005.

Details:

  1. -Maintenance Plan has been working well for months.
  2. -Std Edition Sql Server 2008
  3. -Db Integrity check successfull
  4. -sort result in tempdb is off
  5. -keep index online while reindexing is off
  6. -local server connection works for all other jobs prior to the task

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend