Solved

PowerShell

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

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

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

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…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

831 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