Avatar of spraocs
spraocs

asked on 

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

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
Microsoft SQL ServerWindows 8ASP

Avatar of undefined
Last Comment
spraocs
ASKER CERTIFIED SOLUTION
Avatar of Scott Fell
Scott Fell
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of spraocs
spraocs

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of spraocs
spraocs

ASKER

As I mentioned earlier, I never thought there was another connection string. Was looking only at the error and not on the last line that was coming from a different file once in a while.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo