Search results for query: *

How can I make a copy of an SSRS Report history snaphot to another folder in Report Manager. I have a report that has history snapshots. But want a copy of the report snapshot history in another folder for users to view easier in Report Manager. I would appreciate anyone's help.

Hello I am having Problems Saving VS 2008 analysis services Properties Deployment Options. I configure Dev, Test and Staging Environments on the Properties Deployment configuration page. You get their by right clicking project. You close project and open project again. Right click project and...

My SSIS 2008 R2 package processing 55 excel files successfully in BIDS, but when I run the SSIS pacakge under Sql Serve Agent the job hangs with about 25 excel files processed. I notice their were a 15 excel.exe processes in the Windows Task Manager Processes tab. Does anyone have a solution? I...

I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIS package i get an error. Please let me know if you have any questions. thanks. Error is below: Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL Server...

I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIS package i get an error. Please let me know if you have any questions. thanks. Error is below: Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL Server...

I have a SSIS Package that works in BIDS and it works by double clicking the SSIS package. But when I schedule Job using SSIs package i get an error. Please let me know if you have any questions. thanks. Error is below: Message Executed as user: SCONET\svc_BIGCCPRD84_SSA. Microsoft (R) SQL...

Hello, I keep getting error thrown by connections collection when the specific element is not found in my ssis package. I recreated my connection managers and still the same problem. Problem points to SQLTask:Connection="{293CC3EC-C94E-4F99-8FFA-DE627F0C821C}". Here is the problem in XML below...

Hello anyone, I open up reporting services configuration manager. I click report manager url and a windows security dialogue box displays. when I type credentials it works. But I need to click report manager url and go directly to report manager using IE. I would appreciate anyone's help. Thanks

Hello, My SQL SERVER AGENT 2008 R2 will not start. It was working before I installed active directory. I have the following programs installed on my server. Sharepoint 2010, Visio Services, SQl Server 2008 R2 enterprise edition. This is for your information. I am not getting any specific errors...

Hello, My SQL SERVER AGENT 2008 R2 will not start. It was working before I installed active directory. I have the following programs installed on my server. Sharepoint 2010, Visio Services, SQl Server 2008 R2 enterprise edition. This is for your information. I am not getting any specific errors...

I need help in coding a Login page. The user can only use that current password after 10 iterations of different passwords. Example if my password is dog. I cannot use that passsword again until after 10 other different passwords. I need a starting point with some code. I would appreciate...

Hello. I have a project to sync file system images in 53 directories on our production database server with a new failover Database server on Windows 2008 server. Can I use SQL Server 2008? It would be nice to sync within 15 minutes of each other. Not critical, but would like the best...

When I click on Report Manager URL and click the URL I get the following error: User 'WIN-SE61OJ3F3KA\SSRS' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

I am getting an error Opening SQL Server 2000 DTS Packages using SQL Server 2005 Management Studio. error: operation not supported on version 10.5 I would appreciate anyone's help.

I want to move SQL Server 2000 Linked Servers to SQL Server 2008. What is the best way to move Linked Servers with remote logins and passwords. I would appreciate anyone's help.

What does this mean below. I can't copy a database from sql server 2000 to sql server 2008. I would appreciate anyone's help. The “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’” that occurs when copying a database can be solved by ensuring the ID running the “SQL Server Agent...

I am trying to Copy data and objects from Oracle Database to SQL Server 2008 Database using SQL Server 2008 Managment studio. I am also trying to use BIDS. The dialog box ask OLE DB Provide and I pick Oracle Provider for OLE DB. Then it ask what is server name or file name. What is Server name...

I just installed the SQL server 2008 Enterprise. It said everything installed successfully. When I go to SQL Server Management Studio I can only connect to Database Engine. I cannot even see or connect to analysis services or Integration Services. What is the problem. I tried re-install both the...

Unable to open MSDB node in SQL Server 2005 Management Studio. I get the follwoing error. Login timeout expired An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL...

I get a SSIS error message when trying to open MSDB in management studio. It keeps hanging. I tried modifying the MsDtsSrvr.ini.xml file to <ServerName>.\SQL2005</ServerName>. I restarted sql server 2005 integration services. Still hangs. I would appreciate anyone's help.