troubleshooting Question

Classic ASP connection to SQL Server 2012 on Windows Server 2008 R2

Avatar of spraocs
spraocs asked on
Microsoft SQL ServerASPWindows 8
3 Comments2 Solutions4005 ViewsLast Modified:
I am not able to connect to the SQL Server 2012 on Windows Server 2008 R2 from the classic ASP application. I have IIS 7.5 running. 32 bit application support is enabled for the application pool.

Still I get different errors. I tried with the different connection strings mentioned on Connectionstrings.com also. The result is same. Different errors for each type of string. I tried everything from SQLOLEDB to SQLNCLI11 for the provider. I have also tried to use the port 1433 explicitly in the connection string.  

Classic ASP - IIS 7.5 - MS SQL Server 2012 - SQL Native Client 11 - Windows Server 2008 R2  

Is there any issue with the above configuration? I have found very little help when I googled.

-- I don't see MS SQL Server 2012 when I tried to add topics for this question..!!!

Thanks
sprao
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros