Solved

PowerShell

Posted on 2012-04-08
6
551 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Limited time offer using promo code EXPERTS25

Designed with a wealth of functionality and convenience, ATEN's new Thunderbolt™ 2 Sharing Switch takes your Thunderbolt setup to the next level. Now through August 31, 2017, Experts Exchange members get 25% off the US7220 on the ATEN USA eShop using promo code EXPERTS25.

 

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
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.

622 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