I have installed SQL Server 2014. When I start PowerShell on Windows Server 2008 R2 and do the "sqlps" command to test, this error occurs which shows in the image below ...
On another computer, with windows 7 and the same version of SQL Server 2014, it works normally.
How to solve?
Texterror:
"Import-Module: Can not Load Windows PowerShell C: \ Program Files (x86) \ Microsoft SQL Server \ 120 \ Tools \ PowerShell \ Modules \ SQLPS \ Microsoft.SqlServer.Management.PSSnapins.dll because of the following error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. Loader Exceptions: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version = 12.0.0.0, Culture = neutral, PublicKeyToken = 898 45dcd8080cc91 'or one of its dependencies. The system can not find the specified file. Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version = 12.0.0.0, Culture = neutral, PublicKeyToken = 898 45dcd8080cc91 'or one of its dependencies. The system can not find the specified file. Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version = 12.0.0.0, Culture = neutral, PublicKeyToken = 898 45dcd8080cc91 'or one of its dependencies. The system can not find the specified file. Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version = 12.0.0.0, Culture = neutral, PublicKeyToken = 898 45dcd8080cc91 'or one of its dependencies. The system can not find the specified file. At line: 1 char: 14 + import-module
