Showing posts with label reinstall. Show all posts
Showing posts with label reinstall. Show all posts

Monday, March 12, 2012

move report server to new machine

Can someone tell me how I can move report server web sites into a new machine without reinstall it?

I like to keep the current report server database intact, it’s residing on a third server.

I copied the report server file folders including bin (dlls) into the new machine and set up in the new machine the Reportserver and Reports web sites pointing to these two folders while keeping the report server database still residing on the third machine, but the new site did not work, I got "Event source Report Server does not exist. (rsEventLogSourceNotFound)" error

Any advice will be greatly appreciated.

Thanks

Jerry

Well, the short answer is you can't. :) You'll need to install RS on the new machne. Licensing requires that if your RS and SQL are on different machines, you will need a seperate license for each.|||

Thanks James.

Well my next quest is: when I install RS on new machine with the license, I think I should install the new RS database on the same SQL server/database as the old RS server does, then will the newly installed RS DB overwrite the existing RS DB? or it will just makes use it without change anything in it?

Thanks a lot!

Jerry

|||It will never overwrite your RS database. Since you are doing a RS only install, you will only be able to use the "files-only" option (you will see this in the installation wizard). Post-install, you need to use the configuration tool to either create the RS databases, or set RS to connect to your old databases. The decision is up to you, but you will need to do it manually.|||Thanks a lot James, I will try.

Friday, March 9, 2012

Move logins with passwords

Hello!
I will reinstall my server who has SQL server 2000, containing a few
databases with logins.
Which is the easiest way to store these on disk and when I have reinstalled
my server, add these to SQL again, hopefully containing passwords as well.
Regards Magnushttp://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly
SQL Server MVP
"MB" <magnus.blomberg@.skanska.se> wrote in message
news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> Hello!
> I will reinstall my server who has SQL server 2000, containing a few
> databases with logins.
> Which is the easiest way to store these on disk and when I have
reinstalled
> my server, add these to SQL again, hopefully containing passwords as well.
> Regards Magnus
>|||Thank you. It helped
Regards Magnus
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OtBdL4w9DHA.1636@.TK2MSFTNGP12.phx.gbl...
> http://www.support.microsoft.com/?id=314546 Moving DB's between
Servers
> http://www.support.microsoft.com/?id=224071 Moving SQL Server
Databases
> to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465 Using WITH MOVE in a
> Restore
> http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
> Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a
> Restore
> http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
> users
> http://www.support.microsoft.com/?id=168001 User Logon and/or
Permission
> Errors After Restoring Dump
> http://www.support.microsoft.com/?id=240872 How to Resolve Permission
> Issues When a Database Is Moved Between SQL Servers
> http://www.sqlservercentral.com/scr...sp?scriptid=599
> Restoring a .mdf
> http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
> for SQL Server
>
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "MB" <magnus.blomberg@.skanska.se> wrote in message
> news:%23Qq4wnw9DHA.2404@.TK2MSFTNGP12.phx.gbl...
> reinstalled
well.
>