<div>
So should I use reportingserver option then to connect?<br />
<br />
Cannot connect to &quot;oursqlservername&quot;<br />
Additional information: report server WMI provider error:<br />
Invalid namespace (Microsoft.SqlServer.Manag<wbr />ement.UI.R<wbr />SClient)<br />
Invalid namespace (System.Management)<br />
<br />
Thanks for PS commands but they also work from Windows 2012 to WIndows 2008 R2 and SQL 2008 database?<br />
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)?
</div>


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)?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
We have a sql reporting server 2008 (on Windows 2008 server) for SCCM.<br />
<br />
I'd like to:<br />
*connect to the server via reporting server client (cannot do that, even when selecting &quot;reporting services&quot;<br />
*create a new database to which I would write (and read) data via Powershell <br />
<br />
Please advise.<br />
J.
</div>
</div>


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.

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.