Installing MSDE SQL 2000 SP4

I was working on a install for MSDE SQL SERVER 2000 when I noticed that there
was a more recent version available. I have not yet installed and wanted to
kow if the Service Pack 4 for Microsoft SQL Server 2000 - Desktop Engine
(MSDE 2000) included the Microsoft SQL Server 2000 - Database Engine
Components and the Service Pack 4 for Microsoft SQL Server 2000 - Analysis
Services Components in it's install or do I have to install them after I set
up the engine for the first time. Let me re-iterate that I am not upgrading
an instance rather I am trying to install an instance with the SP4 updates,
hoping that I get all of the tools that I can in one shot.
ANDREA,
Thank you for your answer. I have another question. I am sending these
files across a network and trying to automate the installation. I know how
to automate the MSDE install after I have extracted the files from the
SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE, but is there a way to use command
lines to extract silently or maybe even feed it a path to extract to? That
way I only have to worry about one file?
ANdrew
"Andrea Montanari" wrote:

> hi,
> Thunda wrote:
> you can directly go with the sp4 version... it can both install fresh sp
> level MSDE instances as long as upgrade existing pre-sp4 instances..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>

Installing 2005 Samples

I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm trying
an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
Server\90\Samples directory.
Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked all
the installs for AdventureWorks and Samples, and it finally says must use
"Add Remove Programs to Install". So I went to Control Panel, "Add Remove
Programs", then it's tricky to decide which SQL 2005 to choose. I tried
several, but either got the same message, or it said that everything was
already installed.
Is there a simple .zip I can just download somewhere? Or what is the
correct way to install the samples, this has taken me almost an hour just to
get the samples.
Thanks,
Neal Walters
http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
demonstrating how I'm migrating my SQL hosting to SQL Express on my own
server.
http://Biztalk-Training.com
Hi Neal
I had these problems with my RTM build. I mucked around with a few
suggestions for a while & ended up simply uninstalling, then re-installing.
Everything went fine after that. If you choose this route, do make sure
you've carefully selected the individual samples nodes from the installer
options rather than simply selecting the "install everything locally on my
computer" heading node as apparently there may be some problems with that
route.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>
|||Did you try
C:\Program Files\Microsoft SQL Server\90\Tools\Samples? (Including Tools)
Ben Nevarez
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>
|||Yes, no Samples in Tools. I did a directory search for Samples, and nowhere
to be found under 90.
Neal
|||The instructions for installing the sample databases and samples are in the
Books Online topic "Running Setup to Install AdventureWorks Sample Databases
and Samples". Alternatively, you can download the samples from this site:
http://msdn.microsoft.com/sql/downloads/samples/
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:92583FD2-2D88-427F-865A-03B36D990264@.microsoft.com...
> Yes, no Samples in Tools. I did a directory search for Samples, and
> nowhere
> to be found under 90.
> Neal
>
|||I have same issue even after uninstall and reinstall of sql. I suspect it
is a reg entry flag that is not getting reset for samples.
William Stacey [MVP]
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>

Installing 2005 Samples

I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm trying
an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
Server\90\Samples directory.
Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked all
the installs for AdventureWorks and Samples, and it finally says must use
"Add Remove Programs to Install". So I went to Control Panel, "Add Remove
Programs", then it's tricky to decide which SQL 2005 to choose. I tried
several, but either got the same message, or it said that everything was
already installed.
Is there a simple .zip I can just download somewhere? Or what is the
correct way to install the samples, this has taken me almost an hour just to
get the samples.
Thanks,
Neal Walters
http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
demonstrating how I'm migrating my SQL hosting to SQL Express on my own
server.
http://Biztalk-Training.comHi Neal
I had these problems with my RTM build. I mucked around with a few
suggestions for a while & ended up simply uninstalling, then re-installing.
Everything went fine after that. If you choose this route, do make sure
you've carefully selected the individual samples nodes from the installer
options rather than simply selecting the "install everything locally on my
computer" heading node as apparently there may be some problems with that
route.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Did you try
C:\Program Files\Microsoft SQL Server\90\Tools\Samples? (Including Tools)
Ben Nevarez
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Yes, no Samples in Tools. I did a directory search for Samples, and nowhere
to be found under 90.
Neal|||The instructions for installing the sample databases and samples are in the
Books Online topic "Running Setup to Install AdventureWorks Sample Databases
and Samples". Alternatively, you can download the samples from this site:
http://msdn.microsoft.com/sql/downloads/samples/
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:92583FD2-2D88-427F-865A-03B36D990264@.microsoft.com...
> Yes, no Samples in Tools. I did a directory search for Samples, and
> nowhere
> to be found under 90.
> Neal
>|||I have same issue even after uninstall and reinstall of sql. I suspect it
is a reg entry flag that is not getting reset for samples.
William Stacey [MVP]
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>

Installing 2005 Samples

I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm trying
an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
Server\90\Samples directory.
Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked all
the installs for AdventureWorks and Samples, and it finally says must use
"Add Remove Programs to Install". So I went to Control Panel, "Add Remove
Programs", then it's tricky to decide which SQL 2005 to choose. I tried
several, but either got the same message, or it said that everything was
already installed.
Is there a simple .zip I can just download somewhere? Or what is the
correct way to install the samples, this has taken me almost an hour just to
get the samples.
Thanks,
Neal Walters
http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
demonstrating how I'm migrating my SQL hosting to SQL Express on my own
server.
http://Biztalk-Training.comHi Neal
I had these problems with my RTM build. I mucked around with a few
suggestions for a while & ended up simply uninstalling, then re-installing.
Everything went fine after that. If you choose this route, do make sure
you've carefully selected the individual samples nodes from the installer
options rather than simply selecting the "install everything locally on my
computer" heading node as apparently there may be some problems with that
route.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Did you try
C:\Program Files\Microsoft SQL Server\90\Tools\Samples? (Including Tools)
Ben Nevarez
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>|||Yes, no Samples in Tools. I did a directory search for Samples, and nowhere
to be found under 90.
Neal|||The instructions for installing the sample databases and samples are in the
Books Online topic "Running Setup to Install AdventureWorks Sample Databases
and Samples". Alternatively, you can download the samples from this site:
http://msdn.microsoft.com/sql/downloads/samples/
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:92583FD2-2D88-427F-865A-03B36D990264@.microsoft.com...
> Yes, no Samples in Tools. I did a directory search for Samples, and
> nowhere
> to be found under 90.
> Neal
>|||I have same issue even after uninstall and reinstall of sql. I suspect it
is a reg entry flag that is not getting reset for samples.
--
William Stacey [MVP]
"Neal Walters" <NealWalters@.discussions.microsoft.com> wrote in message
news:00F51F16-A03C-4882-9A26-3447FA33004F@.microsoft.com...
>I installed SQL 2005 Dev Edition on laptop, basics working fine. I'm
>trying
> an SSIS tutorial, it refers to: c:\Program Files\Microsoft SQL
> Server\90\Samples directory.
> Said directory is not on my disk. I inserted Setup (CD 2 of 2), clicked
> all
> the installs for AdventureWorks and Samples, and it finally says must use
> "Add Remove Programs to Install". So I went to Control Panel, "Add Remove
> Programs", then it's tricky to decide which SQL 2005 to choose. I tried
> several, but either got the same message, or it said that everything was
> already installed.
> Is there a simple .zip I can just download somewhere? Or what is the
> correct way to install the samples, this has taken me almost an hour just
> to
> get the samples.
> Thanks,
> Neal Walters
> http://SQL-Online-Training.com - SQL2005 Videos/Samples - I'll be
> demonstrating how I'm migrating my SQL hosting to SQL Express on my own
> server.
> http://Biztalk-Training.com
>sql

Installed SQL Server, yet not listening on any port

Hi all,

I'm working on a school project on web and mobile applications, and had decided to use MS SQL Server for my backend database.

However, after I've installed MS SQL Server 2000, I ran a port scan and I couldn't find the server running on any ports (MySQL is running on my port 3306, but I guess it doesn't matter) Can something drop some hints on how to debug the problem?

I'm running on Athlon XP 2000+ w/ Windows XP Professional SP2

Thanks a lot!SQL Server runs on port 1433 by default, I believe. In your SQL Server group on the machine running SQL Server, there is a Client Network Utility. Go into that and ensure that TCP/IP is enabled.|||yes i went to the Enterprise Manager, under my Server Group's properties, went to Network Configuration and enabled both TCP/IP on port 1433 and Named Pipes. It still didn't work though.

Another thing I've noticed is that my server is named "(LOCAL) (Windows NT)." Could this be a hint that it's not listening for external connections?|||No, local is an alias for the machine you are on.

Are you certain that SQL Server is running? In Enterprise Manager, can you see the any databases?|||Yes I could see all the databases from the master database to the NorthWind and tempdb database.

The Distributed Transaction Coordinator, SQL Server and SQL Server Agent are all enabled.

Update: I've checked the Event Log. I think I probably know what's the problem.. Here is the message from the log:

You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with this version of Windows. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/default.asp

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'll go patch up and reply if I had any more problems. Thanks for the help douglas.reilly!|||This is just to say that the problem is resolved after patching the SQL Server to SP3. Sorry for the trouble and thanks!sql

Installed .NET 1.1 Framework and MSDE stopped working

I just upgraded the .NET 1.0 to 1.1 today and now when I launch the Web Data Administrator for MSDE it hangs up as soon as I hit the login button.

I reinstalled MSDE and the Web Data Administrator and that didn't correct the problem.

Help!

Try this:

Cause

This problem occurs if the following registry subkey is missing:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
This issue may also occur if this registry subkey does not have valid registry entries. If this registry subkey is missing, you cannot use the ODBC tool in Control Panel to add or to create a new data source.

Resolution

To resolve this issue, copy the missing registry subkey from a computer that does not experience this problem.

Important When you copy a registry subkey from one computer to a computer that is experiencing this issue, you must verify that the system folder is the same on both computers. For example, the system folder must be C:\Windows on the source computer and on the destination computer. If the system folder is different on these computers, Setup will continue to fail.

If the issue is not resolved after you copy the registry subkey, you can reinstall the MDAC drivers on the affected computer. To do this, follow these steps.

Important To perform this procedure, you must have the Windows XP installation CD. Or, you must have access to the Windows XP source files. 1. Configure Windows to show the hidden files: a. Click Start, and then click My Computer.
b. On the Tools menu, click Folder Options.
c. Click the View tab, and then click to select the check box that is next to Show hidden files and folders in the Advanced settings list.
d. In the Advanced settings list, click to clear the check box that is next to Hide extensions for known file types, and then click OK.

2. Reinstall MDAC.

Note You may not have to perform all the following steps. a. Click Start, click Run, type %windir%\inf, and then click OK.
b. Right-click the Mdac.inf file, and then click Install.
c. If you are running Microsoft Windows XP Service Pack 2 (SP2), insert the Windows XP SP2 CD when you are prompted, and then open the following location:
Drive name:\Windows\ServicePackFiles\i386
If you are running Windows XP, insert the Windows XP CD when you are prompted, and then open the following location:
Drive name:\I386
Note In both paths, Drive name is the name of the CD drive.
d. When the installation is completed, restart the computer.

Buck Woody

Installed .NET 1.1 Framework and MSDE stopped working

I just upgraded the .NET 1.0 to 1.1 today and now when I launch the Web Data Administrator for MSDE it hangs up as soon as I hit the login button.

I reinstalled MSDE and the Web Data Administrator and that didn't correct the problem.

Help!

Try this:

Cause

This problem occurs if the following registry subkey is missing:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
This issue may also occur if this registry subkey does not have valid registry entries. If this registry subkey is missing, you cannot use the ODBC tool in Control Panel to add or to create a new data source.

Resolution

To resolve this issue, copy the missing registry subkey from a computer that does not experience this problem.

Important When you copy a registry subkey from one computer to a computer that is experiencing this issue, you must verify that the system folder is the same on both computers. For example, the system folder must be C:\Windows on the source computer and on the destination computer. If the system folder is different on these computers, Setup will continue to fail.

If the issue is not resolved after you copy the registry subkey, you can reinstall the MDAC drivers on the affected computer. To do this, follow these steps.

Important To perform this procedure, you must have the Windows XP installation CD. Or, you must have access to the Windows XP source files. 1. Configure Windows to show the hidden files: a. Click Start, and then click My Computer.
b. On the Tools menu, click Folder Options.
c. Click the View tab, and then click to select the check box that is next to Show hidden files and folders in the Advanced settings list.
d. In the Advanced settings list, click to clear the check box that is next to Hide extensions for known file types, and then click OK.

2. Reinstall MDAC.

Note You may not have to perform all the following steps. a. Click Start, click Run, type %windir%\inf, and then click OK.
b. Right-click the Mdac.inf file, and then click Install.
c. If you are running Microsoft Windows XP Service Pack 2 (SP2), insert the Windows XP SP2 CD when you are prompted, and then open the following location:
Drive name:\Windows\ServicePackFiles\i386
If you are running Windows XP, insert the Windows XP CD when you are prompted, and then open the following location:
Drive name:\I386
Note In both paths, Drive name is the name of the CD drive.
d. When the installation is completed, restart the computer.

Buck Woody

sql

installation trouble

ok i am working on Win2k pro.
i want to be able to develop reports and then move them to the production
server.
I can't use MSDE, or Std Edition on my machine-- so I finally settled on
Developers' edition of SQL OLTP.
The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
to use SQL Developers' edition for the RS databases.
So I had to download the trial.
And now the http://127.0.0./reportServer site is failing; but it looks like
the http://127.0.0.1/reportManager site is working as expected.. with about
80% of the functionality that I remembered.
I am a local admin.
I guess that I am a lil bit confused.. When I installed; it wanted to make 2
sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
I was just confused; the report manager site-- shouldn't that be called
ReportManager? It defaulted to 'Reports' and i changed it-
People will actually naviagate to the ReportServer site in order to view
reports' Or does everyone-- from me to an end user; have to go to
http://127.0.0.1/ReportManager site now?
-aaronReportServer is the home for Web Service. You should just get a simple page
if you go there.. if your getting an error, details would be appreciated.
/Reports or /ReportManager whatever you called it is the UI for the Web
Service.
thats what your users should use.
<aaron_kempf@.hotmail.com> wrote in message
news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> ok i am working on Win2k pro.
> i want to be able to develop reports and then move them to the production
> server.
> I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> Developers' edition of SQL OLTP.
> The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
> to use SQL Developers' edition for the RS databases.
> So I had to download the trial.
> And now the http://127.0.0./reportServer site is failing; but it looks
> like
> the http://127.0.0.1/reportManager site is working as expected.. with
> about
> 80% of the functionality that I remembered.
> I am a local admin.
> I guess that I am a lil bit confused.. When I installed; it wanted to make
> 2
> sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> I was just confused; the report manager site-- shouldn't that be called
> ReportManager? It defaulted to 'Reports' and i changed it-
> People will actually naviagate to the ReportServer site in order to view
> reports' Or does everyone-- from me to an end user; have to go to
> http://127.0.0.1/ReportManager site now?
> -aaron
>
>|||thank you.
I am getting a directory listing when i browse the ReportServer site; do i
need to at least drop that perms?
I'm a local admin
"CJ Taylor" <jjackson@.jackson5.com> wrote in message
news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
> ReportServer is the home for Web Service. You should just get a simple
page
> if you go there.. if your getting an error, details would be appreciated.
> /Reports or /ReportManager whatever you called it is the UI for the Web
> Service.
> thats what your users should use.
> <aaron_kempf@.hotmail.com> wrote in message
> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> > ok i am working on Win2k pro.
> >
> > i want to be able to develop reports and then move them to the
production
> > server.
> >
> > I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> > Developers' edition of SQL OLTP.
> >
> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
Std
> > to use SQL Developers' edition for the RS databases.
> >
> > So I had to download the trial.
> >
> > And now the http://127.0.0./reportServer site is failing; but it looks
> > like
> > the http://127.0.0.1/reportManager site is working as expected.. with
> > about
> > 80% of the functionality that I remembered.
> >
> > I am a local admin.
> >
> > I guess that I am a lil bit confused.. When I installed; it wanted to
make
> > 2
> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> >
> > I was just confused; the report manager site-- shouldn't that be called
> > ReportManager? It defaulted to 'Reports' and i changed it-
> >
> > People will actually naviagate to the ReportServer site in order to view
> > reports' Or does everyone-- from me to an end user; have to go to
> > http://127.0.0.1/ReportManager site now?
> >
> > -aaron
> >
> >
> >
>|||If you check the URL of an actual report inside ReportManager, you'll see
that it's actually calling a ReportServer URL, so you shouldn't change
permissions on ReportServer. Whatever permissions you set via ReportManager
will be reflected in the ReportServer. ReportManager is simply a friendly
interface to the same thing, with some admin tools on top if it for
administrators.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
<aaron_kempf@.hotmail.com> wrote in message
news:%238D%23zTW3EHA.2572@.tk2msftngp13.phx.gbl...
> thank you.
> I am getting a directory listing when i browse the ReportServer site; do i
> need to at least drop that perms?
> I'm a local admin
>
>
> "CJ Taylor" <jjackson@.jackson5.com> wrote in message
> news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
>> ReportServer is the home for Web Service. You should just get a simple
> page
>> if you go there.. if your getting an error, details would be
>> appreciated.
>> /Reports or /ReportManager whatever you called it is the UI for the Web
>> Service.
>> thats what your users should use.
>> <aaron_kempf@.hotmail.com> wrote in message
>> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > ok i am working on Win2k pro.
>> >
>> > i want to be able to develop reports and then move them to the
> production
>> > server.
>> >
>> > I can't use MSDE, or Std Edition on my machine-- so I finally settled
>> > on
>> > Developers' edition of SQL OLTP.
>> >
>> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
> Std
>> > to use SQL Developers' edition for the RS databases.
>> >
>> > So I had to download the trial.
>> >
>> > And now the http://127.0.0./reportServer site is failing; but it looks
>> > like
>> > the http://127.0.0.1/reportManager site is working as expected.. with
>> > about
>> > 80% of the functionality that I remembered.
>> >
>> > I am a local admin.
>> >
>> > I guess that I am a lil bit confused.. When I installed; it wanted to
> make
>> > 2
>> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
>> >
>> > I was just confused; the report manager site-- shouldn't that be called
>> > ReportManager? It defaulted to 'Reports' and i changed it-
>> >
>> > People will actually naviagate to the ReportServer site in order to
>> > view
>> > reports' Or does everyone-- from me to an end user; have to go to
>> > http://127.0.0.1/ReportManager site now?
>> >
>> > -aaron
>> >
>> >
>> >
>>
>

Installation error in Sql Server 2005 Enterprise edition on Vista RTM

Hi Every One,

I would like to install the Sql Server 2005 on Vista RTM. prevoiusly I had Vista RC1 on which it was working fine.

Now, as the installation starts, the Vista Error dialog box gets appeared and the asks for the debugging, close or Online solution.

Please help me to install that.

Thanking you

gaurav gupta

SQL Server 2005 Enterprise Edition requires a server operating system like Windows 2000 Advanced Server 2004, Windows 2003 Enterprise Server SP1 and the coming Longhorn Server. Vista RTM is a client operating sytems like XP SP2, on which SQL Server Enterprise Edition cannot be installed. Please see BOL for more information.

Installation Error - Need some Help

Hello All:
Had a working SQL cluster but we had to uninstall SQL. When we go to
reinstall SQL (virtual server) on node 1, we get the following error.
"An error occured while creating SQL virtual server resources for
clustering. Setup could not connect to the database to update
cluster-specific information is the system tables."
Setup then goes to cleaning up etc and exits. However, SQL server is not
succesfully installed. I cannot find referrence to this error anywhere and
cannot figure out what the problem is. I would greatly appreciate any help.
Stan,
I see no one has answered you. I am having a similar problem with almost the same error message. The one I'm getting is more like:
"An error occured while creating SQL virtual server resources for
clustering. The specified module could not be found".
My problem is on a brand new cluster, both nodes working fine, passing all failover tests. This is on the initial installation attempt. I don't know what gives.
I am seeking help as well, but there aren't a whole lot of individuals out there that have gone down this path. What a piece of crap Microsoft has dumped on us now. Good luck in finding your answer.
"stan" wrote:

> Hello All:
> Had a working SQL cluster but we had to uninstall SQL. When we go to
> reinstall SQL (virtual server) on node 1, we get the following error.
> "An error occured while creating SQL virtual server resources for
> clustering. Setup could not connect to the database to update
> cluster-specific information is the system tables."
> Setup then goes to cleaning up etc and exits. However, SQL server is not
> succesfully installed. I cannot find referrence to this error anywhere and
> cannot figure out what the problem is. I would greatly appreciate any help.
>
>
|||Guy
I similar problem If you uninstall sql server and reinstall
it with same name make sure you do clean up record in
Wins and Dns server and replicate if you use AD.
good luck
>--Original Message--
>Stan,
>I see no one has answered you. I am having a similar
problem with almost the same error message. The one I'm
getting is more like:
>"An error occured while creating SQL virtual server
resources for
> clustering. The specified module could not be found".
>My problem is on a brand new cluster, both nodes working
fine, passing all failover tests. This is on the initial
installation attempt. I don't know what gives.
>I am seeking help as well, but there aren't a whole lot
of individuals out there that have gone down this path.
What a piece of crap Microsoft has dumped on us now. Good
luck in finding your answer.[vbcol=seagreen]
>"stan" wrote:
When we go to[vbcol=seagreen]
following error.[vbcol=seagreen]
resources for[vbcol=seagreen]
update[vbcol=seagreen]
SQL server is not[vbcol=seagreen]
this error anywhere and[vbcol=seagreen]
appreciate any help.
>.
>
|||Guy
I similar problem If you uninstall sql server and reinstall
it with same name make sure you do clean up record in
Wins and Dns server and replicate if you use AD.
good luck
>--Original Message--
>Stan,
>I see no one has answered you. I am having a similar
problem with almost the same error message. The one I'm
getting is more like:
>"An error occured while creating SQL virtual server
resources for
> clustering. The specified module could not be found".
>My problem is on a brand new cluster, both nodes working
fine, passing all failover tests. This is on the initial
installation attempt. I don't know what gives.
>I am seeking help as well, but there aren't a whole lot
of individuals out there that have gone down this path.
What a piece of crap Microsoft has dumped on us now. Good
luck in finding your answer.[vbcol=seagreen]
>"stan" wrote:
When we go to[vbcol=seagreen]
following error.[vbcol=seagreen]
resources for[vbcol=seagreen]
update[vbcol=seagreen]
SQL server is not[vbcol=seagreen]
this error anywhere and[vbcol=seagreen]
appreciate any help.
>.
>

Installation Error

After I uninstalled Reporting Services (which it was working just fine) and
to reinstall it, the setup screen for installing SQL Server Reporting
Services Setup Support Files completes successfully. When I click the Next
button nothing happens.
If I go to the event viewer, I get this:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Any ideas? I turned on logging by doing this:
setup.exe /l*v setupmsi.log
and no log file was generated. Does anyone know what else I can try to get
this thing installed? I hope to god I don't have to rebuild my server. So
far, I have 3 servers that I cannot get reporting services installed on
since I have "screwed the pooch" on this by uninstalling RS - and now I
cannot put them back on. The development team is breathing down my neck on
this.
=-ChrisI apologize for the duplicate postings. I couldn't see this post and thought
that it didn't go through.
"Christopher Conner" wrote:
> After I uninstalled Reporting Services (which it was working just fine) and
> to reinstall it, the setup screen for installing SQL Server Reporting
> Services Setup Support Files completes successfully. When I click the Next
> button nothing happens.
> If I go to the event viewer, I get this:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Any ideas? I turned on logging by doing this:
> setup.exe /l*v setupmsi.log
> and no log file was generated. Does anyone know what else I can try to get
> this thing installed? I hope to god I don't have to rebuild my server. So
> far, I have 3 servers that I cannot get reporting services installed on
> since I have "screwed the pooch" on this by uninstalling RS - and now I
> cannot put them back on. The development team is breathing down my neck on
> this.
> =-Chris
>
>