Connect to SQL reporting server via SQL Management Studio + create database?

Hi,

We have a sql reporting server 2008 (on Windows 2008 server) for SCCM.

I'd like to:
*connect to the server via reporting server client (cannot do that, even when selecting "reporting services"
*create a new database to which I would write (and read) data via Powershell

Please advise.
J.
janhoedtAsked:
Who is Participating?
 
Gaurav SinghSolution ArchitectCommented:
For first one what error are you getting while connecting to reporting services?

new powershell commands are introduced to read / write via SQL

Refer

https://www.mssqltips.com/sqlservertip/4627/new-powershell-cmdlets-to-read-and-write-sql-server-tables/
1
 
janhoedtAuthor Commented:
So should I use reportingserver option then to connect?

Cannot connect to "oursqlservername"
Additional information: report server WMI provider error:
Invalid namespace (Microsoft.SqlServer.Management.UI.RSClient)
Invalid namespace (System.Management)

Thanks for PS commands but they also work from Windows 2012 to WIndows 2008 R2 and SQL 2008 database?
Note that PS is not main concern, main concern is howto create and connect to a database on a SQL reporting server database (is that even possible or advised)?
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.

All Courses

From novice to tech pro — start learning today.