Saturday, March 23, 2013

[SQL 2012] How to Change the TCP Port on SQL Server 2012 Core Edition

[SQL 2012] How to Change the TCP Port on SQL Server 2012 Core Edition

How to Change the TCP Port on SQL Server 2012 Core Edition

Posted: 22 Mar 2013 02:53 PM PDT

Can anyone tell me how to change the TCP port on SQL Server 2012 Core Edition?SQL Server Configuration Manager (i.e., SQLServerManager11.msc) is normally used for configuring the TCP port in SQL Server. However, since the Core Edition does not have any Start Menu entries, I am having trouble getting it to run. I found two copies of SQLServerManager11.msc on the system:1) C:\Windows\System32\SQLServerManager11.msc2) C:\Windows\SysWOW64\SQLServerManager11.mscBut both copies generate an error when executed:[code="plain"]PS C:\> C:\Windows\System32\SQLServerManager11.mscProgram 'SQLServerManager11.msc' failed to run: Class not registeredAt line:1 char:1+ C:\Windows\System32\SQLServerManager11.msc+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~.At line:1 char:1+ C:\Windows\System32\SQLServerManager11.msc+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ResourceUnavailable: (:) [], ApplicationFailedException + FullyQualifiedErrorId : NativeCommandFailed[/code][code="plain"]PS C:\> C:\Windows\SysWOW64\SQLServerManager11.mscProgram 'SQLServerManager11.msc' failed to run: Class not registeredAt line:1 char:1+ C:\Windows\SysWOW64\SQLServerManager11.msc+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~.At line:1 char:1+ C:\Windows\SysWOW64\SQLServerManager11.msc+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ResourceUnavailable: (:) [], ApplicationFailedException + FullyQualifiedErrorId : NativeCommandFailed[/code]

Training recommendation for 2008 R2 to 2012 with emphasis on Always On

Posted: 22 Mar 2013 08:37 AM PDT

I've got six SQL Server 2008 R2 servers to upgrade to SQL Server 2012. There is one standalone that's used for dev and admin and the others support enterprise systems. I've got mirroring running on two of them for our most critical enterprise application.I need to get all of them updated to SQL Server 2012 and implement Always On for the primary enterprise cluster and a second cluster for the other db's. I really can't afford to hack at it any more than I have to. Are there any particular training opportunities anyone can suggest that would provide specific topics on migration from 2008 and implementing Always On? Any format, any place in the Intermountain West or the Pacific Northwest would be good. (I'm in Wyoming.)

SharePoint 2010 and Multiple SSRS Servers on Different Versions of SQL Server

Posted: 22 Mar 2013 06:58 AM PDT

We have an existing SharePoint 2010 sp1 farm with a SQL 2008R2 integrated Reporting Services server. Does anyone know if it is possible to add another Reporting Services to the SharePoint farm without dropping the existing one? What about one running on SQL Server 2012? Considering how the integration mode changes (SSRS is a service in 2012), it would seem this may be possible.Thanks!

Sql Server 2012 can't see 2nd drive

Posted: 14 May 2012 02:33 PM PDT

I installed Sql Server 2012 Express. Everything went without a hitch until I attempted to create a new database and place it on a second drive (E:). The location window displays C: and an external drive (Z:), but not the E: drive where I wish to place the database. Permissions show full control, but Sql Server won't display it.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog