Hi
I am new to the sql server, we need to move the database from one server to another from developer's edition to standard edition of sql server 2005. it has the reproting services and lot of reporting service jobs are running on the server now. we need to move all those jobs also to the new server. could some body help me on how to move the database and reporting services jobs to the another server. Thanks!
We are moving to a new data center. We have RS install on appweb server that points to different sql server for Reportserver and Reportservertempdb. So, We created a new virtual appweb server and new physical database sql server 2008 r2 at new DC. I did a fresh install of new reporting services 2008 r2 on appweb server. I backed up and restored Reportserver and reportservertempdb dbs from old 2005 sql server to new 2008 r2 database server.
During new RS configuration, I pointed databases to the new restored databases and restored encryption keys. When launched reporting services URL, it works fine.
I stopped and restarted reporting services after configuration.
However, I am not seeing any single job created on new database server. Old server had 20 jobs.
How do I get these subscriptions back to the new install? I thought this should be created with migration and I do not have to do anything.
One odd thing I had to do during config was that:
In scale-out deployment tab in RS configuration, it was showing both the new and old appweb server name as status joined. I was unable to remove the old server name by clicking 'remove server' there. So, I deleted old server name from keys table in Reportsserver as suggested by some forums to have a clean installation. Does it have anything to do with jobs not created?
What do I need to do now to get subscripts jobs created. Ther eare only 20 jobs here but another RS server has over 800 subscriptions that I can not mess up. So, need to find the issue and correct it before I can move on to the another RS instance.
Hi,
I have to move my SQL server data from win95 to NT.
When it comes to databases I would execute attach option.
When it comes to backup devices I think I could simply copy the folder where
backup devices are being located? IS it true??
How about moving jobs; DTS and Database Maintenance Plans???
Any Ideas??
Thanks,
Andy
Hi ,
I need to move databases and related jobs from one server to another.
I can move the database no problem. how can I get jobs moving.
Pls help me
Sunthar
Our users tend to generate a lot of one-time reports through Reporting Services. The problem is that this seems to generate a lot of Jobs in SQL Agent. So many, in fact, that we'd like to set up a job to delete them periodically (nightly or weekly). I could go in & delete them through SS Management Studio but I'd like to manage it automatically. Let me state up front that I have limited experience with Reporting Services so if my questions seem basic, forgive me.
First, is there a way to avoid creating a SQL Agent job if this is a non-scheduled report? That would be optimal then there would be nothing to clean up.
Barring that, what's the "Best Practice" for doing this automatically? I found the jobs listed in msdb.dbo.sysjobs and other sysjob* tables. Is it reasonable for me to delete from these various tables (sysjobs, sysjobactivity, sysjobhistory, sysjobschedules, sysjobsteps, & sysjobstepslogs) if the job was generated by reporting services (i.e. sysjobs.description containing 'report server process') and no schedule exists (i.e. sysjobactivity.next_scheduled_run_date IS NULL)? What damage could this cause? Is there anything else I need to take into account?
Thanks,
Pat Brickson
Hi,
I have some questions about moving the reporting services. I need to move the reporting services from one server to another server in production. some body already installed the reporting services in production server, I moved the reporting services to the production server from the other server using the backup file. after that I tried to initialize using the reporting services configuration tool but every thing in the left side are turned to green except the initialize thing. it is just grey and i am not able to connect to reporting services, when I tried to initialize it is saying the user doesn't have the permission to connect to the reporting services. I posted before I had lot of suggestions but it does'nt work. Thank you very much for your support. Any body have any idea about this issue.
I have a requirement for a side by side upgrade of an instance from SQL 2008 to SQL 2014. There are reporting services configured. How to I properly migrate and configure the reporting piece on new SQL 2014 instance?
View 4 Replies View RelatedWe will making a change to our Reporting Services deployment next month. We will be moving from our SQL 2000 server to a new SQL 2005 server. In addition, we will moving from a Local Catalog Deployment to a Remote Catalog Deployment. My question is this: Is there a way I can prevent my team from having to manually redeploy our reports in the new system? They have not been diligent about saving the Visual Studio solution or project files, so they will have to pull the most up-to-date RDL's off the server and deploy them on the new server one by one.
I suppose I can install SQL 2000 on the new server first, then move the Reporting Services databases to the new server, then upgrade the server to 2005, but installing 2000 and upgrading to 2005 does not sound like a best practice. I would prefer a clean install of 2005. Does anyone know if I can move the deployed reports from one server to another?
Paul Teal
paul@partytilyoupop.com
Using the "move" command it's possible to relocate e.g. datasources without negatively impacting reports that use them. We've got some folders where users have uploaded images for reuse in several reports as external images (2008 R2).
Now I'm trying to consolidate these folders. Yet it seems, moving images will not update the reports that use them as it happens with datasource. Instead, the link to the image breaks.
Is there a way to move the images and telling the reports that reference them that I did so?
Some textbox are great moving, and need to when the box above gets extra data.. but how do a stop one from moving? make it stay right where I put it.
A stays where it is... for some reason. but B doesnt? it moves down according the textboxes to the left (where is says phone) ...
I am actually the MOM administrator and only know enough SQL 2005 to keep mom working....sometimes I noticed on my dev mom box that SQL server agent has a lot of jobs configured to run against the mom onepoint database. The production box does not have these jobs. What would be the simplest way to export these jobs so that i can import them on the production box. Any help would be appreciated.
View 1 Replies View RelatedHi,
I am moving DBs from one server(say Server A) to other (say server B) & once everything moved i will rename the Server B to Server A.
-I am backing up from .bak file & .trn file.
Now, i am confused here..
How to trasnfer all jobs running on server A to server B?
I am really novice to DTS.
If some one can throw somelight on that,that will really helpfull for me.
With Regards.
Wasim
Hello,
We want the reporting tool to be integrated with visual studio 2005. From my understanding SQL reporting services 2000 can be integrated only with visual studio 2003 (Please correct me if I am wrong) . Hence we have decided to go for SQL reporting services 2005
I understand that SQL reporting services 2005 can be used with SQL server 2000 database. I want to know if SQL reporting services 2005 and SQL server 2000 database are on a single machine, would a single license for SQL server 2000 suffice or should we have a license for sql server 2005 (since we use SQL reporting services 2005) as well.
Many thanks in advance,
Vaneeth
I've got reporting services on a different box from the database and I can see all the reports, but when I try to setup a subscription, I get this weird error:
The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding)
The same error happens when I connect to the database server via management studio and try to run a job.
I can confirm that SQL Agent service is running.
We migrated ssrs from 2008 to ssrs 2014.after that we need to move only subscriptions to  New 2014 report server DB.
How to proceed that.
I am trying to insert record in DB. But subscription ID is not identity column. How to do this.
Can I place old Subscription IDS in New 2014 reporting DB?
Is there any way to deploy reports to a Report Manager in SQL Server Reporting Services 2005 if the reports query SQL Server 2000 databases? Or are only 2005 databases able to deploy to the web?
Also, if I have a report that queries both, can I deploy it to the web on the 2005 Report Manager with a linked server to the 2000 server?
Hi boys and girls, I am a total newbie to ms sql. So please be gentle.
I have a ms sql database on one server but I need a duplicate of the ms sql database on another server with all packages and jobs duplicated on the new server.
I was able to export the database over to the new database on the new server no problems there.
The problem is under DTS I have "local packages" that all need to be moved to the new server. I am able to export them into my computer. But on the new server there is no import for the local packages. How do I get these packages onto the new server into my server's ms sql???
Also under the management and sql agent manager, there are jobs that are on the old db, that I need to go to the new server in ms sql.
Any help at all would be appreciated!!!
Thanks!!!
When i try to restore the encrypt key to reporting service getting the below error.The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is '147'. The expected version is 'C.0.9.45'I found the table in Database  called DBUpgrdaeHistory
UpgradeID DBVersion
Datetime
31 147 Â Â Â Â Â
[code]...
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni
View 4 Replies View RelatedI'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)
The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
Justin Song
Hi While we are migrating Access Database to SQL Server, we would like to keep the Access Database running on schedule in steps until we migrate everything in SQL Server. I have created a SQL Server Job under “Operating System Command (CmdExec)� and in command, pointed where the Access Database is located.
I have created this job as an Admin, so admin has full rights. But when I run this job it does not execute Access Database and gives an error. Following (under dotted line) is the error from Event Log.…………………………………………………..Event Type: WarningEvent Source: SQLSERVERAGENTEvent Category: Job Engine Event ID: 208Date: 11/21/2006Time: 9:15:53 AMUser: N/AComputer: SqlServer01Description:SQL Server Scheduled Job 'Test' (0x86BC5A6881DF1E48BF270E6513B2A0DD) - Status: Failed - Invoked on: 2006-11-21 09:15:51 - Message: The job failed. The Job was invoked by User admin. The last step to run was step 1 (test).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.……………………………………………………
I had replaced access database with some exe file then ran the job. Job ran fine. Why SQL Server job is not able to execute Access Database?
Note: SQL Server has Access Database installed.
Please let me know. I know this is not a very common situation but this is also an option available to utilize.
ThanksRashid
I am trying to move a database which I wrote in SQL Server 2005 to a SQL Server 2000 database.
I'm not sure the best way to do this.......
Can anyone enlighten me?.....
I want to schedule a database backup using SQL Server Agent Jobs how can i do this?
View 1 Replies View RelatedI have a SQL Server 2005 Express database on my local machince called OpenAssess.mdf. The server we host with has a file extension of .mdb. How can I go about getting my database to the server? I tried changing the extension to mdb on the local machine but then it tried opening the database in MS Access and didn't work. I just need to connect to the database in my web pages. Here is my connection string and then the error which is visible at the botton of openassessment.org.
*********************************************connection string*************************************************
OPEN_Conn = "Provider=SQLOLEDB;Data Source=connectionToHostServer;Network Library=DBMSSOCN;Initial Catalog=OpenAssess.mdb;User ID=myuserid;Password=mypassword"
*****************************************************error*********************************************************
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database requested in login 'OpenAssess.mdb'. Login fails.
hi guys
i got few questions. i need to move a databases from old server to new server. old server has 25 user databases total datafile around 300GB. heres the questions.
1. what is the fastest way to move all the data to new server? and what's the best way to do it? (DTS? MDF copy over/attach? bak copy over/restore? other theres other way?)
2. i got alot of job and user need to transfer over. i know DTS can do the user.. how about the jobs?
3. do i need to move the master and msdb over too?
4. beside all 3 questions above... do i miss anything that need to be move too?
Thanks guys!!!!!!!!
Hi,
I have a database that resides on a server that`s become too old. It spans
2 devices that sit on 2 different drive letters - D: and E:.
I bought a new server, installed and configured NT4.0 and SQL6.5.
Initially I restored the database to the new server from a dump .It worked
fine, however all the login information was lost. Then I tried partitioning
the new server the same way as the old one and copying all the DAT files
over. Thus I was hoping to retain the information contained in the MASTER.DAT,
drop the database, repartition to create 1 physical drivewith 1 database device,
and restore from a dump to it.
After copying the DATs, though, SQL Server would not start.
Help Please!
I am not a SQL person. I want to copy/move a SQL datbase from old server to a new server and eventualy bring the old server down. What is the procedure to do it. Thanks in advance.
Navid
Hi all. I know that since you know nothing about my database it will
be a stretch to answer this - but does anyone have a boiler plate
checklist for moving a database, dts packages, agent jobs, etc...from
one server to another? Maybe something that just says I should at
least do x,y,z.
Also if anyone out there has any hard won experience/advice about
gotchas when doing this I would love to hear it. We have outgrown a
server and are installing a new one this week that we need to move
over to.
Thanks!
Sql Server 2000 is running on machine havivng two HDD. The HDD where SQL Server resides is reaching capacity. Only 3Gb is remaining. I want to move SQL Server database to other hard drive so that space problem would not occure. How to do it?
View 1 Replies View Relatedi need help moving a database to a new server.
I have an existing database on a Windows XP Pro box running MS SQL Server Desktop Engine 8.00.
I want to move this database to another machine running Windows Server 2003 Small Business Server w/full SQL Server (new edition).
I can see the database, and the directory structures are almost identical on both machines. But when I simply copy the data over nothing works. Obviously to me I must somehow back up the original database and restore it somehow on the new machine.
Any tips on where I begin? I have done searches in the Microsoft Knowledgebase for articles on how to backup and restore from one type SQL to another with frustrating results. No clear directions.
Thanks!
Hello,
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?
Any help is appreciated
I started my Reporting Server and if I use the Internet Explorer as a Administrator everything works fine.But if I don't open it as an admin it calls "rsAccess Denied The user [...] does not have the permission...".Problem is that I want to run it in an SAP Program with an HTML Viewer. how I can get those Permissions ?By the way somehow I'm not able to create or change roles in the Microsoft SQL Server Management Studio.
View 5 Replies View RelatedHello Everyone. I recently installed MS Sql Server 2005 and Reporting services on a dedicated server. My report server database and my content databases (report content) are all mounted on a named instance of SQL (on the local machine). When I attempt to run a report via the web based report manager I get the following error message.
An error has occurred during report processing.
Cannot create a connection to data source 'Production'.
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.
The data source production has a connection string with the Data Source element set to the named instance of SQL running on the local machine. The report manager web application is also running on the same machine.
All databases are on the local machine (SERVER217MSSQL2K5WG). The version of reporting services installed is what shipped with the Workgroup edition of SQL Server 2005. Does anyone know what could be causing this error? I can assure you all of the data is on the local machine.
Thanks in advance,
Beau