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

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Scott Fell

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
spraocs

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy