i'm creating an small application which uses sqlConnection for the purpose of connection to the database.
but i'm not able to connect to the server
the error is:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
my code is:
ConnString = "Data Source=(HOME\SQLEXPRESS);Initial Catalog=college;Integrated Security=True" here ConnString is the connection string, college is my sql database.
the error is displayed when i try to open the connection to the database.
please tell me how to write the correct connection string (i want to access the database through windows authentication)