من براي بكاپ از كد زير استفاده مي كنم . كه در اولين اجرا بكاپ ور داشت . ولي ديگه ور نمي داره و اين ارور را ميده
Cannot open database "kdb" requested by the login. The login failed.
Login failed for user 'PROGRAMMER\yashar'.
كد هاي بكاپ
privatevoid button20_Click(object sender, EventArgs e)
{
string strFileName = string.Empty;
saveFileDialog1.DefaultExt = "BAK";
saveFileDialog1.FileName = "BackFile";
saveFileDialog1.Filter = "Create BackUp (*.bak)|*.bak|All file(*.*)|*.*";
saveFileDialog1.FilterIndex = 1;
saveFileDialog1.OverwritePrompt = true;
saveFileDialog1.Title = "Backup SQL File";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
strFileName = saveFileDialog1.FileName;
back(strFileName);
}
}
privatevoid back(string strFileName)
{
try
{
string command = @"BACKUP DATABASE kdb TO DISK='" + strFileName + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand oCommand = null;
SqlConnection oConnection = null;
oConnection = newSqlConnection("Data Source=.; initial catalog=kdb ;integrated security=true;");
if (oConnection.State != ConnectionState.Open)
oConnection.Open();
oCommand = newSqlCommand(command, oConnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("پ¬¢ï ںëï ں êيهçï¢ ںë¤ںê ¬§");
}
catch (Exception ex)
{
//MessageBox.Show("ERROR Occurd: " + ex.Message);
textBox26.Text = ex.Message.ToString();
}
}
ك هاي restore هم به اين شكل هست
privatevoid button23_Click(object sender, EventArgs e)
{
string strFileName = string.Empty;
openFileDialog1.FileName = " ";
openFileDialog1.Filter = "Restore BackUp (*.bak)|*.bak|All file(*.*)|*.*";
openFileDialog1.FilterIndex = 1;
openFileDialog1.Title = "Restor SQL File";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
strFileName = saveFileDialog1.FileName;
rest(strFileName);
}
}
privatevoid rest(string strFileName)
{
try
{
string command = "ALTER DATABASE kdb SET SINGLE_USER with ROLLBACK IMMEDIATE " +
"use master " +
" RESTORE DATABASE kdb FROM DISK='" + strFileName + "'";
this.Cursor = Cursors.WaitCursor;
SqlCommand oCommand = null;
SqlConnection oConnection = null;
oConnection = newSqlConnection("Data Source=.; initial catalog=kdb ;integrated security=true;");
if (oConnection.State != ConnectionState.Open)
oConnection.Open();
oCommand = newSqlCommand(command, oConnection);
oCommand.ExecuteNonQuery();
this.Cursor = Cursors.Default;
MessageBox.Show("پ¬¢ï ںë ں êيهçï¢ ںھ詧ںë§ى ¬§");
}
catch (Exception ex)
{
MessageBox.Show("ERROR Occurd: " + ex.Message);
}
}
ارور بالا هم ميگه با يوزر programmer نمي تونم لاگين بشم . كه حرف چرتي زده
و يوزر و پس ميخواد كه چون لاين به صورت Windows Authentication هست اين ارور بي معني هست
پاسخ با نقل قول