MS Sql Server LocalDB connectivity via classic asp [Correct Connection String]

In this post I will show how to make connection string for LocalDB to use with Classic ASP ( Might also work with PHP)


After googling and visiting connection string websites I am still stuck with error like

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Invalid authorization specification
/login.asp, line 19

or

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/login.asp, line 19

or

ADODB.Connection Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 


Here is the list of Possible correct connection string

DSN Based  -While setup ODBC DSN I supplied Sql server authentication 

#1 Driver={SQL Server};Data Source=localsqldb;

#2 DSN=localsqldb;Uid=sa;Pwd=urpassword;

Why DNS based : I do not know but all tries were failed until i setup and made 1 successful connectivity with asp application using DSN after that other methods are also start working 

SQLOLEDB Based

#1 Windows authentication , I setup application pool and site identity to  computers username and password
 Provider=SQLOLEDB;Integrated Security=SSPI;Server=np:\\.\pipe\LOCALDB#SH5E512B\tsql\query;  


#2 Sql server authentication 

Provider=SQLOLEDB;Persist Security Info=False;Initial Catalog=urDBName;Data Source=np:\\.\pipe\LOCALDB#SH5E512\tsql\query;User Id=sa;Password=urpassword


To Setup SA for your localdb 

1. Start Navicat and login to DB via Windows authentication as i mention in my last post and run these queries


ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = 'urpassword' ;
GO


Ref -> http://stackoverflow.com/questions/26403000/how-can-i-setup-my-sql-server-localdb-to-be-as-close-to-a-normal-sql-server

Note : We have navicat so other steps shown on ref page is not required.

Regards