We help IT Professionals succeed at work.

Brutal Migration To Windows Server 2012

1,263 Views
Last Modified: 2014-08-25
I am beside myself.  Sites have been down for 18 hours now.  All files have been moved.  All data has been moved.  There seems to be some problems with my sql server connection string...it was working fine on my windows server 2008 and seems to be problematic on 2012.

Here is my 2008 connection string:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLNCLI11;Server=localhost\SQLExpress;Database=xxx;Uid=xxx;Pwd=xxx;"

The file structure on that server was:
C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS

The file structure on my new server is:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER

The error highlights the conn,open line and says it can't find the instance.  I tried replacing SQLExpress with SQLSERVER but that didn't help.

Could really use some resolution here.
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Big MontyWeb Ninja at large
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
David Johnson, CDSimple Geek from the '70s
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Bob SchneiderCo-Owner

Author

Commented:
1) yes I am using sql server 2012 on Windows Server 2012 R 2
2) Yes I attached the dbs
3) Mgmt Studio Says Sql Server 11.0.3153
4) I have MIcrosoft Sql Server 2012 Native Client
4) I will try to run it with the abbreviated connection string.

Related to all of this,
1) This is a non-db site with mostly straight html and it renders fine: http://rosemountata.com/
2) This one throws an error that I believe is database related: http://www.my-etraxc.com/
3) This one doesn't appear to be able to be found on the new server at all: www.etraxc.com/

Thanks for the help so far.  My kingdom, such as it is, for the one who can get this figured out for me.
Big MontyWeb Ninja at large
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott FellDeveloper
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott FellDeveloper
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Bob SchneiderCo-Owner

Author

Commented:
Here's the error from the failed request logs:
SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Here is the modified connection string:
conn.Open "Provider=SQLOLEDB; datasource=72.52.136.29; Database=xxx; Uid=xxx; Pwd=xxx;"

Tried to use the sql config mgr as indicated in the link but when I right click on the ip addresses I don't get a "properties" option.  Not sure what port I should be looking for....
Bob SchneiderCo-Owner

Author

Commented:
On top of all of this, on my sites in IIS, at various points, I get the lock error indicated in the attachment
lock-error.docx
David Johnson, CDSimple Geek from the '70s
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Scott FellDeveloper
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Bob SchneiderCo-Owner

Author

Commented:
myst_black, where is that in your web.config file?
Bob SchneiderCo-Owner

Author

Commented:
The top line appears to be the source of many of my issues in my web.config file:

    <httpErrors errorMode="Custom" defaultPath="/500err.asp" defaultResponseMode="ExecuteURL">
      <remove statusCode="404" subStatusCode="-1" />
      <remove statusCode="500" subStatusCode="-1" />
      <error statusCode="500" prefixLanguageFilePath="" path="/500err.asp" responseMode="ExecuteURL" />
      <error statusCode="404" path="/404err.asp" responseMode="ExecuteURL" />
    </httpErrors>

Why is that?  How do I change it?  Is there a workaround?
Bob SchneiderCo-Owner

Author

Commented:
I have no idea how to run this script...now I am getting max log file truncate issues.  This is supposedly how i fix that but  is there a command prompt that I need to use?

cd /d "%windir%\system32\inetsrv"
appcmd set config /section:sites -siteDefaults.traceFailedRequestsLogging.maxLogFileSizeKB:1024
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Bob SchneiderCo-Owner

Author

Commented:
Just a quick update that we are back online now.  The problems were two-fold:
1) The connection string...thanks for all the help on that.
2) When I moved the web files from the old server to the new I left the web.config files in there.  That was causing all of my "Lock" issues.

Learned a lot from you all.  Thanks so much!
Glad you are out of the woods now!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.