Knowledgebase


Portal Home > Knowledgebase > Windows & Java/JSP > MS SQL Server connection String

MS SQL Server connection String

------------------------------------------
con.ConnectionString = "Data Source=Domain.com;Initial Catalog=hostingUser_DBname;user id=user;password=pass";

-------------------------------------------
 connectionString="Data Source=(local);Initial Catalog=hostingUser_DBname;User ID=USER;Password=PASS; Integrated Security=True;Trusted_Connection=False;" providerName="System.Data.SqlClient"
--------------------------------------------

<add name="NAME" connectionString="data source=(local); initial catalog=dbNAME; user id=USER; password=PASSWORD" 
providerName="System.Data.SqlClient" />


Also Read