Failed MSDE installation - Feedback on posting by Jason Howell

Hi Jason, Hi all,
I have been having an error installing MSDE and discovered a thread in this
newsgroup, which appears to handle the same error.
Specifically, the post http://tinyurl.com/2vtzv by Jason Howell seemed
relevant.
Interestingly, setting BLANKSAPWD=1 did get the installation to complete,
but I was still not able to start the service. This did not really help me.
Now I believe that I have more information , which may be interesting to
others.
The problem appears to be related to the facts that,
- I have the SQL Server 2000 Enterprise Edition client tools installed on my
machine
- I have already installed and deinstalled an MSDE instance with the same
instance name (CS3DB).
I have managed to install a second instance of MSDE using a different
instance name (CS3DBTEST) and this works perfectly.
The problem is clearly related to the instance name CS3DB.
However, although I had unistalled the CS3DB instance, various entries were
left in the registry. These were:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
InstalledInstances=CS3DB CS3DBTEST
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set
InstanceComponentSet.1={E09B48B5-E141-427A-AB0C-D3605127224A}
InstanceComponentSet.2={689404D2-1C94-44B3-9203-BEC5594FDA7A}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\CS3DB
...
which all indicate to me that the CS3DB instance had not been removed
properly, and that in some manner or other, there were still two versions
installed. However, the CS3DB instance no longer appeared in the Add/Remove
programs dialog in the control panel.
My suspision is, that is you have the SQL Server 2000 client tools installed
before you install MSDE, then you cannot cleanly remove the first instance
of MSDE.
I have now modified the registry, by:
removing CS3DB from
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\InstalledInstances
deleting
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Component Set
InstanceComponentSet.1={E09B48B5-E141-427A-AB0C-D3605127224A}
deleting the related key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall\{E09B
48B5-E141-427A-AB0C-D3605127224A}
and deleting the key and subkeys
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\CS3DB
This seems to have down the trick.
I have now reinstalled the MSDE instance CS3DB and it seems to be working.
So again, my guess is that uninstalling MSDE in the presence of the SQL
client tools does not work properly.
Hope this helps somebody and any feedback would be appreciated.
Phil
Hi,
I have now repeated this, as follows:
- uninstall instance CS3DB
- try to reinstall - it fails
- remove registry entries as described before
- try to reinstall - it works.
Phil
|||"Phil Jollans" <nospam@.messring.de> wrote in message
news:2kg1ioF1qnrpU1@.uni-berlin.de...
> Hi,
> I have now repeated this, as follows:
> - uninstall instance CS3DB
> - try to reinstall - it fails
> - remove registry entries as described before
> - try to reinstall - it works.
> Phil
>
This may not be big news to others, but it's a valuable piece of information
to me, as we use MSDE in our labs and classrooms, and many of our students
use it at home in conjunction with Visual Studio .NET. (Next time I have a
student who is having MSDE trouble, I now have one more question/possible
solution to use).
Thanks very much for sharing! It's what makes these groups so valuable.
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Fail to install RS 2k on windows 2k3 with IIS configuration error

***Environment:
Windows 2003 Standard, IIS 6.0, SQL Server 2000
***Error:
When installing, warning message appears as:
"IIS is either not installed or not configurated for a server component
installation"
After the installation is finished by ignoreing the preceding warning, no
virtual dir is crated for RS to run.
***My idea:
After reading the setup document, I find out that:
"If you are using IIS 6.x, Setup uses the default application pool. If the
default Web site or application pool is not available, Setup will continue,
but your installation will not work once Setup is finished." That might be
the major cause of the problem...
***My problem:
Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
6.0. The only thing is that RS can not recognize it...
Is there anybody could give some advice? Thanks in advance!!!i found this once when i hadnt got aspnet reg'd for iis
i went to
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
i then went into start > programs > sql server 2005 > reporting
services configuration
and you can get it to have another go at creating the websites (an
option on the left). this worked for me.
db
--
http://www.osix.net
the open source institute
home of the geek programming challenges
CrazyCalculator wrote:
> ***Environment:
> Windows 2003 Standard, IIS 6.0, SQL Server 2000
> ***Error:
> When installing, warning message appears as:
> "IIS is either not installed or not configurated for a server component
> installation"
> After the installation is finished by ignoreing the preceding warning, no
> virtual dir is crated for RS to run.
> ***My idea:
> After reading the setup document, I find out that:
> "If you are using IIS 6.x, Setup uses the default application pool. If the
> default Web site or application pool is not available, Setup will continue,
> but your installation will not work once Setup is finished." That might be
> the major cause of the problem...
> ***My problem:
> Actually, I have the Default Application Pool (DefaultAppPool) in my IIS
> 6.0. The only thing is that RS can not recognize it...
> Is there anybody could give some advice? Thanks in advance!!!|||Thank bb for your suggestion :)
However, I am install Reporting services 2000 on SQL Server 2000 and my
ASP.NET 1.1 seems to be perfectly registed...|||then sorry friend, cant really help as ive not tried with 2000
tell your techies to get update with the latest stuff!
good luck
db
CrazyCalculator wrote:
> Thank bb for your suggestion :)
> However, I am install Reporting services 2000 on SQL Server 2000 and my
> ASP.NET 1.1 seems to be perfectly registed...|||At last, with the inspiration of the goddess in my dream, I solve the evil
problem...
(1) Cause
SQL Server 2000 Need the "Default Web Site" as one of its installation
prerequisite. When I say "Default Web Site", I mean the Site with the
identifier 1. You can view the indentifier once you click "Web Sites" in your
IIS Manager.
(2) Why I fail
Really simple, I deleted the "Default Web Site" long time ago. The install
program can not find one Web Site with identifier 1, so it fails.
(3) How to do
Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
Kit Tools, with Metabase Explorer", Download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
(4) And there is a document to help you
"http://www.gafvert.info/notes/IISDefaultWebsite.htm"
Hope you lucky.|||Hi, I have the same problem, it is just that I have a nr 1 and when I tried
to change I got the erroe that I didn´t have IIS installed, prior to this I
"only" have the error that I dont have asp.net installed or configured,
despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
I have tried to switch between both, but the result is the same error, any
ideas?
DQ
"CrazyCalculator" wrote:
> At last, with the inspiration of the goddess in my dream, I solve the evil
> problem...
> (1) Cause
> SQL Server 2000 Need the "Default Web Site" as one of its installation
> prerequisite. When I say "Default Web Site", I mean the Site with the
> identifier 1. You can view the indentifier once you click "Web Sites" in your
> IIS Manager.
> (2) Why I fail
> Really simple, I deleted the "Default Web Site" long time ago. The install
> program can not find one Web Site with identifier 1, so it fails.
> (3) How to do
> Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> Kit Tools, with Metabase Explorer", Download it from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> (4) And there is a document to help you
> "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
>
> Hope you lucky.|||SOLUTION that helped me!!
FIX: Error "ASP.NET v1.1 not Installed" while installing Sql Server 2000
Reporting Services
I finally had the chance to rebuild my dev machine with the RTM version of
Sql Server 200 Reporting Services [SQL2kRS] and ran into an unusual error.
During the "Check Prerequisites" stage of installation, it said that I didnt
have ASP.NET v1.1 installed on my PC. Considering that I do web-development
with VS.NET 2003 on this PC I was a bit perplexed why it said that.
After much digging and exploring, I finally discovered the problem. A
recent install of the new XP version of the Longhorn Command Shell had
installed the .NET Framework v2.0.31113.33 and set it as the Root Version of
the framework for ASP.NET.
So, the fix is pretty trivial, just update the RootVer registry value to
correctly (or temporarily) show v1.1.4322.573.
[\\HKLM\SOFTWARE\Microsoft\ASP.NET\RootVer] = "1.1.4322.573"
Strangely enough, this didnt seem to be affecting my ASP.NET applications.
*shrug*
None of this was documented in the verbose Help files that shipped with
SQL2kRS. This got me thinking about the nature of help files. Far too
often, I see FAQ's and "Common Issues" under the Troubleshooting section of
help files, yet rarely do I have those "common" problems.
I would much prefer a generic section on, "How to troubleshoot", "Where to
look for error clues", and provide deep lists of "Why an application or
installation might fail".
In this case, I actually did find a good reference in the Help entitled "Log
Files Used During Installation". This section explained how to locate the
log files created during installation, and this is how I eventually solved
the problem.
For reference, in SQL2kRS there are 3 main places to look for log files;
C:\Program Files\Microsoft SQL Server\80\RS Setup Bootstrap\Log\RSStp_.cab
(inside the CAB)
AND
%temp%\rsstp<integer>.log
(<integer> = number to make filename unique. e.g. rsstp2.log)
AND
%temp%\RSMSI<integer>.log
The latter 2 log files are the same ones that get copied into the CAB file
listed above, but its still useful knowledge in case something fails before
they get added to the CAB.
"DQ" wrote:
> Hi, I have the same problem, it is just that I have a nr 1 and when I tried
> to change I got the erroe that I didn´t have IIS installed, prior to this I
> "only" have the error that I dont have asp.net installed or configured,
> despite that it is installed and configured, I have both asp.net 1.1 and 2.0,
> I have tried to switch between both, but the result is the same error, any
> ideas?
> DQ
> "CrazyCalculator" wrote:
> > At last, with the inspiration of the goddess in my dream, I solve the evil
> > problem...
> >
> > (1) Cause
> > SQL Server 2000 Need the "Default Web Site" as one of its installation
> > prerequisite. When I say "Default Web Site", I mean the Site with the
> > identifier 1. You can view the indentifier once you click "Web Sites" in your
> > IIS Manager.
> >
> > (2) Why I fail
> > Really simple, I deleted the "Default Web Site" long time ago. The install
> > program can not find one Web Site with identifier 1, so it fails.
> >
> > (3) How to do
> > Create a Web Site with identifier 1. This could be done by "IIS 6.0 Resource
> > Kit Tools, with Metabase Explorer", Download it from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyID=56fc92ee-a71a-4c73-b628-ade629c89499&DisplayLang=en
> >
> > (4) And there is a document to help you
> > "http://www.gafvert.info/notes/IISDefaultWebsite.htm"
> >
> >
> > Hope you lucky.

Extremely critical. problems with OLAP SERVER (sorry)

I am so sorry fot insist this way, such be a pain, i know but it is very
critical.
A lot!
When I launch my routine from our back-end vb appears this:
Cannot open connection to Analysis server 'BUESSQL01'.
Error in data [Possible data corruption] ''
..
Set m_dsoServer = New DSO.Server
m_dsoServer.Connect m_strMDSERVER
What is happening?
-That servers is reached via PING.
-OLAP services are up and running.
-OLAP server belong to NT domain.
-User which is being responsible for that (via vb code) belong to NT Domain.
?
Any help will be welcomed.
Thanks,1. Ping is against a different service, so it has nothing to do.
2. Service running and database corruption are two different things
3. Domain membership does not appear to be the problem here (database or use
r)
It does not appear that you have an authentication issue, based on your
post. I would check your analysis services database and make sure it is not
corrupt. If it is, no amount of tinkering will help.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Enric" wrote:

> I am so sorry fot insist this way, such be a pain, i know but it is very
> critical.
> A lot!
>
> When I launch my routine from our back-end vb appears this:
> Cannot open connection to Analysis server 'BUESSQL01'.
> Error in data [Possible data corruption] ''
> ..
> Set m_dsoServer = New DSO.Server
> m_dsoServer.Connect m_strMDSERVER
>
> What is happening?
> -That servers is reached via PING.
> -OLAP services are up and running.
> -OLAP server belong to NT domain.
> -User which is being responsible for that (via vb code) belong to NT Domai
n.
> ?
> Any help will be welcomed.
> Thanks,
>|||Have you changed your password lately? I have seen this error when I change
my network password but still have an open connection (remote) with the old
password. If this is the case logoff and login again.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:6FA71B2A-BCD6-4475-946A-8DBE80640272@.microsoft.com...
>I am so sorry fot insist this way, such be a pain, i know but it is very
> critical.
> A lot!
>
> When I launch my routine from our back-end vb appears this:
> Cannot open connection to Analysis server 'BUESSQL01'.
> Error in data [Possible data corruption] ''
> ..
> Set m_dsoServer = New DSO.Server
> m_dsoServer.Connect m_strMDSERVER
>
> What is happening?
> -That servers is reached via PING.
> -OLAP services are up and running.
> -OLAP server belong to NT domain.
> -User which is being responsible for that (via vb code) belong to NT
> Domain.
> ?
> Any help will be welcomed.
> Thanks,
>

Extracting XSD Collection

I've got a really quick - and I'm sure easy - question...

I'm wondering is there any way to extract an XSD Schema collection so that it appears as a well formed XML document?

The only thing I've seen is if you right click on a sche,a collection, you can either script it as a CREATE or a DROP. The CREATE script has no formatting whatsoever - it's all one one line.

If anyone has done this or knows of an effective way to accomplish this, your help would be greatly appreciated!

Thanks!

SELECT xml_schema_namespace('db_SchemaName','XmlSchemaCollectionName')

e.g.: SELECT xml_schema_namespace('dbo','MyXmlSchema')

|||Thanks Phe....!!