sql error: cannot open database

Question

hi... i m getting error like this in my code public partial class items : Form { string con = 'Server=.\SQLEXPRESS;Database=|DataDirectory|/db1.mdf;Trusted_Connection=True;'; SqlDataAdapter da = new SqlDataAdapter(); SqlConnection objconnection; private void btnshow_Click(object sender, EventArgs e) { objconnection = new SqlConnection(con); objconnection.Open(); string ss=comboBox1.SelectedValue.ToString(); string q = 'select * from items where cname= ' + ''' + ss.ToString() + '''; SqlCommand comm = new SqlCommand('select * from items where cname=@cname', objconnection); comm.Parameters.AddWithValue('@cname', ss.ToString()); comm.ExecuteNonQuery(); textBox1.Text = comboBox1.SelectedValue.ToString(); da = new SqlDataAdapter(q, con); DataSet ds = new DataSet(); da.Fill(ds); dataGrid1.DataSource = ds.Tables[0]; } Error Cannot open database '|DataDirectory|/db1.mdf' requested by the login. The login failed. Login failed for user 'AHUJA-2FD08D31D\Ahuja's'.

Jose · Answer

Well, as you say, this is working in another app, it does appear to be the syntax of the connection string. Try editing your connection string to something like: Server =. \SQLEXPRESS; Database = myDataBase; Trusted_Connection = True; Jose

Dipa Ahuja · Answer

No...... dats not problem... coz this all working well in SQL/asp.net project.. bt i dont know how to write in c# :(

Jose · Answer

It sounds like the user account does not have enough rights to the database using the trusted connection. You can edit the user rights using some OSQL commands or if you have the SQL management studio, you can do it easily from there by editing the login. Normally by default, if your account has local admin rights, you should have access to the database. You can also test your connectivity to the database by going to the Data sources (ODBC) snapin from the Control Panel > Administrative tools. From there, you can click on the system DSN tab, and add new. Select SQL Server at the bottom of the list, then click Finish. On the next screen give it a name (any name will do) and make sure the local server " .\SQLEXPRESS" is shown in the last field, then click Next. Now you get to the authentication part. Make sure the first option is selected (NT authentication), and check the box below and click Next. At this point, if you are authenticated to the SQL server instance, you should see a combo box with the list of databases (after checking Change default database to). If you get this far, select the database you are trying to connect to and click next and then finish. On the final screen, click the Test button to see if the connection is successful. If not, try making the tweaks from the SQLExpress instance. Might need to add the user role to that database if it does not have access.

Dipa Ahuja · Answer

but i dont know that id and password.. i have not set password.. i hav worked with access database how to deal with SQL?? n i m not getting help anywhere... :(

Lalit M · Answer

try this link about login fail http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

Santhosh N · Answer

Your DB instance is protected with username and password and you need to provide valid username and password in the connection string to open this... try to login to the instance first with userrname and password and provide the same in the connection string and check

sql error: cannot open database

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)