Help on SQL Reporting Services

Can someone please explain what is required to install this Software ? I mean , anything special needed at all or I can just slap it on to any Win2K server . I am assuming it doesn't have to be on the same server as SQLIn case you are not concerned about the cost, you don't have to install MS Reporting Services and MS SQL Server on the same machine (you will need extra SQL Server license though). In case you'd like to create web-based reports only, you may fiind LGX Report interesting (it is free): www.FreeReporting.com.

Help needed on installing Sql Server 2000 on Win2k3.

Hi All Gurus
I am trying to install SQL2K on Win2003 Ent.Ed.
I could successfully configure MSDTC as a resource , then i tried to install
Sql Server 2k (Ent Ed), After i provided all the information like ip name,
n/name all off a sudden , istallation failed saying cannot continue .
I checked, both the nodes , terminal services is not running.
Please help I am simulating this clustering as a proof of concept.and Once
this is done i need to do the same on production, in 15 days.
Please Please help
I looked at all the resouces but could not
Here are some helpful resources
SQL Server 2000 cluster does not install on Windows Server 2003-based
computers where Terminal Services is installed
http://support.microsoft.com/default...b;en-us;301520
Note that Remote Desktop Connection is not Terminal services for the
purposes of this article.
PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
Nodes
http://support.microsoft.com/default...b;en-us;811054
This is probably the most common problem I see
PRB: Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default...b;en-us;815431
Finally, make sure you are launching the installer from a Domain-level
account that is a local administrator on all nodes. Log in to each of the
nodes using the launch account, the cluster account, and the SQL service
account before starting the installation.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> Hi All Gurus
> I am trying to install SQL2K on Win2003 Ent.Ed.
> I could successfully configure MSDTC as a resource , then i tried to
install
> Sql Server 2k (Ent Ed), After i provided all the information like ip name,
> n/name all off a sudden , istallation failed saying cannot continue .
> I checked, both the nodes , terminal services is not running.
> Please help I am simulating this clustering as a proof of concept.and Once
> this is done i need to do the same on production, in 15 days.
> Please Please help
> I looked at all the resouces but could not
>
|||Nikhil,
Is this the error you are getting? "An error occurred while creating
virtual server resources for clustering. Cluster specific registry entries
couldn't be written" If so, then make sure the remote registry service is
running on all nodes. I had this problem this morning and that work for me.
Kevin
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:#3rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
> Here are some helpful resources
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
> Note that Remote Desktop Connection is not Terminal services for the
> purposes of this article.
> PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
> Nodes
> http://support.microsoft.com/default...b;en-us;811054
> This is probably the most common problem I see
> PRB: Installation of a named instance of SQL Server 2000 virtual server on
a[vbcol=seagreen]
> Windows 2003-based cluster fails
> http://support.microsoft.com/default...b;en-us;815431
> Finally, make sure you are launching the installer from a Domain-level
> account that is a local administrator on all nodes. Log in to each of the
> nodes using the launch account, the cluster account, and the SQL service
> account before starting the installation.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
> news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> install
name,[vbcol=seagreen]
Once
>
|||Thanks Geoff
I did exactly like the KB says.
Terminal Service Component is not installed on either nodes. But when i
check the services then Terminal Server says started but the buttons on the
top (start, pause and stop) are all grayed out.
Again i am not using named instance, it is default .
I cannot find any any sql logs either, nothing is in the data drive (shared
data on cluster)apart from program files\Mssql\Install\SetUp.iss.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%233rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
> Here are some helpful resources
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
> Note that Remote Desktop Connection is not Terminal services for the
> purposes of this article.
> PRB: Virtual SQL Server 2000 Installation Fails on Cluster That Has Eight
> Nodes
> http://support.microsoft.com/default...b;en-us;811054
> This is probably the most common problem I see
> PRB: Installation of a named instance of SQL Server 2000 virtual server on
a[vbcol=seagreen]
> Windows 2003-based cluster fails
> http://support.microsoft.com/default...b;en-us;815431
> Finally, make sure you are launching the installer from a Domain-level
> account that is a local administrator on all nodes. Log in to each of the
> nodes using the launch account, the cluster account, and the SQL service
> account before starting the installation.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
> news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> install
name,[vbcol=seagreen]
Once
>
|||Thanks Kevin
I have Remote Reg Services Started.
"Kevin Wheeler" <kevin.l.wheeler@.lmco.com> wrote in message
news:e%23zorvMyEHA.2260@.TK2MSFTNGP15.phx.gbl...
> Nikhil,
> Is this the error you are getting? "An error occurred while creating
> virtual server resources for clustering. Cluster specific registry entries
> couldn't be written" If so, then make sure the remote registry service is
> running on all nodes. I had this problem this morning and that work for
me.[vbcol=seagreen]
> Kevin
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:#3rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
Eight[vbcol=seagreen]
on[vbcol=seagreen]
> a
the
> name,
> Once
>
|||Install logs are in the Windows folder on each host node.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
news:ObLwyaNyEHA.1300@.TK2MSFTNGP14.phx.gbl...
> Thanks Geoff
> I did exactly like the KB says.
> Terminal Service Component is not installed on either nodes. But when i
> check the services then Terminal Server says started but the buttons on
the
> top (start, pause and stop) are all grayed out.
> Again i am not using named instance, it is default .
> I cannot find any any sql logs either, nothing is in the data drive
(shared[vbcol=seagreen]
> data on cluster)apart from program files\Mssql\Install\SetUp.iss.
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:%233rECXMyEHA.1192@.tk2msftngp13.phx.gbl...
Eight[vbcol=seagreen]
on[vbcol=seagreen]
> a
the
> name,
> Once
>
|||Thanks Geoff and Kevin
I got it working finally. I had to all the remote services automatic, some
were manual, but thanks a lot
"Nikhil Patel" <patelnikhil30@.hotmail.com> wrote in message
news:OaNhUBFyEHA.4040@.TK2MSFTNGP11.phx.gbl...
> Hi All Gurus
> I am trying to install SQL2K on Win2003 Ent.Ed.
> I could successfully configure MSDTC as a resource , then i tried to
install
> Sql Server 2k (Ent Ed), After i provided all the information like ip name,
> n/name all off a sudden , istallation failed saying cannot continue .
> I checked, both the nodes , terminal services is not running.
> Please help I am simulating this clustering as a proof of concept.and Once
> this is done i need to do the same on production, in 15 days.
> Please Please help
> I looked at all the resouces but could not
>

Help me: SQL Server 2005 Enterprise Setup Error

I have my computer clean with windows 2000 server SP4

then I install Visual Studio.NET 2005 Professional (With SQL Server 2005 Express Edition) - Everything is OK!

after that i try to install SQL Server 2005 Enterprise Edition, but I get an error message at the begining as following:

Title: setup.exe - Entry Point Not Found

Content: The procedure entry point _encode_pointer could not be located in the dynamic link library MSVCR80.dll

so, is there anybody can help me to solve this problem? thanks!

You may want to post this in the setup section - they have a lot more information there and might have this question answered already.

Help me: SQL Server 2005 Enterprise Setup Error

I have my computer clean with windows 2000 server SP4

then I install Visual Studio.NET 2005 Professional (With SQL Server 2005 Express Edition) - Everything is OK!

after that i try to install SQL Server 2005 Enterprise Edition, but I get an error message at the begining as following:

Title: setup.exe - Entry Point Not Found

Content: The procedure entry point _encode_pointer could not be located in the dynamic link library MSVCR80.dll

so, is there anybody can help me to solve this problem? thanks!

You may want to post this in the setup section - they have a lot more information there and might have this question answered already.

help me with MSDE 2000A sp3

Hi,
i tried to install MSDE 2000A sp3, but the installation wasn't seccessful.
Can somebody help me and write me what I have to do to install MSDE 2000A sp3 with SQL authentification (and how can I add some user, database and table)?
I'm using Win XP sp2, .NET Framework 1.1 and VS .NET 2003 (but I haven't got SQL Enterprise manager)
Thank'sTry the solution in this post. Hope this helps.

http://forums.asp.net/941156/ShowPost.aspx
|||

Hi,
I tried to install MSDE via the solution in the previous post, but when I run OSQL, there is an error (SQL Server doesn't exist, or acces denied).
So, I haven't solved my problem yet.

|||The second option was to download the eval edition which will allow you to install the MSDE as a second instance and I forgot to tell you OSQL is not a very user friendly tool. If you cannot download most SQL Server books from Osborne press have the eval edition I am assuming you can get them from library check outs. Hope this helps.|||Ok,
can you send me some hyperlink to that files?
Thank's
|||

Here is the link and SQL Server developer edition is $40 less on the web. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx

|||Thank's for help.

Help me install eval, please.

I little experience with sql and no experience with rs. Recently, during a
.net class, the instructor demonstrated rs with the bikeworks db and I was
blown away. I want to give the same demo to the bosses here, so they will
send me to sql and rs classes. Our server is SBS2003 premium with sql
installed, my workstation is XP pro with Visual Studio.net 2003 and sql
desktop, and we also have a server2k we use for terminal services. What
machine should I isntall the rseval on? I seem to get into trouble with all
of them. Please don't send me to our System Administrator, because that's
me.
XP box starts OK, but says the local sql server is not supported. This the
desktop engine installed with studio.net.
2003 box says visual studio isn't installed and it doesn''t seem to like
sharepoint.
2k box says mdac and visual studio are missing.
I'd rather install on my xp box because it will be a while before it goes
into production. I'd just like put on a nice demo.
Thanks, SteveWhat is the version of SQL running on XP? One option would be to run RS on
XP with the RS catalog on the 2003 box. When setup asks where to put the DB
just put in the 2003 box name. Just remember that the user running setup
must have system admin rights on the server with SQL since this user is used
for all DB commands during setup.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Mahon" <stevemahon@.lhpinc.com> wrote in message
news:#xLAX6#nEHA.3628@.TK2MSFTNGP09.phx.gbl...
> I little experience with sql and no experience with rs. Recently, during a
> .net class, the instructor demonstrated rs with the bikeworks db and I was
> blown away. I want to give the same demo to the bosses here, so they will
> send me to sql and rs classes. Our server is SBS2003 premium with sql
> installed, my workstation is XP pro with Visual Studio.net 2003 and sql
> desktop, and we also have a server2k we use for terminal services. What
> machine should I isntall the rseval on? I seem to get into trouble with
all
> of them. Please don't send me to our System Administrator, because that's
> me.
> XP box starts OK, but says the local sql server is not supported. This the
> desktop engine installed with studio.net.
> 2003 box says visual studio isn't installed and it doesn''t seem to like
> sharepoint.
> 2k box says mdac and visual studio are missing.
> I'd rather install on my xp box because it will be a while before it goes
> into production. I'd just like put on a nice demo.
> Thanks, Steve
>|||Please see http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
for a detailed list of the Reporting Services System requirements.
The general requirements are:
1. Some component of Visual Studio must be installed to use Report
Designer. Installing VB .NET satisfies this requirement.
2. Make a distinction between where report data stored and where the
Reporting Services catalog resides. Data can come from
a number of different sources, however the Reporting Services EVAL
version will only work with SQL Server 2000 Developer,
Standard, or Enterprise editions. Note that in all cases you need to
have SQL Server SP3a installed.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Steve Mahon" <stevemahon@.lhpinc.com> wrote in message
news:%23xLAX6%23nEHA.3628@.TK2MSFTNGP09.phx.gbl...
> I little experience with sql and no experience with rs. Recently, during a
> .net class, the instructor demonstrated rs with the bikeworks db and I was
> blown away. I want to give the same demo to the bosses here, so they will
> send me to sql and rs classes. Our server is SBS2003 premium with sql
> installed, my workstation is XP pro with Visual Studio.net 2003 and sql
> desktop, and we also have a server2k we use for terminal services. What
> machine should I isntall the rseval on? I seem to get into trouble with
all
> of them. Please don't send me to our System Administrator, because that's
> me.
> XP box starts OK, but says the local sql server is not supported. This the
> desktop engine installed with studio.net.
> 2003 box says visual studio isn't installed and it doesn''t seem to like
> sharepoint.
> 2k box says mdac and visual studio are missing.
> I'd rather install on my xp box because it will be a while before it goes
> into production. I'd just like put on a nice demo.
> Thanks, Steve
>

Help me get MSDE SP3a installed on Win Server 2003

I've tried every which way I can from the docs and but I can't seem to get MSDE to install correctly. Found out that Win2003 only runs SP3a, downloaded and tried it.
tried these different commands from the prompt:
setup SAPWD="xxxxx" INSTANCENAME="xxxxx" TARGETDIR="xxxx" (from MSDE2000 only)
setup /upgradesp sqlrun INSTANCENAME="xxxxx" DISABLENETWORKPROTOCOLS=1 (after installing MSDE2000 first)
setup INSTANCENAME="xxxxx" SAPWD="xxxxx" (straight from MSDE2000 SP3a)
Services shows that the SQL agent and the MSSQL$xxxx running. MSSQLServerADHelper is not running. The Service Manager isn't showing any services in the tray nor does it have the little green arrow. I can't connect to anything with Enterprise Manager eithe
r.
What do I need to do? Please note, I'm a totally complete noob with SQL admin and set up...
Thanks...
PS: and note that I'm in the correct directory with the installer and the xxxx are the correct instances and pw's
addition: This is Win 2003 Server Standard Edition...