Error when using rskeymgmt to backup encryption key

When I run the rskeymgmt program to backup the encryption key, I get the
following error:
The Report Server Windows service is not responding to RPC requests. The
service may not be running.
I have checked, and the service is running. We are using SQL Server 2005
sp2. The command I am using is:
rskeymgmt -e -fc:\rskey\rsdbkey.txt -psomepassword
Any ideas why this is failing. I was able to run the program some time ago.
Thanks.On May 2, 11:50 am, "Tim Kelley" <tkel...@.company.com> wrote:
> When I run the rskeymgmt program to backup the encryption key, I get the
> following error:
> The Report Server Windows service is not responding to RPC requests. The
> service may not be running.
> I have checked, and the service is running. We are using SQL Server 2005
> sp2. The command I am using is:
> rskeymgmt -e -fc:\rskey\rsdbkey.txt -psomepassword
> Any ideas why this is failing. I was able to run the program some time ago.
> Thanks.
This link might be helpful:
http://www.technologyone.org/new-6210113-3731.html
Regards,
Enrique Martinez
Sr. Software Consultant

Error when trying to execute a job from windows service.

Hi,
I'm trying to execute a DTS package from a .NET service. The service is
running under a domain account that owns the job which it executes using
'sp_start_job'. The call to the sp succeeds however checking the Job history
gives: -
"The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
job <JobName> has server access (reason: Could not obtain information about
Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Error 8198
))."
SQL Server 2000 SP4
Both SQLServer + SQLAgent run under a domain account (different to the
service)
ServiceUser has login to sql server not an admin, however I've tried using
the SQL Agent Proxy account still no success.
Any ideas?
thanks Paul> SQL Server 2000 SP4
> Both SQLServer + SQLAgent run under a domain account (different to the
> service)
> ServiceUser has login to sql server not an admin, however I've tried using
> the SQL Agent Proxy account still no success.
The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
the SQL Agent service account must be a member of the local Administrators
group in order to "Create CmdExec and ActiveScript jobs belonging to someone
other than a SQL Server administrator".
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Coulson" <nospam@.nospam.net> wrote in message
news:OZUDQ3WOGHA.3144@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm trying to execute a DTS package from a .NET service. The service is
> running under a domain account that owns the job which it executes using
> 'sp_start_job'. The call to the sp succeeds however checking the Job
> history gives: -
> "The job failed. Unable to determine if the owner (DOMAIN\ServiceUser) of
> job <JobName> has server access (reason: Could not obtain information
> about Windows NT group/user 'DOMAIN\ServiceUser'. [SQLSTATE 42000] (Er
ror
> 8198))."
> SQL Server 2000 SP4
> Both SQLServer + SQLAgent run under a domain account (different to the
> service)
> ServiceUser has login to sql server not an admin, however I've tried using
> the SQL Agent Proxy account still no success.
> Any ideas?
> thanks Paul
>|||Hi Dan,
Thanks that's sorted it. Also got it working using the proxy account
again this needed local admin rights.
Cheers Paul
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:ueU6PriOGHA.1192@.TK2MSFTNGP11.phx.gbl...
> The SQL 2000 Books Online <instsql.chm::/in_overview_6k1f.htm> states that
> the SQL Agent service account must be a member of the local Administrators
> group in order to "Create CmdExec and ActiveScript jobs belonging to
> someone other than a SQL Server administrator".
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Paul Coulson" <nospam@.nospam.net> wrote in message
> news:OZUDQ3WOGHA.3144@.TK2MSFTNGP11.phx.gbl...
>|||I'm glad you were able to get it working. However, I'd be leery about
granting admin rights the proxy account since that allows non-sysadmins to
run processes with admin rights. Now that you got the service accounts
sorted out, I would expect your DTS package to run fine as long as the proxy
account has permissions on data and files accessed by the package.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul Coulson" <nospam@.nospam.net> wrote in message
news:eCdaOR4OGHA.812@.TK2MSFTNGP10.phx.gbl...
> Hi Dan,
> Thanks that's sorted it. Also got it working using the proxy account
> again this needed local admin rights.
> Cheers Paul
>
>
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:ueU6PriOGHA.1192@.TK2MSFTNGP11.phx.gbl...
>

Error when starting SQLSERVER AGENT

Hello!, I have the following error message when I want to start the
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
Message posted via http://www.droptable.com
The MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.

Error when starting SQLSERVER AGENT

Hello!, I have the following error message when I want to start the
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
--
Message posted via http://www.sqlmonster.comThe MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.

Error when starting SQLSERVER AGENT

Hello!, I have the following error message when I want to start the
sqlserver agent: "The SQLSERVER AGENT SERVICE on local computer started and
then stopped. Some services stop automatically if they have no work to do,
for example the performance logs and alerts service"
In this server I have windows 2003 and sql server 2000 (it has the service
pack already), actually some days ago it had no problem, suddenly the jobs
did not run so I realized this problem.
Help!!!!!!!!
Message posted via http://www.droptable.comThe MSDB database has some problem,maybe it is running in single user mode.
maybe you moved it from another BD check the MSDB for any thing out of the
normal.sql

Error when starting SQL SERVER service

Hello all,
When i am starting SQL Server, I am getting an error saying "Encryption Error When starting SQL Server service.. on connecttionbopen.... " What could be the problem ?
Please help me with the steps..
Saiwhat are the log on properties of the sql server services on your server?
have u recently changed the password for the server?
or else try using some other protocol from client/server utility.|||hello Harshal,
Actually when i am logging in to the database using my regular user details i am getting this error. Infact i am not able to see the Properties of the SQL server from the Enterprise manager. When i right Click and select properties of the Service in E.M i am getting the same error.

I tried re-installing the SQL server in the same Directory.. But Still the problem hooks..

What should i do now ?

Sai|||RE:
...I tried re-installing the SQL server in the same Directory.. But Still the problem hooks..
Q1 What should i do now ?
Sai

A1 Much depends on the specific situation.

Some things to consider / investigate:

a If the server was previously functional; what environment changes may have been made prior to the server having the issue, i.e.(where any patches, development environments, upgrades, etc. applied)?

b If the server was previously functional; what was the nature of any activity performed prior to the server having the issue, e.g.(were there any peak / near peak resource utilization conditions present, where load tests, intrusion tests, etc., performed)?

{Somewhat similar issues on development machines may sometimes be traced to such things as corrupted / damaged registry keys and / or dlls. On occasion, the fix is relatively simple, but this is not always necessarily so.}

If inital efforts are unsucessful, and the time / resources to investigate in detail are not available, you may wish to consider completely reinstalling OS, MS Sql Server (from "scratch"). However, if the issue ultimately is caused by a misbehaving custom application or perhaps even failing hardware, it may well re-occur (until any underlying issues have been resolved).

Error when SQL 2000 start

When starting my SQL Server 2000 generate error and stop. This is the log:
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

2004-01-20 11:05:36.59 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-01-20 11:05:36.59 server All rights reserved.
2004-01-20 11:05:36.59 server Server Process ID is 115.
2004-01-20 11:05:36.59 server Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2004-01-20 11:05:36.63 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-01-20 11:05:36.66 server SQL Server configured for thread mode processing.
2004-01-20 11:05:36.66 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-01-20 11:05:36.67 server Attempting to initialize Distributed Transaction Coordinator.
2004-01-20 11:05:38.69 spid3 Starting up database 'master'.
2004-01-20 11:05:38.85 spid3 Server name is 'DB_SERVER'.
2004-01-20 11:05:38.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-01-20 11:05:38.87 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-01-20 11:05:38.87 server SQL server listening on 192.168.1.29:1433, 172.16.48.10:1433, 127.0.0.1:1433.
2004-01-20 11:05:38.87 server SQL Server is ready for client connections
2004-01-20 11:05:38.87 spid5 Starting up database 'model'.
2004-01-20 11:05:38.87 spid8 Starting up database 'msdb'.
2004-01-20 11:05:38.87 spid9 Starting up database 'pubs'.
2004-01-20 11:05:38.87 spid10 Starting up database 'Northwind'.
2004-01-20 11:05:38.87 spid11 Starting up database 'SIM'.
2004-01-20 11:05:39.21 spid5 Error: 9003, Severity: 20, State: 1
2004-01-20 11:05:39.21 spid5 The LSN (5:377:1) passed to log scan in database 'model' is invalid..
2004-01-20 11:05:39.31 spid8 Bypassing recovery for database 'msdb' because it is marked SUSPECT.
2004-01-20 11:05:39.39 spid11 Starting up database 'GMS'.
2004-01-20 11:05:39.39 spid8 Starting up database 'euro'.
2004-01-20 11:05:40.14 spid10 Starting up database 'TigrisDB'.have you moved your system's devices around recently?|||Originally posted by ms_sql_dba
have you moved your system's devices around recently?

No, but 2 weeks before, I receive a message (Administrator alert) from PC with installed on SQL 2000.

"Drive Z: is nearly full. 1216688128 bytes are available.
Please warn users and delete unneeded files."

On "drive Z:" there is 9GB free space ...

Thanks for reading.
Best Regards|||looks like your system databases is having some problem.
try restarting sql server in single user mode and do a dbcc checkdb on model and msdb.

If this do not work, you might have to rebuild them

amit

Error when downloading SQL Server

I keep getting eeror mess when downloading SQL server 2005. Micro soft cust service says they are not qualified to fix but if I pay $99.00 they can have someone help with it.

I think that is nuts since they are sending me the download. I tried to do it manually and some components installed but everyday I get update notifications

HELP! PLEASE!

What's the error message you are receiving? And which version are you trying to download?

To download SQL Express SP2, grab it from here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=31711d5d-725c-4afa-9d65-e4465cdff1e7

To download SP2 for any other edition, grab it from here:

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

Download that file locally and run from your machine. That should do the trick. Let us know if you hit errors.

Thanks,
Sam Lester (MSFT)

Error when downloading SQL Server

I keep getting eeror mess when downloading SQL server 2005. Micro soft cust service says they are not qualified to fix but if I pay $99.00 they can have someone help with it.

I think that is nuts since they are sending me the download. I tried to do it manually and some components installed but everyday I get update notifications

HELP! PLEASE!

What's the error message you are receiving? And which version are you trying to download?

To download SQL Express SP2, grab it from here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=31711d5d-725c-4afa-9d65-e4465cdff1e7

To download SP2 for any other edition, grab it from here:

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

Download that file locally and run from your machine. That should do the trick. Let us know if you hit errors.

Thanks,
Sam Lester (MSFT)

sql

Error when connecting to SSIS.

I just installed a default instance of SS 2005 and applied the most recent service pack, release date March 5th, SQLServer2005SP2-KB921896-x64-ENU.exe.

All services are running as localsystem. When I try to connect to SSIS through Management Studio on the local machine I receive the following error.

Any help would be appreciated.

TITLE: Connect to Server

Cannot connect to [server name].

ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "[server name]" failed:
Error loading type library/DLL.
.

Connect to SSIS Service on machine "[server name]." failed:
Error loading type library/DLL.
.

BUTTONS:
OK

Do you have the SQL Server SSIS service started (running)?|||I do.|||

There was one thing that was a little weird. I tried re-installing the Service Pack and it did not recognize that the services were running or would interfere with the install.

The first time I installed SP2 it forced me to stop the services before installing, but the second time it did not. Seemed as if the install did not detect the services were running.

After installing the second time, I did a reboot to attempt to clear it up. SSIS still did not allow a connection and I received the same error.

|||Does this help? Are you also running SQL Server 2000?

http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx|||No not running SQL 2000 on this computer. It is a brand new server.|||

I am looking at the link you sent, thought this may be relevant also.

There was a previous named instance that I uninstalled, before installing the default instance. There were no other instances on the computer after I uninstalled the named instance.

|||

Phil,

The xml ini file in the link appears to be correct on my server.

It shows the servername as <ServerName>.</ServerName>.

I appreciate the help, so does my client. ;)

|||

Phil,

The issue on the post at this site seems to be the same.

http://www.kbalertz.com/Feedback_926629.aspx

The cause is listed as "This problem occurs because the 32-bit Dts.dll file is unregistered when the 64-bit SSIS is installed as part of the hotfix.". Does this ring a bell?

|||Have you tried reinstalling the client tools?|||

SnoChoJoe wrote:

Phil,

The issue on the post at this site seems to be the same.

http://www.kbalertz.com/Feedback_926629.aspx

The cause is listed as "This problem occurs because the 32-bit Dts.dll file is unregistered when the 64-bit SSIS is installed as part of the hotfix.". Does this ring a bell?

I just read that myself. Are you on a 32 bit machine? The SP2 service pack you indicated is for 64 bit.|||No it is an X64 architecture.|||No I have not, you know I get an error on the Client Tools Update when installing SP2. Could that be related?|||

SnoChoJoe wrote:

No I have not, you know I get an error on the Client Tools Update when installing SP2. Could that be related?

Perhaps... Make sure you have a working installation before applying any service packs.|||

Ok, I am going to trouble shoot the client install.

I will advise if I determine the problem. Thanks Phil.

Error when connecting to SSIS.

I just installed a default instance of SS 2005 and applied the most recent service pack, release date March 5th, SQLServer2005SP2-KB921896-x64-ENU.exe.

All services are running as localsystem. When I try to connect to SSIS through Management Studio on the local machine I receive the following error.

Any help would be appreciated.

TITLE: Connect to Server

Cannot connect to [server name].

ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "[server name]" failed:
Error loading type library/DLL.
.

Connect to SSIS Service on machine "[server name]." failed:
Error loading type library/DLL.
.

BUTTONS:
OK

Do you have the SQL Server SSIS service started (running)?|||I do.|||

There was one thing that was a little weird. I tried re-installing the Service Pack and it did not recognize that the services were running or would interfere with the install.

The first time I installed SP2 it forced me to stop the services before installing, but the second time it did not. Seemed as if the install did not detect the services were running.

After installing the second time, I did a reboot to attempt to clear it up. SSIS still did not allow a connection and I received the same error.

|||Does this help? Are you also running SQL Server 2000?

http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx|||No not running SQL 2000 on this computer. It is a brand new server.|||

I am looking at the link you sent, thought this may be relevant also.

There was a previous named instance that I uninstalled, before installing the default instance. There were no other instances on the computer after I uninstalled the named instance.

|||

Phil,

The xml ini file in the link appears to be correct on my server.

It shows the servername as <ServerName>.</ServerName>.

I appreciate the help, so does my client. ;)

|||

Phil,

The issue on the post at this site seems to be the same.

http://www.kbalertz.com/Feedback_926629.aspx

The cause is listed as "This problem occurs because the 32-bit Dts.dll file is unregistered when the 64-bit SSIS is installed as part of the hotfix.". Does this ring a bell?

|||Have you tried reinstalling the client tools?|||

SnoChoJoe wrote:

Phil,

The issue on the post at this site seems to be the same.

http://www.kbalertz.com/Feedback_926629.aspx

The cause is listed as "This problem occurs because the 32-bit Dts.dll file is unregistered when the 64-bit SSIS is installed as part of the hotfix.". Does this ring a bell?

I just read that myself. Are you on a 32 bit machine? The SP2 service pack you indicated is for 64 bit.|||No it is an X64 architecture.|||No I have not, you know I get an error on the Client Tools Update when installing SP2. Could that be related?|||

SnoChoJoe wrote:

No I have not, you know I get an error on the Client Tools Update when installing SP2. Could that be related?

Perhaps... Make sure you have a working installation before applying any service packs.|||

Ok, I am going to trouble shoot the client install.

I will advise if I determine the problem. Thanks Phil.

Error when browsing the page http://localhost/reports

I have installed SQL Server Reporting service 2005 and when I am trying to
browse the page http://localhost/reports, it is giving me following error:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.IO.FileNotFoundException:
C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
at
Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
at
Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
SQL Server 2005 is installed on different machine. I am installing SQL
Server Reporting service 2005 on CRM server. I have install/uninstall for a
number of times. Previously, it was working properly and after some
installaion/uninstallation, it has started giving the above error.Just to be sure where is can be the problem (network config, or installation
issue), have you tried to use the IP Address of the machine instead of
localhost?
http://yourip/reports
or
http://127.0.0.1/Reports
Good luck
Braulio
/// --
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// --
"Bhumit" wrote:
> I have installed SQL Server Reporting service 2005 and when I am trying to
> browse the page http://localhost/reports, it is giving me following error:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.IO.FileNotFoundException:
> C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> at
> Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> SQL Server 2005 is installed on different machine. I am installing SQL
> Server Reporting service 2005 on CRM server. I have install/uninstall for a
> number of times. Previously, it was working properly and after some
> installaion/uninstallation, it has started giving the above error.
>|||Another thing to do is go to your Reporting Services Configuration Tool and
make sure all your Settings are pointing to the correct location. I found
this area to be extremely sensitive.
"Braulio Diez" wrote:
> Just to be sure where is can be the problem (network config, or installation
> issue), have you tried to use the IP Address of the machine instead of
> localhost?
> http://yourip/reports
> or
> http://127.0.0.1/Reports
> Good luck
> Braulio
> /// --
> /// Braulio Diez
> ///
> /// http://www.tipsdotnet.com
> /// --
>
>
> "Bhumit" wrote:
> > I have installed SQL Server Reporting service 2005 and when I am trying to
> > browse the page http://localhost/reports, it is giving me following error:
> >
> > System.Web.Services.Protocols.SoapException: Server was unable to process
> > request. --> System.IO.FileNotFoundException:
> > C:\WINDOWS\assembly\GAC_32\Microsoft.ReportingServices.Diagnostics\9.0.242.0__89845dcd8080cc91\ReportingServicesNativeServer.dll
> > at System.Diagnostics.FileVersionInfo.GetVersionInfo(String fileName) at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.GetNativeProductVersion()
> > at
> > Microsoft.ReportingServices.Diagnostics.RSConfiguration.get_NativeServerProductVersion()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.ServerInfoHeader..ctor()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.get_ServerInfoHeaderValue() -- End of inner exception stack trace --
> >
> > SQL Server 2005 is installed on different machine. I am installing SQL
> > Server Reporting service 2005 on CRM server. I have install/uninstall for a
> > number of times. Previously, it was working properly and after some
> > installaion/uninstallation, it has started giving the above error.
> >
> >

Error VSS service

Sqllib error: Database TRADE is not simple.
Problem NTBACKUP and Job SQL is in parallel carried out
How, when and where is this error encountered? By the statement "Database
TRADE is not simple", I'll assume that TRADE doesnt have simple recovery
model? And does this error occur when there are 2 parallel backup jobs
running? Please explain.
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error VSS service

Sqllib error: Database TRADE is not simple
Problem NTBACKUP and Job SQL is in parallel carried outHow, when and where is this error encountered? By the statement "Database
TRADE is not simple", I'll assume that TRADE doesnt have simple recovery
model? And does this error occur when there are 2 parallel backup jobs
running? Please explain.
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error VSS service

Sqllib error: Database TRADE is not simple.
Problem NTBACKUP and Job SQL is in parallel carried outHow, when and where is this error encountered? By the statement "Database
TRADE is not simple", I'll assume that TRADE doesnt have simple recovery
model? And does this error occur when there are 2 parallel backup jobs
running? Please explain.
thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error trying to open Service Manager

Can anybody help me with this error. I have looked all
over the MSDN and support and can not find anything to
fix this.
HERE IS THE ERROR:
MMC can not open the file C:\Program Files\Microsoft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an
MMC console, or was created by a later version of MMC.
This may also be because you do not have sufficient
access rights to the file.
I have SQL 6.5 and 2000 installed. I have XP, Office
2003 Professional and FP 2003. 6.5 Works excellent.Are any of the conditions suggested true..?
Does the file exist..
Do you have permission to it
Are you starting EnterPrise Manager v6.5 and trying to open a file create
with v2000
HTH
Ryan Waight, MCDBA, MCSE
"Raymond Conklin" <rconklin@.jcpenney.com> wrote in message
news:0ae301c39c9c$31f4bda0$a301280a@.phx.gbl...
> Can anybody help me with this error. I have looked all
> over the MSDN and support and can not find anything to
> fix this.
>
> HERE IS THE ERROR:
> MMC can not open the file C:\Program Files\Microsoft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an
> MMC console, or was created by a later version of MMC.
> This may also be because you do not have sufficient
> access rights to the file.
> I have SQL 6.5 and 2000 installed. I have XP, Office
> 2003 Professional and FP 2003. 6.5 Works excellent.

error to run reporting service

When I try to run the web page which host the report, I am not able to reach the home page and following error show up.

" 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 and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data."

I then went to Reporting Services Configuration Manager -> Encryption Keys

then I clicked the Change button

after all these I can get back to the reporting service home page. Any one can tell me the reason of this error? thanks

when I tried to open the reporting service web site. The following error pop up

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 and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data.

Then I go to Reporting Service Manager-> Encryption keys. After I changed the encryption keys; the reporting service works again. Could anyone explain the reason behind this? ans is that the right way to reslove the error?

Thanks

|||Reporting Services data is encrypted. Did you restore the database or change the service account not through the Condifguration manager ? After changing / deleting the key 8and the encrypted content) the database was empty, you had a new key and you could start all over.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error System.InvalidOperationException: Client found response cont

Hi, All.
I have a windows 2000 server machine with SQL Enterprise 2000 edition and
reporting service enterprise edition on it.
The Report Mangaer application and the Report Server Web service are both
working.
and i have a web application that makes calls against the reporting service
API.
and I get the following error regardless of any method I call.
System.InvalidOperationException: Client found response content type of
'text/html', but expected 'text/xml'. The request failed with the error
message: -- -2146893039 (0x80090311) --. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
Recursive).
Can anyone help to explain what to do?
tksThe problem is you are getting back an html response rather then a SOAP
response (xml). Have you verified that the .Url property is correct set on
your proxy object?
The error you are seeing is:
No authority could be contacted for authentication.
Have you set the credentials property correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hang" <Hang@.discussions.microsoft.com> wrote in message
news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> Hi, All.
> I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> reporting service enterprise edition on it.
> The Report Mangaer application and the Report Server Web service are both
> working.
> and i have a web application that makes calls against the reporting
> service
> API.
> and I get the following error regardless of any method I call.
> System.InvalidOperationException: Client found response content type of
> 'text/html', but expected 'text/xml'. The request failed with the error
> message: -- -2146893039 (0x80090311) --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> Recursive).
>
> Can anyone help to explain what to do?
> tks
>|||Thanks for replying, Daniel
Yes. the .Url property is correct. I explicitly set it once i create a proxy
object.
here is a sample code
Dim rs As sqlReport.ReportingService
rs = New ReportingService
rs.Url = "http://severName/ReportServer/ReportService.asmx"
rs.Credentials = New NetworkCredential
("userName", "password", "theDomainName")
Dim c As CatalogItem() = rs.ListChildren("/", True)
that is the code code that throws the exception
by the way, On the same server, I used to have reporting service evaluation
edition and my application worked fine.
Then I got that problem after installing the official version(I uninstalled
the evalutiaon edition and deleted all the database associated with it before
installing).
tks.
"Daniel Reib [MSFT]" wrote:
> The problem is you are getting back an html response rather then a SOAP
> response (xml). Have you verified that the .Url property is correct set on
> your proxy object?
> The error you are seeing is:
> No authority could be contacted for authentication.
> Have you set the credentials property correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Hang" <Hang@.discussions.microsoft.com> wrote in message
> news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > Hi, All.
> > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > reporting service enterprise edition on it.
> >
> > The Report Mangaer application and the Report Server Web service are both
> > working.
> > and i have a web application that makes calls against the reporting
> > service
> > API.
> > and I get the following error regardless of any method I call.
> >
> > System.InvalidOperationException: Client found response content type of
> > 'text/html', but expected 'text/xml'. The request failed with the error
> > message: -- -2146893039 (0x80090311) --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > Recursive).
> >
> >
> > Can anyone help to explain what to do?
> >
> > tks
> >
>
>|||Just to follow up on this. It turned out it was an credential problem in this
case.
The web server, which hosts the web application, needs to be in the same
domain as that of the web server hosting the reporting services web service.
And a proper domain account is needed for accessing the reporting services
web service in this case.
hope this helps others who have encountered similiar problems.
Tks
"Hang" wrote:
> Thanks for replying, Daniel
> Yes. the .Url property is correct. I explicitly set it once i create a proxy
> object.
> here is a sample code
> Dim rs As sqlReport.ReportingService
> rs = New ReportingService
> rs.Url = "http://severName/ReportServer/ReportService.asmx"
> rs.Credentials = New NetworkCredential
> ("userName", "password", "theDomainName")
> Dim c As CatalogItem() = rs.ListChildren("/", True)
> that is the code code that throws the exception
> by the way, On the same server, I used to have reporting service evaluation
> edition and my application worked fine.
> Then I got that problem after installing the official version(I uninstalled
> the evalutiaon edition and deleted all the database associated with it before
> installing).
>
> tks.
> "Daniel Reib [MSFT]" wrote:
> > The problem is you are getting back an html response rather then a SOAP
> > response (xml). Have you verified that the .Url property is correct set on
> > your proxy object?
> >
> > The error you are seeing is:
> >
> > No authority could be contacted for authentication.
> >
> > Have you set the credentials property correctly?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Hang" <Hang@.discussions.microsoft.com> wrote in message
> > news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > > Hi, All.
> > > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > > reporting service enterprise edition on it.
> > >
> > > The Report Mangaer application and the Report Server Web service are both
> > > working.
> > > and i have a web application that makes calls against the reporting
> > > service
> > > API.
> > > and I get the following error regardless of any method I call.
> > >
> > > System.InvalidOperationException: Client found response content type of
> > > 'text/html', but expected 'text/xml'. The request failed with the error
> > > message: -- -2146893039 (0x80090311) --. at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters) at
> > > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > > Recursive).
> > >
> > >
> > > Can anyone help to explain what to do?
> > >
> > > tks
> > >
> >
> >
> >

Error starting the SQL service after renaming one of the log files..

Is there anyone out there who can help me ? Please ? ?
The log file for one of the MSSQL 2000 databases ha grown really big.
(15 GB)
After setting a limit on the size to grow, the log file date did not
modifie.
After a few weaks I stopped the SQL service, and renamed the log file.
When I was trying to start the SQL again, it would not start. Even
not when I gave the log file back its old name.
Is there any way to restart / restore the SQL service / database
without a backup ? ?
Regards,
ØivindWhen you try to start the service, what message do you get?
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind|||If the error messages are correct... simply
Restore database model with recovery
Restore database axdb with recovery
the error messages say you have started a recovery that was not completed..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind

Error starting SQLserver on windows 2000

When starting the SQLserver service on a Windows 2000 server, we get
following error:
17050 :
initerrlog: Could not open error log file
's:\MSSQL8\MSSQL\log\ERRORLOG'. Operating system error = 3(error not
found).
We're running SQL 2000 std ed.. This is no cluster, access rights on
file are correct, the file is not locked by another process.
I've compared registry settings with a working server (same config) and
there identical.
registry setting:
& #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\MSSQLServer\Parameter
s]
"SQLArg0"="-ds:\\MSSQL8\\MSSQL\\data\\master.mdf"
"SQLArg1"="-es:\\MSSQL8\\MSSQL\\log\\ERRORLOG"
"SQLArg2"="-ls:\\MSSQL8\\MSSQL\\data\\mastlog.ldf".
There's a local d, e and l-drive (No SAN)
Anyone has an idea what's going wrongHi Olivier
The parameters are expecting a S drive, where are the files supposed to be?
You could start sqlservr.exe from the command prompt and specify the correct
file names, see the topic "sqlservr Application" in Books Online and change
the values through Enterprise Manager, if you don't want to change the
registry directly.
John
"sqlservr Application"
"olivier.lammens@.gmail.com" wrote:

> When starting the SQLserver service on a Windows 2000 server, we get
> following error:
> 17050 :
> initerrlog: Could not open error log file
> 's:\MSSQL8\MSSQL\log\ERRORLOG'. Operating system error = 3(error not
> found).
> We're running SQL 2000 std ed.. This is no cluster, access rights on
> file are correct, the file is not locked by another process.
> I've compared registry settings with a working server (same config) and
> there identical.
> registry setting:
> & #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\MSSQLServer\Paramet
ers]
> "SQLArg0"="-ds:\\MSSQL8\\MSSQL\\data\\master.mdf"
> "SQLArg1"="-es:\\MSSQL8\\MSSQL\\log\\ERRORLOG"
> "SQLArg2"="-ls:\\MSSQL8\\MSSQL\\data\\mastlog.ldf".
> There's a local d, e and l-drive (No SAN)
> Anyone has an idea what's going wrong
>|||Hi Olivier
The parameters are expecting a S drive, where are the files supposed to be?
You could start sqlservr.exe from the command prompt and specify the correct
file names, see the topic "sqlservr Application" in Books Online and change
the values through Enterprise Manager, if you don't want to change the
registry directly.
John
"sqlservr Application"
"olivier.lammens@.gmail.com" wrote:

> When starting the SQLserver service on a Windows 2000 server, we get
> following error:
> 17050 :
> initerrlog: Could not open error log file
> 's:\MSSQL8\MSSQL\log\ERRORLOG'. Operating system error = 3(error not
> found).
> We're running SQL 2000 std ed.. This is no cluster, access rights on
> file are correct, the file is not locked by another process.
> I've compared registry settings with a working server (same config) and
> there identical.
> registry setting:
> & #91;HKEY_LOCAL_MACHINE\SOFTWARE\Microsof
t\MSSQLServer\MSSQLServer\Paramet
ers]
> "SQLArg0"="-ds:\\MSSQL8\\MSSQL\\data\\master.mdf"
> "SQLArg1"="-es:\\MSSQL8\\MSSQL\\log\\ERRORLOG"
> "SQLArg2"="-ls:\\MSSQL8\\MSSQL\\data\\mastlog.ldf".
> There's a local d, e and l-drive (No SAN)
> Anyone has an idea what's going wrong
>