Thursday, December 6, 2012

So, here we are trying to expand the SharePoint 2010 farm a bit. The farm is comprised of one or more VM sitting in an elaborate VMware infrastructure and a few physical servers hosting the databases. So the VM hosting the application services for SharePoint 2010 is kinda slow, so, decided to add a new one and yank the slow one out, or perhaps even leave both of them in there, y'know how cool it is for us to have more servers doing stuff, good for my ego.And after going through the harrowing experience of missing locally and missing in xxxx servers and yyyy servers, and other annoying language pack issues, the box was finally ready. So, I fired up the SharePoint 2010 Products Configuration Wizard of Oz, and got this along the way, just the very first steps really:

Familiar it seems. Of course the error is not familiar, but getting errors from SharePoint is like our thing. I mean if you don't get any you begin to wonder am I doing things right? Kidding.

So, how do we resolve this?

Create an alias on the server for the SQL client. For some reason this was just the solution.

And to do that:

SQL Alias is something which you may have to create when you’re moving your database server. I had a requirement to move from an old database server to new one and as a part of the migration had to create SQL Alias. This is how you create it.

You will have to create SQL Alias on each web front and application server of SharePoint.

Total Pageviews

Follow Me Also On:

About Me

James Olorunosebi (PMP,MCITP,MCTS,MCNPS,MCPS,MCC,MCP), an MCC 2011 awardee, a multiple certified technology professional has over 10 years experience in computing. He spent the first 3 years of that time doing compTIA, graphics design and video productions using Adobe, Corel, as well as AutoCAD suites; the next 2 years following he delved into network infrastructure studying at NIIT. He has since been teaching and instructing in MOS, Graphics and Photography, CompTIA A+, CompTIA N+, CompTIA Server+, CompTIA Security+, MCSE, MCITP, and now the new MCSE and has led hundreds into certifications. He is a certified Project Management Professional, currently undergoing Canadian CBAP training. He holds a degree in History and International Relations. He has worked with many technology institutes, from NIIT, to Dimension Data, Total E&P, Tavia Technologies, and MTN Nigeria. A motivational speaker, life coach, and avid lover of Japanese animes, his favourite being Bleach.