connecting to a sql server using sqlconnection class

Question

Hi Guys.I am trying to connect to a Sql Server in my apllication using the following code :

SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = "Data Source = (local);Initial Catalag = Inventory;
                                 Persist Security Info = false;
                                 Integrated Security = true;
                                 Packet Size = 4096;Connect TimeOut = 30";
myConnection.Open();

where Inventory is my database and it exists on my local machine.

"Error 40: Could not open a Connection to Sql Server" ---error comes while the above code executes.

Answer 1

If you do not specify the Network Library in the connection string a connection to the database will be established using TCP/IP, by default.

The TCP/IP network library is usually not enabled after installation of SQL Server. Use the SQL Server Configuration Manager to enable to protocol.

Alternatively, if you want to use an enabled protocol, perhaps Shared Memory, add Network Library=dbmslpcn to the connection string.

Answer 2

Its Initial Catalog and not Initial Catalag.

You may want to test with this changed.

Answer 3

Do you have more than 1 instance of SQL Server in your pc? Then Data Source = (local) is ambiguous.

If this is the case, then try out with Data Source = MyServername\MyInstance in the connection string.