Problems In Changing Windows Service Identity In Configuration Manager

Aug 1, 2007



Hi all,

I have installed SQL Server 2005 Express Edition with Advanced Services and also Toolkit in my system. Following which I cofigured the Reporting Services Configuration.

When I try http://localhost/Reports it throws the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help






The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)


Bad Data. (Exception from HRESULT: 0x80090005)

---------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have tried to search exhaustively for the solution and nothing seems to be crystal clear in solving the above error.

Under Reporting Services Configuraiton Manager (RSCM) all are ticked excepting:
Initialization, SharePoint Integration,Encryption Keys, EMail Settings,Execution Account.

Before this unknowingly I have changed "Windows Service Identity" during configuration which is not the same as Web Service Identity. Under "Web Service Identity" ASP.Net Service Account is listed as <machinename>ASPNET.

Now under "Windows Service Identity" it is selected to "Windows Account" : homequinn. After reading the installation steps it is suggested to have it with "Buil-in Account" ->"Network Services" is recommended. When I try to change it asks me for password and key file. Once I provide it, it is throwing me the following error.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

Can someone tell how should I proceed to get the reporting services working.


View 3 Replies


ADVERTISEMENT

Unable To Open Windows Service Identity Panel In Reporting Services Configuration Manager

Jul 4, 2007

Hi,



I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:



" Reporting Services Configuration Manager:



There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:



InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.

Parameter name: SelectedIndex "



I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.



Any ideas as to what it is doing and how I should go about fixing it?



Sim

View 4 Replies View Related

Changing Connection Manager Provider In Package Configuration

Nov 6, 2007

I originally developed SSIS packages with the destination DB to be SQL Server 2005 for unit testing on my desktop. We are planning on deploying to Oracle. After changing the Provider and other attributes in the configuration file the package loads, however there are lots of issues. The primary one is that the mappings are gone. I'm not sure if that is the result of how the table names are stored "Oracle"."File" versus [SQLSERVER].[File] . Even after attempting to change the way the table names appear I still get the message "the external metadata column is out of sync with the data source columns". Then it lists all of the columns that need to be added.

Is there any way to accomplish this that you are aware of.

Thanks

John Shaening

View 7 Replies View Related

Configure Report Server From Reporting Service Configuration Manager

Jan 25, 2008

When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace

What is the problem and how to solve it.

View 1 Replies View Related

SQL Configuration Manager And SQL Server Surface Area Configuration Tools

May 2, 2007

I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.

===================================



The following components are installed on this server

DEV

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Reporting Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

QA

Analysis Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Database Engine

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Common components

Integration Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Notification Services

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

Workstation Components

[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]

===================================

View 1 Replies View Related

Configuration Manager - Which Configuration Type To Chose ?

Jan 14, 2006

It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.

Is this the preferable way of doing it ? I would like to hear some positive/negative comment of why chosing a configuration type instead of another.

It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)

Let's have some comments

View 3 Replies View Related

Package Execution Fails In Windows Service But Runs Fine As A Windows Application.

Jun 23, 2006

I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.

The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.

Again, the app will run all packages just fine. The data is imported and the results return as "Success."

The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)

Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult

pkgLocation = sPackageFolder & PackageName & ".dtsx"

pkg = app.LoadPackage(pkgLocation, Nothing)

Dim vars As Variables = pkg.Variables

vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath

pkgResults = pkg.Execute()

View 3 Replies View Related

Problems Running Enterprise Manager And Service Manager

Jul 20, 2005

On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF

View 2 Replies View Related

Help! Enterprise Manager Turns SQL Server Service Manager Off

Dec 6, 2006

IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.

View 2 Replies View Related

Does The SSRS Web Service And Windows Service Share A Common Engine?

Sep 27, 2007

All,

I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.

My question is:

Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?

Any help is greatly appreciated!

Mark

View 4 Replies View Related

Changing Cluster Configuration

Oct 17, 2006

In a two node cluster, is it possible to change from a Active-Passive configuration to Active-Active without completely reinstalling?

Thanks

View 1 Replies View Related

Dynamically Changing Configuration File Path

Apr 30, 2008

Before I launch into a long description of the issue, I was wondering whether its possible to dynamically amend the file path held in a configuration string? (I'm looking at the Package Configurations Organizer)

Basically recreating the /CONF switch in the dtexec utility

So a parent package could somehow tell a child package to pull its configuration from a selection of different xml config files at run time... I couldn't see a variable in the child package to set from the former

My only idea at the moment is to replace the Execute Package Task with an Execute Process Task, and directly invoke the child using dtexec & an expression to dynamically set the /CONF switch..

thanks

James

View 3 Replies View Related

Configuration Manager ?

Apr 12, 2006

Each time you start a SSIS project you have Solutions Configuration showing "Development". In the drop down box you can select "Configuration Manager..."

Can someone tell me the use of this, and is it related to the package configurations somehow. I've tried to create new Solution Configurations like "Test" and "Production" with the purpose of binding different configuration files and deplymentfolders to each Solution Configuration but still it seems like this isn't the way i should be used...

View 4 Replies View Related

Changing Identity Column Value

Jul 30, 2007

Hi. Is there a way to remove a gap between identity column values? Some records were deleted and now we have identity column values that jump all over the place.

View 4 Replies View Related

SQL Server Configuration Manager

Apr 27, 2006

I have an application ready to transfer to the web hosting server with MS SQL 2005.
Database and tables were created with the VWD on the local machine (SQLEXPRESS).
I am using MS SQL Server Managenemt Studio Express to create the SQL to add the local tabales and data to the hosting database.
My connect to the hosting server is great.
Problem: My connection to SQLEPRESS is good but it only allows me to map Database from this directory C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. I need to map to another directory as follows  C:Documents and SettingsdflournoyMy DocumentsVisual Studio 2005WebSitescolumbushapps/app_data.  So I can get to the tables I created locally.
Also has someone put together a process to migrate from SQLEXPRESS (Local) to Remote or Production SQL 2005 or 2000.

View 3 Replies View Related

SQL Server Configuration Manager

Jun 6, 2008

For some reason, when opening up the SQL Server Configuration Manager for one of my SQL Servers, the 'Requesting data from WMI provider..' message stays there. It never gets the data. This is in regards to services management. Its not a big deal, because I can log on to the server to accomplish this, but it would be nice to do it from SSMS. It works for other SQL Servers. Has anyone experienced this before?

View 4 Replies View Related

Ql Server Configuration Manager

May 25, 2007

Guys,

can you guys pls let me know how do you access sql server configuration manager from command line?

Thanks

View 1 Replies View Related

Report Manager Configuration

May 2, 2007

We deployed Reporting Services recently to a customer with a latest release and build. When they type in http://<server>/ReportServer, this just comes up with a screen like a navigation sreen showing folders and links to reports. What needs to be done to get the Report Manager screen showing?



It has been a while since I actually installed Reporting Services. When they go into configuration, all of the green checks are there (except for Web Service Identity, which is Red).



Thanks for any information.

View 1 Replies View Related

Sql Exp Configuration Manager MMC Problem

May 7, 2007

Hi,



I've had weeks trying to establish connections between my PC and Small Business Server 2003 running SqlExpress. Finally sorted out the problem, and wanted to go into Sql Exp Configuration Manager.



This I've been using for weeks, yet today I get a message that " MMC could not create the snap-in".



I thought that MMC update 3.0 may be the problem., however, cannot find any indication that my server has been updated to MMC 3.0.



If that does happen to be the cause, how do I get around it.?



Thanks for any advice



View 2 Replies View Related

SQL Server Configuration Manager

May 2, 2007

I just installed 3 instances of SQL Server 2005, installing the two named instances first and then the defaul instance third.



My configuration Manager only shows the two named instance services and the default does not show up.



Under Services in Computer Manager, it does show.



Any one run across this, and I would think it might cause some problems now that all the service configuration changes need to be performed in SQL Server Configuration Manager.



Thanks

View 5 Replies View Related

Nothing In SQL Server Configuration Manager?

May 23, 2006

Trying to setup local server agent.

SQL Server Configuration Manager---->SQL Server 2005 Services-->Nothing showed up??? No single items there.

So strange, Anyone could tell me what is wrong with this.

2005 Developer Ed

Windows Xp professional 32 I guess.

View 1 Replies View Related

Slowly Changing Dimension - Lost Configuration On Package Open

Feb 28, 2008

Often when I open an SCD component that was previously configured I find that the configurations are lost. The "Input Columns" and the "Key Type" columns on the first screen ("Select a Dimension Table and Keys") are blank. The "Dimension Columns" column is still populated.

If I run the package, the SCD component appears to function the way it was configurated to function. However, the settings cannot be viewed.

Has anyone experienced anything similar? Any ideas why this happens?

Thank you.

View 2 Replies View Related

Changing Identity Column Format

Mar 19, 2007

Hi,

Is it possible to change the format of the identity column? i.e. I have and integer value that will be the ID for the records to follow in the database. Instead of the values being 1,2,3,4,5,6,7,8,9 etc I want them still to be in sequence but I want the format to be 001,002,003,004,005,006,007,008,009 etc.

Is it possible to do that in SQL when you're creating the table?

View 1 Replies View Related

Windows Server Configuration For 300 GB DB

Oct 26, 2005

Hi,

What should be ideal windows server configuration to support 300 GB database in SQL Server 2000 & 2005? I mean number of processors, RAM, etc.

Thanks

Prashant

View 3 Replies View Related

Unable To Open Configuration Manager

Dec 27, 2013

I am getting this error when i clicked on configuration manager. "Cannot connect to WMI provider. You do not have permissions or the server is unreachable. Note that you can only manage SQL server 2005 and later servers with configuration manager only."

View 10 Replies View Related

SQL 2012 :: Configuration Manager TCP / IP Settings?

Apr 7, 2015

We changed the IP addresses for several SQL Servers and we're a little confused by what we see in Configuration Manager. The TCP/IP properties "IP Addresses" tab still shows the old IP address, even after a restart. On "Protocol" tab, Listen All is set to "Yes".

We've found one source that says this setting causes the listening on an individual IP to be ignored.

View 0 Replies View Related

Oracle Connection Manager Configuration Help

Apr 14, 2006

Hi, I dont know if I should post this question here, or on oracle forums, but here goes ...

I made a simple package that performs 2 Excecute SQL Tasks, one task does a select query on a SQL Server DB Table, the other task does a select query on an Oracle DB Table.

The package runs fine in BIDS when debugging, but when I deployed the package to a file system and added it to an sql server agent Job, it all went wrong ...

I tried the ms oledb dataprovider (ole db) for oracle but also the oracleclient data provider (ado.net) but the package always fails.

The error messages in the logfile are these:








event
OnError

computer
ComputerName

operator
NT AUTHORITYSYSTEM

source
Execute SQL Task PLSQL

sourceid
{B29C4FC9-3345-4657-8680-F770B8C2E136}

executionid
{7312A7EC-2555-4268-BB29-38659507BADD}

starttime
14/04/2006 16:40

endtime
14/04/2006 16:40

datacode
-1073573396

databytes
0x

message
Failed to acquire connection "aaa.bbb.oracleClient". Connection may not be configured correctly or you may not have the right permissions on this connection.

the OnError logrow for the package itself says almost the same.

Now my question is: What do I need to configure to get it all working? I think I need to configure the oracle db no? What should I configure? ...

View 6 Replies View Related

How To Do XML Configuration With Different Connection Manager In SSIS

Sep 15, 2006

Hi



I want know how to config SSIS Package With different connection Manager.

Sample .



When Design time i gave The Connection Manager(Devlopement Server) Name : STG1.XXXSchema

Server Name STG.ssss

Password : xxxxx

I make the The XML configuration file .

after deploy the Package i want from Development Server to Production Server . so i will change the Package Config File Open wiht Notepad .

Server Name STG.qqq

Password :xxxxxx

after Edit Connection String I run the Package . It Always Taking Whatever igave the Connection String When Design time only .is not taking what connection string edit hte in the Package Config File. Please Any one give the Solution .

How we can Change the connection string in XML Config File .Whne I tested . It always taking what ever we given in the Desing Time .





Thanks & Regards,

Jeyakumar .M





View 4 Replies View Related

Certificate Not Displaying In Configuration Manager

May 21, 2007

Hi Guys,

I have installed a certifcate following

http://msdn2.microsoft.com/en-us/library/ms191192.aspx

But when i try to enable the certificate using Configuration manager i cant see the certificate. I can see the

certificate using MMC console. I followed the instructions and all the "Certifcate Requirements" from BOL is looking fine, but still cannot able to see the certificate in the configuration manager.

Any help/direction much appreciated.



kind Regards

A

View 6 Replies View Related

Indirect Configuration Of Connection Manager

May 25, 2007

Greetings All;
I am having trouble getting an indirect configuration to work. Can someone offer a hand?

Here's the deal....
I have a package the currently has an OLE DB Connection manager. I have an XML configuration file set up to acquire the connection string. That works fine. I have a package variable that contains the absolute path to the .dtsconfig file.

How can I get the connection manager to read the package variable (which has the path to the *.dtsconfig file) instead of the hard coded value?

Thanks in advance.

View 7 Replies View Related

Confused About Configuration Manager's TCP/IP Settings

Jun 26, 2006

I need another opinion about the SQL Server Configuration Manager's TCP/IP settings...

Recreation steps:
Start, (All) Programs, SQL Server 2005, Configuration Tools, SQL Server Configuration Manager.
Expand the "SQL Server 2005 Network Configuration"
Select the "Protocols for x" where "x" is the named-instance or "MSSQLServer" for default.
On the right-hand pane, right-click "TCP/IP" and select "Properties."
Select the "IP Addresses" tab.

Visually on the screen I have this:
_______________________________________
- IP1
Active            Yes
Enabled           No
IP Address        106.xx.xxx.xx
TCP Dynamic Ports
TCP Port          1433

- IP2
Active            Yes
Enabled           No
IP Address        127.0.0.1 <-loopback
TCP Dynamic Ports
TCP Port          1433

-IPAll
TCP Dynamic Ports
TCP Port          1433
_______________________________________

Questions:
1. If I want to change the listening port, I change all three at the same time?
1a. Does a value in the IPAll section override the individual IPx sections?
2. What does "enabled" mean? How can IP1 and IP2 not be enabled?
3. What does "active" mean? How can something be both active yet not enabled?
(4. Any plans to change the "NULL=False, 0=True" values for the Dynamic Ports?)

 

View 4 Replies View Related

Error Sql Server Configuration Manager

Sep 5, 2007

when i open services in the computer management console i get the error message
sql server configuration manager .... error... snap in...restart mmc

View 2 Replies View Related

Starting Configuration Manager In A Cluster

Nov 19, 2007

I have a 2 node cluster in an active/active configuration. Install is SQL 2005 Enterprise Edition x64, patched to KB934458

If I try and run SQL Server Configuration Manager on node 1 the application does not start and I get the following message: "Connection to target machine could not be made in a timely fashion." This happens for both SQL Server instances (SQL01 and SQL02).
I can connect fine on the 2nd node with both instances.

Further to this, if I try and run the Surface Area Configuration tool on node 1 - I can't connect to either SQL Instance (SQL01 and SQL02)
If I run the SAC tool on the second node, I can connect to the instance SQL02 that is active on node 2. If I fail that SQL Instance over to node 1, I can no longer connect
I think there is clearly something not quite right about node 1.

Any help/pointers would be appreciated.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved