• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

PowerShell

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
Peter
Asked:
Peter
  • 2
  • 2
  • 2
2 Solutions
 
als315Commented:
0
 
AnuroopsunddCommented:
at ps prompt.
Import-Module “sqlps” -DisableNameChecking


then you should be able to connect to your sql
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
PeterAuthor Commented:
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
 
als315Commented:
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
 
PeterAuthor Commented:
Thanks. I found the executable in the binn folder and pinned it to my taskbar. It works.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now