The typical structure of a sql connection string is as follows.
Data Source=abc ;Initial Catalog=dbname;User ID=xyz ;Password= *****;Persist Security Info=False;
Here
Data Source is the Dbserver Name or you can provide ipaddress of the same
Initial Catalog is database name which you want to connect.
Persist Security Info The .NET Framework Data Provider for SQL Server does not persist or return the password in a connection string if it set as false [default value is false]
Incase you going to connect the sql server using youe windows authentication instead of userid and password you can set it as
Integrated Security=sspi or true;
Data Source=abc ;Initial Catalog=dbname;Integrated Security=sspi;
Please note these are the basic things required to make a connection with sql server. You also set some advance settings line connection time out etc.
There are many synonym exits like you can user UID instead of User ID or pwd instead of Password.
To know more about this take a look at the msdn link bellow
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx
Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator