Showing posts with label upgrade. Show all posts
Showing posts with label upgrade. Show all posts

Tuesday, March 20, 2012

Change Database from Sql-Server 2000 to 2005

Hi ,

Currently my application running on Sql-Server 2000 and I want to upgrade with Sql-Server 2005
will It work sql- server 2005?

if no what changed i need to do?
Can anyone help me?

Thanx

Move the thread from Visual Basic General forum. The question is mainly on SQL Server upgrading issue. There are more exports in SQL Server Setup & Upgrade forum, I believe you can get the satisfying answer in this forum.

Thanks again for your question.

|||Yes ! There are 2 types of upgrades available,
1. Inplace upgrade
2. Side by Side upgrade

You can refer these documents,
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
http://www.sqlservercentral.com/columnists/ssamuel/2987.asp
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2068912&SiteID=1

In side by side upgrade you can choose any of the following,
1. backup db in sql 2000 and restore it in sql 2005
2. detach db in sql 2000 and attach it in sql 2005
3. copy database wizard

You need to install sql 2005 first and then perform as above

Inplace upgrade will automatically upgrade the existing sql 2000 instance to sql 2005 instance..........but you need to make use of upgrade advisor to check if any errors are reported and then take corrective actions and then proceed........you can go ahead with Inplace upgrade...........

http://msdn2.microsoft.com/en-us/library/ms144256.aspx upgrade advisor
http://msdn2.microsoft.com/en-us/library/ms144245.aspx


Change Database from Sql-Server 2000 to 2005

Hi ,

Currently my application running on Sql-Server 2000 and I want to upgrade with Sql-Server 2005
will It work sql- server 2005?

if no what changed i need to do?
Can anyone help me?

Thanx

Move the thread from Visual Basic General forum. The question is mainly on SQL Server upgrading issue. There are more exports in SQL Server Setup & Upgrade forum, I believe you can get the satisfying answer in this forum.

Thanks again for your question.

|||Yes ! There are 2 types of upgrades available,
1. Inplace upgrade
2. Side by Side upgrade

You can refer these documents,
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
http://www.sqlservercentral.com/columnists/ssamuel/2987.asp
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2068912&SiteID=1

In side by side upgrade you can choose any of the following,
1. backup db in sql 2000 and restore it in sql 2005
2. detach db in sql 2000 and attach it in sql 2005
3. copy database wizard

You need to install sql 2005 first and then perform as above

Inplace upgrade will automatically upgrade the existing sql 2000 instance to sql 2005 instance..........but you need to make use of upgrade advisor to check if any errors are reported and then take corrective actions and then proceed........you can go ahead with Inplace upgrade...........

http://msdn2.microsoft.com/en-us/library/ms144256.aspx upgrade advisor
http://msdn2.microsoft.com/en-us/library/ms144245.aspx


Thursday, March 8, 2012

change a named instance to the default instance

We have a SQL 7 that I want to upgrade to SQL 2000 but
the setup wizard does not allow it to do so. The only
option that I'm allowed is to create a named instance.
If I do this and copy all of the databases to the SQL
2000 named instance, can I uninstall SQL 7 and change the
named instance to the default instance?You cannot make a named instance to a default or change name of an instance.
You have do use backup/restore or detach/attach.
Some of the below articles *might* be of help:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jim" <jim.abel@.lmco.com> wrote in message
news:047801c3aa2a$3cd905f0$a101280a@.phx.gbl...
> We have a SQL 7 that I want to upgrade to SQL 2000 but
> the setup wizard does not allow it to do so. The only
> option that I'm allowed is to create a named instance.
> If I do this and copy all of the databases to the SQL
> 2000 named instance, can I uninstall SQL 7 and change the
> named instance to the default instance?|||Hi Jim,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
First of all, I would like to confirm my understanding of your issue.
From your description, I understand that you'd like to upgrade SQL 7 to SQL
2000. However, I'm unsure of the meaning "The only option that I'm allowed
is to create a named instance." When upgrading, SQL Server 7.0
automatically becomes the default instance of SQL Server 2000.
As we known, you can overwrite the existing installation of SQL Server 7.0
by installing a default instance of SQL Server 2000. You can also keep the
installation of SQL Server 7.0 intact by installing a named instance of SQL
Server 2000. Both operations are performed using the following procedure.
To upgrade SQL Server 7.0 to SQL Server 2000
1. Insert the Microsoft SQL Server 2000 compact disc for the edition to
which you want to upgrade into your CD-ROM drive. If the compact disc does
not autorun, double-click Autorun.exe in the root directory of the compact
disc.
2. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3. In Computer Name dialog box, Local Computer is the default option and
the local computer name appears in the edit box. Click Next.
4. In the Installation Selection dialog box, click Upgrade, remove, or add
components to an existing instance of SQL Server, and then click Next.
5. In the Instance Name dialog box, Default will be selected. Click Next.
# Note # When upgrading, SQL Server 7.0 automatically becomes the
default instance of SQL Server 2000.
6. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7. In the Upgrade dialog box, you are prompted as to whether you want to
proceed with the requested upgrade. Click Yes, upgrade my <text specific to
the upgrade> to start the upgrade process, and then click Next. The upgrade
runs until finished.
8. In the Connect to Server dialog box, select an authentication mode, and
then click Next.
If you are not sure which mode to use, accept the default: The Windows
account information I use to log on to my computer with (Windows).
9. In Start Copying Files dialog box, click Next.
10. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish.
Additionally, instead of a full upgrade from SQL Server 7.0 to SQL Server
2000, which overwrites SQL Server 7.0, you can upgrade SQL Server 7.0
databases and associated meta data. To upgrade a SQL Server 7.0 database to
a SQL Server 2000 database, please use the following procedure:
1. Expand a server group, and then expand a server.
2. Right-click the server, point to All Tasks, and then click Copy Database
Wizard.
3. Complete the steps in the wizard.
After upgrading databases from SQL Server 7.0, run sp_updatestats (update
statistics) against the database on the destination server to ensure
optimal performance of the copied database.
Jim, does this answer your question? Please feel free to let me know if
this help solves your problem. If there is anything more I can still
assist you with, please feel free to post it in the group.
Best regards,
Billy Yao
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||You are correct in that I want to upgrade my SQL 7 to SQL
2000. I followed the steps you have below But when I get
to step 5 the wizard comes up with an empty instance text
box and will not allow me to use the word Default. It
says that there is an error in the current SQL 7 install
that the Client tools or the registry may have been
modified and only gives me the option to install a named
instance.
I need the upgrade to be the default instance because
there is a large number of programs that call the
database with the default instance. I am thinking that I
might be able to detach all of the databases then
uninstall SQL 7 and install SQL 2000 and finish up by
reattahing the databases.
I am conserned that I will lose scheduled jobs,
maintenace programs and DTS packages by doing the detach
attach method. Is there a way to ensute that I can bring
these other objects to the new SQ: 2000?
>--Original Message--
>Hi Jim,
>Thank you for using MSDN Newsgroup! It's my pleasure to
assist you with
>your issue.
>First of all, I would like to confirm my understanding
of your issue.
>From your description, I understand that you'd like to
upgrade SQL 7 to SQL
>2000. However, I'm unsure of the meaning "The only
option that I'm allowed
>is to create a named instance." When upgrading, SQL
Server 7.0
>automatically becomes the default instance of SQL Server
2000.
>As we known, you can overwrite the existing installation
of SQL Server 7.0
>by installing a default instance of SQL Server 2000. You
can also keep the
>installation of SQL Server 7.0 intact by installing a
named instance of SQL
>Server 2000. Both operations are performed using the
following procedure.
>To upgrade SQL Server 7.0 to SQL Server 2000
>1. Insert the Microsoft SQL Server 2000 compact disc
for the edition to
>which you want to upgrade into your CD-ROM drive. If the
compact disc does
>not autorun, double-click Autorun.exe in the root
directory of the compact
>disc.
>2. Select SQL Server 2000 Components, select Install
Database Server, and
>then setup prepares the SQL Server Installation Wizard.
At the Welcome
>screen, click Next.
>3. In Computer Name dialog box, Local Computer is
the default option and
>the local computer name appears in the edit box. Click
Next.
>4. In the Installation Selection dialog box, click
Upgrade, remove, or add
>components to an existing instance of SQL Server, and
then click Next.
>5. In the Instance Name dialog box, Default will be
selected. Click Next.
> # Note # When upgrading, SQL Server 7.0
automatically becomes the
>default instance of SQL Server 2000.
>6. In the Existing Installation dialog box, click
Upgrade your existing
>installation, and then click Next.
>7. In the Upgrade dialog box, you are prompted as to
whether you want to
>proceed with the requested upgrade. Click Yes, upgrade
my <text specific to
>the upgrade> to start the upgrade process, and then
click Next. The upgrade
>runs until finished.
>8. In the Connect to Server dialog box, select an
authentication mode, and
>then click Next.
>If you are not sure which mode to use, accept the
default: The Windows
>account information I use to log on to my computer with
(Windows).
>9. In Start Copying Files dialog box, click Next.
>10. In the Setup Complete dialog box, click Yes, I
want to restart my
>computer now, and then click Finish.
>
>Additionally, instead of a full upgrade from SQL Server
7.0 to SQL Server
>2000, which overwrites SQL Server 7.0, you can upgrade
SQL Server 7.0
>databases and associated meta data. To upgrade a SQL
Server 7.0 database to
>a SQL Server 2000 database, please use the following
procedure:
>1. Expand a server group, and then expand a server.
>2. Right-click the server, point to All Tasks, and
then click Copy Database
>Wizard.
>3. Complete the steps in the wizard.
>After upgrading databases from SQL Server 7.0, run
sp_updatestats (update
>statistics) against the database on the destination
server to ensure
>optimal performance of the copied database.
>
>Jim, does this answer your question? Please feel free to
let me know if
>this help solves your problem. If there is anything
more I can still
>assist you with, please feel free to post it in the
group.
>Best regards,
>Billy Yao
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>
>.
>|||> I am conserned that I will lose scheduled jobs,
> maintenace programs and DTS packages by doing the detach
> attach method. Is there a way to ensute that I can bring
> these other objects to the new SQ: 2000?
You can't restore msdb. But you can script the jobs alerts etc (EM, Management, Agent ... Script).
But I very much doubt it'll work for maint wiz. However, that shouldn't be too much work to redo
through the wizard. Also, don't forget stuff in master.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jim" <jim.abel@.lmco.com> wrote in message news:017801c3af8f$a20b0080$a301280a@.phx.gbl...
> You are correct in that I want to upgrade my SQL 7 to SQL
> 2000. I followed the steps you have below But when I get
> to step 5 the wizard comes up with an empty instance text
> box and will not allow me to use the word Default. It
> says that there is an error in the current SQL 7 install
> that the Client tools or the registry may have been
> modified and only gives me the option to install a named
> instance.
> I need the upgrade to be the default instance because
> there is a large number of programs that call the
> database with the default instance. I am thinking that I
> might be able to detach all of the databases then
> uninstall SQL 7 and install SQL 2000 and finish up by
> reattahing the databases.
> I am conserned that I will lose scheduled jobs,
> maintenace programs and DTS packages by doing the detach
> attach method. Is there a way to ensute that I can bring
> these other objects to the new SQ: 2000?
> >--Original Message--
> >Hi Jim,
> >
> >Thank you for using MSDN Newsgroup! It's my pleasure to
> assist you with
> >your issue.
> >
> >First of all, I would like to confirm my understanding
> of your issue.
> >
> >From your description, I understand that you'd like to
> upgrade SQL 7 to SQL
> >2000. However, I'm unsure of the meaning "The only
> option that I'm allowed
> >is to create a named instance." When upgrading, SQL
> Server 7.0
> >automatically becomes the default instance of SQL Server
> 2000.
> >
> >As we known, you can overwrite the existing installation
> of SQL Server 7.0
> >by installing a default instance of SQL Server 2000. You
> can also keep the
> >installation of SQL Server 7.0 intact by installing a
> named instance of SQL
> >Server 2000. Both operations are performed using the
> following procedure.
> >
> >To upgrade SQL Server 7.0 to SQL Server 2000
> >1. Insert the Microsoft SQL Server 2000 compact disc
> for the edition to
> >which you want to upgrade into your CD-ROM drive. If the
> compact disc does
> >not autorun, double-click Autorun.exe in the root
> directory of the compact
> >disc.
> >2. Select SQL Server 2000 Components, select Install
> Database Server, and
> >then setup prepares the SQL Server Installation Wizard.
> At the Welcome
> >screen, click Next.
> >3. In Computer Name dialog box, Local Computer is
> the default option and
> >the local computer name appears in the edit box. Click
> Next.
> >4. In the Installation Selection dialog box, click
> Upgrade, remove, or add
> >components to an existing instance of SQL Server, and
> then click Next.
> >5. In the Instance Name dialog box, Default will be
> selected. Click Next.
> > # Note # When upgrading, SQL Server 7.0
> automatically becomes the
> >default instance of SQL Server 2000.
> >
> >6. In the Existing Installation dialog box, click
> Upgrade your existing
> >installation, and then click Next.
> >7. In the Upgrade dialog box, you are prompted as to
> whether you want to
> >proceed with the requested upgrade. Click Yes, upgrade
> my <text specific to
> >the upgrade> to start the upgrade process, and then
> click Next. The upgrade
> >runs until finished.
> >8. In the Connect to Server dialog box, select an
> authentication mode, and
> >then click Next.
> >If you are not sure which mode to use, accept the
> default: The Windows
> >account information I use to log on to my computer with
> (Windows).
> >9. In Start Copying Files dialog box, click Next.
> >10. In the Setup Complete dialog box, click Yes, I
> want to restart my
> >computer now, and then click Finish.
> >
> >
> >Additionally, instead of a full upgrade from SQL Server
> 7.0 to SQL Server
> >2000, which overwrites SQL Server 7.0, you can upgrade
> SQL Server 7.0
> >databases and associated meta data. To upgrade a SQL
> Server 7.0 database to
> >a SQL Server 2000 database, please use the following
> procedure:
> >
> >1. Expand a server group, and then expand a server.
> >2. Right-click the server, point to All Tasks, and
> then click Copy Database
> >Wizard.
> >3. Complete the steps in the wizard.
> >After upgrading databases from SQL Server 7.0, run
> sp_updatestats (update
> >statistics) against the database on the destination
> server to ensure
> >optimal performance of the copied database.
> >
> >
> >Jim, does this answer your question? Please feel free to
> let me know if
> >this help solves your problem. If there is anything
> more I can still
> >assist you with, please feel free to post it in the
> group.
> >
> >Best regards,
> >
> >Billy Yao
> >Microsoft Online Support
> >----
> >Get Secure! - www.microsoft.com/security
> >This posting is provided "as is" with no warranties and
> confers no rights.
> >Please reply to newsgroups only. Thanks.
> >
> >
> >.
> >|||Hi Jim,
The following step by step KB guide you move the DTS packages and Scheduled Jobs.
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
Additionally, if you want to move the database diagrams, please following the following article
to separately move them (otherwise they will be lost):
320125 HOW TO: Move a Database Diagram
http://support.microsoft.com/?id=320125
Best regards,
Billy Yao
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
=====================
The issue is not resolved. I'm trying to decide the next steps to take to get the 7.0 Database
upgraded to 2000.
I'm upgrading a Standard edition to a Standard edition. As stated in the thread I need to find
out
what other objects that I need to migrate, and how, that won't be done when I detach and
reattach
the databases. Mainly what comes to mind is the DTS packages, Scheduled Jobs and not
so
important backups and maintenance plans.
A lost of the items and links of where to find How to's would be great.|||Billy,
Thanks for your help. This did the trick. I now have
all the information that I need to do the upgrade this
Saturday. Once again thank you for digging up all of the
articales. They have given me the necessary information
to complete the task.
Take Care
>--Original Message--
>Hi Jim,
>The following step by step KB guide you move the DTS
packages and Scheduled Jobs.
>314546 HOW TO: Move Databases Between Computers That Are
Running SQL Server
>http://support.microsoft.com/?id=314546
>Additionally, if you want to move the database diagrams,
please following the following article
>to separately move them (otherwise they will be lost):
>320125 HOW TO: Move a Database Diagram
>http://support.microsoft.com/?id=320125
>
>Best regards,
>Billy Yao
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>
>
>=====================>The issue is not resolved. I'm trying to decide the
next steps to take to get the 7.0 Database
>upgraded to 2000.
>I'm upgrading a Standard edition to a Standard edition.
As stated in the thread I need to find
>out
>what other objects that I need to migrate, and how, that
won't be done when I detach and
>reattach
>the databases. Mainly what comes to mind is the DTS
packages, Scheduled Jobs and not
>so
>important backups and maintenance plans.
>A lost of the items and links of where to find How to's
would be great.
>.
>

Saturday, February 25, 2012

Certification

I am just wondering if I wanna upgrade my MCDBA 2000 certification to MCDBA
2005 then which exam I have to clear ?
Thanks
Hi,
google should be your friend allthe time before asking in the groups:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||That means only one exam (Exam 70-447 to upgrade from 2000 to 2005 ?
Please advice.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169066687.258676.201810@.a75g2000cwd.googlegr oups.com...
> Hi,
> google should be your friend allthe time before asking in the groups:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||Hi,
and 70-431 in addition.
HTH, jens K. Suessmeyer.
http://www.sqlserver2005.de

Certificate not recognized by SQL 2005 - Encryption Problem

Hi,

We recently upgraded from SQL 2K to SQL 2005 on WINDOWS 2003 Server. The entire upgrade process has run pretty smoothly aside from encryption.

We have ASP.NET 1.x apps that connect to an internal server but fail when encrypted. We have tried all of the steps available on the MS KB and still have not resolved the issue.

On http://msdn2.microsoft.com/en-us/library/ms191192.aspx, we find the following:
To configure the server to accept encrypted connections

1. In SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, right-click Protocols for <server instance>, and then selectProperties.
2. In the Protocols for<instance name> Properties dialog box, on the Certificate tab, select the desired certificate from the drop down for the Certificate box, and then click OK.
3. On the Flags tab, in the ForceEncryption box, select Yes, and then click OK to close the dialog box.
4. Restart the SQL Server service.

The problem is when we get to step 2, there are NO certificates available in the dropdown box.

This problem is solely the result of installing SQL Server 2005. The apps were successfully encrypting data connections prior to the install. All internal and non-encrypted connections work correctly and no other changes were made to the box aside from the SQL 2005 upgrade.

This issue has remained unresolved for almost two weeks now.... We have tried the KB articles many times over, none of which have made a difference. We have also created certificates many times over, checking Server Authentication in the EKU section and making sure the cert has a private key. The expiration date on the certs we create are in 2009 and are named using the FQDN. Clearly, I'm no certificate expert, but there has got to be something we're missing with the certificates since every other app connection works like it should

What can I do to get certificates to appear in the Certificate tab of the Properties dialog box? What else would you recommend?

Many thanks.

-Matt

Orcabbelle,

To help you troubleshoot this issue, I need you to share some more info,

(1) ERRORLOG of the SQL Server,

You should be able to find it under place similar to

'C:\Program Files\Microsoft SQL Server\MSSQL.XX\MSSQL\LOG\ERRORLOG''

Extract specific lines that show certificate if any.

(2) Run certutil.exe as

certutil.exe -v -store my.

pasted the output w.r.t the cert that you have just installed here.

Generally, there is also way to modify the registry value to force server encryption. But it is not recommended because it is errorprone. Let me know if you want to do that to get you problem solved faster.

|||Nan,

There is only one relevant line I can find in the errorlog:
2006-04-04 11:11:03.59 Server A self-generated certificate was successfully loaded for encryption.

Not sure what this means or where I can find the self-generated cert. Is it the cert in with the data files?

As for #2, we ran the cmd line you suggested and everything looks good aside from:
CERT_ARCHIVED_PROP_ID(19):
3988ce37fa66df4b79d75bb63c7f8d0d_c381bd65-7971-4be2-9c1b-aef143aed909
ERROR: Certificate public key does NOT match stored keyset

|||

So the certificate you are using is corrupted somehow.

One possible reason is that you have a previous installed certificate, and the newly installed certificate does not have permission to over write the private key of the old one. I am assuming you do have a certificates that have both public key and private key is expotable.

Try to clean up your certificate store using MMC. that have same FQDN as this new one has. Then install the certificate in the local store. Try to run as local admin to clean/install the certificate.

Let me know what you get.

Selfsigned certificate is newly added feature in SS2k5 that help to encrypt even user does not have certificate. the self signed certificate is stored in master database. It is briefly mentioned here. As result, it is possible to force encryption without provisioning a valid certificate in SS2k5

http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx

|||We cleaned up our MMC and our new cert seems to be fine (not corrupted). We want to use our cert, not the self-signed cert.

As soon as we upgraded, all of our ASP.NET apps that were using Encrypt=True in their connection strings simply stopped working. Nothing else on either box, the server or the client, was changed. We changed the connection string to Encrypt=False and the apps work like they should, aside from not being encrypted. What could cause this?

We have tried just about every MS KB article and recommendation we can find. We created new certificates using a CA server. We made sure they have had private keys and allowed server authentication. Force protocol encryption is set to YES on the server.

We have never been able to get the certificate we create to appear in the list. We are logging on the server as the domain admin and starting the service under the same account.

Any ideas why we can't see the cert in the list or why the encryption failed after a SQL upgrade?

Many thanks!
|||

First, Your sql service should run under admin account, otherwise it has no permissing to the private key and thus the cert would not show up in the drop down list of SSCM, visit KB article for more detail:
http://support.microsoft.com/?kbid=900495.


Secondly, SQL Server 2005 has a new kind cert called self-signed certificate, which means when server can not find a good cert to load in the cert store, it will load such a self-signed cert. the encryption failure you saw is due to the reason that your server might load a self-signed cert(To verify this, you can go to server errorlog and see there is keyword "self-signed certificate"), and you forced client encryption through setting "Encrypt=True". If you already forced server encryption, the connection should be encrypted. And if you require forcing client encryption, you need to have server loading a certificate issued by a trusted CA.

Thirdly, please run "certutil.exe -v -store my", the tool would verify whether the certs you installed are valid;and try change sql service running under LocalSystem account, see whether any cert appear in the list.

|||

The only thing that I can think of is that the certificates that you are generating and the one you used for SS2K do not meet the stricter requirements of SS2K5. Please have a look at this post to see what properties we require from a cert:
http://blogs.msdn.com/sql_protocols/archive/2005/12/30/508311.aspx.

Thanks,
Il-Sung.

|||II-Sung, thanks again for your help.

Ok, IT has had a look at what you said and has had trouble with #4 found on the link you provided.

4) The Certficate’s key usage must include AT_KEYEXCHANGE property, which means Key Encipherment (a0)

They were able to find the Key Encipherment value but ours is not (a0), it's (f0). Not sure if this makes a difference or not.

From running "certutil.exe -v -store my":

Key Usage

Digital Signature, Non-Repudiation, Key Encipherment, Data Encipherment (f0)

|||

Hi Orcabelle,

Would you be able to try using a certificate that has a key usage of 0xA0 instead of 0xF0 and see if that makes a difference?

Also, could you indicate whether you're generating your own self-signed certificate? If so, what is the command that you're using the generate it. I believe it should be similar to:

makecert -r -pe -n "CN= MySQLServerName" -b 01/01/2000 -e 01/01/2036 -eku 1.3.6.1.5.5.7.3.1 -ss my -sr localMachine -sky exchange -sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12

Thanks,
Il-Sung.

|||At this point we're happy to try anything....

Now my question is, how do I change key usage from F to A?
|||

Hi Orcabelle,

I did some more looking into this and a key usage of f0 is perfectly fine. This is very perplexing problem. Could you please confirm that you're looking at the correct entry of the "certutil.exe -v -store my" output? i.e., you've properly correlated the cert hash with the one in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Certificate registry key?

Thanks,
Il-Sung.

|||II-Sung,

We have the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Certificate, but it has no value. We also have the cert hash data, but what syntax should the key be in?

If the cert hash is supposed to automatically appear in this registry key, it does not. When the key value is changed to match the thumbprint (cert hash (sha1)) of the certificate then the MSSQL service will not start. When the value is blanked the service starts as it should.
|||Here is the error we recieve from asp.net 2.0 when Encrypt=True...

"System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Security.GetSystemData() in C:\Inetpub\screen\App_Code\Security.vb:line 109
at Security.SecurityCheck() in C:\Inetpub\screen\App_Code\Security.vb:line 94"
|||

Orcabelle,

(1) To configure the server hash in sqlserver 2005, you need to put the ascii form of the Thumbprint in to the registry mentioned above, without any spacec in between and before and after, for example "06065fbcc0fd1b45b04dd67fd236673a9aa6563c". If the certificate specified in the hash is not a valid one from the point a view of sql server, sql server will fail to started. If your case if later, you can look the errorlog, look for certificate related and find what is the root cause.

(2) If you force encryption in the client, asp2.0 in your case, and that the server happens to use a self-signed certificate or a certificate that is not trusted by the client, you will see the error "The certificate chain was issued by an authority that is not trusted". In such case, in order to still use encryption, you can add a connection string property,

"TrustServerCertificate = true", such that client does not validate certificate hierarchy.

http://msdn2.microsoft.com/en-US/library/system.data.sqlclient.sqlconnection.connectionstring(VS.80).aspx

SQL book online, "Using Encryption Without Validation" in SQL Server 2005 Books Online." also have related info.

|||So after speaking with Microsoft, we have determined the issue, but we're still awaiting a possible resolution.

The problem we've run into is caused by our using both an internal (abc.local) and external (xyz.com) domain. All this time, we had been using the FQDN for our external domain, but this wasn't being recognized by SQL Server 2005. As soon as we created a certificate using the FQDN for our internal domain, it was recognized.

That said, we still don't know for sure whether client based encryption is possible using SQL Server 2005 with valid but different named domains. We have tested and server based encryption does seem to work, but we still want to know why client based does not. It should be a two way street or so they say.

Anyway, thank you all for the help you provided. I will post Microsoft's response/recommendations once we hear from them.

Have a good day.

-Matt

Friday, February 24, 2012

CE upgrade tool?

Have anyone written a tool to upgrade from CE to Everywhere that is easier to use that the upgrade.exe program?

Thanks

Hi,
I have written a free GUI Interface to it - available at
http://www.gui-innovations.com/download/SqlUpgrade.zip

Pete

|||

Hello Pete,

Thanks for the link to your program.

I ran the program and got this error message:

SQLMobile appears not to be installed - can't continue. Cab files should be in the C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 folders on your PC

What product/SDK is it expecting?

Thanks

Tom

|||

Hi,

you will need the .Net CF 2 runtimes, and the SqlMobile runtimes on the PPC to run it

Pete

Tuesday, February 14, 2012

Catastrophic Failure after SP2 Upgrade

We recently installed SP2 for reporting services. Everything seemed to work
fine for about 2 days, and now I'm getting errors and I can't access
reporting services at all.
Accessing http://server/reports gives the following error:
Unable to communicate with report server. Please verify that the report
server is operational.
After enabling debug mode, trying to access http://server/reportserver gives
me a COMException (0x800ffff): Catastrophic failure messge.
The only thing helpful in the log file seems to be this:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error doing timer action for Memory stats update;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Runtime.InteropServices.COMException (0x8000FFFF):
Catastrophic failure
I can't find any information on anything even remotely similar to this.
Does anyone have any ideas? Additionally, after settings debug=true in the
web.config file, the following page is displaying at
http://server/reportserver :
Server Error in '/ReportServer' Application.
----
Catastrophic failure
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Catastrophic
failure
Source Error:
Line 30: private static bool __initialized = false;
Line 31:
Line 32: public global_asax() {
Line 33: if ((ASP.global_asax.__initialized == false)) {
Line 34: ASP.global_asax.__initialized = true;
Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line: 32
Stack Trace:
[COMException (0x8000ffff): Catastrophic failure]
System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo) +0
Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
+46
Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
+5
Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
Microsoft.ReportingServices.WebServer.Global..ctor()
ASP.global_asax..ctor() in
c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
[TargetInvocationException: Exception has been thrown by the target of an
invocation.]
System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
+664
System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
Binder binder, Object[] args, CultureInfo culture, Object[]
activationAttributes) +200
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance() +160
System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
context) +20
System.Web.HttpApplicationFactory.Init(HttpContext context) +497
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +170
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032This doesn't sound related to SP2. Software upgrades in my experience do
wait 2 days to totally hose you, they tend to hose you right away.
What happens if you are on the server itself? Can you see the report then.
Be physically on the server and use this URL:
http://localhost/Reports/Pages/Folder.aspx
See anything? Do reports work?
Next try this:
http://localhost/ReportServer
Do you see anything? Will any report work?
The first URL brings you to Report Manager which is the front end (portal)
which ships with RS. The second is the guts of the system. It is where the
reports really reside.
If neither of these work then my guess is you had some sort of hardware
failure that corrupted either the web applications or corrupted the
database. RS uses SQL Server as an object store. All reports (plus lots of
other stuff) is stored in SQL Server databases.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe K" <jmk@.endowmentcapital.com> wrote in message
news:eOm1przdFHA.1040@.TK2MSFTNGP10.phx.gbl...
> We recently installed SP2 for reporting services. Everything seemed to
> work fine for about 2 days, and now I'm getting errors and I can't access
> reporting services at all.
> Accessing http://server/reports gives the following error:
> Unable to communicate with report server. Please verify that the report
> server is operational.
> After enabling debug mode, trying to access http://server/reportserver
> gives me a COMException (0x800ffff): Catastrophic failure messge.
> The only thing helpful in the log file seems to be this:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., Error doing timer action for Memory stats update;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.Runtime.InteropServices.COMException
> (0x8000FFFF): Catastrophic failure
> I can't find any information on anything even remotely similar to this.
> Does anyone have any ideas? Additionally, after settings debug=true in the
> web.config file, the following page is displaying at
> http://server/reportserver :
> Server Error in '/ReportServer' Application.
> ----
> Catastrophic failure
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.COMException:
> Catastrophic failure
> Source Error:
> Line 30: private static bool __initialized = false;
> Line 31:
> Line 32: public global_asax() {
> Line 33: if ((ASP.global_asax.__initialized == false)) {
> Line 34: ASP.global_asax.__initialized = true;
> Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
> ASP.NET Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line: 32
> Stack Trace:
> [COMException (0x8000ffff): Catastrophic failure]
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo) +0
> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
> +46
> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
> +5
> Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
> Microsoft.ReportingServices.WebServer.Global..ctor()
> ASP.global_asax..ctor() in
> c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
> Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
> [TargetInvocationException: Exception has been thrown by the target of an
> invocation.]
> System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
> System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
> System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
> binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
> +664
> System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
> Binder binder, Object[] args, CultureInfo culture, Object[]
> activationAttributes) +200
> System.Web.HttpApplicationFactory.GetSpecialApplicationInstance() +160
> System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
> context) +20
> System.Web.HttpApplicationFactory.Init(HttpContext context) +497
> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
> context) +170
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
>|||http://localhost/Reports/Pages/Folder.aspx just brings up the error message
"Unable to communicate with report server. Please verify that the report
server is operational." http://localhost/ReportServer is what gives me the
"Catatrophic failure" exception I pasted at the bottom of the last message.
I can't access any portion of reporting services. The only additional change
was SQL Server SP4. I haven't had any problems with any other database
applications.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e1zW%237zdFHA.3012@.tk2msftngp13.phx.gbl...
> This doesn't sound related to SP2. Software upgrades in my experience do
> wait 2 days to totally hose you, they tend to hose you right away.
> What happens if you are on the server itself? Can you see the report then.
> Be physically on the server and use this URL:
> http://localhost/Reports/Pages/Folder.aspx
> See anything? Do reports work?
> Next try this:
> http://localhost/ReportServer
> Do you see anything? Will any report work?
> The first URL brings you to Report Manager which is the front end (portal)
> which ships with RS. The second is the guts of the system. It is where the
> reports really reside.
> If neither of these work then my guess is you had some sort of hardware
> failure that corrupted either the web applications or corrupted the
> database. RS uses SQL Server as an object store. All reports (plus lots of
> other stuff) is stored in SQL Server databases.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Joe K" <jmk@.endowmentcapital.com> wrote in message
> news:eOm1przdFHA.1040@.TK2MSFTNGP10.phx.gbl...
>> We recently installed SP2 for reporting services. Everything seemed to
>> work fine for about 2 days, and now I'm getting errors and I can't access
>> reporting services at all.
>> Accessing http://server/reports gives the following error:
>> Unable to communicate with report server. Please verify that the report
>> server is operational.
>> After enabling debug mode, trying to access http://server/reportserver
>> gives me a COMException (0x800ffff): Catastrophic failure messge.
>> The only thing helpful in the log file seems to be this:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., Error doing timer action for Memory stats update;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.Runtime.InteropServices.COMException
>> (0x8000FFFF): Catastrophic failure
>> I can't find any information on anything even remotely similar to this.
>> Does anyone have any ideas? Additionally, after settings debug=true in
>> the web.config file, the following page is displaying at
>> http://server/reportserver :
>> Server Error in '/ReportServer' Application.
>> ----
>> Catastrophic failure
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>> Exception Details: System.Runtime.InteropServices.COMException:
>> Catastrophic failure
>> Source Error:
>> Line 30: private static bool __initialized = false;
>> Line 31:
>> Line 32: public global_asax() {
>> Line 33: if ((ASP.global_asax.__initialized == false)) {
>> Line 34: ASP.global_asax.__initialized = true;
>> Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
>> ASP.NET Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line: 32
>> Stack Trace:
>> [COMException (0x8000ffff): Catastrophic failure]
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> errorCode, IntPtr errorInfo) +0
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
>> +46
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
>> +5
>> Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
>> Microsoft.ReportingServices.WebServer.Global..ctor()
>> ASP.global_asax..ctor() in
>> c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
>> Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
>> [TargetInvocationException: Exception has been thrown by the target of an
>> invocation.]
>> System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
>> System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
>> System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
>> binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +664
>> System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +200
>> System.Web.HttpApplicationFactory.GetSpecialApplicationInstance() +160
>> System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
>> context) +20
>> System.Web.HttpApplicationFactory.Init(HttpContext context) +497
>> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
>> context) +170
>> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
>> +414
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>|||I have not seen anyone with this problem. I think you should open a service
request with MS. Or, just uninstall and reinstall everything.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe K" <jmk@.endowmentcapital.com> wrote in message
news:%231B6LU0dFHA.228@.TK2MSFTNGP12.phx.gbl...
> http://localhost/Reports/Pages/Folder.aspx just brings up the error
> message "Unable to communicate with report server. Please verify that the
> report server is operational." http://localhost/ReportServer is what
> gives me the "Catatrophic failure" exception I pasted at the bottom of the
> last message. I can't access any portion of reporting services. The only
> additional change was SQL Server SP4. I haven't had any problems with any
> other database applications.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e1zW%237zdFHA.3012@.tk2msftngp13.phx.gbl...
>> This doesn't sound related to SP2. Software upgrades in my experience do
>> wait 2 days to totally hose you, they tend to hose you right away.
>> What happens if you are on the server itself? Can you see the report
>> then. Be physically on the server and use this URL:
>> http://localhost/Reports/Pages/Folder.aspx
>> See anything? Do reports work?
>> Next try this:
>> http://localhost/ReportServer
>> Do you see anything? Will any report work?
>> The first URL brings you to Report Manager which is the front end
>> (portal) which ships with RS. The second is the guts of the system. It is
>> where the reports really reside.
>> If neither of these work then my guess is you had some sort of hardware
>> failure that corrupted either the web applications or corrupted the
>> database. RS uses SQL Server as an object store. All reports (plus lots
>> of other stuff) is stored in SQL Server databases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Joe K" <jmk@.endowmentcapital.com> wrote in message
>> news:eOm1przdFHA.1040@.TK2MSFTNGP10.phx.gbl...
>> We recently installed SP2 for reporting services. Everything seemed to
>> work fine for about 2 days, and now I'm getting errors and I can't
>> access reporting services at all.
>> Accessing http://server/reports gives the following error:
>> Unable to communicate with report server. Please verify that the report
>> server is operational.
>> After enabling debug mode, trying to access http://server/reportserver
>> gives me a COMException (0x800ffff): Catastrophic failure messge.
>> The only thing helpful in the log file seems to be this:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., Error doing timer action for Memory stats update;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.Runtime.InteropServices.COMException
>> (0x8000FFFF): Catastrophic failure
>> I can't find any information on anything even remotely similar to this.
>> Does anyone have any ideas? Additionally, after settings debug=true in
>> the web.config file, the following page is displaying at
>> http://server/reportserver :
>> Server Error in '/ReportServer' Application.
>> ----
>> Catastrophic failure
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>> Exception Details: System.Runtime.InteropServices.COMException:
>> Catastrophic failure
>> Source Error:
>> Line 30: private static bool __initialized = false;
>> Line 31:
>> Line 32: public global_asax() {
>> Line 33: if ((ASP.global_asax.__initialized == false)) {
>> Line 34: ASP.global_asax.__initialized = true;
>> Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
>> ASP.NET Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line: 32
>> Stack Trace:
>> [COMException (0x8000ffff): Catastrophic failure]
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> errorCode, IntPtr errorInfo) +0
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
>> +46
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
>> +5
>> Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
>> Microsoft.ReportingServices.WebServer.Global..ctor()
>> ASP.global_asax..ctor() in
>> c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
>> Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
>> [TargetInvocationException: Exception has been thrown by the target of
>> an invocation.]
>> System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
>> System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
>> System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder
>> binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +664
>> System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +200
>> System.Web.HttpApplicationFactory.GetSpecialApplicationInstance() +160
>> System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
>> context) +20
>> System.Web.HttpApplicationFactory.Init(HttpContext context) +497
>> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
>> context) +170
>> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
>> +414
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>>
>|||Thanks alot for the advice, Bruce. I'll try a reinstall first and see what
happens.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OcrHR40dFHA.796@.TK2MSFTNGP09.phx.gbl...
>I have not seen anyone with this problem. I think you should open a service
>request with MS. Or, just uninstall and reinstall everything.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joe K" <jmk@.endowmentcapital.com> wrote in message
> news:%231B6LU0dFHA.228@.TK2MSFTNGP12.phx.gbl...
>> http://localhost/Reports/Pages/Folder.aspx just brings up the error
>> message "Unable to communicate with report server. Please verify that
>> the report server is operational." http://localhost/ReportServer is what
>> gives me the "Catatrophic failure" exception I pasted at the bottom of
>> the last message. I can't access any portion of reporting services. The
>> only additional change was SQL Server SP4. I haven't had any problems
>> with any other database applications.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e1zW%237zdFHA.3012@.tk2msftngp13.phx.gbl...
>> This doesn't sound related to SP2. Software upgrades in my experience do
>> wait 2 days to totally hose you, they tend to hose you right away.
>> What happens if you are on the server itself? Can you see the report
>> then. Be physically on the server and use this URL:
>> http://localhost/Reports/Pages/Folder.aspx
>> See anything? Do reports work?
>> Next try this:
>> http://localhost/ReportServer
>> Do you see anything? Will any report work?
>> The first URL brings you to Report Manager which is the front end
>> (portal) which ships with RS. The second is the guts of the system. It
>> is where the reports really reside.
>> If neither of these work then my guess is you had some sort of hardware
>> failure that corrupted either the web applications or corrupted the
>> database. RS uses SQL Server as an object store. All reports (plus lots
>> of other stuff) is stored in SQL Server databases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Joe K" <jmk@.endowmentcapital.com> wrote in message
>> news:eOm1przdFHA.1040@.TK2MSFTNGP10.phx.gbl...
>> We recently installed SP2 for reporting services. Everything seemed to
>> work fine for about 2 days, and now I'm getting errors and I can't
>> access reporting services at all.
>> Accessing http://server/reports gives the following error:
>> Unable to communicate with report server. Please verify that the
>> report server is operational.
>> After enabling debug mode, trying to access http://server/reportserver
>> gives me a COMException (0x800ffff): Catastrophic failure messge.
>> The only thing helpful in the log file seems to be this:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., Error doing timer action for Memory stats update;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.Runtime.InteropServices.COMException
>> (0x8000FFFF): Catastrophic failure
>> I can't find any information on anything even remotely similar to this.
>> Does anyone have any ideas? Additionally, after settings debug=true in
>> the web.config file, the following page is displaying at
>> http://server/reportserver :
>> Server Error in '/ReportServer' Application.
>> ----
>> Catastrophic failure
>> Description: An unhandled exception occurred during the execution of
>> the current web request. Please review the stack trace for more
>> information about the error and where it originated in the code.
>> Exception Details: System.Runtime.InteropServices.COMException:
>> Catastrophic failure
>> Source Error:
>> Line 30: private static bool __initialized = false;
>> Line 31:
>> Line 32: public global_asax() {
>> Line 33: if ((ASP.global_asax.__initialized == false)) {
>> Line 34: ASP.global_asax.__initialized = true;
>> Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
>> ASP.NET Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line: 32
>> Stack Trace:
>> [COMException (0x8000ffff): Catastrophic failure]
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> errorCode, IntPtr errorInfo) +0
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
>> +46
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
>> +5
>> Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
>> Microsoft.ReportingServices.WebServer.Global..ctor()
>> ASP.global_asax..ctor() in
>> c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
>> Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
>> [TargetInvocationException: Exception has been thrown by the target of
>> an invocation.]
>> System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
>> System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
>> System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +664
>> System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +200
>> System.Web.HttpApplicationFactory.GetSpecialApplicationInstance()
>> +160
>> System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
>> context) +20
>> System.Web.HttpApplicationFactory.Init(HttpContext context) +497
>> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
>> context) +170
>> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
>> +414
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>>
>>
>|||Just as an FYI to anybody, a reinstall worked (although a reboot was
necessary).
"Joe K" <jmk@.endowmentcapital.com> wrote in message
news:u25IvR2dFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Thanks alot for the advice, Bruce. I'll try a reinstall first and see
> what happens.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OcrHR40dFHA.796@.TK2MSFTNGP09.phx.gbl...
>>I have not seen anyone with this problem. I think you should open a
>>service request with MS. Or, just uninstall and reinstall everything.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joe K" <jmk@.endowmentcapital.com> wrote in message
>> news:%231B6LU0dFHA.228@.TK2MSFTNGP12.phx.gbl...
>> http://localhost/Reports/Pages/Folder.aspx just brings up the error
>> message "Unable to communicate with report server. Please verify that
>> the report server is operational." http://localhost/ReportServer is
>> what gives me the "Catatrophic failure" exception I pasted at the bottom
>> of the last message. I can't access any portion of reporting services.
>> The only additional change was SQL Server SP4. I haven't had any
>> problems with any other database applications.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e1zW%237zdFHA.3012@.tk2msftngp13.phx.gbl...
>> This doesn't sound related to SP2. Software upgrades in my experience
>> do wait 2 days to totally hose you, they tend to hose you right away.
>> What happens if you are on the server itself? Can you see the report
>> then. Be physically on the server and use this URL:
>> http://localhost/Reports/Pages/Folder.aspx
>> See anything? Do reports work?
>> Next try this:
>> http://localhost/ReportServer
>> Do you see anything? Will any report work?
>> The first URL brings you to Report Manager which is the front end
>> (portal) which ships with RS. The second is the guts of the system. It
>> is where the reports really reside.
>> If neither of these work then my guess is you had some sort of hardware
>> failure that corrupted either the web applications or corrupted the
>> database. RS uses SQL Server as an object store. All reports (plus lots
>> of other stuff) is stored in SQL Server databases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Joe K" <jmk@.endowmentcapital.com> wrote in message
>> news:eOm1przdFHA.1040@.TK2MSFTNGP10.phx.gbl...
>> We recently installed SP2 for reporting services. Everything seemed to
>> work fine for about 2 days, and now I'm getting errors and I can't
>> access reporting services at all.
>> Accessing http://server/reports gives the following error:
>> Unable to communicate with report server. Please verify that the
>> report server is operational.
>> After enabling debug mode, trying to access http://server/reportserver
>> gives me a COMException (0x800ffff): Catastrophic failure messge.
>> The only thing helpful in the log file seems to be this:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., Error doing timer action for Memory stats update;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.Runtime.InteropServices.COMException
>> (0x8000FFFF): Catastrophic failure
>> I can't find any information on anything even remotely similar to
>> this. Does anyone have any ideas? Additionally, after settings
>> debug=true in the web.config file, the following page is displaying at
>> http://server/reportserver :
>> Server Error in '/ReportServer' Application.
>> ----
>> Catastrophic failure
>> Description: An unhandled exception occurred during the execution of
>> the current web request. Please review the stack trace for more
>> information about the error and where it originated in the code.
>> Exception Details: System.Runtime.InteropServices.COMException:
>> Catastrophic failure
>> Source Error:
>> Line 30: private static bool __initialized = false;
>> Line 31:
>> Line 32: public global_asax() {
>> Line 33: if ((ASP.global_asax.__initialized == false)) {
>> Line 34: ASP.global_asax.__initialized = true;
>> Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
>> ASP.NET Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line: 32
>> Stack Trace:
>> [COMException (0x8000ffff): Catastrophic failure]
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> errorCode, IntPtr errorInfo) +0
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
>> +46
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
>> +5
>> Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
>> Microsoft.ReportingServices.WebServer.Global..ctor()
>> ASP.global_asax..ctor() in
>> c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
>> Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
>> [TargetInvocationException: Exception has been thrown by the target of
>> an invocation.]
>> System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
>> System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
>> System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +664
>> System.Activator.CreateInstance(Type type, BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +200
>> System.Web.HttpApplicationFactory.GetSpecialApplicationInstance()
>> +160
>> System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
>> context) +20
>> System.Web.HttpApplicationFactory.Init(HttpContext context) +497
>> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
>> context) +170
>> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
>> +414
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>>
>>
>>
>|||Good. Glad you are back up. Thanks for getting back with the result. It
definitely helps to know what worked.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe K" <jmk@.endowmentcapital.com> wrote in message
news:OU4qO7NeFHA.412@.tk2msftngp13.phx.gbl...
> Just as an FYI to anybody, a reinstall worked (although a reboot was
> necessary).
> "Joe K" <jmk@.endowmentcapital.com> wrote in message
> news:u25IvR2dFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Thanks alot for the advice, Bruce. I'll try a reinstall first and see
>> what happens.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcrHR40dFHA.796@.TK2MSFTNGP09.phx.gbl...
>>I have not seen anyone with this problem. I think you should open a
>>service request with MS. Or, just uninstall and reinstall everything.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joe K" <jmk@.endowmentcapital.com> wrote in message
>> news:%231B6LU0dFHA.228@.TK2MSFTNGP12.phx.gbl...
>> http://localhost/Reports/Pages/Folder.aspx just brings up the error
>> message "Unable to communicate with report server. Please verify that
>> the report server is operational." http://localhost/ReportServer is
>> what gives me the "Catatrophic failure" exception I pasted at the
>> bottom of the last message. I can't access any portion of reporting
>> services. The only additional change was SQL Server SP4. I haven't had
>> any problems with any other database applications.
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:e1zW%237zdFHA.3012@.tk2msftngp13.phx.gbl...
>> This doesn't sound related to SP2. Software upgrades in my experience
>> do wait 2 days to totally hose you, they tend to hose you right away.
>> What happens if you are on the server itself? Can you see the report
>> then. Be physically on the server and use this URL:
>> http://localhost/Reports/Pages/Folder.aspx
>> See anything? Do reports work?
>> Next try this:
>> http://localhost/ReportServer
>> Do you see anything? Will any report work?
>> The first URL brings you to Report Manager which is the front end
>> (portal) which ships with RS. The second is the guts of the system. It
>> is where the reports really reside.
>> If neither of these work then my guess is you had some sort of
>> hardware failure that corrupted either the web applications or
>> corrupted the database. RS uses SQL Server as an object store. All
>> reports (plus lots of other stuff) is stored in SQL Server databases.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Joe K" <jmk@.endowmentcapital.com> wrote in message
>> news:eOm1przdFHA.1040@.TK2MSFTNGP10.phx.gbl...
>> We recently installed SP2 for reporting services. Everything seemed
>> to work fine for about 2 days, and now I'm getting errors and I can't
>> access reporting services at all.
>> Accessing http://server/reports gives the following error:
>> Unable to communicate with report server. Please verify that the
>> report server is operational.
>> After enabling debug mode, trying to access
>> http://server/reportserver gives me a COMException (0x800ffff):
>> Catastrophic failure messge.
>> The only thing helpful in the log file seems to be this:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log
>> for more details., Error doing timer action for Memory stats update;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log
>> for more details. --> System.Runtime.InteropServices.COMException
>> (0x8000FFFF): Catastrophic failure
>> I can't find any information on anything even remotely similar to
>> this. Does anyone have any ideas? Additionally, after settings
>> debug=true in the web.config file, the following page is displaying
>> at http://server/reportserver :
>> Server Error in '/ReportServer' Application.
>> ----
>> Catastrophic failure
>> Description: An unhandled exception occurred during the execution of
>> the current web request. Please review the stack trace for more
>> information about the error and where it originated in the code.
>> Exception Details: System.Runtime.InteropServices.COMException:
>> Catastrophic failure
>> Source Error:
>> Line 30: private static bool __initialized = false;
>> Line 31:
>> Line 32: public global_asax() {
>> Line 33: if ((ASP.global_asax.__initialized == false)) {
>> Line 34: ASP.global_asax.__initialized = true;
>> Source File: c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
>> ASP.NET Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs Line:
>> 32
>> Stack Trace:
>> [COMException (0x8000ffff): Catastrophic failure]
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> errorCode, IntPtr errorInfo) +0
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateBytes()
>> +46
>> Microsoft.ReportingServices.Utilities.ProcessUtilities.GetPrivateMBytes()
>> +5
>> Microsoft.ReportingServices.Diagnostics.ResourceUtilities.UpdatePrivateMBytes()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer.DoTimerAction()
>> Microsoft.ReportingServices.Diagnostics.MemoryStatsTimer..ctor()
>> Microsoft.ReportingServices.WebServer.Global..ctor()
>> ASP.global_asax..ctor() in
>> c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET
>> Files\reportserver\94eb9a55\49df36c9\ofoapisc.0.cs:32
>> [TargetInvocationException: Exception has been thrown by the target
>> of an invocation.]
>> System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) +0
>> System.Activator.CreateInstance(Type type, Boolean nonPublic) +66
>> System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr,
>> Binder binder, Object[] args, CultureInfo culture, Object[]
>> activationAttributes) +664
>> System.Activator.CreateInstance(Type type, BindingFlags
>> bindingAttr, Binder binder, Object[] args, CultureInfo culture,
>> Object[] activationAttributes) +200
>> System.Web.HttpApplicationFactory.GetSpecialApplicationInstance()
>> +160
>> System.Web.HttpApplicationFactory.FireApplicationOnStart(HttpContext
>> context) +20
>> System.Web.HttpApplicationFactory.Init(HttpContext context) +497
>> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
>> context) +170
>> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
>> +414
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>>
>>
>>
>>
>