Advertisements

Archive

Archive for the ‘Others’ Category

DACPAC – Could not deploy package, the database platform service with type Sql130DatabaseSchemaProvider is not valid


 
So, today while deploying a DACPAC file by using SqlPackage.exe utility I faced an error:

*** Could not deploy package
Internal error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider is not valid. You must make sure the service is loaded, or you must provide the full type name of a valid database platform service.

For few minutes I was wondering why this error was coming, but when I saw the version number in above error message it became clear. The version number 130 highlighted above belongs to SQL Server 2016, and the database where I need to deploy DACPAC was SQL Server 2012. So, its clear that the DACPAC was built in Visual Studio with SQL Server 2016 setting.

So I went back to Visual Studio – Project Settings and changed the version to SQL Server 2012, and re-build the Project, and got the correct DACPAC file.


Advertisements
Categories: Uncategorized

Powershell error – Import-Module : File AzureRM.psm1 cannot be loaded because running scripts is disabled on this system


 
After installing the AzureRM module, I tried to import it, but it gave me an error:

Import-Module : File C:\Program Files\WindowsPowerShell\Modules\AzureRM\4.0.2\AzureRM.psm1 cannot
be loaded because running scripts is disabled on this system. For more information, see
about_Execution_Policies at http://go.microsoft.com/fwlink/?LinkID=135170.
At line:1 char:1
+ Import-Module AzureRM
+ ~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : SecurityError: (:) [Import-Module], PSSecurityException
+ FullyQualifiedErrorId : UnauthorizedAccess,Microsoft.PowerShell.Commands.ImportModuleComman
d

This error means that the AzureRM module downloaded from internet must be signed by a trusted publisher before they can be run.
 

–> Now to fix it you need to change the execution policy by this simple command:

PS c:\> Set-ExecutionPolicy RemoteSigned

If you are on PowerShell Window then it will throw a popup to confirm to change the Execution policy, you can choose “Yes”:

Now try running again the import command, it will run:

PS c:\> Import-Module AzureRM


Powershell error – The term ‘Login-AzureRmAccount’ is not recognized as the name of a cmdlet, function, script file, or operable program


 
If you are new to PowerShell like me then you would have encountered this ans similar errors.

Recently while executing one PowerShell script to connect to Azure Resource Manager I faced following error:

XyzPSScript.ps1 : The term ‘Login-AzureRmAccount’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
+ CategoryInfo : ObjectNotFound: (Login-AzureRmAccount:String) [XyzPSScript.ps1], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException,XyzPSScript.ps1

This error means that you do not have Azure PowerShell module installed on your system or server.
 

–> So, let’s see how to install the dependent modules.
 

1. Connect to PowerShell from command prompt (CMD) in Admin mode:

c:\> powershell.exe

Windows PowerShell
Copyright (C) 2016 Microsoft Corporation. All rights reserved.

 

2. Check the version of PowerShell:

PS c:\> $PSVersionTable.PSVersion

Major Minor Build Revision
—– —– —– ——–
5 1 14409 1005

 

3. Run the below command to check if you have PowerShellGet installed on your system:

PS c:\> Get-Module PowerShellGet -list | Select-Object Name,Version,Path

Name Version Path
—- ——- —-
PowerShellGet 1.0.0.1 C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PowerShellGet.psd1

 

4. Now we can easily install the Azure PowerShell from the PowerShell Gallery by runnign following command:

PS C:\> Install-Module AzureRM

NuGet provider is required to continue
PowerShellGet requires NuGet provider version ‘2.8.5.201’ or newer to interact
with NuGet-based repositories. The NuGet provider must be available in
‘C:\Program Files\PackageManagement\ProviderAssemblies’ or
‘C:\Users\essensed\AppData\Local\PackageManagement\ProviderAssemblies’. You can
also install the NuGet provider by running ‘Install-PackageProvider -Name
NuGet -MinimumVersion 2.8.5.201 -Force’. Do you want PowerShellGet to install
and import the NuGet provider now?
[Y] Yes [N] No [S] Suspend [?] Help (default is “Y”): Y

Untrusted repository
You are installing the modules from an untrusted repository. If you trust this
repository, change its InstallationPolicy value by running the Set-PSRepository
cmdlet. Are you sure you want to install the modules from ‘PSGallery’?
[Y] Yes [A] Yes to All [N] No [L] No to All [S] Suspend [?] Help
(default is “N”):Y

On every prompt type ‘Y’ to proceed ahead.

While Installing the module you will see this screen:

5. Finally you just need to import the AzureRM module:

PS C:\> Import-Module AzureRM

This import command will not give any output, and you may proceed with the PS prompt.


Error – The following feature couldn’t be installed – .NET Framework 3.5


 
I got error this message on a pop window while running a new application after installing it on my Windows Server 2012 Azure VM.


 

This feature can be installed from the “Windows Server Manager”, you will see its icon on the task bar besides the Start button, as shown below. Or you can directly type “servermanager” on CMD or Run prompt.

Click on the “Add Roles and Features”


 

A new window will open up “Add Roles and Features Wizard”, click Next.
On “Installation Type”, click Next again.
On “Server Selection”, select the current/default server and click Next.
On “Server Roles” click Next.
Now on Features select the “.NET Framework 3.5 Features” option, an click Next.
On Confirmation page you will see “Specify an alternate source path” link, click on that link, and a new window opens up, as shown below:


 

Here on the highlighted text box you need to specify the “side-by-side (SxS) folder” path of the OS installation media. So, if you have an ISO file you can mount it or if you have a dump of the setup, provide the path form the respective location. Finally click on Install button.
 

If you are on an Azure Windows VM, you will not have access to the ISO or installation media. In this case you can simply run a Windows Update from Control Panel–> System and Security –> Windows Update.


Categories: MS.net, Windows

Microsoft hosts its first-ever Accessibility Summit in India to enhance technology access for people with disabilities


 
Continues its efforts to bridge technology divide and drive digital inclusion to empower people to achieve more


(From L-R)

Dr. Jitender Aggarwal, Founder & CEO Sarthak Educational Trust, Shri M. Jagadeeshwar, IAS, Department of Women and Child Development, Government of Telangana,

Shri Navreet Kang, Secretary, Department of Empowerment of Persons with Disabilities, Ministry of Social Justice and Empowerment, Government of India,

Shri Jayesh Ranjan, IT Secretary, Department of IT, Electronics & Communication, Government of Telangana,

Madhu Khatri, Associate General Counsel and Accessibility Lead, Microsoft India

… at the first-ever Microsoft Accessibility Summit in India that is focused on enhancing technology access for people with disabilities.
 

Hyderabad, 30 May 2017: Microsoft India today hosted its first-ever Accessibility Summit (#ThinkAccessAbility) in the country to enhance technology access for people with disabilities. The summit aimed at demonstrating the business value of accessible technology for organizations, the need for a collaborative effort as well as assessing policy’s role in creating an accessible India. The summit brought together leaders from the government, non-profit organizations, filmmakers, entrepreneurs and budding technologists to present their views and best practices around accessibility and technology’s potential in aiding inclusion.
 

Shri Navreet Kang, Secretary, Department of Empowerment of Persons with Disabilities, Ministry of Social Justice and Empowerment, Government of India said, “We believe that inclusion of persons with disabilities is imperative for India’s growth. It is therefore, critical that we empower them with equal access and opportunity. We look forward to public-private partnerships that can enable better social inclusion and help people with disabilities achieve more.”
 

Speaking at the summit, Shri Jayesh Ranjan, IT Secretary, Department of IT, Electronics & Communication, Government of Telangana said, “Our vision is to ensure that persons with diverse abilities have equal access to the physical environment, transportation, information and communication technologies, and to other facilities and services. The Microsoft Accessibility Summit provides an ideal platform to bring together policymakers and influencers to understand the policy environment and chart a direction for making life, experiences and opportunities accessible to all.”
 

A platform to discuss, imagine and bring new perspectives for innovative use of technology
Through a series of constructive sessions, the conference focused on the role of technology in creating accessible businesses, scalable and sustainable models for skilling youth with disability. It also examined how assistive technologies can help in treating Autism Spectrum Disorders and Special Learning Disabilities (SLD). There was a special focus on the need for regulatory policies for innovation on accessible technologies and inclusive hiring practices. These interactions also provided insights into regulations, specifications and standards in terms of accessibility along with an understanding of optimization of existing hardware and software configuration to drive accessibility. Shri M. Jagadeeshwar, IAS, Department of Women and Child Development, Government of Telangana also contributed to the discussions as part of the summit.
 

Technology innovations for driving accessibility
The summit featured unique technology-based projects that empower people with disabilities. These included innovations from non-profit organizations, assistive technologies developed by Microsoft partners as well as Microsoft solutions. A young team of three students from IIT Kharagpur showcased White Cane, a personal assistant device for the visually impaired, which they have developed as part of Microsoft Imagine Cup.
 

According to Dr. Jitender Aggarwal, Founder & CEO Sarthak Educational Trust, “Accessibility is one of the dire necessities for creating an inclusive environment. The difference between the able bodied and disabled is not so much because of physical challenges, as due to the fact that everything around us is designed from the perspective of able bodied people only. In such a scenario, accessible and adaptive technologies act as a support system to promote inclusion and empowerment of persons with disabilities.”
 

Speaking at the conference, Madhu Khatri, Associate General Counsel and Accessibility Lead, Microsoft India said, “At Microsoft we believe there are no limits to what people can achieve when technology reflects the diversity of everyone who uses it. We are committed to transparency, accountability, and inclusion in our products and our culture, and we are deeply inspired by the opportunity to work with others around the world to explore what’s possible. A market-driven ecosystem is the best environment for encouraging greater accessibility for all users. The Summit is a significant step forward in advancing our efforts towards sensitizing stakeholders and partners on the need for the business and social value of accessibility.”
 

Please find more information to Microsoft’s approach to accessibility on Microsoft Accessibility Website and see Microsoft India’s video on Empowering for Inclusion.
 

About Microsoft India
Founded in 1975, Microsoft (Nasdaq “MSFT” @microsoft) is the leading platform and productivity company for the mobile-first, cloud-first world, and its mission is to empower every person and every organization on the planet to achieve more. Microsoft set up its India operations in 1990. Today, Microsoft entities in India have over 8,000 employees, engaged in sales and marketing, research and development and customer services and support, across 11 Indian cities – Ahmedabad, Bangalore, Chennai, New Delhi, Gurugram, Noida, Hyderabad, Kochi, Kolkata, Mumbai and Pune. Microsoft offers its global cloud services from local datacenters to accelerate digital transformation across Indian start-ups, businesses, and government agencies. In 2016, Microsoft opened one of its eight Cyber Security Engagement Centers in the country, to address security needs of both public and private sectors.
 

For further information, contact
Anindita Phukan
Microsoft Corporation India Pvt. Ltd.
Email: Anindita.phukan@microsoft.com
+919811402847

Dhairya Chaudhry
Edelman India
dhairya.chaudhry@edelman.com
+9199689 84563
 

FOR MORE INFORMATION:
Microsoft India news: http://news.microsoft.com/en-in/
Log onto: http://microsoft.com/india/news
Follow us on: Twitter | Facebook


Categories: Microsoft