Difficulty Installing SQL Reporting Services on SBS 2003 Premium

I am trying to run reporting services on a SBS 2003 Premium server and have
been runninng into a lot of issues.
I have installed the SQL Reporting Services Components on the server and the
Visual Studio .Net components on my workstation. The goal behind installing
the components in the specified locations include: report authoring on my
workstation and finished reports available to all via the server.
The issues I have encountered include:
1) SQL Reporting Services activation error due to a conflict with
Sharepoint. I have removed Sharepoint from the server as outlined in KB
829114. After completion of the Sharepoint removal, I reinstalled SQL
Reporting Services and Reporting Services SP2 and was again informed that
activation was not possible due to a conflict with Sharepoint. How do I
work around this problem?
2) When accessing SQL Reporting Services from Visual Studio .Net on my
workstation, I can open an existing project but I can't view content within
the data sources tab. When trying to do so I get an error that states: "A
connection cannot be made to the database. Set and test the connection
string. Can't generate the SSPI context. How do I resolve this problem?
3) When creating a new SQL Reporting Services project using the Report
Wizard, the Shared Data Source field is blank and unavailable. Likewise,
attempts to access shared data sources using the Server Explorer window
result in the system prompting for a login when I try to select a listed in
the tree under my server. I am unable to login using our available network
or SQL User IDs.
My server is running SBS 2003 SP1 which includes SQL 2000 SP4. My
workstation is a member of the domain for which the server is the PDC.
Is my topology realistic and can my problems resolved or should I relocate
all components to the server? Even if located on the server, I will still
encounter the activation problem and need a work around.
Thanks for your help!Hello RS,
A few weeks ago I wanted to order SQL Server Reporting Services on a CD vom
Microsoft Direct. At that occasion, they told me that Reporting Services
simply are not supported on SBS. Seems like MS wants you to by the full SQL
Server product if you want to use RS. But please re-check that with your
contacts.
Greetings,
Stefan Falk|||Hi Stefan,
Sehr interesant. I initially posted my issue in the SBS forum and was
instructed by Microsoft to post in the reporting services forum. No mention
was made of non-compatability and I have noticed from the SBS forum that
other SBS users are running reporting services. You should be able to get a
copy of the software from one of the US Microsoft resellers.
Take care,
RS
"Stefan Falk" wrote:
> Hello RS,
> A few weeks ago I wanted to order SQL Server Reporting Services on a CD vom
> Microsoft Direct. At that occasion, they told me that Reporting Services
> simply are not supported on SBS. Seems like MS wants you to by the full SQL
> Server product if you want to use RS. But please re-check that with your
> contacts.
> Greetings,
> Stefan Falk
>
>

Differences between SQL Server Versions

Hello,

I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a server
machine. It works almost fine, except the application which uses the SQL
Server. The main part of the application runs (since the last update) fine,
but other tools of that application (database import and the database
manager for check and rebuild) doesn't. They hang up or kill the database.

Our software developer says that these problems are in correlation with the
server os. But there won't be any problem if we install Win 2000 Server and
add an additional SQL Server 2000.

Finally my question is: Are there any differences between the SQL Server
2000 Versions, which are sold (a) as a single product, (b) as part of the
Win 2003 SBS Premium package and (c) as part of other Server versions?

Thanks in Advance,

MartinHi

I believe the component products that are packaged in SBS and their singular
produces are effectively the same. Comparing windows 2000 and windows 2003
is not a like for like comparison, and you don't say is if it is the same
hardware. It is also not clear where these applications are located and how
they access the database. Security in Windows 2003 is significantly tighter
and therefore you may be assuming something that had a lax default in
Windows 2000 is still the case, the may explain some of the application
failures. For the other problems check out your SQL Server configuration is
the same as your previous one, also look at the SQL Server logs and the
Event logs for any messages being logged when the problems occur. Profiler
may also help as well as running the applications in debug mode.

John

"Martin Meyer im Hagen" <an@.mmih.de> wrote in message
news:cddrb5$395$00$1@.news.t-online.com...
> Hello,
> I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a
server
> machine. It works almost fine, except the application which uses the SQL
> Server. The main part of the application runs (since the last update)
fine,
> but other tools of that application (database import and the database
> manager for check and rebuild) doesn't. They hang up or kill the database.
> Our software developer says that these problems are in correlation with
the
> server os. But there won't be any problem if we install Win 2000 Server
and
> add an additional SQL Server 2000.
> Finally my question is: Are there any differences between the SQL Server
> 2000 Versions, which are sold (a) as a single product, (b) as part of the
> Win 2003 SBS Premium package and (c) as part of other Server versions?
> Thanks in Advance,
> Martin|||Martin Meyer im Hagen (an@.mmih.de) writes:
> I've got installed Win 2003 SBS Premium with the SQL Server 2000 on a
> server machine. It works almost fine, except the application which uses
> the SQL Server. The main part of the application runs (since the last
> update) fine, but other tools of that application (database import and
> the database manager for check and rebuild) doesn't. They hang up or
> kill the database.
> Our software developer says that these problems are in correlation with
> the server os. But there won't be any problem if we install Win 2000
> Server and add an additional SQL Server 2000.
> Finally my question is: Are there any differences between the SQL Server
> 2000 Versions, which are sold (a) as a single product, (b) as part of the
> Win 2003 SBS Premium package and (c) as part of other Server versions?

There are a couple of different editions of SQL Server: Enterprise,
Standard, Personal, Developer and MSDE (Desktop Engine). There are indeed
differences between these editions. I doubt however that these differences
can account for the problems you are seeing. Even less would I believe
in that the operating system matters.

I am more inclined to blame that on poor applicataion design. Then again,
you description does not offer much detail, so I could be wrong.

I don't know what editiion might have, but my guess would be Standard.
You can find out, with this SELECT statement:

select serverproperty('Edition')

You can run this from Query Analyzer or the command-line tool OSQL.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <esquel@.sommarskog.se> schrieb im Newsbeitrag
news:Xns952ABCA7C23A7Yazorman@.127.0.0.1...
> Martin Meyer im Hagen (an@.mmih.de) writes:
> There are a couple of different editions of SQL Server: Enterprise,
> Standard, Personal, Developer and MSDE (Desktop Engine). There are indeed
> differences between these editions. I doubt however that these differences
> can account for the problems you are seeing. Even less would I believe
> in that the operating system matters.

I think that it's the Standard edition that we use, but I can't check it
now. Definively it's not the MSDE version

Something about our Server's Hardware: AMD Athlon 2600+, Chaintech 7NJS UZ
(nForce2), 1024 MB RAM, 2*160 GB RAID1 (mirror) on Adaptec 1200A, Win 2003
SBS (without Exchange, Active Directory, Frontpage, Firewall etc.). Our
trader recommends to install a Win 2000 Server or Win 2000 SBS (with the
included SQL Server) or with a separate version of the SQL Server. The
server isn't connected to the internet and in this moment not running an
antivirus solution (CA eTrust is already avaible but not installed yet).

Before we had switched to the server we had used the MSDE on a local machine
(for only one user). Now we want to use the application on 2 workstations
via LAN with an extra database server (higher performance and the
possibility to import more article datas).

My problem is that the trader of our most important 'office' program says
that our version of the MS SQL Server isn't officially supported. In the
newest version it's possible to use the main functions of the database, but
an important import function doesn't work. Further the reindex (a third
programm of that package) destroys the database!

A friend told me that there might be a newer database version used in our
SQL Server and that the application makes some bad requests which doesn't
make any effect (instand of the log file, which growed up from 30 MB to 2
GB) or kill the database.

have a nice day,
Martin

--
127.0.0.1 is the best place on earth.|||Martin Meyer im Hagen (an@.mmih.de) writes:
> Something about our Server's Hardware: AMD Athlon 2600+, Chaintech 7NJS UZ
> (nForce2), 1024 MB RAM, 2*160 GB RAID1 (mirror) on Adaptec 1200A, Win 2003
> SBS (without Exchange, Active Directory, Frontpage, Firewall etc.). Our
> trader recommends to install a Win 2000 Server or Win 2000 SBS (with the
> included SQL Server) or with a separate version of the SQL Server. The
> server isn't connected to the internet and in this moment not running an
> antivirus solution (CA eTrust is already avaible but not installed yet).

Excuse a language question, but when you say "trader", do you mean a
representative of the company from which you have bought the application
you are having problem with?

> My problem is that the trader of our most important 'office' program says
> that our version of the MS SQL Server isn't officially supported.

So which version of MS SQL Server does he claim to support?

The current service pack of SQL Server 2000 is SP3, and it has been out
for one year and a half, and if he does not support that it's a cry and
shame.

It could be that he is not supporting Windows 2003, but that, too, would
be quite some egg on his face.

> In the newest version it's possible to use the main functions of the
> database, but an important import function doesn't work. Further the
> reindex (a third programm of that package) destroys the database!

Sounds serious, but without further information it's a little difficult
to comment. Normally, when you talk about reindexing and SQL Server,
this is a command within SQL Server, and it should not destroy your
database.

> A friend told me that there might be a newer database version used in our
> SQL Server and that the application makes some bad requests which doesn't
> make any effect (instand of the log file, which growed up from 30 MB to 2
> GB) or kill the database.

It could be an issue of recovery modes. The default is ro run with
full recovery, and if you want up-to-the-minute recovery in case of
a crash, or a fatal incorrect update, you need full recovery. In that
case, you also need to back up the transaction log regularly. But if
you are content with restoring the latest backup, you can run with
simple recovery. Then you don't have to bother about the transaction log.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"Erland Sommarskog" <esquel@.sommarskog.se> schrieb im Newsbeitrag
news:Xns952B5CF5ECBAYazorman@.127.0.0.1...
> Excuse a language question, but when you say "trader", do you mean a
> representative of the company from which you have bought the application
> you are having problem with?

Yes, that is the person.

> > My problem is that the trader of our most important 'office' program
says
> > that our version of the MS SQL Server isn't officially supported.
> So which version of MS SQL Server does he claim to support?
> The current service pack of SQL Server 2000 is SP3, and it has been out
> for one year and a half, and if he does not support that it's a cry and
> shame.

SP3 is installed.

> It could be that he is not supporting Windows 2003, but that, too, would
> be quite some egg on his face.
> > In the newest version it's possible to use the main functions of the
> > database, but an important import function doesn't work. Further the
> > reindex (a third programm of that package) destroys the database!
> Sounds serious, but without further information it's a little difficult
> to comment. Normally, when you talk about reindexing and SQL Server,
> this is a command within SQL Server, and it should not destroy your
> database.

I've read in the manual: that function reindexes the database, checks it for
errors and other bad stuff. If you choose Auto-Repair it destroys the
database, if you doesn't do anything.

> It could be an issue of recovery modes. The default is ro run with
> full recovery, and if you want up-to-the-minute recovery in case of
> a crash, or a fatal incorrect update, you need full recovery. In that
> case, you also need to back up the transaction log regularly. But if
> you are content with restoring the latest backup, you can run with
> simple recovery. Then you don't have to bother about the transaction log.

Since we've got the server installed I'm very familiar with backup and
recovery. There shouldn't been any problems because of the limitation of the
MSDE we had used before? I've 'copied' the database via backup and recovery.

have a nice day,
Martin

--
127.0.0.1 is the best place on earth.|||Martin Meyer im Hagen (an@.mmih.de) writes:
> "Erland Sommarskog" <esquel@.sommarskog.se> schrieb im Newsbeitrag
> news:Xns952B5CF5ECBAYazorman@.127.0.0.1...
>> Sounds serious, but without further information it's a little difficult
>> to comment. Normally, when you talk about reindexing and SQL Server,
>> this is a command within SQL Server, and it should not destroy your
>> database.
> I've read in the manual: that function reindexes the database, checks it
> for errors and other bad stuff. If you choose Auto-Repair it destroys
> the database, if you doesn't do anything.

Does it actually say in the manual that it destroys the database?

Anyway, it sounds very much to me that the application runs DBCC DBREINDEX
and DBCC CHECKDB. CHECKDB does indeed have a couple of auto-repair options.
Howeve it should not destroy the database. However, one the of the repair
options is REPAIR_ALLOW_DATA_LOSS, which means that if the internal
structure in the database is damaged, DBCC tries to repair those errors,
even if this leads to data being lost.

Your description is very vague. You have talked about "kill", "hang up"
or "destroy" the database. That tells me very little. I would need to
have more exact description of what happens. Does SQL Server become
unresponsive when you run the reindexing and auto-repair? Or does the
database remain inaccessible even after these jobs have completed? Do
you get any error messages along the way?

It goes without saying that if the application is using DBCC that SP3
should not be a problem.

> Since we've got the server installed I'm very familiar with backup and
> recovery. There shouldn't been any problems because of the limitation of
> the MSDE we had used before? I've 'copied' the database via backup and
> recovery.

Let's see in MSDE, the default recovery model is simple I believe.
And since you used MSDE before, the database can not be that big? The
reason I am interested in the size, is of course the bigger the database
the longer will CHECKDB and REINDEX take.

You can check the current recovery model with sp_helpdb.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp