Categories
Connection string ASP.NET / SQL Server database
What does the connection string look like when I want to access a SQL Server database from ASP.NET
For SQL 2005
Data Source=sql1.myhostingpartner.co.uk;Initial Catalog=myDataBase;UserId=User Name;Password=Password;
For SQL 2008
Data Source=sql3.myhostingpartner.co.uk; InitialCatalog=myDataBase;User Id=Username;Password=Password;
For SQL 2012
Data Source=sql8.myhostingpartner.co.uk;Initial Catalog=myDataBase;User Id=User Name;Password=Password;
For SQL 2014Data
Source=sql2014-1.myhostingpartner.co.uk;Initial Catalog=myDataBase;User Id=User Name;Password=Password;
For SQL 2016
Data Source=192.168.10.102;Initial Catalog=myDataBase;User Id=User Name;Password=Password;