On different server?

HI All,
Currently we have two servers in our poduction farm. One runs
sharepoint and the other is the database server. Can i install
reporting services o nthe sharepoint server and tell it point to the
database server? Right now I have it installed the db server, but
would like to move it to the other server.
Any ideas
Thanks!
-SJOn Jul 5, 9:25 am, SJ <sjour...@.gmail.com> wrote:
> HI All,
> Currently we have two servers in our poduction farm. One runs
> sharepoint and the other is the database server. Can i install
> reporting services o nthe sharepoint server and tell it point to the
> database server? Right now I have it installed the db server, but
> would like to move it to the other server.
> Any ideas
> Thanks!
> -SJ
SJ,
Yes, you can install it on the sharepoint server and point it to the
DB server. During installation it will ask you the location of the DB
server.|||Yes, you can install Reporting Services on a computer without SQL Server
installed (as long as it has access to a SQL Server to store its meta data).
However, you need a SQL Server license for the computer where Reporting
Service runs.
"SJ" <sjourdan@.gmail.com> wrote in message
news:1183652738.671128.102340@.n60g2000hse.googlegroups.com...
> HI All,
> Currently we have two servers in our poduction farm. One runs
> sharepoint and the other is the database server. Can i install
> reporting services o nthe sharepoint server and tell it point to the
> database server? Right now I have it installed the db server, but
> would like to move it to the other server.
> Any ideas
> Thanks!
> -SJ
>|||On Jul 5, 1:38 pm, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> Yes, you can install Reporting Services on a computer without SQL Server
> installed (as long as it has access to a SQL Server to store its meta data).
> However, you need a SQL Server license for the computer where Reporting
> Service runs.
> "SJ" <sjour...@.gmail.com> wrote in message
> news:1183652738.671128.102340@.n60g2000hse.googlegroups.com...
>
> > HI All,
> > Currently we have two servers in our poduction farm. One runs
> > sharepoint and the other is the database server. Can i install
> > reporting services o nthe sharepoint server and tell it point to the
> > database server? Right now I have it installed the db server, but
> > would like to move it to the other server.
> > Any ideas
> > Thanks!
> > -SJ- Hide quoted text -
> - Show quoted text -
Thank you both for the reply's I reall appreciate it!
-SJ

old sql2k5 folder

I have remove the existing sql 2k5server db by "remove/add program" and the
install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
server folder and within. But it gives me an error saying it is in used ...
and therefore I cannot remove it. Can anyone please advise me how to remove
this folder? I thought the old folder is not used by any program after I
re-install a new ms sql server. Please help. Thanks.Hi,
have a look in the registry and search for the absolute path of the old
installation. There might be some logs which be flushed to the old
location.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Can anyone please help? Thanks
"00MichaelJordan" <MJ@.yahoo.com> wrote in message
news:ObrvrOfOHHA.4940@.TK2MSFTNGP03.phx.gbl...
>I have remove the existing sql 2k5server db by "remove/add program" and the
>install a new sql2k5 in another folder. Now I tried to remove the old MS
>SQL server folder and within. But it gives me an error saying it is in used
>... and therefore I cannot remove it. Can anyone please advise me how to
>remove this folder? I thought the old folder is not used by any program
>after I re-install a new ms sql server. Please help. Thanks.
>|||You need to see what process still has this folder open. When I'm
*desperate* I use this program:
http://ccollomb.free.fr/unlocker/
It will tell you what's using the file and will let you "force" it
closed, allowing you to delete it. Hopefully SQL Server will not be
using it. Try not to force-delete these things. See what program is
using the file first, shut it down, then delete the file. Just be
careful not to hose your SQL Server installation ;-)
--
-Dave Markle
http://www.markleconsulting.com/blog
00MichaelJordan wrote:
> I have remove the existing sql 2k5server db by "remove/add program" and the
> install a new sql2k5 in another folder. Now I tried to remove the old MS SQL
> server folder and within. But it gives me an error saying it is in used ...
> and therefore I cannot remove it. Can anyone please advise me how to remove
> this folder? I thought the old folder is not used by any program after I
> re-install a new ms sql server. Please help. Thanks.
>