I am using sql server express edition, that comes along with visual studio 2005, in my application. i made the database by adding a new database in application data. i gave the following code for connecting :

SqlConnection cn=new SqlConnection();
        cn.ConnectionString = "data source=Gaurav;Database=tracker";
        cn.Open();
        string sql = "Insert into track (node_id,node_name,node_no) values ('fffff','fffff',45)";
        SqlCommand cmd = new SqlCommand(sql, cn);
        cmd.ExecuteScalar();
        cn.Close();

here, gaurav is my server name and tracker is the database. on debugging, it displays the error message as "unable to connect to the database, and that it does not allow remote login. can anybody help??

Hi there,

You need to provide much more information. How is the instance of SQL Server called? Did you install it as a SqlExpress instance? If so, did you try Gaurav\SqlExpress

Also, take a look at other SqlExpress connection strings If by "new database in application data" you are referring to the App_Data folder, you need a different connection string that uses the AttachDBFileName attribute.

Take a look at the following URLs for a better understanding of SQL Server security and connection strings:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395
http://www.connectionstrings.com

P.S. Hopefully this code snippet is just an example. Usually it's considered a bad practice to embed connection strings in your code directly. For some better ideas: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=250

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
While typing this post, I was listening to: Without Belief by Nitzer Ebb (Track 9 from the album: Belief) What's This?