2
I have installed SQL Server 2014. When starting Powershell in Windows Server 2008 R2 and I do the command "sqlps" to test, happens this error that shows in the image below...
NOTE: On another computer, with windows 7 and same version SQL Server 2014, works normally.
How to solve?
Text error:
"Import-Module : Cannot load Windows Powershell snap-in 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 cannot find the file specified. 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 cannot find the file specified. 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 cannot find the file specified. 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 cannot find the file specified. At line:1 char:14 + import-module <<<< SQLPS -Disablenamechecking + Categoryinfo : Resourceunavailable: (:) [Import-Module], Pssnapinexception + Fullyqualifiederrorid : Pssnapinloadfailure,Microsoft.PowerShell.Commands.Importmodulecommand"
try Windows Server 2012
– Thiago Friedman
Avoid the use of images to represent errors or codes, readers, crawlers and searchers (including Sopt itself). Do not paste code and error images, use Ctrl+C to copy real texts, this makes it easy to search.
– Guilherme Nascimento