Install reporting services after SQL sp2

Hello,
our customer tried to update his existing SQL Server 64 Bit Enterprise
Edition with reporting services to SP2. During Setup there was an error with
the reporting services. So the customer decided to uninstall the reporting
services and applied SP2 successfully after that.
Now he needs the reporting services for a new application. Can i install the
reporting services from the original media and then upgrade that reporting
services installation to sp2?What do i have to take care of?
My plan was to install reporting services via software. Change SQL Server
Installation and add reporting services.
I tried that but the setup then comes up with the warning that there is a
version change. I think that is because the sql server has another
patchlevel than the original installation media. Can i ignore that?
thanks in advance
thomasHi Thomas
Although I haven't tried what you are doing, there is not really any
alternative as there is no slipstreamed releases of SQL Server that will go
straight in as SP2, so I guess you have to ignore the error and continue. It
is probably better to install this by hand!
John
"Thomas Oeser" wrote:
> Hello,
> our customer tried to update his existing SQL Server 64 Bit Enterprise
> Edition with reporting services to SP2. During Setup there was an error with
> the reporting services. So the customer decided to uninstall the reporting
> services and applied SP2 successfully after that.
> Now he needs the reporting services for a new application. Can i install the
> reporting services from the original media and then upgrade that reporting
> services installation to sp2?What do i have to take care of?
> My plan was to install reporting services via software. Change SQL Server
> Installation and add reporting services.
> I tried that but the setup then comes up with the warning that there is a
> version change. I think that is because the sql server has another
> patchlevel than the original installation media. Can i ignore that?
> thanks in advance
> thomas
>

Install Report Designer on XP

I am trying to install Report Designer on my XP development machine. We
already have Reporting Services Enterprise install on our SQL Server. When I
insert the CD it automatically attempts to install the Server components and
fails becuase it is an XP machine. I only want to install the client
components but the install never gets to that point. Is there a way that I
can just install the client from the CD and bypass the System check for the
server compnents.
ThanksNot sure, but I know that the 2005 Developer Edition will work for you,
if that's possible for you to do-
Matt A|||Is it 2000 or 2005 installation?
In 2000, if I remember well you still have the possibility to click on NEXT
and ignore the errors reported by the SCC tool. This will install only the
client tools.
In 2005, Select Workstation components, Books Online and development tools
on the Components to Install page
Med Bouchenafa
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> a écrit dans le
message de news: C20A2556-1C93-4880-966F-50AE546BCF4F@.microsoft.com...
>I am trying to install Report Designer on my XP development machine. We
> already have Reporting Services Enterprise install on our SQL Server.
> When I
> insert the CD it automatically attempts to install the Server components
> and
> fails becuase it is an XP machine. I only want to install the client
> components but the install never gets to that point. Is there a way that
> I
> can just install the client from the CD and bypass the System check for
> the
> server compnents.
> Thanks|||It is the 2000 edition. It never gets past the SCC tool errors. I
eventually get some kind of windows error. I will have to try it again
tomorrow morning to get the error.
Thanks
Rob Willhite
"Med Bouchenafa" wrote:
> Is it 2000 or 2005 installation?
> In 2000, if I remember well you still have the possibility to click on NEXT
> and ignore the errors reported by the SCC tool. This will install only the
> client tools.
> In 2005, Select Workstation components, Books Online and development tools
> on the Components to Install page
> Med Bouchenafa
> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> a écrit dans le
> message de news: C20A2556-1C93-4880-966F-50AE546BCF4F@.microsoft.com...
> >I am trying to install Report Designer on my XP development machine. We
> > already have Reporting Services Enterprise install on our SQL Server.
> > When I
> > insert the CD it automatically attempts to install the Server components
> > and
> > fails becuase it is an XP machine. I only want to install the client
> > components but the install never gets to that point. Is there a way that
> > I
> > can just install the client from the CD and bypass the System check for
> > the
> > server compnents.
> >
> > Thanks
>
>|||I am running Reporting Services Standard Edition
"Robert Willhite" wrote:
> I am trying to install Report Designer on my XP development machine. We
> already have Reporting Services Enterprise install on our SQL Server. When I
> insert the CD it automatically attempts to install the Server components and
> fails becuase it is an XP machine. I only want to install the client
> components but the install never gets to that point. Is there a way that I
> can just install the client from the CD and bypass the System check for the
> server compnents.
> Thanks

Install path SQL Enterprise Manager

Hi,

We want to install SQL Enterprise Manager on a seperate server. Our provider for this server requires us to install SQL EM on a non-default drive/path, d:\programs. How can I achieve this?

TIA,

Wim

Run the setup.bat file from the SQL Server installation CD, and select Install Client components, and you can specify where you want the programs installed.|||

Looks like this works for 2005. However we want to use 2000. My mistake, should have mentioned this.

We already looked quite extensively on the CD but could not find any clues for resolving this. Does anyone have an idea?

It could be that Enterprise Manager 2000 is not meant to be installed seperately from SQL Server 2000. Can anyone say anything about this?

TIA,

Wim.

install newer standard etition over older enterprise edition

If I were to install SQL Server 2005 Standard over SQL Server 2003
Enterprise, would there be any negative effects? What would happen to the
features that are not supported by the newer Standard Edition? Would it be
better to uninstall SQL Server 2003 Enterprise before I install SQL Server
2005 Standard?
Daniel Brower
You can't upgrade from EE to Std editions. You will need to uninstall EE
first and then install the Std edition.
Andrew J. Kelly SQL MVP
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:eoARzT$DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If I were to install SQL Server 2005 Standard over SQL Server 2003
> Enterprise, would there be any negative effects? What would happen to the
> features that are not supported by the newer Standard Edition? Would it
> be better to uninstall SQL Server 2003 Enterprise before I install SQL
> Server 2005 Standard?
> Daniel Brower
>
|||there is NO SQL Server 2003 version.
If you mean 2000, then what the other guy wrote is correct. If you are on 7
DON"T uninstall as it will destroy your user databases.
d.
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:eoARzT$DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If I were to install SQL Server 2005 Standard over SQL Server 2003
> Enterprise, would there be any negative effects? What would happen to the
> features that are not supported by the newer Standard Edition? Would it
be
> better to uninstall SQL Server 2003 Enterprise before I install SQL Server
> 2005 Standard?
> Daniel Brower
>

install newer standard etition over older enterprise edition

If I were to install SQL Server 2005 Standard over SQL Server 2003
Enterprise, would there be any negative effects? What would happen to the
features that are not supported by the newer Standard Edition? Would it be
better to uninstall SQL Server 2003 Enterprise before I install SQL Server
2005 Standard?
Daniel Brower
You can't upgrade from EE to Std editions. You will need to uninstall EE
first and then install the Std edition.
Andrew J. Kelly SQL MVP
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:eoARzT$DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If I were to install SQL Server 2005 Standard over SQL Server 2003
> Enterprise, would there be any negative effects? What would happen to the
> features that are not supported by the newer Standard Edition? Would it
> be better to uninstall SQL Server 2003 Enterprise before I install SQL
> Server 2005 Standard?
> Daniel Brower
>
|||there is NO SQL Server 2003 version.
If you mean 2000, then what the other guy wrote is correct. If you are on 7
DON"T uninstall as it will destroy your user databases.
d.
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:eoARzT$DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If I were to install SQL Server 2005 Standard over SQL Server 2003
> Enterprise, would there be any negative effects? What would happen to the
> features that are not supported by the newer Standard Edition? Would it
be
> better to uninstall SQL Server 2003 Enterprise before I install SQL Server
> 2005 Standard?
> Daniel Brower
>

install newer standard etition over older enterprise edition

If I were to install SQL Server 2005 Standard over SQL Server 2003
Enterprise, would there be any negative effects? What would happen to the
features that are not supported by the newer Standard Edition? Would it be
better to uninstall SQL Server 2003 Enterprise before I install SQL Server
2005 Standard?
Daniel BrowerYou can't upgrade from EE to Std editions. You will need to uninstall EE
first and then install the Std edition.
--
Andrew J. Kelly SQL MVP
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:eoARzT$DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If I were to install SQL Server 2005 Standard over SQL Server 2003
> Enterprise, would there be any negative effects? What would happen to the
> features that are not supported by the newer Standard Edition? Would it
> be better to uninstall SQL Server 2003 Enterprise before I install SQL
> Server 2005 Standard?
> Daniel Brower
>|||there is NO SQL Server 2003 version.
If you mean 2000, then what the other guy wrote is correct. If you are on 7
DON"T uninstall as it will destroy your user databases.
d.
"Daniel" <dwbnews@.hotmail.com> wrote in message
news:eoARzT$DGHA.128@.TK2MSFTNGP10.phx.gbl...
> If I were to install SQL Server 2005 Standard over SQL Server 2003
> Enterprise, would there be any negative effects? What would happen to the
> features that are not supported by the newer Standard Edition? Would it
be
> better to uninstall SQL Server 2003 Enterprise before I install SQL Server
> 2005 Standard?
> Daniel Brower
>

Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?
First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:

> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>
|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...[vbcol=seagreen]
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:[vbcol=seagreen]
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:[vbcol=seagreen]
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:

Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:
> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
>> I am having a really hard time installing SQL Server 2005 Enterprise
>> Edition. My server definitely meets the hardware requirements of the
>> server. The server OS is Windows 2003 Enterprise R2. The problem
>> occurs during setup. After checking my system configuration, it goes
>> to the window that generates a list of items it is going to install (I
>> believe). Here, as soon as it starts generating the list, it freezes
>> the whole server and then shuts down. It does this every single time.
>> Any thoughts or suggestions?
>>|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> > First thing, check the setup log files in C:\Program Files\Microsoft SQL
> > Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> > error info.
> >
> > Linchi
> >
> > "CarlosSanchezJr@.gmail.com" wrote:
> >
> >> I am having a really hard time installing SQL Server 2005 Enterprise
> >> Edition. My server definitely meets the hardware requirements of the
> >> server. The server OS is Windows 2003 Enterprise R2. The problem
> >> occurs during setup. After checking my system configuration, it goes
> >> to the window that generates a list of items it is going to install (I
> >> believe). Here, as soon as it starts generating the list, it freezes
> >> the whole server and then shuts down. It does this every single time.
> >>
> >> Any thoughts or suggestions?
> >>
> >>|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:
> > In addition , if your computer is connected to the network , try unplug
> > the cable and start an installation
> >
> >
> > "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> > news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...
> > > First thing, check the setup log files in C:\Program Files\Microsoft SQL
> > > Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> > > error info.
> > >
> > > Linchi
> > >
> > > "CarlosSanchezJr@.gmail.com" wrote:
> > >
> > >> I am having a really hard time installing SQL Server 2005 Enterprise
> > >> Edition. My server definitely meets the hardware requirements of the
> > >> server. The server OS is Windows 2003 Enterprise R2. The problem
> > >> occurs during setup. After checking my system configuration, it goes
> > >> to the window that generates a list of items it is going to install (I
> > >> believe). Here, as soon as it starts generating the list, it freezes
> > >> the whole server and then shuts down. It does this every single time.
> > >>
> > >> Any thoughts or suggestions?
> > >>
> > >>

Install issue with SQL Server 2005 Enterprise

I am having a really hard time installing SQL Server 2005 Enterprise
Edition. My server definitely meets the hardware requirements of the
server. The server OS is Windows 2003 Enterprise R2. The problem
occurs during setup. After checking my system configuration, it goes
to the window that generates a list of items it is going to install (I
believe). Here, as soon as it starts generating the list, it freezes
the whole server and then shuts down. It does this every single time.
Any thoughts or suggestions?First thing, check the setup log files in C:\Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
error info.
Linchi
"CarlosSanchezJr@.gmail.com" wrote:

> I am having a really hard time installing SQL Server 2005 Enterprise
> Edition. My server definitely meets the hardware requirements of the
> server. The server OS is Windows 2003 Enterprise R2. The problem
> occurs during setup. After checking my system configuration, it goes
> to the window that generates a list of items it is going to install (I
> believe). Here, as soon as it starts generating the list, it freezes
> the whole server and then shuts down. It does this every single time.
> Any thoughts or suggestions?
>|||In addition , if your computer is connected to the network , try unplug
the cable and start an installation
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...[vbcol=seagreen]
> First thing, check the setup log files in C:\Program Files\Microsoft SQL
> Server\90\Setup Bootstrap\LOG\Files for where the setup failed and for any
> error info.
> Linchi
> "CarlosSanchezJr@.gmail.com" wrote:
>|||I have checked the log files and did not see anything there that caused
an issue. I also tried the disabling of my network connection and that
also did not work.
I am at a complete loss here. Everything is great until it does the
System Configuration Check. Then it just suddenly freezes the whole
server and I have to do a hard reboot.
Uri Dimant wrote:[vbcol=seagreen]
> In addition , if your computer is connected to the network , try unplug
> the cable and start an installation
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:0A94A25C-0C87-4777-92FF-4F76A5420387@.microsoft.com...|||Never did get this working on 2003 Enterprise R2, however, I tried it
on 2003 Standard R2 and it installed without any problems. Very odd.
CarlosSanchezJr@.gmail.com wrote:[vbcol=seagreen]
> I have checked the log files and did not see anything there that caused
> an issue. I also tried the disabling of my network connection and that
> also did not work.
> I am at a complete loss here. Everything is great until it does the
> System Configuration Check. Then it just suddenly freezes the whole
> server and I have to do a hard reboot.
> Uri Dimant wrote:sql

Install fails on SQL2k5 because no IIS on Server

We have a new cluster that we are trying to install SQL 2k5 enterprise on and the security requirements will not allow us to install IIS on the same server as SQL. Is there a way around the requirement of having IIS installed on the server with SQL 2k5?It's not a requirement, unless you need RS on the cluster. You'll get a warning early on, but Setup will proceed if IIS is missing.|||The setup just closes itself down when it is doing the check for server components. There is no error at all. When we check the log file there is a statement about IIS not being installed or is disabled.|||Ugh. Well, the crash is likely due to another cause. Are you referring to summary.txt, or one of the detailed logs? If the former, I would proceed by looking at ...core.log and/or core(local).log. But at this stage there aren't going to be very many logs so check everything there for clues.

Install Error 1603

I am getting the install error 1603 with ignore greyed out.
I am trying to install reporting services enterprise edition onto server
running
WIN 2003 with SQL server 2000.
I am installing it without VS.NET installed and
The .Net Framework has been installed
I have looked at http://support.microsoft.com/?kbid=867872 but I still get
the same error.
I even reinstalled the IIS 6.0. ASP.NET 1.1.4322 is registered with IIS.
I have changed the SQL Server instance used to host the report server
database to Local.
I have been busy installing it at a client for 2 days now.
I have a local version that installed without giving any problems.
Can someone please tell me how to get it installed?Hi,
I had this problem already with one of our customers. Their IT department
did a really closed installation of a Windows 2003 Standard web server.
Now the solution which worked for me:
1. Take a look on the services: COM+ Event System -> enable and run it!
2. Open Administrative Tools->Component Services
- Navigate to Component Services->Computers->My Computer and right click on it
- On tab COM security add IWAM_MACHINE and IUSR_MACHINE to [Access
Permissions] and [Default Launch Permission] by clicking on Edit Defaults...
Now hopefully it should work!
John D''Eramo
IT Manager
"Wesley" wrote:
> I am getting the install error 1603 with ignore greyed out.
> I am trying to install reporting services enterprise edition onto server
> running
> WIN 2003 with SQL server 2000.
> I am installing it without VS.NET installed and
> The .Net Framework has been installed
> I have looked at http://support.microsoft.com/?kbid=867872 but I still get
> the same error.
> I even reinstalled the IIS 6.0. ASP.NET 1.1.4322 is registered with IIS.
> I have changed the SQL Server instance used to host the report server
> database to Local.
> I have been busy installing it at a client for 2 days now.
> I have a local version that installed without giving any problems.
> Can someone please tell me how to get it installed?
>

Install Enterprise manager without install sql server

Hi,

Is it possible to install Enterprise Manager without to install the
server ?

Thanks !

--
J-L M. (Alphomega)
ICQ: 149635116
Pour m'crire, cliquer le lien ci-dessous
http://cerbermail.com/?G5iYdBb2CeJean-Luc M. wrote:
> Hi,
> Is it possible to install Enterprise Manager without to install the
> server ?
> Thanks !

Yes, just run the install. I forget the exact option name but it is there.

Zach|||during the install there is an option to install the server or install the
utilities. this is one of the first screens.
select the button for installing utilities.
Kevin

"Jean-Luc M." <nospam@.nospam.com> wrote in message
news:mn.a3d27d4caa59a6bf.1476@.nospam.com...
> Hi,
> Is it possible to install Enterprise Manager without to install the server
> ?
> Thanks !
> --
> J-L M. (Alphomega)
> ICQ: 149635116
> Pour m'crire, cliquer le lien ci-dessous
> http://cerbermail.com/?G5iYdBb2Ce|||... a lot ! :-)

--
J-L M. (Alphomega)
ICQ: 149635116
Pour m'crire, cliquer le lien ci-dessous
http://cerbermail.com/?G5iYdBb2Ce

Install enterprise manager on 64 bit server

Is it possible to install the enterprise manager and tools on the 64 bit
version of sql server, running on windows 2003 server?
Thanks,
JeffI'm pretty certain that there is code in there that doesn't run on 64 bit,
hence why MS removed the client tools from the install in the first place.
:-)=
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Scanner2001" <jeffsanders125@.hotmail.com> wrote in message
news:%23YS3LkS4DHA.1816@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Is it possible to install the enterprise manager and tools on the 64 bit
> version of sql server, running on windows 2003 server?
> Thanks,
> Jeff
>

---

Install enterprise manager on 64 bit server

Is it possible to install the enterprise manager and tools on the 64 bit
version of sql server, running on windows 2003 server?
Thanks,
JeffI'm pretty certain that there is code in there that doesn't run on 64 bit,
hence why MS removed the client tools from the install in the first place.
:-)=--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Scanner2001" <jeffsanders125@.hotmail.com> wrote in message
news:%23YS3LkS4DHA.1816@.TK2MSFTNGP12.phx.gbl...
> Is it possible to install the enterprise manager and tools on the 64 bit
> version of sql server, running on windows 2003 server?
> Thanks,
> Jeff
>sql

install dtsrun utility

Hello everybody,

I need to install the dtsrun util on a client who needs to call a dts package. I want to do this without enterprise manager.
We had no problem in the past withWin NT 4 client. Right now, I try to
install this dtsrun utility on a Win2k pro client and when I do regsvr32
dtsffile.dll
The instructions are explained on redist.txt on the sql server CD rom.

I receive each time the message that I can't register the dll.

Can anyone point me in some direction ?

Thanks,

Bjorn

this is the information I found :

INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
------------------
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll

Example: regsvr32 80\Tools\Binn\dtsffile.dll

The sqlunirl.dll file should reside in the system folder (i.e.,
\winnt\system32 or \windows\system).in the Text Box type: regsvr32 d:\YourDir\YourFile

where "d:\YourDir\YourFile" is the full path to the dll's.

Seems like you may have left out the c:\pf\MSQLS\80\...\file.dll

Hope this may help...

To unregister it, type in the text box: regsvr32 /u d:\YourDir\YourFile

NOTE: The full path of the dll must be enclosed as regsvr32 "c:\PF\MSLS\80\your.dll" to succeed.|||Also this file may be used to register dll's by right clicking with the shift key

Installation

Hi,
I am very new to MSDE version. I just installed MSDE ver
A and cannot see Enterprise Manager pointer or Query
Analyzer pointer in All Programs menu. I guess, MSDE does
not have these editors.
I would really appreciate if you can answer my following
Q:
1) Does MSDE has all these editors mentioned above.
2) Where can i read more stuffs related to MSDE ver A
3) I am unable to connect to MSDE ver A from another
machine through Client tools.
4) How do i install my SQL scripts to create database,
tables, procedures etc
Thanks again,
David
David wrote:
> Hi,
> I am very new to MSDE version. I just installed MSDE ver
> A and cannot see Enterprise Manager pointer or Query
> Analyzer pointer in All Programs menu. I guess, MSDE does
> not have these editors.
> I would really appreciate if you can answer my following
> Q:
> 1) Does MSDE has all these editors mentioned above.
> 2) Where can i read more stuffs related to MSDE ver A
> 3) I am unable to connect to MSDE ver A from another
> machine through Client tools.
> 4) How do i install my SQL scripts to create database,
> tables, procedures etc
>
Hi David,
AFAIK MSDE comes without any tools - by design the client
application is responsible for creating the table etc.
(e.g. M$ Access in an ADP-project).
but there exists some freeware tools which can act as a
replacement for the enterprise manager, e.g. DbaMgr2k
which you can find at http://www.asql.biz/DbaMgr.shtm
HTH,
Gerald
|||hi David,
"David" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:14ce01c4df1b$08502e40$a601280a@.phx.gbl
> Hi,
> I am very new to MSDE version. I just installed MSDE ver
> A and cannot see Enterprise Manager pointer or Query
> Analyzer pointer in All Programs menu. I guess, MSDE does
> not have these editors.
> I would really appreciate if you can answer my following
> Q:
> 1) Does MSDE has all these editors mentioned above.
nope, as Gerald already pointed out, MSDE comes with no tool but oSql.exe, a
command line tool; please have a look at
http://support.microsoft.com/default...;EN-US;q325003 for further
info about it and some common uses with MSDE...
further tools are listed at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442 ... google for others...

> 2) Where can i read more stuffs related to MSDE ver A
actually, AFAIK, there are no related stuffs to read about MSDE, as it is an
edition of SQL Server 2000, so you can have a look at SQL Server related
stuffs... you have to be aware of MSDE limitations you can inspect at
http://www.microsoft.com/sql/msde/pr...o/overview.asp , but, if the
eventual feature you are reading about is available for MSDE too, you can
take advantage of existing SQL Server doumentation...
for your convenience, if you didn't already, you can download SQL Server
Books On Line, the official Microsoft documentation about SQL Server, at
http://www.microsoft.com/sql/techinf...000/books.asp, updated at
the latest service pack..

> 3) I am unable to connect to MSDE ver A from another
> machine through Client tools.
MSDE installs by default disabling network protocols to protect the server
from remote malicious attacks, so only local connections are enabled... to
change this behaviour at install time, you have to provide the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe boostrapper installer, or, if already installed,
you have to run the Server Network Utility (svrnetcn.exe) to enable the
desired network protocol..

> 4) How do i install my SQL scripts to create database,
> tables, procedures etc
if you do have the DDL Transact-SQL scripts, you can execute them via
oSql.exe (have a look at the provided link for further info about oSql.exe),
my project too provides executing Transact-SQL scripts features too as quite
all the Query Analizer replacement tool...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea. Your reply really gives me lot of info.
David

>--Original Message--
>hi David,
>"David" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:14ce01c4df1b$08502e40$a601280a@.phx.gbl
ver[vbcol=seagreen]
does[vbcol=seagreen]
following
>nope, as Gerald already pointed out, MSDE comes with no
tool but oSql.exe, a
>command line tool; please have a look at
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q325003 for further
>info about it and some common uses with MSDE...
>further tools are listed at
>http://www.microsoft.com/sql/msde/partners/default.asp
and/or
>http://www.aspfaq.com/show.asp?id=2442 ... google for
others...
>
>actually, AFAIK, there are no related stuffs to read
about MSDE, as it is an
>edition of SQL Server 2000, so you can have a look at
SQL Server related
>stuffs... you have to be aware of MSDE limitations you
can inspect at
>http://www.microsoft.com/sql/msde/pr...fo/overview.as
p , but, if the
>eventual feature you are reading about is available for
MSDE too, you can
>take advantage of existing SQL Server doumentation...
>for your convenience, if you didn't already, you can
download SQL Server
>Books On Line, the official Microsoft documentation
about SQL Server, at
>http://www.microsoft.com/sql/techinf...ctdoc/2000/boo
ks.asp, updated at
>the latest service pack..
>
>MSDE installs by default disabling network protocols to
protect the server
>from remote malicious attacks, so only local connections
are enabled... to
>change this behaviour at install time, you have to
provide the
>DISABLENETWORKPROTOCOLS=0
>parameter to the setup.exe boostrapper installer, or, if
already installed,
>you have to run the Server Network Utility
(svrnetcn.exe) to enable the
>desired network protocol..
>
>if you do have the DDL Transact-SQL scripts, you can
execute them via
>oSql.exe (have a look at the provided link for further
info about oSql.exe),
>my project too provides executing Transact-SQL scripts
features too as quite
>all the Query Analizer replacement tool...
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>

install cluster sql 2005

I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000
cluster and analysis services cluster.
I must install sql 2005 and analysis services 2005 without upgrade 2000
instances.
can you help me ?
What do you need help with? Knowledge base articles, etc. etc.....
DatabaseAdmins.com,LLC
"Gigi73" wrote:

> I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with sql2000
> cluster and analysis services cluster.
> I must install sql 2005 and analysis services 2005 without upgrade 2000
> instances.
> can you help me ?
>
|||You will have to establish two new cluster groups, which will contain
dedicated IP addresses, network names, disks, and the SQL Server instance
for one, Analysis Services for the other.
You install SQL Server just like you normally would, but need to give it a
new unique Server Name and Instance Name.
Analysis Services on the other hand is truly clustered, whereas AS2000 only
used the general services resource.
Migrate a SQL Server 2000 Analysis Services cluster to a SQL Server 2005
Analysis Services cluster
http://support.microsoft.com/kb/910233
SQL Server 2005 Failover Clustering White Paper
http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
SQL Server 2005 Upgrade Technical Reference Guide
http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Sincerely,
Anthony Thomas

"Gigi73" <Gigi73@.discussions.microsoft.com> wrote in message
news:1E59C379-13BF-4C60-B6C4-BAFFA95E4251@.microsoft.com...
> I've setup a Windows 2003 Enterprise Edition cluster of 2 nodes, with
sql2000
> cluster and analysis services cluster.
> I must install sql 2005 and analysis services 2005 without upgrade 2000
> instances.
> can you help me ?
>

Install Client Management Tool in WinXP Professional with SQL2005 CTP

SQL server 2005 was installed successfully with SQL2005 CTP CD(Enterprise edition). However, I tried to install Client Management Tool in my WinXP Professional desktop, it stated that incompatibility of OS. Does it mean that I can only install client management tool in WinXP profession with CTP for other editions except enterprise one? Thanks in advance.

Yep, you hit a bug. We've fixed this. The work around is to pull down one of the other Editions.

Dan

Install 2005 Enterprise Edition on windows XP Home Edition has pro

My pc used to have 2000, and i tried to install 2005 once with the instance
as name instance but failed, so i uninstall 2000, but looks like it always
recognize the default instance there even though there is no more 2000 sever,
when i try to install 2005 with name instance again, i got the error failed
to install database engineer, i don't know what to look at the
SQLSetup0006_DDAI_SQL.log, can somebody advice? thank you
Machine : DDAI
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL Server
2005 Setup Log Files" and "Starting SQL Server Manually.
----
Machine : DDAI
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0006_DDAI_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more
information, see the SQL Server Books Online topics, "How to: View SQL Server
2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1053) The service did not respond to the start or control
request in a timely fashion.
Error Number : 29503Hi
According to http://msdn2.microsoft.com/en-us/library/ms143506.aspx
Enterprise Edition is not supported on XP home.
You should be able to have an instance of SQL 2000 and a named instance of
SQL 2005 running on the same machine.
It sounds like SQL 2000 did not fully un-install.This may hekp you to remove
it http://support.microsoft.com/kb/290991
John
"tulip" wrote:
> My pc used to have 2000, and i tried to install 2005 once with the instance
> as name instance but failed, so i uninstall 2000, but looks like it always
> recognize the default instance there even though there is no more 2000 sever,
> when i try to install 2005 with name instance again, i got the error failed
> to install database engineer, i don't know what to look at the
> SQLSetup0006_DDAI_SQL.log, can somebody advice? thank you
> Machine : DDAI
> Product : SQL Server Database Services
> Error : The SQL Server service failed to start. For more
> information, see the SQL Server Books Online topics, "How to: View SQL Server
> 2005 Setup Log Files" and "Starting SQL Server Manually."
> ----
> Machine : DDAI
> Product : Microsoft SQL Server 2005
> Product Version : 9.00.1399.06
> Install : Failed
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0006_DDAI_SQL.log
> Last Action : InstallFinalize
> Error String : The SQL Server service failed to start. For more
> information, see the SQL Server Books Online topics, "How to: View SQL Server
> 2005 Setup Log Files" and "Starting SQL Server Manually."
> The error is (1053) The service did not respond to the start or control
> request in a timely fashion.
> Error Number : 29503|||according to
http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx,
I am installing the trial edition, so should work on windows xp home
edition, right?
"John Bell" wrote:
> Hi
> According to http://msdn2.microsoft.com/en-us/library/ms143506.aspx
> Enterprise Edition is not supported on XP home.
> You should be able to have an instance of SQL 2000 and a named instance of
> SQL 2005 running on the same machine.
> It sounds like SQL 2000 did not fully un-install.This may hekp you to remove
> it http://support.microsoft.com/kb/290991
>
> John
> "tulip" wrote:
> > My pc used to have 2000, and i tried to install 2005 once with the instance
> > as name instance but failed, so i uninstall 2000, but looks like it always
> > recognize the default instance there even though there is no more 2000 sever,
> > when i try to install 2005 with name instance again, i got the error failed
> > to install database engineer, i don't know what to look at the
> > SQLSetup0006_DDAI_SQL.log, can somebody advice? thank you
> >
> > Machine : DDAI
> > Product : SQL Server Database Services
> > Error : The SQL Server service failed to start. For more
> > information, see the SQL Server Books Online topics, "How to: View SQL Server
> > 2005 Setup Log Files" and "Starting SQL Server Manually."
> > ----
> > Machine : DDAI
> > Product : Microsoft SQL Server 2005
> > Product Version : 9.00.1399.06
> > Install : Failed
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Files\SQLSetup0006_DDAI_SQL.log
> > Last Action : InstallFinalize
> > Error String : The SQL Server service failed to start. For more
> > information, see the SQL Server Books Online topics, "How to: View SQL Server
> > 2005 Setup Log Files" and "Starting SQL Server Manually."
> > The error is (1053) The service did not respond to the start or control
> > request in a timely fashion.
> > Error Number : 29503|||Hi
It does say that is allowed, but loading a trial edition onto a XP machine
when you can not use the same machine or OS for production is not really
going to give you anything. If you just want to learn SQL Server you can use
SQL Express or buy a copy of Developer edition. If you are looking at testing
compatibility either use a server that you can trash or a virtual machine
with the server os.
John
"tulip" wrote:
> according to
> http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx,
> I am installing the trial edition, so should work on windows xp home
> edition, right?
> "John Bell" wrote:
> > Hi
> >
> > According to http://msdn2.microsoft.com/en-us/library/ms143506.aspx
> > Enterprise Edition is not supported on XP home.
> >
> > You should be able to have an instance of SQL 2000 and a named instance of
> > SQL 2005 running on the same machine.
> >
> > It sounds like SQL 2000 did not fully un-install.This may hekp you to remove
> > it http://support.microsoft.com/kb/290991
> >
> >
> >
> > John
> >
> > "tulip" wrote:
> >
> > > My pc used to have 2000, and i tried to install 2005 once with the instance
> > > as name instance but failed, so i uninstall 2000, but looks like it always
> > > recognize the default instance there even though there is no more 2000 sever,
> > > when i try to install 2005 with name instance again, i got the error failed
> > > to install database engineer, i don't know what to look at the
> > > SQLSetup0006_DDAI_SQL.log, can somebody advice? thank you
> > >
> > > Machine : DDAI
> > > Product : SQL Server Database Services
> > > Error : The SQL Server service failed to start. For more
> > > information, see the SQL Server Books Online topics, "How to: View SQL Server
> > > 2005 Setup Log Files" and "Starting SQL Server Manually."
> > > ----
> > > Machine : DDAI
> > > Product : Microsoft SQL Server 2005
> > > Product Version : 9.00.1399.06
> > > Install : Failed
> > > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > > Bootstrap\LOG\Files\SQLSetup0006_DDAI_SQL.log
> > > Last Action : InstallFinalize
> > > Error String : The SQL Server service failed to start. For more
> > > information, see the SQL Server Books Online topics, "How to: View SQL Server
> > > 2005 Setup Log Files" and "Starting SQL Server Manually."
> > > The error is (1053) The service did not respond to the start or control
> > > request in a timely fashion.
> > > Error Number : 29503|||Hi
Re-reading this is only says Windows XP SP2 and not what variety of Windows
XP. As Windows 2000 was only professional then it could be that it the
information is not specific enough.
John
"tulip" wrote:
> according to
> http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx,
> I am installing the trial edition, so should work on windows xp home
> edition, right?
> "John Bell" wrote:
> > Hi
> >
> > According to http://msdn2.microsoft.com/en-us/library/ms143506.aspx
> > Enterprise Edition is not supported on XP home.
> >
> > You should be able to have an instance of SQL 2000 and a named instance of
> > SQL 2005 running on the same machine.
> >
> > It sounds like SQL 2000 did not fully un-install.This may hekp you to remove
> > it http://support.microsoft.com/kb/290991
> >
> >
> >
> > John
> >
> > "tulip" wrote:
> >
> > > My pc used to have 2000, and i tried to install 2005 once with the instance
> > > as name instance but failed, so i uninstall 2000, but looks like it always
> > > recognize the default instance there even though there is no more 2000 sever,
> > > when i try to install 2005 with name instance again, i got the error failed
> > > to install database engineer, i don't know what to look at the
> > > SQLSetup0006_DDAI_SQL.log, can somebody advice? thank you
> > >
> > > Machine : DDAI
> > > Product : SQL Server Database Services
> > > Error : The SQL Server service failed to start. For more
> > > information, see the SQL Server Books Online topics, "How to: View SQL Server
> > > 2005 Setup Log Files" and "Starting SQL Server Manually."
> > > ----
> > > Machine : DDAI
> > > Product : Microsoft SQL Server 2005
> > > Product Version : 9.00.1399.06
> > > Install : Failed
> > > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > > Bootstrap\LOG\Files\SQLSetup0006_DDAI_SQL.log
> > > Last Action : InstallFinalize
> > > Error String : The SQL Server service failed to start. For more
> > > information, see the SQL Server Books Online topics, "How to: View SQL Server
> > > 2005 Setup Log Files" and "Starting SQL Server Manually."
> > > The error is (1053) The service did not respond to the start or control
> > > request in a timely fashion.
> > > Error Number : 29503

Install 2005 Enterprise Edition on windows XP Home Edition has pro

I am trying to install the sql server 2005 trial edition on my home pc with
windows xp home edition, based on the link should be fine, but after that
start management studio failed to connect to the database engine
http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx,
so does this os actually could support the trial software? thank youAccording to the BOL entry for Hardware and Software Requirements for
Installing SQL Server 2005 you need Windows XP Professional to install the
Evaluation edition.
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"tulip" wrote:
> I am trying to install the sql server 2005 trial edition on my home pc with
> windows xp home edition, based on the link should be fine, but after that
> start management studio failed to connect to the database engine
> http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx,
> so does this os actually could support the trial software? thank you|||... and here's the I-URL:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:164FDD7B-3ADD-4CE4-8958-3BEF6787C5BB@.microsoft.com...
> According to the BOL entry for Hardware and Software Requirements for
> Installing SQL Server 2005 you need Windows XP Professional to install the
> Evaluation edition.
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "tulip" wrote:
>> I am trying to install the sql server 2005 trial edition on my home pc with
>> windows xp home edition, based on the link should be fine, but after that
>> start management studio failed to connect to the database engine
>> http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx,
>> so does this os actually could support the trial software? thank you