Solved

PowerShell

Posted on 2012-04-08
6
540 Views
Last Modified: 2012-06-27
I have Windows 7 Professsional and SQL Server 2008R2 Developer Edition installed on my laptop. I can open up Powershell but cannot log into sql server via the command 'sqlps' at the PS prompt. What gives?
0
Comment
Question by:Peter
  • 2
  • 2
  • 2
6 Comments
 
LVL 40

Expert Comment

by:als315
ID: 37820756
0
 
LVL 17

Assisted Solution

by:Anuroopsundd
Anuroopsundd earned 50 total points
ID: 37820784
at ps prompt.
Import-Module “sqlps” -DisableNameChecking


then you should be able to connect to your sql
0
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37820787
0
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

 

Author Comment

by:Peter
ID: 37827986
All comments pertain to SQL SRV 2012; I have 2008R2.
However, I did try all suggestions and got error messages; see attached screenshots.
The Database Journal directions did not let me complete because I have 2008.
sqlps.PNG
sqlps2.PNG
0
 
LVL 40

Accepted Solution

by:
als315 earned 450 total points
ID: 37831190
There are different implementations of sqlps. You have sqlps.exe (in binn folder of SQL installed) in pre SQL 2012. It can't be run from powershell. It is so-called minishell (Powershell with integrated SQL commandlets).
You can run it directly from command prompt.
In SQL 2012 you can download it and import it into standard powershell. I hope you can use it also with SQL 2008.
0
 

Author Closing Comment

by:Peter
ID: 37833106
Thanks. I found the executable in the binn folder and pinned it to my taskbar. It works.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
No single Antivirus application (despite claims by manufacturers) will catch or protect you from all Virus / Malware or Spyware threats. That doesn't stop you from further protecting yourself however - and this article is to show you how.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question