New deployed program giving error A network-related or instance-specific error occurred while establishing a connection to SQL Server

[mcfee12345]

I am having a nightmarish start on my first program.when i finished my program i used innosetup and put all the required files including the database for me me to make a setup file.When ever i install the program on the computer it gives me a network related error. Here is the connection string

if (string.IsNullOrEmpty(txtbxusername.Text))
{
MessageBox.Show("Please enter username", "Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txtbxusername.Focus();
return;
}
try
{
using (LoginEntities data = new LoginEntities())
{

var query = from o in data.Users
where o.username == txtbxusername.Text && o.password == txtbxPassword.Text
select o;
if (query.SingleOrDefault() != null)
{
MessageBox.Show("You have been authenticated sucessfully.", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
//add process here


MainPage main = new MainPage();
main.Show();


this.Hide();
}
else
{
MessageBox.Show("You have input the wrong credentials", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}


<connectionStrings>
<add name="Taona_File_Reference_Locator.Properties.Settings.VIMBISOConnectionString" connectionString="Data Source=.\vimbiso;Initial Catalog=VIMBISO;Integrated Security=True" providerName="System.Data.SqlClient" />


Is there another way of installing the software without me having to install sql server software on a client machine.I just want to install my program on a PC like the way we install ms office


Your assistance is greatly appreciated

Continue reading...