How do I install Reporting services?

I come from access development background and I am new to SQL Server. I am
trying to learn it using the Developer edition. When I was installing SQL
server 2005 Developer edition, I came to the "Components to Install, Select
the components to install or upgrade"on the setup form , I noticed that
"Reporting Services" option was disabled is there a reason why? how can I
install it. After instalation, I tried to use the configure tools to
configure Report server I got the message "No report servers were found on
the specified machine.details: Invalid namespace". I had a dialog box
entiteled "Report Server Installation Instance Selection" with the Machine
Name box enabled and the machine name was entered but the "Instance name box"
was disabled? any idea.
thanks
AlYou need to installed the report service component from your Windows Server
2003 operating system
"Al" wrote:
> I come from access development background and I am new to SQL Server. I am
> trying to learn it using the Developer edition. When I was installing SQL
> server 2005 Developer edition, I came to the "Components to Install, Select
> the components to install or upgrade"on the setup form , I noticed that
> "Reporting Services" option was disabled is there a reason why? how can I
> install it. After instalation, I tried to use the configure tools to
> configure Report server I got the message "No report servers were found on
> the specified machine.details: Invalid namespace". I had a dialog box
> entiteled "Report Server Installation Instance Selection" with the Machine
> Name box enabled and the machine name was entered but the "Instance name box"
> was disabled? any idea.
> thanks
> Al|||Hi,
to clarify this a bit, there is no reporting services components of the
Windows 2003 Server system, but Reporting Services has the
prerequisites of IIS Service. This has to be installed from the
"Add/Remove Software" panel with the appropiate Windows 2003 Server
media.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--|||Thank you for responding. I do not have the Windows 2003 Server. I am
installing the Developer edition locally on Windows xp professional. is there
away to do it? is there another place (microsoft website) where I get IIS
service?
thanks
Al
"Jens" wrote:
> Hi,
> to clarify this a bit, there is no reporting services components of the
> Windows 2003 Server system, but Reporting Services has the
> prerequisites of IIS Service. This has to be installed from the
> "Add/Remove Software" panel with the appropiate Windows 2003 Server
> media.
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>|||For developer edition of SQL Server, you do not need Win2003 server. WinXP
is OK. You need to have IIS running (install it if you haven't. Since you
have WinXP Pro, you are OK).
"Al" <Al@.discussions.microsoft.com> wrote in message
news:65F24FC2-3F9C-48D6-B4F4-9323D10BC229@.microsoft.com...
> Thank you for responding. I do not have the Windows 2003 Server. I am
> installing the Developer edition locally on Windows xp professional. is
> there
> away to do it? is there another place (microsoft website) where I get IIS
> service?
> thanks
> Al
> "Jens" wrote:
>> Hi,
>> to clarify this a bit, there is no reporting services components of the
>> Windows 2003 Server system, but Reporting Services has the
>> prerequisites of IIS Service. This has to be installed from the
>> "Add/Remove Software" panel with the appropiate Windows 2003 Server
>> media.
>> HTH, Jens K. Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>|||Windows XP Pro has IIS but it is not running/installed. Go to Control Panel,
Add/Remove, then on the left there will be a selection called something like
Windows Components. You need to have IIS running prior to installing RS. You
also need to have SQL Server Installed. If you are installing RS 2005 then
you can install both SQL Server and RS at the same time. Note you will have
two installs. The server install and then the client tools. I strongly
recommend using RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Al" <Al@.discussions.microsoft.com> wrote in message
news:65F24FC2-3F9C-48D6-B4F4-9323D10BC229@.microsoft.com...
> Thank you for responding. I do not have the Windows 2003 Server. I am
> installing the Developer edition locally on Windows xp professional. is
> there
> away to do it? is there another place (microsoft website) where I get IIS
> service?
> thanks
> Al
> "Jens" wrote:
>> Hi,
>> to clarify this a bit, there is no reporting services components of the
>> Windows 2003 Server system, but Reporting Services has the
>> prerequisites of IIS Service. This has to be installed from the
>> "Add/Remove Software" panel with the appropiate Windows 2003 Server
>> media.
>> HTH, Jens K. Suessmeyer.
>> --
>> http://www.sqlserver2005.de
>> --
>>|||yes you are right. I tried to install the IIS from the windows Components
and from the original cd and made all the selections it asked me. I then
restarted my computer but nothing happened. it does not show on the control
panel>add remove program and it does not show on the all programs menu. how
do I know if it was installed?
Al
"Bruce L-C [MVP]" wrote:
> Windows XP Pro has IIS but it is not running/installed. Go to Control Panel,
> Add/Remove, then on the left there will be a selection called something like
> Windows Components. You need to have IIS running prior to installing RS. You
> also need to have SQL Server Installed. If you are installing RS 2005 then
> you can install both SQL Server and RS at the same time. Note you will have
> two installs. The server install and then the client tools. I strongly
> recommend using RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Al" <Al@.discussions.microsoft.com> wrote in message
> news:65F24FC2-3F9C-48D6-B4F4-9323D10BC229@.microsoft.com...
> > Thank you for responding. I do not have the Windows 2003 Server. I am
> > installing the Developer edition locally on Windows xp professional. is
> > there
> > away to do it? is there another place (microsoft website) where I get IIS
> > service?
> > thanks
> > Al
> >
> > "Jens" wrote:
> >
> >> Hi,
> >>
> >> to clarify this a bit, there is no reporting services components of the
> >> Windows 2003 Server system, but Reporting Services has the
> >> prerequisites of IIS Service. This has to be installed from the
> >> "Add/Remove Software" panel with the appropiate Windows 2003 Server
> >> media.
> >>
> >> HTH, Jens K. Suessmeyer.
> >>
> >> --
> >> http://www.sqlserver2005.de
> >> --
> >>
> >>
>
>

How do I get SQL Server 2000 Personal Edition

Does SQL Server 2000 Personal Edition install from the SQL Server 2000
Standard CD? I see on the Microsoft website that licensing SQL Server 2000
Standard entitles users to SQL Server 2000 Personal but I don't see an
option for installing Personal. Is it a separate CD?David,
I don't have the CD here to confirm. However, I believe it's on the CD under
Personal/MSDE folder.
--
-oj
http://www.rac4sql.net
"David Morrison" <me@.nospam.com> wrote in message
news:unXLtoG5DHA.1948@.TK2MSFTNGP12.phx.gbl...
> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server
2000
> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>|||it came on a separate CD purchased in 2001, don't know how it is now.
"David Morrison" <me@.nospam.com> wrote in message
news:unXLtoG5DHA.1948@.TK2MSFTNGP12.phx.gbl...
> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server
2000
> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>

How do I get SQL Server 2000 Personal Edition

Does SQL Server 2000 Personal Edition install from the SQL Server 2000
Standard CD? I see on the Microsoft website that licensing SQL Server 2000
Standard entitles users to SQL Server 2000 Personal but I don't see an
option for installing Personal. Is it a separate CD?David,
I don't have the CD here to confirm. However, I believe it's on the CD under
Personal/MSDE folder.
-oj
http://www.rac4sql.net
"David Morrison" <me@.nospam.com> wrote in message
news:unXLtoG5DHA.1948@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server

---

2000

quote:

---

> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>

---

|||it came on a separate CD purchased in 2001, don't know how it is now.
"David Morrison" <me@.nospam.com> wrote in message
news:unXLtoG5DHA.1948@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Does SQL Server 2000 Personal Edition install from the SQL Server 2000
> Standard CD? I see on the Microsoft website that licensing SQL Server

---

2000

quote:

---

> Standard entitles users to SQL Server 2000 Personal but I don't see an
> option for installing Personal. Is it a separate CD?
>

---

How do I force new databases to be created on another drive on same server?

I successfuly installed SQL Server 2005 Enterprise Edition today (on the first shot!) but can't figure out how to force new databases, etc to be created on another drive on the server. SQL installed on the c: drive (I had no choice!) but it is a very small partition. I need to install Sharepoint Portal 2003 next (on a different server) and want to make sure everything goes on the other drive.

Help me, please!!

Thanks :-)

As far as I can remember Sharepoint let you choose the destination of the data files. Anyway the default data directory can be changed in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Thanks, I'll give it a try.|||

I just tried it and it is still creating new databases on c: drive. We had to slick the server for another reason, so I have a fresh install and told it to install to d:\Program Files\.... during installation and the registry entry did not change; it still pointed to c: drive. I created a d:\Program Files\Microsoft SQL Server\Data directory and changed the registry and no joy. Even restarted the server a few times and it didn't matter.

Shouldn't there be a way to change this default in the Server Management Studio?!?

If any can help me, it would be appreciated! This problem is holding up installation of a few more apps.

Thanks!!

|||Sorry for that I copied the wrong key :-(

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=407351&SiteID=1

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

Thanks. I actually found out where to do it in the SQL Server Management Studio!

SERVER--PROPERTIES--DATABASE SETTINGS

The path for databases and logs are blank. After I selected my folders on the D: drive I created a new db and it went to the correct path! Whew. Glad that's over with :-)

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
Venki
Sorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||use master
select @.@.version
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:
> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>> Hello:
>> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
>> editions.
>> Can you tell me how I can determine which flavor is installed?
>> I thought I had Standard Edition but when I tried to install Standard
>> Edition of the Reporting services, it said that it was a wrong type.
>> Thanks.
>> Venki

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
VenkiSorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||use master
select @.@.version
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote:
>