Skip to main content

PowerShell SQL Snapins


Ran into an issue with SQL snapins not registering in PS x86 (needed to run ADMT related scripts). The following resolved the issue.


Start PowerShell x86 (important - run as Administrator) execute the following sequence:
cd "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn"
$framework=$([System.Runtime.InteropServices.RuntimeEnvironment]::GetRuntimeDirectory())
Set-Alias installutil "$($framework)installutil.exe"
installutil Microsoft.SqlServer.Management.PSSnapins.dll
installutil Microsoft.SqlServer.Management.PSProvider.dll
Add-PSSnapin SqlServerCmdletSnapin100
Add-PSSnapin SqlServerProviderSnapin100


To verify that snapins registered correctly examine the output of the following command:
get-pssnapin -registered
Labels:

Comments

  1. nguyenhuongJanuary 19, 2016 at 2:29 AM

    Thanks for sharing, nice post!

    Đến Casanova đây là những quán cafe sân vườn đẹp nhất sài gòn bạn không nên bỏ qua hay bạn muốn học bài thì cafe học bài cực thú vị đấy hay quán cafe view đẹp ở sài gòn bạn không nên bỏ qua hay quán cafe có đàn piano ở tphcm siêu lãng mạn hay casanovacafe là 1 trong cafe giá rẻ bạn nên đến 1 lần, hay tổng hợp những quán cafe dễ thương ở sài gòn hay những quán quan cafe nho va xinh đến là mê hay cafe doc dao o tphcm không đụng hàng hay casanova là quán cafe wifi mạnh tphcm thích hợp để làm việc hay cà phê sang chảnh bạn nên trải nghiệm hay quan cafe doc la cực đẹp hay quán cafe có bánh Pizza cực ngon ăn là nghiền hay đây là quán cafe nhạc acoustic cực lãng mạn hay may dua vong tu dong giúp bé ngủ ngon hay đây là quán cafe phong cách lạ bạn nên đến hay đây là quán cafe có chỗ cho trẻ em chơi hay bạn muốn hội họp thì đây là cafe may chieu cho bạn làm việc hay cafe phòng riêng tphcm cho làm offline làm việc hay điểm danh quán cafe thú cưng tphcm bạn nên đến hay quán cafe bói bài tarot cực thú vị.

    ReplyDelete

Post a Comment

Popular posts from this blog

Mail-enabled security groups in Office 365

Another update (11/19/2013):  further evolution of Office 365 services makes creation of distribution and security groups even easier, plus there's now an option of creating a dynamic distribution group (click here for more information):    Update (08/06/2012): a clear sign of Office 365 evolving along the same lines as other agile cloud services - small incremental features and minor new functionality are being delivered almost continuously and, unlike important major service updates,  without much fanfare. For example, there's no need to resort to using PowerShell to setup mail-enabled security groups anymore, it can now be done at creation using management portal:       Those managing Office 365 ( O365 ) tenant via the Microsoft Online Services Portal  ( MOS Portal ) interface would notice that there are two distinct group entities: Security Groups: can be created via MOS Portal (main portal page>Management>Security Groups) and used for assigning
13 comments
Read more

Drumbeat - Sales and Technical Resources for Office 365

​ Drumbeat - provides information as well as technical and sales resources for Office 365. From partnering with Microsoft, to building up your sales and technical readiness, to adopting proven methodologies for successful deployment - you will find lots of good information and many helpful links there. Here's a quick sample of topics covered: The Customer Decision Framework is Microsoft's selling methodology designed to help partners sell Office 365 to their customers. Office 365 FastTrack is Microsoft's new, 3-step pilot and deployment methodology designed so customers experience service value early in the sales cycle with a smooth path to advance from a pilot to deployment.
Post a Comment
Read more

UAG 2010, SP4

Unified Access Gateway (UAG) 2010 Service Pack 4 (SP4) has been out for a while. Another much anticipated update which brings support for  Windows 8.1, IE11, etc. Download the Service Pack  here Review release notes  here Read through the installation instructions here After performing the upgrade test UAG functionality from the client side, on a number of occasions the following error has been reported - "Forbidden Directory, Listing Denied Error code 403.14". If you find yourself among the unlucky few, read through the following post ; which applies, even though it references a different update. Here are the steps outlined in the post with a minor modification (steps 7-8): Open Forefront UAG management on the UAG server Open/Explore the Trunks under the HTTP and/or HTTPS connections Right click each Trunk and select Disable Save and Activate the UAG configuration Right Click the trunks again and select enable Save and Activate the Configuration again Open the
Post a Comment
Read more