read data from database and write to xml file , read from xml file and write to database

See more:

ASP.NET

SQL-Server

Dear Friends,


I Backup and restore in asp.net and sql server using following code (with XML):

----------------------------------------------------------------------

public string RestoreData_to_Database(string tableName, DataSet XmlFileDS)
    {
        try
        {
            DataTable dt = new DataTable();
            dt = XmlFileDS.Tables[0];

            SqlBulkCopy bulkcopy = new SqlBulkCopy(connect.ConnectionString, SqlBulkCopyOptions.KeepIdentity );
            bulkcopy.DestinationTableName = tableName;
            bulkcopy.WriteToServer(dt);
            return "true";
        }
        catch(Exception ex)
        {
            return ex.Message;
        }
        finally
        {
            CloseConnection();
        }   
    }

--------------------------------------------------------

Backup and Restore is OK on localhost, but on a host with plesk control panel,Backup is OK but during restore following error occur :

Login failed for user 'a'.


in advance, Thanks a lot.