Install RS on SQL2000

I have SQL2000 Developer installed my XP box. Look like I can't put any
except the trial version of RS. Does RS run on SQL Std and Ent only? I
want to play with RS but don't want to install the trial version. Is there
a workaround? Thanks.Hi,
I have SS2000 Developer SP3 AND RS2000 SP2 on my XP SP2 machine with no
problem.
You need to double-check what is the problem with your installation.
Best Regards
Jordi Rambla
SQL Server MVP
Solid Quality Learning
Spain

Install roll back

Hi Guys,
During install of msde2000a, at the last few second of
install on a 2000 server box, installation failed and
rollback. Could anyone can help to solve the problem,
below copied from msde log file.
Thanks,
Ted
Action 14:58:50:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 14:58:50: WriteEnvironmentStrings. Updating
environment strings
WriteEnvironmentStrings: Name: PATH, Value: C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\, Action
1610612738
Action 14:58:50: RegisterTypeLibraries. Registering type
libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
00AA004A34D5}
Action 14:58:51: InstallServices. Installing new services
Action 14:58:51:
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 14:58:52: InstallFinalize. Return value 3.
Action 14:58:52: Rollback. Rolling back action:
If more of the log will help let me know.
Hi Ted,
Is your 2000 server part of a domain or standalone?
bigp
"Ted" <anonymous@.discussions.microsoft.com> wrote in message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> Hi Guys,
> During install of msde2000a, at the last few second of
> install on a 2000 server box, installation failed and
> rollback. Could anyone can help to solve the problem,
> below copied from msde log file.
> Thanks,
> Ted
>
> Action 14:58:50:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action DisableNetAccess()
> Ending custom action DisableNetAccess()
> Action 14:58:50: WriteEnvironmentStrings. Updating
> environment strings
> WriteEnvironmentStrings: Name: PATH, Value: C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\, Action
> 1610612738
> Action 14:58:50: RegisterTypeLibraries. Registering type
> libraries
> RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
> 00AA004A34D5}
> Action 14:58:51: InstallServices. Installing new services
> Action 14:58:51:
> InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 14:58:52: InstallFinalize. Return value 3.
> Action 14:58:52: Rollback. Rolling back action:
> If more of the log will help let me know.
|||I'm having the same problem he describes. It is a standalone server. I have found several web pages that detail this problem, but have yet to find a solution to it for Windows 2000 professional.
This page outlines the specific problem I'm having:
http://www.crescentbloom.com/III/D/11.htm
But in it's workaround, step 4 is something that my computer doesn't have (a 'Server' item on my services list)
I have also found instructions from Microsoft's site on how to fix this in Win 2003, but they also do not work for Win 2000 Pro. Can anybody be of help? Thank you!
-Greg
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...erver-msde/681
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...a630a1edd2a9d2
*****************************************
|||The Server is part of a large domain, I have installed
MSDE on other servers on the same domain and they worked
fine.

>--Original Message--
>Hi Ted,
>Is your 2000 server part of a domain or standalone?
>bigp
>"Ted" <anonymous@.discussions.microsoft.com> wrote in
message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
type[vbcol=seagreen]
services[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-
>.
>
|||The server service is runing ok

>--Original Message--
>I'm having the same problem he describes. It is a
standalone server. I have found several web pages that
detail this problem, but have yet to find a solution to
it for Windows 2000 professional.
>This page outlines the specific problem I'm having:
>http://www.crescentbloom.com/III/D/11.htm
>But in it's workaround, step 4 is something that my
computer doesn't have (a 'Server' item on my services
list)
>I have also found instructions from Microsoft's site on
how to fix this in Win 2003, but they also do not work
for Win 2000 Pro. Can anybody be of help? Thank you!
>-Greg
>*****************************************
>* A copy of the whole thread can be found at:
>* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-
msde/681
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?
aid=c471d6429e704a1082a630a1edd2a9d2
>*****************************************
>.
>
|||Can your server locate the PDC, the fsmocheck line of dcdiag?
<anonymous@.discussions.microsoft.com> wrote in message news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
> The Server is part of a large domain, I have installed
> MSDE on other servers on the same domain and they worked
> fine.
> message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> {E09B48B5-
> {E09B48B5-
> type
> services
> {E09B48B5-
> {E09B48B5-
|||It is the pdc.
Do you think it my be rights?

>--Original Message--
>Can your server locate the PDC, the fsmocheck line of
dcdiag?
><anonymous@.discussions.microsoft.com> wrote in message
news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
worked[vbcol=seagreen]
$a401280a@.phx.gbl>...[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
problem,[vbcol=seagreen]
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
C:\Program[vbcol=seagreen]
AE68-[vbcol=seagreen]
AE6E-[vbcol=seagreen]
AE7B-[vbcol=seagreen]
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
value 3.
>.
>

Install on Personal Edition 2000 SP3a

I installed SQL 2000 on a Windows XP box with a typical install, but
Full-Text Search does not appear to have been installed. It does not appear
at all. I want to go back and install it, but the install wants to create a
new instance. Can this be done without creating a new instance or
uninstalling and then reinstalling?
Thanks
It should work, can you issue this query?
select ServerProperty(N'IsFulltextInstalled')
This will tell you whether it is installed or not.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Audrey" <Audrey@.discussions.microsoft.com> wrote in message
news:16AC1E43-9D2F-4889-8527-90B05A3B6AC3@.microsoft.com...
> I installed SQL 2000 on a Windows XP box with a typical install, but
> Full-Text Search does not appear to have been installed. It does not
appear
> at all. I want to go back and install it, but the install wants to create
a
> new instance. Can this be done without creating a new instance or
> uninstalling and then reinstalling?
> Thanks
sql

Install on non-default website

I would like to install RS on my intranet box on a non-default website and
use host-headers to hit the site.
Is this possible even though RS books online says to set the IP address for
the site to "all unassigned"?
TIA,
Berry"Berry Morgan" wrote:
> I would like to install RS on my intranet box on a non-default website and
> use host-headers to hit the site.
> Is this possible even though RS books online says to set the IP address for
> the site to "all unassigned"?
It's not possible to install it to a non-default website, but you can move
it afterwards. Follow this link for more details:
http://www.henriksen.no/Blog/PermaLink,guid,5235a943-d55a-482c-ba1f-e599fb75e960.aspx

Install Katmai on WHS box

Could/Should I install on my Windows Home Server Box RC release?

WHS code base is the same/similar to 2003 Server so there is no reason why you shouldn't be able to install Katmai on WHS. However, you might be best to install Virtual Server on WHS and run Katmai inside a VM as personally, I wouldn't want a CTP running on a machine which is also backing up all of my machines. If it kills the VM, it won't affect anything else.

sql

Install Katmai on WHS box

Could/Should I install on my Windows Home Server Box RC release?

WHS code base is the same/similar to 2003 Server so there is no reason why you shouldn't be able to install Katmai on WHS. However, you might be best to install Virtual Server on WHS and run Katmai inside a VM as personally, I wouldn't want a CTP running on a machine which is also backing up all of my machines. If it kills the VM, it won't affect anything else.

Install help

I have recently inherited a Windows 2003 server box that has both
SQLExpress installed along with a Named 2005 instance. The problem I'm
having is that on the named instance they didn't(or it failed) install
Integrated Services. I went into add/remove programs and tried to change the
install options(add SSIS). I choose the named Instance but it never allows
me choose Integrated Services to install.
How can I get SSIS installed?
I looked at the folder structure and the named instance doesn't have
reference to SSIS being there.
Thanks.
SSIS isn't instance aware. Or rather, you cannot have several instances in SSIS, and basically SSIS
isn't tied to a specific instance. I haven't done this myself, but I'd just run setup from the
install DVD and add SSIS from there.
There's is one connection for SSIS to an instance, and this is in which MSDB to store the packages,
and you configure this in below XML file (after installation):
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
> I have recently inherited a Windows 2003 server box that has both SQLExpress installed along with
> a Named 2005 instance. The problem I'm having is that on the named instance they didn't(or it
> failed) install Integrated Services. I went into add/remove programs and tried to change the
> install options(add SSIS). I choose the named Instance but it never allows me choose Integrated
> Services to install.
> How can I get SSIS installed?
> I looked at the folder structure and the named instance doesn't have reference to SSIS being
> there.
>
> Thanks.
|||This file exists "C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
start?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> SSIS isn't instance aware. Or rather, you cannot have several instances in
> SSIS, and basically SSIS isn't tied to a specific instance. I haven't done
> this myself, but I'd just run setup from the install DVD and add SSIS from
> there.
> There's is one connection for SSIS to an instance, and this is in which
> MSDB to store the packages, and you configure this in below XML file
> (after installation):
> C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "AHartman" <Hoosbruin@.Kconline.com> wrote in message
> news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
>
|||You need to modify that file so that it will point to your
named instance. Modify the section for the server:
<ServerName>.</ServerName>
to point to your named instance:
<ServerName>ServerName\InstanceName</ServerName>
There is a topic in books online that explains this. Look up
the topic:
Configuring the Integration Services Service
and check the section regarding configuring a named
instance.
-Sue
On Thu, 9 Aug 2007 05:44:05 -0400, "AHartman"
<Hoosbruin@.Kconline.com> wrote:
[vbcol=seagreen]
>This file exists "C:\Program Files\Microsoft SQL
>Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
>start?
>
>
>
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...

Install help

I have recently inherited a Windows 2003 server box that has both
SQLExpress installed along with a Named 2005 instance. The problem I'm
having is that on the named instance they didn't(or it failed) install
Integrated Services. I went into add/remove programs and tried to change the
install options(add SSIS). I choose the named Instance but it never allows
me choose Integrated Services to install.
How can I get SSIS installed?
I looked at the folder structure and the named instance doesn't have
reference to SSIS being there.
Thanks.SSIS isn't instance aware. Or rather, you cannot have several instances in S
SIS, and basically SSIS
isn't tied to a specific instance. I haven't done this myself, but I'd just
run setup from the
install DVD and add SSIS from there.
There's is one connection for SSIS to an instance, and this is in which MSDB
to store the packages,
and you configure this in below XML file (after installation):
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.
gbl...
> I have recently inherited a Windows 2003 server box that has both SQLExpre
ss installed along with
> a Named 2005 instance. The problem I'm having is that on the named instanc
e they didn't(or it
> failed) install Integrated Services. I went into add/remove programs and t
ried to change the
> install options(add SSIS). I choose the named Instance but it never allows
me choose Integrated
> Services to install.
> How can I get SSIS installed?
> I looked at the folder structure and the named instance doesn't have refe
rence to SSIS being
> there.
>
> Thanks.|||This file exists "C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
start?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> SSIS isn't instance aware. Or rather, you cannot have several instances in
> SSIS, and basically SSIS isn't tied to a specific instance. I haven't done
> this myself, but I'd just run setup from the install DVD and add SSIS from
> there.
> There's is one connection for SSIS to an instance, and this is in which
> MSDB to store the packages, and you configure this in below XML file
> (after installation):
> C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "AHartman" <Hoosbruin@.Kconline.com> wrote in message
> news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
>|||You need to modify that file so that it will point to your
named instance. Modify the section for the server:
<ServerName>.</ServerName>
to point to your named instance:
<ServerName>ServerName\InstanceName</ServerName>
There is a topic in books online that explains this. Look up
the topic:
Configuring the Integration Services Service
and check the section regarding configuring a named
instance.
-Sue
On Thu, 9 Aug 2007 05:44:05 -0400, "AHartman"
<Hoosbruin@.Kconline.com> wrote:
[vbcol=seagreen]
>This file exists "C:\Program Files\Microsoft SQL
>Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
>start?
>
>
>
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...sql

Install help

I have recently inherited a Windows 2003 server box that has both
SQLExpress installed along with a Named 2005 instance. The problem I'm
having is that on the named instance they didn't(or it failed) install
Integrated Services. I went into add/remove programs and tried to change the
install options(add SSIS). I choose the named Instance but it never allows
me choose Integrated Services to install.
How can I get SSIS installed?
I looked at the folder structure and the named instance doesn't have
reference to SSIS being there.
Thanks.SSIS isn't instance aware. Or rather, you cannot have several instances in SSIS, and basically SSIS
isn't tied to a specific instance. I haven't done this myself, but I'd just run setup from the
install DVD and add SSIS from there.
There's is one connection for SSIS to an instance, and this is in which MSDB to store the packages,
and you configure this in below XML file (after installation):
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
> I have recently inherited a Windows 2003 server box that has both SQLExpress installed along with
> a Named 2005 instance. The problem I'm having is that on the named instance they didn't(or it
> failed) install Integrated Services. I went into add/remove programs and tried to change the
> install options(add SSIS). I choose the named Instance but it never allows me choose Integrated
> Services to install.
> How can I get SSIS installed?
> I looked at the folder structure and the named instance doesn't have reference to SSIS being
> there.
>
> Thanks.|||This file exists "C:\Program Files\Microsoft SQL
Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
start?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...
> SSIS isn't instance aware. Or rather, you cannot have several instances in
> SSIS, and basically SSIS isn't tied to a specific instance. I haven't done
> this myself, but I'd just run setup from the install DVD and add SSIS from
> there.
> There's is one connection for SSIS to an instance, and this is in which
> MSDB to store the packages, and you configure this in below XML file
> (after installation):
> C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "AHartman" <Hoosbruin@.Kconline.com> wrote in message
> news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
>> I have recently inherited a Windows 2003 server box that has both
>> SQLExpress installed along with a Named 2005 instance. The problem I'm
>> having is that on the named instance they didn't(or it failed) install
>> Integrated Services. I went into add/remove programs and tried to change
>> the install options(add SSIS). I choose the named Instance but it never
>> allows me choose Integrated Services to install.
>> How can I get SSIS installed?
>> I looked at the folder structure and the named instance doesn't have
>> reference to SSIS being there.
>>
>> Thanks.
>|||You need to modify that file so that it will point to your
named instance. Modify the section for the server:
<ServerName>.</ServerName>
to point to your named instance:
<ServerName>ServerName\InstanceName</ServerName>
There is a topic in books online that explains this. Look up
the topic:
Configuring the Integration Services Service
and check the section regarding configuring a named
instance.
-Sue
On Thu, 9 Aug 2007 05:44:05 -0400, "AHartman"
<Hoosbruin@.Kconline.com> wrote:
>This file exists "C:\Program Files\Microsoft SQL
>Server\90\DTS\Binn\MsDtsSrvr.ini.xml" but I still don't have any service to
>start?
>
>
>
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:e3WL1hl2HHA.3940@.TK2MSFTNGP05.phx.gbl...
>> SSIS isn't instance aware. Or rather, you cannot have several instances in
>> SSIS, and basically SSIS isn't tied to a specific instance. I haven't done
>> this myself, but I'd just run setup from the install DVD and add SSIS from
>> there.
>> There's is one connection for SSIS to an instance, and this is in which
>> MSDB to store the packages, and you configure this in below XML file
>> (after installation):
>> C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "AHartman" <Hoosbruin@.Kconline.com> wrote in message
>> news:unCHtdj2HHA.3764@.TK2MSFTNGP04.phx.gbl...
>> I have recently inherited a Windows 2003 server box that has both
>> SQLExpress installed along with a Named 2005 instance. The problem I'm
>> having is that on the named instance they didn't(or it failed) install
>> Integrated Services. I went into add/remove programs and tried to change
>> the install options(add SSIS). I choose the named Instance but it never
>> allows me choose Integrated Services to install.
>> How can I get SSIS installed?
>> I looked at the folder structure and the named instance doesn't have
>> reference to SSIS being there.
>>
>> Thanks.

Install failure: "Error 29550. Cannot connect to the SQL server instance

I'm trying to install the Dev version of Reporting Services (RS) on one
box and have it use an Sql Server 2000 (w/SP3) instance on another box.
Both the RS and SqlServer boxes are Windows 2000 Servers. Neither are
part of a "windows domain"--neither will they ever be. We only connect
to SqlServer via a user/pwd pair. Additionally, there are 2 instances of
SqlServer running on the box and both of them listen on custom ports. (I
have confirmed that I can successfully connect to the desired SqlServer
instance from the RS box.)
The error I got was the "Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.". The installer
attempts a domain login when I explicitly told it *not* to. I found no
way to get the installer to successfully connect to the database. The
solutions I've found on the web/Usenet have not worked either.
Since I couldn't get it to install through the GUI, I switched to using
an .ini file. Of course, it's not working either. The (500KB!) log file
the installer produces has only one useful line in it: "Error 29550.
Cannot connect to the SQL server instance ." That meant that the problem
was the RSDATABASESERVER variable. The instructions tell me to specify
an "SQL Server 2000 instance in format MACHINE\INSTANCENAME". I played
around with that value a lot; I wondered how it could figure out what
port to connect to for one thing. While doing so, I tried sniffing the
network to see if that would help me at all--it just got me more
frustrated: no attempt is made to contact the server! Ever.
First off: WHY choose this uncommon, inadequate format for specifying a
server? Why not just use an alias from "cliconfg" like everything else?
Second: why doesn't the installer even *try* to login to the server? If
there's a reason it can't access the network, wouldn't you think that
500KB log file is a good place to mention it?
What do I do? (Hint: don't suggest making either box part of a windows
domain)
GrangerTo have setup use sql auth during setup you must pass in command line
parameters. The params are RSSETUPACCOUNT and RSSETUPPASSWORD
so run this command
setup.exe RSSETUPACCOUNT=foo RSSETUPPASSWORD=bar
This will allow you to use the setup GUI still but all communication with
the backend server will use sql auth. Note that the setup user needs to be
a dbo. You can safely use the sa account as it is only used during setup.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Granger Godbold" <granger.godbold@.FILLER.prometric.com> wrote in message
news:e4VCZaIEFHA.3888@.TK2MSFTNGP10.phx.gbl...
> I'm trying to install the Dev version of Reporting Services (RS) on one
> box and have it use an Sql Server 2000 (w/SP3) instance on another box.
> Both the RS and SqlServer boxes are Windows 2000 Servers. Neither are part
> of a "windows domain"--neither will they ever be. We only connect to
> SqlServer via a user/pwd pair. Additionally, there are 2 instances of
> SqlServer running on the box and both of them listen on custom ports. (I
> have confirmed that I can successfully connect to the desired SqlServer
> instance from the RS box.)
> The error I got was the "Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection.". The installer attempts
> a domain login when I explicitly told it *not* to. I found no way to get
> the installer to successfully connect to the database. The solutions I've
> found on the web/Usenet have not worked either.
> Since I couldn't get it to install through the GUI, I switched to using an
> .ini file. Of course, it's not working either. The (500KB!) log file the
> installer produces has only one useful line in it: "Error 29550. Cannot
> connect to the SQL server instance ." That meant that the problem was the
> RSDATABASESERVER variable. The instructions tell me to specify an "SQL
> Server 2000 instance in format MACHINE\INSTANCENAME". I played around with
> that value a lot; I wondered how it could figure out what port to connect
> to for one thing. While doing so, I tried sniffing the network to see if
> that would help me at all--it just got me more frustrated: no attempt is
> made to contact the server! Ever.
> First off: WHY choose this uncommon, inadequate format for specifying a
> server? Why not just use an alias from "cliconfg" like everything else?
> Second: why doesn't the installer even *try* to login to the server? If
> there's a reason it can't access the network, wouldn't you think that
> 500KB log file is a good place to mention it?
> What do I do? (Hint: don't suggest making either box part of a windows
> domain)
> Granger|||Thanks for trying, but no, that doesn't work; I was already doing that. I was
trying to use the "sa" account from the beginning because the instructions say
the "setup" account is only used during setup.
My problem is still that the installer doesn't even *try* to connect to the
database server. Once I can get around that, my problem will be that it will
want to use Windows Authentication because the connection information only
consists of "server\instance"; that's why it has to login: to figure out the
port the instance lives at.
If anyone knows the person responsible for the decision to use this connection
method, please smack them upside the head for me.
Other ideas?
Granger
Daniel Reib [MSFT] wrote:
> To have setup use sql auth during setup you must pass in command line
> parameters. The params are RSSETUPACCOUNT and RSSETUPPASSWORD
> so run this command
> setup.exe RSSETUPACCOUNT=foo RSSETUPPASSWORD=bar
> This will allow you to use the setup GUI still but all communication with
> the backend server will use sql auth. Note that the setup user needs to be
> a dbo. You can safely use the sa account as it is only used during setup.
>|||Well first of all, if you want it to connect, what does your client
configuration say?
I take it that on the general tab you have TCP/IP listed at the top - click
the properties tab and is the port set correctly for your particular
instance?
I am running reporting services stand-alone - with SQL Server NOT IN A
DOMAIN - and it runs just fine.
You can also create an ALIAS name to the server instance in the SQL Server
Client Network utility.
Finally, just to be sure we are "connecting the dots" here - fire up the SQL
Server Network utility and verify that the TCP/IP properties are also
listening on the correct port. (I bet they are since you are using the
system successfully)
Last but not least, even if you are using SQL Server authentication, you
should be able to use windows authentication only when doing the setup -
since as you said you have full control over the dev box - then you have
local admin rights - therefore you should be able to logon unless you have
modifed the BUILTIN\Administrators security for that machine. (I assume that
this is not the case).
Please let me know if you are still having an issue, I'll be happy to help
you out.
Of course, this may come as a dumb question, but I assume nothing: Did you
install SP3a for SQL Server? (I assume yes), did you install the SQL Server
hotfix 859 ?
=-Chris
"Granger Godbold" <granger.godbold@.invalid.prometric.com> wrote in message
news:ucLN4gZEFHA.3256@.tk2msftngp13.phx.gbl...
> Thanks for trying, but no, that doesn't work; I was already doing that. I
> was trying to use the "sa" account from the beginning because the
> instructions say the "setup" account is only used during setup.
> My problem is still that the installer doesn't even *try* to connect to
> the database server. Once I can get around that, my problem will be that
> it will want to use Windows Authentication because the connection
> information only consists of "server\instance"; that's why it has to
> login: to figure out the port the instance lives at.
> If anyone knows the person responsible for the decision to use this
> connection method, please smack them upside the head for me.
> Other ideas?
> Granger
>
> Daniel Reib [MSFT] wrote:
>> To have setup use sql auth during setup you must pass in command line
>> parameters. The params are RSSETUPACCOUNT and RSSETUPPASSWORD
>> so run this command
>> setup.exe RSSETUPACCOUNT=foo RSSETUPPASSWORD=bar
>> This will allow you to use the setup GUI still but all communication with
>> the backend server will use sql auth. Note that the setup user needs to
>> be a dbo. You can safely use the sa account as it is only used during
>> setup.|||Thanks Chris.
The connectivity is all OK. It appears I'm just going to have to go
sync the administrators on each of the boxes during the install.
However, that won't be for a while; I just gave up and installed
everything on my own box for now. When I've had a chance to play with it
for a while, I'll do another install attempt in a more "proper" DEV
environment.
As far as the updates on the database go, my DBA says he's only done
security bulletin stuff. I looked it over and it seems the DEV box has
SP3 not SP3a (I checked the Ssnetlib.dll; we have 2000.80.760 not
2000.80.766
(http://support.microsoft.com/default.aspx?scid=kb;en-us;819334)). Also,
since Enterprise Manager reports 8.00.760, I gather he's not done any
hotfixes. This KnowledgeBase article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;888007) implies
we should be at least at .977. I'll go tease him for being a slacker. ;)
I wouldn't guess the hotfixes would have anything to do with my
problem, however, since my local database only has SP3 installed on it
and ReportingServices installed fine.
Again, thanks Chris =)
Granger
Christopher Conner wrote:
<snip>
> Last but not least, even if you are using SQL Server authentication, you
> should be able to use windows authentication only when doing the setup -
> since as you said you have full control over the dev box - then you have
> local admin rights - therefore you should be able to logon unless you have
> modifed the BUILTIN\Administrators security for that machine. (I assume that
> this is not the case).
> Please let me know if you are still having an issue, I'll be happy to help
> you out.
> Of course, this may come as a dumb question, but I assume nothing: Did you
> install SP3a for SQL Server? (I assume yes), did you install the SQL Server
> hotfix 859 ?
> =-Chris
>sql

Installation configuration

I am new to SRS, so bear with me. Can I install SRS on my existing SQL box;
install SRM on my existing web box on a different site; and install VS.NET
with report designer on my desktop?It's just depened only on software and hardware yours PC configuration. There
is not other depenedences. Ofcourse You can instal SRS on your SQL box and
SRM on your web box. VS.NET you can have everywhere you want.
J
"Dwayne" wrote:
> I am new to SRS, so bear with me. Can I install SRS on my existing SQL box;
> install SRM on my existing web box on a different site; and install VS.NET
> with report designer on my desktop?

Install 2000 Reporting Services on SQL server 2005

Hello,
Can you install SQL 2000 Reporting Services on a Windows Server 2003
box running SQL 2005 server?
Thanks for any help.I think you're going to run into problems with this.
If memory serves me correctly, SQL 2005 has RS built into it already.
You will need a copy of VS.net 2005 to develop your reports.
Anyone please correct me if I'm wrong.
kernpanic1@.yahoo.co.uk wrote:
> Hello,
> Can you install SQL 2000 Reporting Services on a Windows Server 2003
> box running SQL 2005 server?
> Thanks for any help.|||Although RS ships with SQL Server it has to be installed. RS 2005 can
install to use a SQL Server 2000 database but I do not believe RS 2000 can
install to use a SQL Server 2005 database.
You DO NOT need a copy of VS 2005. RS 2005 ships with a version of VS to
prevent the need to purchase it (with 2000 you had to purchase VS 2003).
Here is a question for the original poster. Why do you want to do this. RS
2005 is significantly better than RS 2000 (faster, end user sorting,
multi-select parameters, date picker, etc). If you have SQL Server 2005 then
you have the license for RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce Lawrence" <BL32375@.gmail.com> wrote in message
news:1164825003.775511.178720@.80g2000cwy.googlegroups.com...
>I think you're going to run into problems with this.
> If memory serves me correctly, SQL 2005 has RS built into it already.
> You will need a copy of VS.net 2005 to develop your reports.
> Anyone please correct me if I'm wrong.
>
> kernpanic1@.yahoo.co.uk wrote:
>> Hello,
>> Can you install SQL 2000 Reporting Services on a Windows Server 2003
>> box running SQL 2005 server?
>> Thanks for any help.
>|||How do you separate the RS2005 installation so it can install on SQL
2000? I thought it was part of the SQL2005 installation.|||Bruce L-C [MVP] wrote:
> Although RS ships with SQL Server it has to be installed. RS 2005 can
> install to use a SQL Server 2000 database but I do not believe RS 2000 can
> install to use a SQL Server 2005 database.
> You DO NOT need a copy of VS 2005. RS 2005 ships with a version of VS to
> prevent the need to purchase it (with 2000 you had to purchase VS 2003).
> Here is a question for the original poster. Why do you want to do this. RS
> 2005 is significantly better than RS 2000 (faster, end user sorting,
> multi-select parameters, date picker, etc). If you have SQL Server 2005 then
> you have the license for RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce Lawrence" <BL32375@.gmail.com> wrote in message
> news:1164825003.775511.178720@.80g2000cwy.googlegroups.com...
> >I think you're going to run into problems with this.
> >
> > If memory serves me correctly, SQL 2005 has RS built into it already.
> > You will need a copy of VS.net 2005 to develop your reports.
> >
> > Anyone please correct me if I'm wrong.
> >
> >
> > kernpanic1@.yahoo.co.uk wrote:
> >> Hello,
> >>
> >> Can you install SQL 2000 Reporting Services on a Windows Server 2003
> >> box running SQL 2005 server?
> >>
> >> Thanks for any help.
> >
Thanks for replying, it isn't actually me that wants to so this, its a
job that has been logged with us. I am not really familiar with MS SQL
products so apologies if this was a stupid question. I do however have
another question; do you get RS 2005 with all versions of SQL Server
2005 and is it installed by default when you install SQL Server 2005?|||No, you have to install it. It is on the install media but is not installed
automatically. Just like some of the other items in the suite of product
(analysis server for instance). Plus, you have to have IIS installed and
configured prior to install RS.
You can install RS 2005 only from the media and use SQL 2000 as its
metadata/object store. MS specifically allowed this because people are slow
to upgrade databases and they wanted to allow faster rollout of RS. You do
need a SQL Server 2005 license on any box running RS 2005.
You can also install RS on a box separate from the DB server (but you need a
SQL Server license on any box running RS).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<kernpanic1@.yahoo.co.uk> wrote in message
news:1164828730.969134.268030@.16g2000cwy.googlegroups.com...
> Bruce L-C [MVP] wrote:
>> Although RS ships with SQL Server it has to be installed. RS 2005 can
>> install to use a SQL Server 2000 database but I do not believe RS 2000
>> can
>> install to use a SQL Server 2005 database.
>> You DO NOT need a copy of VS 2005. RS 2005 ships with a version of VS to
>> prevent the need to purchase it (with 2000 you had to purchase VS 2003).
>> Here is a question for the original poster. Why do you want to do this.
>> RS
>> 2005 is significantly better than RS 2000 (faster, end user sorting,
>> multi-select parameters, date picker, etc). If you have SQL Server 2005
>> then
>> you have the license for RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bruce Lawrence" <BL32375@.gmail.com> wrote in message
>> news:1164825003.775511.178720@.80g2000cwy.googlegroups.com...
>> >I think you're going to run into problems with this.
>> >
>> > If memory serves me correctly, SQL 2005 has RS built into it already.
>> > You will need a copy of VS.net 2005 to develop your reports.
>> >
>> > Anyone please correct me if I'm wrong.
>> >
>> >
>> > kernpanic1@.yahoo.co.uk wrote:
>> >> Hello,
>> >>
>> >> Can you install SQL 2000 Reporting Services on a Windows Server 2003
>> >> box running SQL 2005 server?
>> >>
>> >> Thanks for any help.
>> >
> Thanks for replying, it isn't actually me that wants to so this, its a
> job that has been logged with us. I am not really familiar with MS SQL
> products so apologies if this was a stupid question. I do however have
> another question; do you get RS 2005 with all versions of SQL Server
> 2005 and is it installed by default when you install SQL Server 2005?
>

Install 2 sql server in same box

Hi,

Something need your help, may be sound funny but we have to do find some source to prove to our customer.

Currently we have one customer is using sql server version 7 with their old system, and now they want to install our system which request sql server version 2000, and they dont want to bought new server for this sql server 2000. Instead they want to install it in same box but different harddisk, can any one provide me any idea regarding this?You can install the 2000 server as an instance on same system as 7.0.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_7303.asp|||You can install the 2000 server as an instance on same system as 7.0.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_7303.asp

Hi,

any drawback on this kind of installation, actually our customer their server spec is not very high. only Pentium III, 512 RAM, 40 G hardisk.