Solved

PowerShell

Posted on 2012-04-08
6
518 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 39

Expert Comment

by:als315
Comment Utility
0
 
LVL 17

Assisted Solution

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


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

Expert Comment

by:Anuroopsundd
Comment Utility
0
The problems with reply email signatures

Do you wish that you could place an email signature under a reply? Well, unfortunately, you can't. That great Exchange/Office 365 signature you've created will just appear at the bottom of an email chain. What a pain! Is there really no way to solve this? Well, there might be...

 

Author Comment

by:Peter
Comment Utility
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 39

Accepted Solution

by:
als315 earned 450 total points
Comment Utility
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
Comment Utility
Thanks. I found the executable in the binn folder and pinned it to my taskbar. It works.
0

Featured Post

Why spend so long doing email signature updates?

Do you spend loads of your time carrying out email signature updates? Not very interesting are they? Don’t let signature updates get you down. Let Exclaimer Cloud - Signatures for Office 365 make managing email signatures a breeze.

Join & Write a Comment

Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup". After a while, you have entered a loop for Auto repair which does not fix anything and you will be in a  panic as all your work w…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
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.

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now