Wednesday, March 28, 2012
Reporting Services setup problem
I've downloaded the SQL Reporting Services eval and am trying to get
it installed but have run into the following problem:
When I get to the step for connecting to the SQL Server instance on
which the ReportServer database will reside I try and connect via SQL
Server account (sa actually). When I supply the sa, password, and
named instance of SQL Server 2000 it gives me the following error
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection." I've seen this when trying to connect through
QA via a Domain User Account but not with a SQL Server login.
Has anybody else had any problems similiar to this with Reporting
Services?
My environment...
Version: Microsoft SQL Server 2000 - 8.00.760
on Windows 2003 Server
Connecting to a named instance via TCP/IP
I can successfully connect to QA using the sa account but can't
complete the Reporting services install.
Thanks> When I get to the step for connecting to the SQL Server instance on
> which the ReportServer database will reside I try and connect via SQL
> Server account (sa actually). When I supply the sa, password, and
> named instance of SQL Server 2000 it gives me the following error
> "Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection." I've seen this when trying to connect through
> QA via a Domain User Account but not with a SQL Server login.
> Has anybody else had any problems similiar to this with Reporting
> Services?
This happen when SQL machine and Reporting service machine aren't on a
single domain or on a couple of trusted domain.
Try to put the same password on local administrator user on both
machine. When the setup is completed succesfully, you can change the
passwords to a different couple again...
HTH
N|||Hi there
If its a domain member server, connect as the domain administrator,
for some reason RS uses your builtin/administrator account to verify
the account BEFORE it uses the details you typed in (why? because if
it doesnt fine the user it will prompt you re its creation if you
choose to do so).
In my case, I was logged in locally to the member as administrator,
then got the trusted connection error. I can connect fine via my SQL
user, but RS simply ignored whatever i typed and didnt attempt to use
this in its first set of checks.
With the domain admin account, my SQL authentication to my
ReportServer repository then worked a treat on install.
Cheers
Ck|||I am having the same problem.
I am trying to install Reporting Services on a Windows 2000 Server Box (Box
A) in domain A.
The SQL Server 2000 - Windows 2000 Server (Box B) that I am trying to attach
to resides in domain B. I am logged into Box as the Domain Admin (A/Admini
strator).
All three options "Service Account", "Domain Account", and "SQL Login Accoun
t" fail. I get the same error as described in previous posts.
"Login failed for user '(null)'. Reason: Not associated with a trusted SQL S
erver connection."
I want to login using "SQL Login Account".
I have tried the suggestions posted here with no luck.
Any help would be appreciated.
-- Justin Bigelow wrote: --
Hi all,
I've downloaded the SQL Reporting Services eval and am trying to get
it installed but have run into the following problem:
When I get to the step for connecting to the SQL Server instance on
which the ReportServer database will reside I try and connect via SQL
Server account (sa actually). When I supply the sa, password, and
named instance of SQL Server 2000 it gives me the following error
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection." I've seen this when trying to connect through
QA via a Domain User Account but not with a SQL Server login.
Has anybody else had any problems similiar to this with Reporting
Services?
My environment...
Version: Microsoft SQL Server 2000 - 8.00.760
on Windows 2003 Server
Connecting to a named instance via TCP/IP
I can successfully connect to QA using the sa account but can't
complete the Reporting services install.
Thanks|||Make sure your SQL install allows SQL logins. On your SQL box, open Query
Analyzer, and attempt to log on with your SQL credentials.
That's the error you usually get when you try to login with a SQL login, but
SQL is configured for Windows Integrated only.
Jeff
"Eric" <removethis eric dot avery at durakon dot com removethis> wrote in
message news:56092B36-FCAA-4D67-915D-7FD4CC8282B8@.microsoft.com...
> I am having the same problem.
> I am trying to install Reporting Services on a Windows 2000 Server Box
(Box A) in domain A.
> The SQL Server 2000 - Windows 2000 Server (Box B) that I am trying to
attach to resides in domain B. I am logged into Box as the Domain Admin
(A/Administrator).
> All three options "Service Account", "Domain Account", and "SQL Login
Account" fail. I get the same error as described in previous posts.
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."
> I want to login using "SQL Login Account".
> I have tried the suggestions posted here with no luck.
> Any help would be appreciated.
> -- Justin Bigelow wrote: --
> Hi all,
> I've downloaded the SQL Reporting Services eval and am trying to get
> it installed but have run into the following problem:
> When I get to the step for connecting to the SQL Server instance on
> which the ReportServer database will reside I try and connect via SQL
> Server account (sa actually). When I supply the sa, password, and
> named instance of SQL Server 2000 it gives me the following error
> "Login failed for user '(null)'. Reason: Not associated with a
trusted
> SQL Server connection." I've seen this when trying to connect through
> QA via a Domain User Account but not with a SQL Server login.
> Has anybody else had any problems similiar to this with Reporting
> Services?
> My environment...
> Version: Microsoft SQL Server 2000 - 8.00.760
> on Windows 2003 Server
> Connecting to a named instance via TCP/IP
> I can successfully connect to QA using the sa account but can't
> complete the Reporting services install.
> Thanks
>|||SQL Server is set-up for Mixed Mode Authentication and I have tested and suc
cessfully connected to it using ODBC/OLEDB connection strings from the box I
am trying to install SQL Server Reporting Services. I am still getting the
error as mentioned earlier
. Additional Information: Domain A has active directory, Domain B has an NT
classic domain. Domain A and Domain B are seperated by a firewall. The fir
ewall has 3 NICs - 1 going to Domain A, 1 to Domain B, and 1 to an Internet
Router. Is there something
that has to be allowed on the firewall?
Thanks!
-- Jeff Dillon wrote: --
Make sure your SQL install allows SQL logins. On your SQL box, open Query
Analyzer, and attempt to log on with your SQL credentials.
That's the error you usually get when you try to login with a SQL login, but
SQL is configured for Windows Integrated only.
Jeff
"Eric" <removethis eric dot avery at durakon dot com removethis> wrote in
message news:56092B36-FCAA-4D67-915D-7FD4CC8282B8@.microsoft.com...
> I am having the same problem.
(Box A) in domain A.
> The SQL Server 2000 - Windows 2000 Server (Box B) that I am trying to
attach to resides in domain B. I am logged into Box as the Domain Admin
(A/Administrator).
> All three options "Service Account", "Domain Account", and "SQL Login
Account" fail. I get the same error as described in previous posts.
> "Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection."
> it installed but have run into the following problem:
> which the ReportServer database will reside I try and connect via SQL
> Server account (sa actually). When I supply the sa, password, and
> named instance of SQL Server 2000 it gives me the following error
> "Login failed for user '(null)'. Reason: Not associated with a
trusted
> SQL Server connection." I've seen this when trying to connect through
> QA via a Domain User Account but not with a SQL Server login.
> Services?
> Version: Microsoft SQL Server 2000 - 8.00.760
> on Windows 2003 Server
> Connecting to a named instance via TCP/IP
> complete the Reporting services install.
>|||See my other thread for my progress
http://communities2.microsoft.com/c...b3-92fb1b49099d
Reporting Services setup problem
I've downloaded the SQL Reporting Services eval and am trying to get
it installed but have run into the following problem:
When I get to the step for connecting to the SQL Server instance on
which the ReportServer database will reside I try and connect via SQL
Server account (sa actually). When I supply the sa, password, and
named instance of SQL Server 2000 it gives me the following error
"Login failed for user '(null)'. Reason: Not associated with a trusted
SQL Server connection." I've seen this when trying to connect through
QA via a Domain User Account but not with a SQL Server login.
Has anybody else had any problems similiar to this with Reporting
Services?
My environment...
Version: Microsoft SQL Server 2000 - 8.00.760
on Windows 2003 Server
Connecting to a named instance via TCP/IP
I can successfully connect to QA using the sa account but can't
complete the Reporting services install.
Thanks> When I get to the step for connecting to the SQL Server instance on
> which the ReportServer database will reside I try and connect via SQL
> Server account (sa actually). When I supply the sa, password, and
> named instance of SQL Server 2000 it gives me the following error
> "Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection." I've seen this when trying to connect through
> QA via a Domain User Account but not with a SQL Server login.
> Has anybody else had any problems similiar to this with Reporting
> Services?
This happen when SQL machine and Reporting service machine aren't on a
single domain or on a couple of trusted domain.
Try to put the same password on local administrator user on both
machine. When the setup is completed succesfully, you can change the
passwords to a different couple again...
HTH
N|||Hi there
If its a domain member server, connect as the domain administrator,
for some reason RS uses your builtin/administrator account to verify
the account BEFORE it uses the details you typed in (why? because if
it doesnt fine the user it will prompt you re its creation if you
choose to do so).
In my case, I was logged in locally to the member as administrator,
then got the trusted connection error. I can connect fine via my SQL
user, but RS simply ignored whatever i typed and didnt attempt to use
this in its first set of checks.
With the domain admin account, my SQL authentication to my
ReportServer repository then worked a treat on install.
Cheers
Ck
Wednesday, March 21, 2012
Reporting Services on SQL Server 2005 Express Edition
I have downloaded the freeware SQL Server 2005 Express Edition for learning SQL Server. Now I want to get familiar with the BIDS and the reporting services. I want to know whether Express Edition supports these tools. If not then what do i need to have to get the same started? I have a pc running on Vista.
Help from anyone will be greatly appreciated as I have been looking at the forums for quite a while and i am totally confused in this respect. What is the most uncomplicated way to solve this problem?
Many Thanks in advance.
Hi
You can download the toolkit for SQl express ed. with advanced services from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en
If you do not have the advanced services installed, download it from here: http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en
Regards,
Janos
Reporting Services not showing in central admin
Am I missing something with this setup?
Make sure the feature is activated by checking whether "Report Server Integration Feature" is activated by going to Site Actions->Site Settings-> Site Collection features.
Note: You may need to be site owner of the Central Admin web site in order to view the "Site Collection features" link.
HTH,
Prash
Monday, March 12, 2012
Reporting Services Install Issues....
I'm new to MS Reporting Services so please forgive the newbie question.
I downloaded the trial version from the microsoft website. When I ran the
installer on my database server (SQL Server 2000, SP3) it gave me 2 warnings
saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
configured correctly (i'm running Windows 2003 server w/ IIS6).
First of all, why would I want to install those two components on a database
server?
Anyways - it allowed me to proceed so I did and then I noticed that it only
gave me the option to install CLIENT tools. SO, my question is: Is there a
"server" component that needs to be installed on the database server? If so,
where do I download it from because I cannot find it anywhere....
very confused.
thanks in advance,
-ZD
yes there is a SQL Server component and also 2 IIS components
You will need to installthe client bits on a box that has VStudio 2003 to develop reports
"Z D" wrote:
> Hello,
> I'm new to MS Reporting Services so please forgive the newbie question.
> I downloaded the trial version from the microsoft website. When I ran the
> installer on my database server (SQL Server 2000, SP3) it gave me 2 warnings
> saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
> configured correctly (i'm running Windows 2003 server w/ IIS6).
> First of all, why would I want to install those two components on a database
> server?
> Anyways - it allowed me to proceed so I did and then I noticed that it only
> gave me the option to install CLIENT tools. SO, my question is: Is there a
> "server" component that needs to be installed on the database server? If so,
> where do I download it from because I cannot find it anywhere....
> very confused.
> thanks in advance,
> -ZD
>
>
|||Hello,
Thanks for the reply. Do you know where I can download the SQL and IIS
components? They do not seem to be part of the file I downloaded from
microsoft: RSEVAL.exe (137,915 KB)
thanks!
-ZD
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:3FEEA68F-C8DE-4AA1-B39A-9BBE3F4B4B1E@.microsoft.com...
> yes there is a SQL Server component and also 2 IIS components
> You will need to installthe client bits on a box that has VStudio 2003 to
develop reports[vbcol=seagreen]
>
> "Z D" wrote:
the[vbcol=seagreen]
warnings[vbcol=seagreen]
database[vbcol=seagreen]
only[vbcol=seagreen]
there a[vbcol=seagreen]
so,[vbcol=seagreen]
|||I dont know anything about the eval...
I downloaded the Developer Edition From MSDN Universal so I could try it out.
In any event, you have to have at least SQL server Developer, STD or Enterprise to install - Personal edition will not work
also, You must patch up to SQL server SP3a before you install
You will need IIS 5X or better and VStudio 2003 for development
If you have a lic. copy of Standard or Enterprise edition of SQL Server you can request a free copy of the SQL Srv Reporting Services CD from MS for the price of shipping and handling.
you may want to read through the FAQs at
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
|||Hi Guys,
OK so everytime I run the installer it says IIS is not configured correctly
so this is why (i'm assuming) its not letting me install the server
components.
BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works just
fine, i have over 10 sites hosted on the box....
Is there any documentation anywhere that explains EXACTLY what's needed in
terms of IIS config?
thanks and sorry for the hassles, this is killing me here...
-ZD
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
> I dont know anything about the eval...
> I downloaded the Developer Edition From MSDN Universal so I could try it
out.
> In any event, you have to have at least SQL server Developer, STD or
Enterprise to install - Personal edition will not work
> also, You must patch up to SQL server SP3a before you install
> You will need IIS 5X or better and VStudio 2003 for development
> If you have a lic. copy of Standard or Enterprise edition of SQL Server
you can request a free copy of the SQL Srv Reporting Services CD from MS for
the price of shipping and handling.
> you may want to read through the FAQs at
> http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
>
>
|||I believe that you have to have the default web site configured and
active. You can later move it with a little work but the installer
expects IIS to have this orginal website setup.
I think this article describes the problem and tells you how to later
move the website which I would guess is what you will want to do.
http://www.sqljunkies.com/HowTo/525B...700C34674.scuk
HTH,
Craig
Z D wrote:
> Hi Guys,
> OK so everytime I run the installer it says IIS is not configured correctly
> so this is why (i'm assuming) its not letting me install the server
> components.
> BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works just
> fine, i have over 10 sites hosted on the box....
> Is there any documentation anywhere that explains EXACTLY what's needed in
> terms of IIS config?
> thanks and sorry for the hassles, this is killing me here...
> -ZD
>
> "AHH" <AHH@.discussions.microsoft.com> wrote in message
> news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
>
> out.
>
> Enterprise to install - Personal edition will not work
>
> you can request a free copy of the SQL Srv Reporting Services CD from MS for
> the price of shipping and handling.
>
>
|||Craig,
Thanks for the link, it was excellent.
Unfortunately I actually deleted my Default Web Site, so, is it sufficient
to just re-create one or was there something 'special' about it?
I've tried to create a new website called "Default Web Site" and made it
accessible from http://localhost and http://serverName and the installer
still doesnt seem to pick that up... am I missing something?
Thanks!
-ZD
"Craig Riter" <criter@.riter.com> wrote in message
news:%23QvA8HWVEHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> I believe that you have to have the default web site configured and
> active. You can later move it with a little work but the installer
> expects IIS to have this orginal website setup.
> I think this article describes the problem and tells you how to later
> move the website which I would guess is what you will want to do.
> http://www.sqljunkies.com/HowTo/525B...700C34674.scuk
> HTH,
> Craig
> Z D wrote:
correctly[vbcol=seagreen]
just[vbcol=seagreen]
in[vbcol=seagreen]
for[vbcol=seagreen]
|||I have the answer for you if your using IIS 6.0, If igure out the solution:
http://www.advernets.com/techshare/article20042707.htm
But if your using IIS 5.0 the only way from what I can see is to re-install IIS 5.0 to regain Default Web Site. Someone might try saving config file for IIS 5.0 and doing the same thing I did with my IIS 6.0 solution.
"Z D" wrote:
> Craig,
> Thanks for the link, it was excellent.
> Unfortunately I actually deleted my Default Web Site, so, is it sufficient
> to just re-create one or was there something 'special' about it?
> I've tried to create a new website called "Default Web Site" and made it
> accessible from http://localhost and http://serverName and the installer
> still doesnt seem to pick that up... am I missing something?
> Thanks!
> -ZD
> "Craig Riter" <criter@.riter.com> wrote in message
> news:%23QvA8HWVEHA.3944@.TK2MSFTNGP12.phx.gbl...
> correctly
> just
> in
> for
>
>
Reporting Services Install Issues....
I'm new to MS Reporting Services so please forgive the newbie question.
I downloaded the trial version from the microsoft website. When I ran the
installer on my database server (SQL Server 2000, SP3) it gave me 2 warnings
saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
configured correctly (i'm running Windows 2003 server w/ IIS6).
First of all, why would I want to install those two components on a database
server?
Anyways - it allowed me to proceed so I did and then I noticed that it only
gave me the option to install CLIENT tools. SO, my question is: Is there a
"server" component that needs to be installed on the database server? If so,
where do I download it from because I cannot find it anywhere....
very confused.
thanks in advance,
-ZDyes there is a SQL Server component and also 2 IIS components
You will need to installthe client bits on a box that has VStudio 2003 to de
velop reports
"Z D" wrote:
> Hello,
> I'm new to MS Reporting Services so please forgive the newbie question.
> I downloaded the trial version from the microsoft website. When I ran the
> installer on my database server (SQL Server 2000, SP3) it gave me 2 warnin
gs
> saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
> configured correctly (i'm running Windows 2003 server w/ IIS6).
> First of all, why would I want to install those two components on a databa
se
> server?
> Anyways - it allowed me to proceed so I did and then I noticed that it onl
y
> gave me the option to install CLIENT tools. SO, my question is: Is there
a
> "server" component that needs to be installed on the database server? If s
o,
> where do I download it from because I cannot find it anywhere....
> very confused.
> thanks in advance,
> -ZD
>
>|||Hello,
Thanks for the reply. Do you know where I can download the SQL and IIS
components? They do not seem to be part of the file I downloaded from
microsoft: RSEVAL.exe (137,915 KB)
thanks!
-ZD
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:3FEEA68F-C8DE-4AA1-B39A-9BBE3F4B4B1E@.microsoft.com...
> yes there is a SQL Server component and also 2 IIS components
> You will need to installthe client bits on a box that has VStudio 2003 to
develop reports[vbcol=seagreen]
>
> "Z D" wrote:
>
the[vbcol=seagreen]
warnings[vbcol=seagreen]
database[vbcol=seagreen]
only[vbcol=seagreen]
there a[vbcol=seagreen]
so,[vbcol=seagreen]|||I dont know anything about the eval...
I downloaded the Developer Edition From MSDN Universal so I could try it out
.
In any event, you have to have at least SQL server Developer, STD or Enterp
rise to install - Personal edition will not work
also, You must patch up to SQL server SP3a before you install
You will need IIS 5X or better and VStudio 2003 for development
If you have a lic. copy of Standard or Enterprise edition of SQL Server you
can request a free copy of the SQL Srv Reporting Services CD from MS for the
price of shipping and handling.
you may want to read through the FAQs at
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp|||Hi Guys,
OK so everytime I run the installer it says IIS is not configured correctly
so this is why (i'm assuming) its not letting me install the server
components.
BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works just
fine, i have over 10 sites hosted on the box....
Is there any documentation anywhere that explains EXACTLY what's needed in
terms of IIS config?
thanks and sorry for the hassles, this is killing me here...
-ZD
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
> I dont know anything about the eval...
> I downloaded the Developer Edition From MSDN Universal so I could try it
out.
> In any event, you have to have at least SQL server Developer, STD or
Enterprise to install - Personal edition will not work
> also, You must patch up to SQL server SP3a before you install
> You will need IIS 5X or better and VStudio 2003 for development
> If you have a lic. copy of Standard or Enterprise edition of SQL Server
you can request a free copy of the SQL Srv Reporting Services CD from MS for
the price of shipping and handling.
> you may want to read through the FAQs at
> http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
>
>|||I believe that you have to have the default web site configured and
active. You can later move it with a little work but the installer
expects IIS to have this orginal website setup.
I think this article describes the problem and tells you how to later
move the website which I would guess is what you will want to do.
http://www.sqljunkies.com/HowTo/525...C700C34674.scuk
HTH,
Craig
Z D wrote:
> Hi Guys,
> OK so everytime I run the installer it says IIS is not configured correctl
y
> so this is why (i'm assuming) its not letting me install the server
> components.
> BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works just
> fine, i have over 10 sites hosted on the box....
> Is there any documentation anywhere that explains EXACTLY what's needed in
> terms of IIS config?
> thanks and sorry for the hassles, this is killing me here...
> -ZD
>
> "AHH" <AHH@.discussions.microsoft.com> wrote in message
> news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
>
> out.
>
> Enterprise to install - Personal edition will not work
>
> you can request a free copy of the SQL Srv Reporting Services CD from MS f
or
> the price of shipping and handling.
>
>
>|||Craig,
Thanks for the link, it was excellent.
Unfortunately I actually deleted my Default Web Site, so, is it sufficient
to just re-create one or was there something 'special' about it?
I've tried to create a new website called "Default Web Site" and made it
accessible from http://localhost and http://serverName and the installer
still doesnt seem to pick that up... am I missing something?
Thanks!
-ZD
"Craig Riter" <criter@.riter.com> wrote in message
news:%23QvA8HWVEHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> I believe that you have to have the default web site configured and
> active. You can later move it with a little work but the installer
> expects IIS to have this orginal website setup.
> I think this article describes the problem and tells you how to later
> move the website which I would guess is what you will want to do.
> http://www.sqljunkies.com/HowTo/525...C700C34674.scuk
> HTH,
> Craig
> Z D wrote:
correctly[vbcol=seagreen]
just[vbcol=seagreen]
in[vbcol=seagreen]
for[vbcol=seagreen]|||I have the answer for you if your using IIS 6.0, If igure out the solution:
http://www.advernets.com/techshare/article20042707.htm
But if your using IIS 5.0 the only way from what I can see is to re-install
IIS 5.0 to regain Default Web Site. Someone might try saving config file for
IIS 5.0 and doing the same thing I did with my IIS 6.0 solution.
"Z D" wrote:
> Craig,
> Thanks for the link, it was excellent.
> Unfortunately I actually deleted my Default Web Site, so, is it sufficient
> to just re-create one or was there something 'special' about it?
> I've tried to create a new website called "Default Web Site" and made it
> accessible from http://localhost and http://serverName and the installer
> still doesnt seem to pick that up... am I missing something?
> Thanks!
> -ZD
> "Craig Riter" <criter@.riter.com> wrote in message
> news:%23QvA8HWVEHA.3944@.TK2MSFTNGP12.phx.gbl...
> correctly
> just
> in
> for
>
>
Reporting Services Install Issues....
I'm new to MS Reporting Services so please forgive the newbie question.
I downloaded the trial version from the microsoft website. When I ran the
installer on my database server (SQL Server 2000, SP3) it gave me 2 warnings
saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
configured correctly (i'm running Windows 2003 server w/ IIS6).
First of all, why would I want to install those two components on a database
server?
Anyways - it allowed me to proceed so I did and then I noticed that it only
gave me the option to install CLIENT tools. SO, my question is: Is there a
"server" component that needs to be installed on the database server? If so,
where do I download it from because I cannot find it anywhere....
very confused.
thanks in advance,
-ZDyes there is a SQL Server component and also 2 IIS components
You will need to installthe client bits on a box that has VStudio 2003 to develop reports
"Z D" wrote:
> Hello,
> I'm new to MS Reporting Services so please forgive the newbie question.
> I downloaded the trial version from the microsoft website. When I ran the
> installer on my database server (SQL Server 2000, SP3) it gave me 2 warnings
> saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
> configured correctly (i'm running Windows 2003 server w/ IIS6).
> First of all, why would I want to install those two components on a database
> server?
> Anyways - it allowed me to proceed so I did and then I noticed that it only
> gave me the option to install CLIENT tools. SO, my question is: Is there a
> "server" component that needs to be installed on the database server? If so,
> where do I download it from because I cannot find it anywhere....
> very confused.
> thanks in advance,
> -ZD
>
>|||Hello,
Thanks for the reply. Do you know where I can download the SQL and IIS
components? They do not seem to be part of the file I downloaded from
microsoft: RSEVAL.exe (137,915 KB)
thanks!
-ZD
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:3FEEA68F-C8DE-4AA1-B39A-9BBE3F4B4B1E@.microsoft.com...
> yes there is a SQL Server component and also 2 IIS components
> You will need to installthe client bits on a box that has VStudio 2003 to
develop reports
>
> "Z D" wrote:
> > Hello,
> >
> > I'm new to MS Reporting Services so please forgive the newbie question.
> >
> > I downloaded the trial version from the microsoft website. When I ran
the
> > installer on my database server (SQL Server 2000, SP3) it gave me 2
warnings
> > saying 1) Visual Studio.NET was not installed, and, 2) IIS was not
> > configured correctly (i'm running Windows 2003 server w/ IIS6).
> >
> > First of all, why would I want to install those two components on a
database
> > server?
> >
> > Anyways - it allowed me to proceed so I did and then I noticed that it
only
> > gave me the option to install CLIENT tools. SO, my question is: Is
there a
> > "server" component that needs to be installed on the database server? If
so,
> > where do I download it from because I cannot find it anywhere....
> >
> > very confused.
> >
> > thanks in advance,
> > -ZD
> >
> >
> >|||I dont know anything about the eval...
I downloaded the Developer Edition From MSDN Universal so I could try it out.
In any event, you have to have at least SQL server Developer, STD or Enterprise to install - Personal edition will not work
also, You must patch up to SQL server SP3a before you install
You will need IIS 5X or better and VStudio 2003 for development
If you have a lic. copy of Standard or Enterprise edition of SQL Server you can request a free copy of the SQL Srv Reporting Services CD from MS for the price of shipping and handling.
you may want to read through the FAQs at
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp|||Hi Guys,
OK so everytime I run the installer it says IIS is not configured correctly
so this is why (i'm assuming) its not letting me install the server
components.
BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works just
fine, i have over 10 sites hosted on the box....
Is there any documentation anywhere that explains EXACTLY what's needed in
terms of IIS config?
thanks and sorry for the hassles, this is killing me here...
-ZD
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
> I dont know anything about the eval...
> I downloaded the Developer Edition From MSDN Universal so I could try it
out.
> In any event, you have to have at least SQL server Developer, STD or
Enterprise to install - Personal edition will not work
> also, You must patch up to SQL server SP3a before you install
> You will need IIS 5X or better and VStudio 2003 for development
> If you have a lic. copy of Standard or Enterprise edition of SQL Server
you can request a free copy of the SQL Srv Reporting Services CD from MS for
the price of shipping and handling.
> you may want to read through the FAQs at
> http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
>
>|||I believe that you have to have the default web site configured and
active. You can later move it with a little work but the installer
expects IIS to have this orginal website setup.
I think this article describes the problem and tells you how to later
move the website which I would guess is what you will want to do.
http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
HTH,
Craig
Z D wrote:
> Hi Guys,
> OK so everytime I run the installer it says IIS is not configured correctly
> so this is why (i'm assuming) its not letting me install the server
> components.
> BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works just
> fine, i have over 10 sites hosted on the box....
> Is there any documentation anywhere that explains EXACTLY what's needed in
> terms of IIS config?
> thanks and sorry for the hassles, this is killing me here...
> -ZD
>
> "AHH" <AHH@.discussions.microsoft.com> wrote in message
> news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
>>I dont know anything about the eval...
>>I downloaded the Developer Edition From MSDN Universal so I could try it
> out.
>>In any event, you have to have at least SQL server Developer, STD or
> Enterprise to install - Personal edition will not work
>>also, You must patch up to SQL server SP3a before you install
>>You will need IIS 5X or better and VStudio 2003 for development
>>If you have a lic. copy of Standard or Enterprise edition of SQL Server
> you can request a free copy of the SQL Srv Reporting Services CD from MS for
> the price of shipping and handling.
>>you may want to read through the FAQs at
>>http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
>>
>
>|||Craig,
Thanks for the link, it was excellent.
Unfortunately I actually deleted my Default Web Site, so, is it sufficient
to just re-create one or was there something 'special' about it?
I've tried to create a new website called "Default Web Site" and made it
accessible from http://localhost and http://serverName and the installer
still doesnt seem to pick that up... am I missing something?
Thanks!
-ZD
"Craig Riter" <criter@.riter.com> wrote in message
news:%23QvA8HWVEHA.3944@.TK2MSFTNGP12.phx.gbl...
> I believe that you have to have the default web site configured and
> active. You can later move it with a little work but the installer
> expects IIS to have this orginal website setup.
> I think this article describes the problem and tells you how to later
> move the website which I would guess is what you will want to do.
> http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> HTH,
> Craig
> Z D wrote:
> > Hi Guys,
> >
> > OK so everytime I run the installer it says IIS is not configured
correctly
> > so this is why (i'm assuming) its not letting me install the server
> > components.
> >
> > BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works
just
> > fine, i have over 10 sites hosted on the box....
> >
> > Is there any documentation anywhere that explains EXACTLY what's needed
in
> > terms of IIS config?
> >
> > thanks and sorry for the hassles, this is killing me here...
> >
> > -ZD
> >
> >
> >
> > "AHH" <AHH@.discussions.microsoft.com> wrote in message
> > news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
> >
> >>I dont know anything about the eval...
> >>
> >>I downloaded the Developer Edition From MSDN Universal so I could try it
> >
> > out.
> >
> >>In any event, you have to have at least SQL server Developer, STD or
> >
> > Enterprise to install - Personal edition will not work
> >
> >>also, You must patch up to SQL server SP3a before you install
> >>
> >>You will need IIS 5X or better and VStudio 2003 for development
> >>
> >>If you have a lic. copy of Standard or Enterprise edition of SQL Server
> >
> > you can request a free copy of the SQL Srv Reporting Services CD from MS
for
> > the price of shipping and handling.
> >
> >>you may want to read through the FAQs at
> >>http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
> >>
> >>
> >>
> >
> >
> >|||I have the answer for you if your using IIS 6.0, If igure out the solution:
http://www.advernets.com/techshare/article20042707.htm
But if your using IIS 5.0 the only way from what I can see is to re-install IIS 5.0 to regain Default Web Site. Someone might try saving config file for IIS 5.0 and doing the same thing I did with my IIS 6.0 solution.
"Z D" wrote:
> Craig,
> Thanks for the link, it was excellent.
> Unfortunately I actually deleted my Default Web Site, so, is it sufficient
> to just re-create one or was there something 'special' about it?
> I've tried to create a new website called "Default Web Site" and made it
> accessible from http://localhost and http://serverName and the installer
> still doesnt seem to pick that up... am I missing something?
> Thanks!
> -ZD
> "Craig Riter" <criter@.riter.com> wrote in message
> news:%23QvA8HWVEHA.3944@.TK2MSFTNGP12.phx.gbl...
> > I believe that you have to have the default web site configured and
> > active. You can later move it with a little work but the installer
> > expects IIS to have this orginal website setup.
> >
> > I think this article describes the problem and tells you how to later
> > move the website which I would guess is what you will want to do.
> > http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> >
> > HTH,
> > Craig
> >
> > Z D wrote:
> > > Hi Guys,
> > >
> > > OK so everytime I run the installer it says IIS is not configured
> correctly
> > > so this is why (i'm assuming) its not letting me install the server
> > > components.
> > >
> > > BUT what's wrong? I'm running IIS6 on Windows Server 2003. IIS works
> just
> > > fine, i have over 10 sites hosted on the box....
> > >
> > > Is there any documentation anywhere that explains EXACTLY what's needed
> in
> > > terms of IIS config?
> > >
> > > thanks and sorry for the hassles, this is killing me here...
> > >
> > > -ZD
> > >
> > >
> > >
> > > "AHH" <AHH@.discussions.microsoft.com> wrote in message
> > > news:A4E3B9D8-5693-4B82-9B00-12B7159B255D@.microsoft.com...
> > >
> > >>I dont know anything about the eval...
> > >>
> > >>I downloaded the Developer Edition From MSDN Universal so I could try it
> > >
> > > out.
> > >
> > >>In any event, you have to have at least SQL server Developer, STD or
> > >
> > > Enterprise to install - Personal edition will not work
> > >
> > >>also, You must patch up to SQL server SP3a before you install
> > >>
> > >>You will need IIS 5X or better and VStudio 2003 for development
> > >>
> > >>If you have a lic. copy of Standard or Enterprise edition of SQL Server
> > >
> > > you can request a free copy of the SQL Srv Reporting Services CD from MS
> for
> > > the price of shipping and handling.
> > >
> > >>you may want to read through the FAQs at
> > >>http://www.microsoft.com/sql/reporting/howtobuy/faq.asp
> > >>
> > >>
> > >>
> > >
> > >
> > >
>
>
Reporting services instalation
I'm not sure if I get it right:
I downloaded RS trial and I'm trying to install it, I'm having trouble
understand requirements. Is it really necessary to have visual studio
installed on (future) RS server? AFAIK, it's only necessary on 'client'
machine running designer, or?
tia
You don't need VS on the RS *server* machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Zarko Jovanovic" <mind_less_NOSPAM_@.bigfoot.com> wrote in message
news:1101121406.631065@.internet.fina.hr...
> hi all
> I'm not sure if I get it right:
> I downloaded RS trial and I'm trying to install it, I'm having trouble
> understand requirements. Is it really necessary to have visual studio
> installed on (future) RS server? AFAIK, it's only necessary on 'client'
> machine running designer, or?
> tia
>
Reporting services instalation
I'm not sure if I get it right:
I downloaded RS trial and I'm trying to install it, I'm having trouble
understand requirements. Is it really necessary to have visual studio
installed on (future) RS server? AFAIK, it's only necessary on 'client'
machine running designer, or?
tiaYou don't need VS on the RS *server* machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Zarko Jovanovic" <mind_less_NOSPAM_@.bigfoot.com> wrote in message
news:1101121406.631065@.internet.fina.hr...
> hi all
> I'm not sure if I get it right:
> I downloaded RS trial and I'm trying to install it, I'm having trouble
> understand requirements. Is it really necessary to have visual studio
> installed on (future) RS server? AFAIK, it's only necessary on 'client'
> machine running designer, or?
> tia
>
Reporting services instalation
I'm not sure if I get it right:
I downloaded RS trial and I'm trying to install it, I'm having trouble
understand requirements. Is it really necessary to have visual studio
installed on (future) RS server? AFAIK, it's only necessary on 'client'
machine running designer, or?
tiaYou don't need VS on the RS *server* machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Zarko Jovanovic" <mind_less_NOSPAM_@.bigfoot.com> wrote in message
news:1101121406.631065@.internet.fina.hr...
> hi all
> I'm not sure if I get it right:
> I downloaded RS trial and I'm trying to install it, I'm having trouble
> understand requirements. Is it really necessary to have visual studio
> installed on (future) RS server? AFAIK, it's only necessary on 'client'
> machine running designer, or?
> tia
>
Reporting Services in SQL Server Express
The SQL Server Express can be downloaded with Advanced Services and thereby Reporting Services are included. I wonder if this is the same Reporting Services as in SQL Server 2005 Standard?
I have heard something that it is a stripped version that is included in the Express download.
Is it so? And if so, what are the differences?That is correct, it is a stripped down version. You might want to check out this document, you can get what is different between the editions.
http://download.microsoft.com/download/E/8/B/E8B42814-6A0C-40EB-911F-E7ADEC87F5D5/UpgrExptoWkgStd.doc
Jarret
|||This is a good description of what you do and do not get with Reporting Services in Express Edition with Advanced Services
http://msdn2.microsoft.com/en-us/library/ms365166.aspx
Specifically, these are the features you do not get:
Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.|||
Is it possible to install SQL Express and RS (for SQL Express) on a windows 2003 server and then host an asp.net application on the same server. I am just wondering if the reporting will work from any machine that is running the asp.net app?
I understand RS (Express) must be installed on the same server and it can only access local data on the server but I assume the url report can be accessed and run from any machine that can connect to the server?
Reporting Services in SQL Server Express
The SQL Server Express can be downloaded with Advanced Services and thereby Reporting Services are included. I wonder if this is the same Reporting Services as in SQL Server 2005 Standard?
I have heard something that it is a stripped version that is included in the Express download.
Is it so? And if so, what are the differences?That is correct, it is a stripped down version. You might want to check out this document, you can get what is different between the editions.
http://download.microsoft.com/download/E/8/B/E8B42814-6A0C-40EB-911F-E7ADEC87F5D5/UpgrExptoWkgStd.doc
Jarret
|||This is a good description of what you do and do not get with Reporting Services in Express Edition with Advanced Services
http://msdn2.microsoft.com/en-us/library/ms365166.aspx
Specifically, these are the features you do not get:
Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.|||
Is it possible to install SQL Express and RS (for SQL Express) on a windows 2003 server and then host an asp.net application on the same server. I am just wondering if the reporting will work from any machine that is running the asp.net app?
I understand RS (Express) must be installed on the same server and it can only access local data on the server but I assume the url report can be accessed and run from any machine that can connect to the server?
Saturday, February 25, 2012
Reporting Services Database not supported by my instance of sql se
I downloaded the trial version of Sql Server Reporting Services from
http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en
But when I try to install the service I get the error message that the
instance of Sql Server that I am running does not support the Reporting
Services Database when I get to the part that asks what account to use. The
default is Service Account, but I also tried Sql Server Account (my instance
of Sql Server is in mixed mode).
I am trying to install the Trial version of Reporting Services for
evaluation on a windows XP computer that contains Sql Server 2000 Standard
Edition (for desktop) Service Pack 4. The Microsoft Management Console Help
About says Service Pack 2. Any suggestions would be appreciated if it is
possible to install the trial Reporting Services on my computer with the
current install of Sql Server, and how this can be accomplished.
Thanks,
RichHi Rich,
I don't believe this will work. Try Windows 2000 Server or Windows 2003
Server, with a server-based SQL Server, not a desktop version.
As far as I know, desktop-SQL Server is not supported. But this is just
as far as I know...
Kind Regards,
Bj=F6rn|||Bjorn is correct, REporting Services is not supported on the develpment
edition of SQL. The best way run it on windows XP for evaluation is to
get a hold of some VM software (VM Ware or MS Virtual Machine) and
install Windows Server and MS SQL Server Evaluation Editions on the
Virtual Machine. Reporting Services will work in this setup.
Cheers,
Guytz72|||Thanks for your reply. You are probably correct. I just needed to confirm
this.
Thanks again,
Rich
"Bjorn" wrote:
> Hi Rich,
> I don't believe this will work. Try Windows 2000 Server or Windows 2003
> Server, with a server-based SQL Server, not a desktop version.
> As far as I know, desktop-SQL Server is not supported. But this is just
> as far as I know...
> Kind Regards,
> Björn
>|||The development edition of RS (which is what the evaluation version is that
you downloaded) will run with the developers edition of SQL Server (and
Developers edition of SQL Server will run on XP - I have run on this
configuration). It will not run with Personal Edition or MSDE. Are you sure
you have the developers edition of SQL Server and not Personal Edition?
You say you have Standard Edition for SQL Server (Desktop). I am not aware
of this designation of product. My guess is that this is Personal Edition
which is not supported.
So, to clarify. You definitely can run in XP but you need to have Developers
edition of SQL Server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:14C92ABB-1F52-4EA3-9257-58531325FCFB@.microsoft.com...
> Hello,
> I downloaded the trial version of Sql Server Reporting Services from
> http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en
> But when I try to install the service I get the error message that the
> instance of Sql Server that I am running does not support the Reporting
> Services Database when I get to the part that asks what account to use.
> The
> default is Service Account, but I also tried Sql Server Account (my
> instance
> of Sql Server is in mixed mode).
> I am trying to install the Trial version of Reporting Services for
> evaluation on a windows XP computer that contains Sql Server 2000 Standard
> Edition (for desktop) Service Pack 4. The Microsoft Management Console
> Help
> About says Service Pack 2. Any suggestions would be appreciated if it is
> possible to install the trial Reporting Services on my computer with the
> current install of Sql Server, and how this can be accomplished.
> Thanks,
> Rich|||Thanks for your reply. I have the personal edition of sql server on my
computer. But it is almost like Enterprise Sql Server. I have Enterprise
manager, Query Analyzer, books on line, even Analsys services. But the disk
did say personal edition when loading onto winxp. But if I load the same
disk onto a server, it is Standard edition. Where can I get the developer's
edition of sql server? can I upgrade my personal edition?
Thanks,
Rich
"Bruce L-C [MVP]" wrote:
> The development edition of RS (which is what the evaluation version is that
> you downloaded) will run with the developers edition of SQL Server (and
> Developers edition of SQL Server will run on XP - I have run on this
> configuration). It will not run with Personal Edition or MSDE. Are you sure
> you have the developers edition of SQL Server and not Personal Edition?
> You say you have Standard Edition for SQL Server (Desktop). I am not aware
> of this designation of product. My guess is that this is Personal Edition
> which is not supported.
> So, to clarify. You definitely can run in XP but you need to have Developers
> edition of SQL Server.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:14C92ABB-1F52-4EA3-9257-58531325FCFB@.microsoft.com...
> > Hello,
> >
> > I downloaded the trial version of Sql Server Reporting Services from
> >
> > http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en
> >
> > But when I try to install the service I get the error message that the
> > instance of Sql Server that I am running does not support the Reporting
> > Services Database when I get to the part that asks what account to use.
> > The
> > default is Service Account, but I also tried Sql Server Account (my
> > instance
> > of Sql Server is in mixed mode).
> >
> > I am trying to install the Trial version of Reporting Services for
> > evaluation on a windows XP computer that contains Sql Server 2000 Standard
> > Edition (for desktop) Service Pack 4. The Microsoft Management Console
> > Help
> > About says Service Pack 2. Any suggestions would be appreciated if it is
> > possible to install the trial Reporting Services on my computer with the
> > current install of Sql Server, and how this can be accomplished.
> >
> > Thanks,
> > Rich
>
>|||Not sure where you get it. I have MSDN subscription so all of my software
comes through that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D2BB40CC-AAD3-4EDF-9F80-8D066B8D8B19@.microsoft.com...
> Thanks for your reply. I have the personal edition of sql server on my
> computer. But it is almost like Enterprise Sql Server. I have Enterprise
> manager, Query Analyzer, books on line, even Analsys services. But the
> disk
> did say personal edition when loading onto winxp. But if I load the same
> disk onto a server, it is Standard edition. Where can I get the
> developer's
> edition of sql server? can I upgrade my personal edition?
> Thanks,
> Rich
> "Bruce L-C [MVP]" wrote:
>> The development edition of RS (which is what the evaluation version is
>> that
>> you downloaded) will run with the developers edition of SQL Server (and
>> Developers edition of SQL Server will run on XP - I have run on this
>> configuration). It will not run with Personal Edition or MSDE. Are you
>> sure
>> you have the developers edition of SQL Server and not Personal Edition?
>> You say you have Standard Edition for SQL Server (Desktop). I am not
>> aware
>> of this designation of product. My guess is that this is Personal Edition
>> which is not supported.
>> So, to clarify. You definitely can run in XP but you need to have
>> Developers
>> edition of SQL Server.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:14C92ABB-1F52-4EA3-9257-58531325FCFB@.microsoft.com...
>> > Hello,
>> >
>> > I downloaded the trial version of Sql Server Reporting Services from
>> >
>> > http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en
>> >
>> > But when I try to install the service I get the error message that the
>> > instance of Sql Server that I am running does not support the Reporting
>> > Services Database when I get to the part that asks what account to use.
>> > The
>> > default is Service Account, but I also tried Sql Server Account (my
>> > instance
>> > of Sql Server is in mixed mode).
>> >
>> > I am trying to install the Trial version of Reporting Services for
>> > evaluation on a windows XP computer that contains Sql Server 2000
>> > Standard
>> > Edition (for desktop) Service Pack 4. The Microsoft Management Console
>> > Help
>> > About says Service Pack 2. Any suggestions would be appreciated if it
>> > is
>> > possible to install the trial Reporting Services on my computer with
>> > the
>> > current install of Sql Server, and how this can be accomplished.
>> >
>> > Thanks,
>> > Rich
>>