Installing MSDE with a different instance name

Hi All,
I'm trying (and have been for ages) to install a MSDE server with adifferent instance name than the default. Im setting theinstancename when using the setup.exe file and all seems to installfine, but when I then restart my system the SQL icon appears in thesystem tray but the white circle is completely empty. It saysthat it is not connected.
If i install with the default instance name then all seems to work fine.
Does anyone know what I am doing wrong and what I can do to fix this problem?
Thanks in advance for any help!
The text below is from the BOL (books online). Hope this helps.
(When you install SQL Server 2000 on a computer with no existing installations of SQL Server, Setup specifies the installation of a default instance. However, you can choose to install SQL Server 2000 as a named instance instead by clearing the Default option in the Instance Name dialog box.)

Installing MSDE

Being new to setting up MSDE, we are currently testing crystal reports
and Microsoft Sharepoint services. We want to install these on a
seperate server and see that they use MSDE. We also have a server
currently installed with MSDE for Altiris deployment images and HP
insite manager. Is it a good practice to link to the existing MSDE
server or house this instance of MSDE on the new test server.
Thanks
John
hi John,
JohnC wrote:
> Being new to setting up MSDE, we are currently testing crystal reports
> and Microsoft Sharepoint services. We want to install these on a
> seperate server and see that they use MSDE. We also have a server
> currently installed with MSDE for Altiris deployment images and HP
> insite manager. Is it a good practice to link to the existing MSDE
> server or house this instance of MSDE on the new test server.
usually it's considered a good practice to separate the database server from
the application server both for security reasons and performance reasons, in
order to have a "dedicated" machine for each task...
just a caveat.. Sharepoint usually requires a lot of database space and
ships with a dedicated MSDE version, known as WMSDE, which has been modified
by Microsoft to remove the 2gb limit for each database.. WMSDE is shipped
only with Sharepoint and can only be (legally) used by it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea for your info, looking at the big picture and future
expansion. Taking on board your info about a dedicated database server,
are we better off having an sql server and all are database accessing
software linking up to it like Altiris, sharepoint, crystal reports,
and our own web site which at the moment is linked to mysql.
Regards
John

Installing DSO ..

This summary is not available. Please click here to view the post.

Installing DSO ..

Hi,
I am in the process of creating/setting up cubes from an ERP application
(Axapta) across user machines. In some of the machines I noticed an error
message (which I believe) indicates DSO objects not being installed.
A quick look at SQL BOI gave me details of DSO library.
My query is - where can I get hold of this DSO library files?
Can someone let me know please. Many thanks in advance,
Harish Mohanbabu
--
MBS Axapta - MVP
http://www.harishm.com/
> My query is - where can I get hold of this DSO library files?
The DSO library is what Analysis Manager uses to build/manage OLAP
Databases. It should be installed when you install the client tools for
Analysis Services 2000. If there is something wrong with the
registration of the dll the default path is C:\Program Files\Common
Files\Microsoft Shared\DSO\msmddo80.dll. But as far as I know there is
no re-distributable version of this library. The users would need to be
OLAP Administrators to use it anyway.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell|||Hi,
You may try to copy the following files
msmddo.dll
msmddo80.dll
msmdint.dll
msmdnet.dll
You could register these com objects by using regsvr32.exe. for example:
regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DSO\msmddo.dll"
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: Darren Gosbell <xxx@.xxx.com>
>Subject: Re: Installing DSO ..
>Date: Tue, 25 Oct 2005 10:20:56 +1000
>Message-ID: <MPG.1dc825762779a60598976e@.news.microsoft.com>
>References: <89CCB5B6-1AE5-4C63-B3D3-37FA2953C0B3@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-15"
>Content-Transfer-Encoding: 7bit
>User-Agent: MicroPlanet-Gravity/2.60.2060
>Newsgroups: microsoft.public.sqlserver.datawarehouse
>NNTP-Posting-Host: cpe-61-9-145-77.vic.bigpond.net.au 61.9.145.77
>Lines: 1
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.datawarehouse:2370
>X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
>
>The DSO library is what Analysis Manager uses to build/manage OLAP
>Databases. It should be installed when you install the client tools for
>Analysis Services 2000. If there is something wrong with the
>registration of the dll the default path is C:\Program Files\Common
>Files\Microsoft Shared\DSO\msmddo80.dll. But as far as I know there is
>no re-distributable version of this library. The users would need to be
>OLAP Administrators to use it anyway.
>
>--
>Regards
>Darren Gosbell [MCSD]
><dgosbell_at_yahoo_dot_com>
>Blog: http://www.geekswithblogs.net/darrengosbell
>

installation verification issue

Hello

I Just installed Reporting Services 2005 and I have a problem to make work

After installing it and setting different properties in the Reporting Services Configuration Manager, When it comes to verifying the installation, http://localhost/ReportServer or http://localhost/Reports pops up a Login Window, Where I enter Windows Account Username/Password, but this windows pops up again 3 times then I get Error page with the message:

HTTP 401.1 - Unauthorized: Logon Failed
Internet Information Services

SQL Server 2005 with SP2 is installed on WinXP SP2

What could be the reason?

http://support.microsoft.com/kb/247593|||I already tried the solution in this article, and I had the same result|||pending on how your Web site is configured, you might encounter one or more HTTP 401 errors when verifying the URL: "HTTP 401.1 - Unauthorized: Logon failed" can occur if you are running Windows XP Service Pack 2 or Windows Server 2003 Service Pack, and the fully qualified domain name of the Web site is different from the local computer name. There are several workarounds for resolving this error. For more information about the error and possible workarounds, go to http://support.microsoft.com/kb/896861.
"HTTP 401.1 - Unauthorized: Access is denied due to invalid credentials" can occur if the application pool is a local account or domain user account, and the Web site is configured to use integrated security. Because the report server virtual directories use integrated security by default, you can expect to encounter this error when you access the report server. For more information about the error and possible workarounds, go to http://support.microsoft.com/kb/871179.