Problem with Club Starter Kit

Hi All,

I have a problem with the Club Starter kit that I downloaded from the SQL Server Express Site. I installed the VSI into VS2005 but when I try to save the project, VS puts up a dialog with "Unable to complete Operation." The project runs OK within VS but any changes I make are lost when the app closes because it won't save.

I know this does not appear to be a SQL Server Express problem but I'm wondering if anyone else has used the starter kit and experienced the same problem, and more importantly, how to fix it.

Thanks a lot

This is starter kit have evolved more than others version 3.0 is in beta, the first link take you to version 2.0 and 3.0 beta 1 and the last two links are almost 60 pages tutorial about the kit. Print out both tutorials read it and if you are still having problems ask the experts at the project. If it is SQL Server database for the kit you can post again and I can answer it including T-SQL. Hope this helps.

http://www.codeplex.com/ClubStarterKit

http://msdn2.microsoft.com/en-us/library/aa479335.aspx

http://msdn2.microsoft.com/en-us/library/aa479303.aspx

problem with browsing cube in MSAS 2005

Hi All,

Am working on MSAS 2005 here i installed MSAS 2005 in OS MS 2003 server i did migration from the existing MSAS 2000 Database and Data Sourse to MSAS 2005.Here everything is fine with migration and i can view all the Datasourse,Cubes,Dimensions etc.The problem is when i am doing processing the cube am getting below error please some body help me on this.

OLE DB error: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified; IM002.

AS2005 does not support ODBC datasources. To process your cube you should change datasource to use OLEDB provider.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Problem with authentication prompting whilst fetching a report over the NET

Hi all,
I'm having a problem with accessing a report.
When I test it on my machine (2000 & reporting services installed on same
machine) there's no problem. As soon as I try to access it vie the internet
(I route through no-ip.org) then a window pops up wanting authentication. I
want to do away with this please.
How do I do this so no prompting occurs?
Regards
John.The authentication for a data source can be different for the dev env than
the production env... Go to the data source in the Prod env, and ensure
that something OTHER than prompt for credentials is set for the data
source...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <a@.b.c> wrote in message
news:%23iJ6eE7XFHA.2768@.tk2msftngp13.phx.gbl...
> Hi all,
> I'm having a problem with accessing a report.
> When I test it on my machine (2000 & reporting services installed on same
> machine) there's no problem. As soon as I try to access it vie the
> internet (I route through no-ip.org) then a window pops up wanting
> authentication. I want to do away with this please.
> How do I do this so no prompting occurs?
> Regards
> John.
>

problem with attaching mdf file

Bob wrote:
> Hi,
> i installed sql server 2005 express on a windows xp prof. sp2 system.
> i also installed the 2005 studio management tool.
> I can connect to the sql server (sqlcmd -S), i can create a new database in
> the 2005 studio management tool, but i can't attach a mdf file. I'm
> administrator so have all rights. I have several mdf (and ldf) files on the
> disc.
> I did this:
> rightclick on Databases, then Attach: i see right an empty windows with an
> ADD button.
> When i click on that button, i get the error:
> c:\myapp\app_data\
> cannot access the specified path or file. Verify that you have the necessary
> privileges ...
> If you know that the service account a specific file, type the path ...
> The sevice account is NT AUTHORITY\NetworkService, but when i see the list
> of the accounts, i can't find it into that list.
>
> Any help would be appreciated.
> Thanks
> Bob
>
>
>
>
Create an actual user to be used as the service account, then make sure
that user has read/write permissions in your data directory.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Bob wrote:
> Thanks for replying.
> Can you tell me how to do that? Do you mean: a windows xp account? And how
> to link it to NT AUTHORITY\Network? I can't even find it in the list of the
> windows accounts.
>
Yes, a Windows XP account or a domain account, whichever is appropriate
for your environment. You don't "link" this new user to NT
AUTHORITY\Network, you'll configure the SQL Server services to run as
the new user that you create. NT AUTHORITY\Network isn't a real user
account.
You could also configure the SQL Server services to run as "Local
System", which will give SQL system-level access to your machine.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

problem with attaching mdf file

Bob wrote:
> Hi,
> i installed sql server 2005 express on a windows xp prof. sp2 system.
> i also installed the 2005 studio management tool.
> I can connect to the sql server (sqlcmd -S), i can create a new database in
> the 2005 studio management tool, but i can't attach a mdf file. I'm
> administrator so have all rights. I have several mdf (and ldf) files on the
> disc.
> I did this:
> rightclick on Databases, then Attach: i see right an empty windows with an
> ADD button.
> When i click on that button, i get the error:
> c:\myapp\app_data\
> cannot access the specified path or file. Verify that you have the necessary
> privileges ...
> If you know that the service account a specific file, type the path ...
> The sevice account is NT AUTHORITY\NetworkService, but when i see the list
> of the accounts, i can't find it into that list.
>
> Any help would be appreciated.
> Thanks
> Bob
>
>
>
>
Create an actual user to be used as the service account, then make sure
that user has read/write permissions in your data directory.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Bob wrote:
> Thanks for replying.
> Can you tell me how to do that? Do you mean: a windows xp account? And how
> to link it to NT AUTHORITY\Network? I can't even find it in the list of the
> windows accounts.
>
Yes, a Windows XP account or a domain account, whichever is appropriate
for your environment. You don't "link" this new user to NT
AUTHORITY\Network, you'll configure the SQL Server services to run as
the new user that you create. NT AUTHORITY\Network isn't a real user
account.
You could also configure the SQL Server services to run as "Local
System", which will give SQL system-level access to your machine.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
sql

problem with attaching mdf file

Hi,
i installed sql server 2005 express on a windows xp prof. sp2 system.
i also installed the 2005 studio management tool.
I can connect to the sql server (sqlcmd -S), i can create a new database in
the 2005 studio management tool, but i can't attach a mdf file. I'm
administrator so have all rights. I have several mdf (and ldf) files on the
disc.
I did this:
rightclick on Databases, then Attach: i see right an empty windows with an
ADD button.
When i click on that button, i get the error:
c:\myapp\app_data\
cannot access the specified path or file. Verify that you have the necessary
privileges ...
If you know that the service account a specific file, type the path ...
The sevice account is NT AUTHORITY\NetworkService, but when i see the list
of the accounts, i can't find it into that list.
Any help would be appreciated.
Thanks
BobBob wrote:
> Hi,
> i installed sql server 2005 express on a windows xp prof. sp2 system.
> i also installed the 2005 studio management tool.
> I can connect to the sql server (sqlcmd -S), i can create a new database in
> the 2005 studio management tool, but i can't attach a mdf file. I'm
> administrator so have all rights. I have several mdf (and ldf) files on the
> disc.
> I did this:
> rightclick on Databases, then Attach: i see right an empty windows with an
> ADD button.
> When i click on that button, i get the error:
> c:\myapp\app_data\
> cannot access the specified path or file. Verify that you have the necessary
> privileges ...
> If you know that the service account a specific file, type the path ...
> The sevice account is NT AUTHORITY\NetworkService, but when i see the list
> of the accounts, i can't find it into that list.
>
> Any help would be appreciated.
> Thanks
> Bob
>
>
>
>
Create an actual user to be used as the service account, then make sure
that user has read/write permissions in your data directory.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks for replying.
Can you tell me how to do that? Do you mean: a windows xp account? And how
to link it to NT AUTHORITY\Network? I can't even find it in the list of the
windows accounts.
"Tracy McKibben" <tracy@.realsqlguy.com> schreef in bericht
news:459BF31D.9050605@.realsqlguy.com...
> Bob wrote:
>> Hi,
>> i installed sql server 2005 express on a windows xp prof. sp2 system.
>> i also installed the 2005 studio management tool.
>> I can connect to the sql server (sqlcmd -S), i can create a new database
>> in the 2005 studio management tool, but i can't attach a mdf file. I'm
>> administrator so have all rights. I have several mdf (and ldf) files on
>> the disc.
>> I did this:
>> rightclick on Databases, then Attach: i see right an empty windows with
>> an ADD button.
>> When i click on that button, i get the error:
>> c:\myapp\app_data\
>> cannot access the specified path or file. Verify that you have the
>> necessary privileges ...
>> If you know that the service account a specific file, type the path ...
>> The sevice account is NT AUTHORITY\NetworkService, but when i see the
>> list of the accounts, i can't find it into that list.
>>
>> Any help would be appreciated.
>> Thanks
>> Bob
>>
>>
>>
> Create an actual user to be used as the service account, then make sure
> that user has read/write permissions in your data directory.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks for replying.
I copied mydb.mdf and .ldf to the directory where i created a new database,
but in Management Studio, it's the same: i don't see it in the list of the
databases and can't attach it.
"Hari Prasad" <HariPrasad@.discussions.microsoft.com> schreef in bericht
news:7601E1FD-2A85-496E-A92F-06189BC57855@.microsoft.com...
> Easy way is copy the required MDF and LDF files to the default data
> directory
> (The place where you create the new database)
> using the windows explorer and then try attaching the database. This will
> defenetely work out.
> The issue is you have full access to machine but once you login to SQL
> Server you will have access rights only belong to
> account "NT AUTHORITY\NetworkService". The account may not have access to
> folder c:\myapp\app_data\.
> My best suggestion is copy the file to the folder where the new database
> is
> created and attach it.
> Thanks
> Hari
> "Bob" wrote:
>> Hi,
>> i installed sql server 2005 express on a windows xp prof. sp2 system.
>> i also installed the 2005 studio management tool.
>> I can connect to the sql server (sqlcmd -S), i can create a new database
>> in
>> the 2005 studio management tool, but i can't attach a mdf file. I'm
>> administrator so have all rights. I have several mdf (and ldf) files on
>> the
>> disc.
>> I did this:
>> rightclick on Databases, then Attach: i see right an empty windows with
>> an
>> ADD button.
>> When i click on that button, i get the error:
>> c:\myapp\app_data\
>> cannot access the specified path or file. Verify that you have the
>> necessary
>> privileges ...
>> If you know that the service account a specific file, type the path ...
>> The sevice account is NT AUTHORITY\NetworkService, but when i see the
>> list
>> of the accounts, i can't find it into that list.
>>
>> Any help would be appreciated.
>> Thanks
>> Bob
>>
>>
>>
>>|||Bob wrote:
> Thanks for replying.
> Can you tell me how to do that? Do you mean: a windows xp account? And how
> to link it to NT AUTHORITY\Network? I can't even find it in the list of the
> windows accounts.
>
Yes, a Windows XP account or a domain account, whichever is appropriate
for your environment. You don't "link" this new user to NT
AUTHORITY\Network, you'll configure the SQL Server services to run as
the new user that you create. NT AUTHORITY\Network isn't a real user
account.
You could also configure the SQL Server services to run as "Local
System", which will give SQL system-level access to your machine.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks it works now
"Tracy McKibben" <tracy@.realsqlguy.com> schreef in bericht
news:459C069B.5080403@.realsqlguy.com...
> Bob wrote:
>> Thanks for replying.
>> Can you tell me how to do that? Do you mean: a windows xp account? And
>> how to link it to NT AUTHORITY\Network? I can't even find it in the list
>> of the windows accounts.
> Yes, a Windows XP account or a domain account, whichever is appropriate
> for your environment. You don't "link" this new user to NT
> AUTHORITY\Network, you'll configure the SQL Server services to run as the
> new user that you create. NT AUTHORITY\Network isn't a real user account.
> You could also configure the SQL Server services to run as "Local System",
> which will give SQL system-level access to your machine.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

problem with attaching mdf file

Hi,
i installed sql server 2005 express on a Windows XP prof. sp2 system.
i also installed the 2005 studio management tool.
I can connect to the sql server (sqlcmd -S), i can create a new database in
the 2005 studio management tool, but i can't attach a mdf file. I'm
administrator so have all rights. I have several mdf (and ldf) files on the
disc.
I did this:
rightclick on Databases, then Attach: i see right an empty windows with an
ADD button.
When i click on that button, i get the error:
c:\myapp\app_data\
cannot access the specified path or file. Verify that you have the necessary
privileges ...
If you know that the service account a specific file, type the path ...
The sevice account is NT AUTHORITY\NetworkService, but when i see the list
of the accounts, i can't find it into that list.
Any help would be appreciated.
Thanks
BobBob wrote:
> Hi,
> i installed sql server 2005 express on a Windows XP prof. sp2 system.
> i also installed the 2005 studio management tool.
> I can connect to the sql server (sqlcmd -S), i can create a new database i
n
> the 2005 studio management tool, but i can't attach a mdf file. I'm
> administrator so have all rights. I have several mdf (and ldf) files on th
e
> disc.
> I did this:
> rightclick on Databases, then Attach: i see right an empty windows with an
> ADD button.
> When i click on that button, i get the error:
> c:\myapp\app_data\
> cannot access the specified path or file. Verify that you have the necessa
ry
> privileges ...
> If you know that the service account a specific file, type the path ...
> The sevice account is NT AUTHORITY\NetworkService, but when i see the list
> of the accounts, i can't find it into that list.
>
> Any help would be appreciated.
> Thanks
> Bob
>
>
>
>
Create an actual user to be used as the service account, then make sure
that user has read/write permissions in your data directory.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Easy way is copy the required MDF and LDF files to the default data director
y
(The place where you create the new database)
using the windows explorer and then try attaching the database. This will
defenetely work out.
The issue is you have full access to machine but once you login to SQL
Server you will have access rights only belong to
account "NT AUTHORITY\NetworkService". The account may not have access to
folder c:\myapp\app_data\.
My best suggestion is copy the file to the folder where the new database is
created and attach it.
Thanks
Hari
"Bob" wrote:

> Hi,
> i installed sql server 2005 express on a Windows XP prof. sp2 system.
> i also installed the 2005 studio management tool.
> I can connect to the sql server (sqlcmd -S), i can create a new database i
n
> the 2005 studio management tool, but i can't attach a mdf file. I'm
> administrator so have all rights. I have several mdf (and ldf) files on th
e
> disc.
> I did this:
> rightclick on Databases, then Attach: i see right an empty windows with an
> ADD button.
> When i click on that button, i get the error:
> c:\myapp\app_data\
> cannot access the specified path or file. Verify that you have the necessa
ry
> privileges ...
> If you know that the service account a specific file, type the path ...
> The sevice account is NT AUTHORITY\NetworkService, but when i see the list
> of the accounts, i can't find it into that list.
>
> Any help would be appreciated.
> Thanks
> Bob
>
>
>
>|||Thanks for replying.
Can you tell me how to do that? Do you mean: a Windows XP account? And how
to link it to NT AUTHORITY\Network? I can't even find it in the list of the
windows accounts.
"Tracy McKibben" <tracy@.realsqlguy.com> schreef in bericht
news:459BF31D.9050605@.realsqlguy.com...
> Bob wrote:
> Create an actual user to be used as the service account, then make sure
> that user has read/write permissions in your data directory.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks for replying.
I copied mydb.mdf and .ldf to the directory where i created a new database,
but in Management Studio, it's the same: i don't see it in the list of the
databases and can't attach it.
"Hari Prasad" <HariPrasad@.discussions.microsoft.com> schreef in bericht
news:7601E1FD-2A85-496E-A92F-06189BC57855@.microsoft.com...[vbcol=seagreen]
> Easy way is copy the required MDF and LDF files to the default data
> directory
> (The place where you create the new database)
> using the windows explorer and then try attaching the database. This will
> defenetely work out.
> The issue is you have full access to machine but once you login to SQL
> Server you will have access rights only belong to
> account "NT AUTHORITY\NetworkService". The account may not have access to
> folder c:\myapp\app_data\.
> My best suggestion is copy the file to the folder where the new database
> is
> created and attach it.
> Thanks
> Hari
> "Bob" wrote:
>|||Bob wrote:
> Thanks for replying.
> Can you tell me how to do that? Do you mean: a Windows XP account? And how
> to link it to NT AUTHORITY\Network? I can't even find it in the list of th
e
> windows accounts.
>
Yes, a Windows XP account or a domain account, whichever is appropriate
for your environment. You don't "link" this new user to NT
AUTHORITY\Network, you'll configure the SQL Server services to run as
the new user that you create. NT AUTHORITY\Network isn't a real user
account.
You could also configure the SQL Server services to run as "Local
System", which will give SQL system-level access to your machine.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks it works now
"Tracy McKibben" <tracy@.realsqlguy.com> schreef in bericht
news:459C069B.5080403@.realsqlguy.com...
> Bob wrote:
> Yes, a Windows XP account or a domain account, whichever is appropriate
> for your environment. You don't "link" this new user to NT
> AUTHORITY\Network, you'll configure the SQL Server services to run as the
> new user that you create. NT AUTHORITY\Network isn't a real user account.
> You could also configure the SQL Server services to run as "Local System",
> which will give SQL system-level access to your machine.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Problem with asp page and ODBC on Windows 2003 SR 64 Bits

I have an Application developed on ASP, I got a few new servers 64bits, I installed microsoft WIN 2003 SR.
When I get in into the web site I receive this errors:

Microsoft OLE DB Provider for ODBC Driverserror '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/ConnectToDatabase.asp, line 17

I made some obvios checks, I checked that the ODBC really exists and we move the IIS 6.0 to run in 32bits mode as I found in some page.

Thanks you.

Ahmed

Hi,

could you please post your connection string right in here ? We can′t see if you use a DSN or a DSNless connection.

HTH, Jens Suessmeyer.

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

You are likely using an ODBC driver that is not available for 64bits. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=20574&SiteID=1 for the relevnat discusion.

Can you connect to the odbc driver in question using ODBC driver manager. Start->Run->ODBCAD32.exe. Using odbc driver manager create a new dsn and test the connection.

Problem with asp page and ODBC on Windows 2003 SR 64 Bits

I have an Application developed on ASP, I got a few new servers 64bits, I installed microsoft WIN 2003 SR.
When I get in into the web site I receive this errors:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/ConnectToDatabase.asp, line 17

I made some obvios checks, I checked that the ODBC really exists and we move the IIS 6.0 to run in 32bits mode as I found in some page.

Thanks you.

Ahmed

Hi,

could you please post your connection string right in here ? We can′t see if you use a DSN or a DSNless connection.

HTH, Jens Suessmeyer.

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

You are likely using an ODBC driver that is not available for 64bits. See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=20574&SiteID=1 for the relevnat discusion.

Can you connect to the odbc driver in question using ODBC driver manager. Start->Run->ODBCAD32.exe. Using odbc driver manager create a new dsn and test the connection.

problem with analysis server connection string

i have just installed a new version of analysis services 2000 on a test machine. when i try to connect to the local host i get the error "Datasource name is too long". I have set the datasource string to

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\MsOLAPRepository$\msmdrep.mdb

This is the same string as i have on other analysis servers, bar the server name, but it still does not work. any ideas?

The olap service is running correctly, just in case its a detail you need to know.

I assume you use Analysis Manager or DSO program to connect, and you change the "Repository Connection String" property from Analysis Manager. Can you check whether you can open msmdrep.mdb repository file from Access ? Or try to migrate repository to SQL Server - will you get the same error ?

Problem with Analysis Server

I just installed 2005 and have an Enterprise Editition instance on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

Rod, can you enable shared memory and try again? This should solve the problem.

Thanks,
Sam Lester (MSFT)

|||How do you "enable" shared memory?sql

Problem with Analysis Server

I just installed 2005 and have an Enterprise Editition instance on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

Rod, can you enable shared memory and try again? This should solve the problem.

Thanks,
Sam Lester (MSFT)

|||How do you "enable" shared memory?

Problem with Analysis Server

I just installed 2005 and have an Enterprise Editition instance on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

Rod, can you enable shared memory and try again? This should solve the problem.

Thanks,
Sam Lester (MSFT)

|||How do you "enable" shared memory?

Problem while exporting OLAP data to Excel

Hello all,

I have Analysis Services installed on one machine (dedicated server) .
Other machnines have OLAP application installed (Pivot Table is used).

When client machine tries to export olap data to excel , it takes a long time to load and sometimes it hangs.
Is it related to analysis server settings?

Regards,
Deepti

Deepti, can your provide some more information?

What version of Excel are you using? What version of Analysis Services? Are you trying to export an Office Web Component Pivot connected to Olap data to Excel? If so, what version is the Office Web Component Pivot?

problem while configuring RS using rsconfih utility.

i installed reporting services on the same machine where i insatalled SQl
server. i did some sample reports in visual studio.net 2003. initally when i
try to deploy it,iam getting 'cannot connect to http://localhost/report
server.' one more insteresting thing is when i browse to
http://localhost/reports or reportserver is an stating that ' connot find to
directory /not having permissions.' then i gave some permission set to both
these virtual directory.
and later i try to browse i got a different error --'The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
command its giving an error that 'No Reporting Services instance found on
localhost.'. What to do Next i don't have any choice,can any one susject me
some thing.
----
--
pammiDid your installation succeed? This seems to look like you didn't actually
have a successful installation.
In your SQL Server, do you have a database named reportserver and another
called reportservertempdb?
In your filesystem, do you have files under c:\program files\sql
server\mssql\reporting services?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>i installed reporting services on the same machine where i insatalled SQl
> server. i did some sample reports in visual studio.net 2003. initally when
> i
> try to deploy it,iam getting 'cannot connect to http://localhost/report
> server.' one more insteresting thing is when i browse to
> http://localhost/reports or reportserver is an stating that ' connot find
> to
> directory /not having permissions.' then i gave some permission set to
> both
> these virtual directory.
> and later i try to browse i got a different error --'The report server
> cannot open a connection to the report server database. A connection to
> the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> command its giving an error that 'No Reporting Services instance found on
> localhost.'. What to do Next i don't have any choice,can any one susject
> me
> some thing.
> ----
> --
> pammi|||Lukasz, while installation i don't have problems but when i check it now i
don't have those two databases(reportserver and reportservertempdb) and i
have files under c:\program files\sql
> server\mssql\reporting services. Now what to do i have to reinstall it again. And one more thing i forgot to say is my reporting services is an Evaluation Edition which i down loaded from microsoft site.
"Lukasz Pawlowski [MSFT]" wrote:
> Did your installation succeed? This seems to look like you didn't actually
> have a successful installation.
> In your SQL Server, do you have a database named reportserver and another
> called reportservertempdb?
> In your filesystem, do you have files under c:\program files\sql
> server\mssql\reporting services?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >i installed reporting services on the same machine where i insatalled SQl
> > server. i did some sample reports in visual studio.net 2003. initally when
> > i
> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> > server.' one more insteresting thing is when i browse to
> > http://localhost/reports or reportserver is an stating that ' connot find
> > to
> > directory /not having permissions.' then i gave some permission set to
> > both
> > these virtual directory.
> > and later i try to browse i got a different error --'The report server
> > cannot open a connection to the report server database. A connection to
> > the
> > database is required for all requests and processing.
> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> > command its giving an error that 'No Reporting Services instance found on
> > localhost.'. What to do Next i don't have any choice,can any one susject
> > me
> > some thing.
> >
> > ----
> >
> > --
> > pammi
>
>|||If you do not have the databases, then the report server will not work.
You will need to reinstall reporting services. Ensure that after setup, the
reportserver service is running in the service control manager. Also ensure
you can access the report server on the virtual directory you specified
during setup,e.g. http://localhost/reportserver (default).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> Lukasz, while installation i don't have problems but when i check it now i
> don't have those two databases(reportserver and reportservertempdb) and i
> have files under c:\program files\sql
>> server\mssql\reporting services. Now what to do i have to reinstall it
>> again. And one more thing i forgot to say is my reporting services is an
>> Evaluation Edition which i down loaded from microsoft site.
>
> "Lukasz Pawlowski [MSFT]" wrote:
>> Did your installation succeed? This seems to look like you didn't
>> actually
>> have a successful installation.
>> In your SQL Server, do you have a database named reportserver and another
>> called reportservertempdb?
>> In your filesystem, do you have files under c:\program files\sql
>> server\mssql\reporting services?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
>> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>> >i installed reporting services on the same machine where i insatalled
>> >SQl
>> > server. i did some sample reports in visual studio.net 2003. initally
>> > when
>> > i
>> > try to deploy it,iam getting 'cannot connect to http://localhost/report
>> > server.' one more insteresting thing is when i browse to
>> > http://localhost/reports or reportserver is an stating that ' connot
>> > find
>> > to
>> > directory /not having permissions.' then i gave some permission set to
>> > both
>> > these virtual directory.
>> > and later i try to browse i got a different error --'The report server
>> > cannot open a connection to the report server database. A connection to
>> > the
>> > database is required for all requests and processing.
>> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
>> > user
>> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
>> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
>> > command its giving an error that 'No Reporting Services instance found
>> > on
>> > localhost.'. What to do Next i don't have any choice,can any one
>> > susject
>> > me
>> > some thing.
>> >
>> > ----
>> >
>> > --
>> > pammi
>>|||Thanks Lukasz,
i reistalled it and now its working...
pavan
"Lukasz Pawlowski [MSFT]" wrote:
> If you do not have the databases, then the report server will not work.
> You will need to reinstall reporting services. Ensure that after setup, the
> reportserver service is running in the service control manager. Also ensure
> you can access the report server on the virtual directory you specified
> during setup,e.g. http://localhost/reportserver (default).
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> > Lukasz, while installation i don't have problems but when i check it now i
> > don't have those two databases(reportserver and reportservertempdb) and i
> > have files under c:\program files\sql
> >> server\mssql\reporting services. Now what to do i have to reinstall it
> >> again. And one more thing i forgot to say is my reporting services is an
> >> Evaluation Edition which i down loaded from microsoft site.
> >
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> >> Did your installation succeed? This seems to look like you didn't
> >> actually
> >> have a successful installation.
> >>
> >> In your SQL Server, do you have a database named reportserver and another
> >> called reportservertempdb?
> >>
> >> In your filesystem, do you have files under c:\program files\sql
> >> server\mssql\reporting services?
> >>
> >> -Lukasz
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> >> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >> >i installed reporting services on the same machine where i insatalled
> >> >SQl
> >> > server. i did some sample reports in visual studio.net 2003. initally
> >> > when
> >> > i
> >> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> >> > server.' one more insteresting thing is when i browse to
> >> > http://localhost/reports or reportserver is an stating that ' connot
> >> > find
> >> > to
> >> > directory /not having permissions.' then i gave some permission set to
> >> > both
> >> > these virtual directory.
> >> > and later i try to browse i got a different error --'The report server
> >> > cannot open a connection to the report server database. A connection to
> >> > the
> >> > database is required for all requests and processing.
> >> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
> >> > user
> >> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> >> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> >> > command its giving an error that 'No Reporting Services instance found
> >> > on
> >> > localhost.'. What to do Next i don't have any choice,can any one
> >> > susject
> >> > me
> >> > some thing.
> >> >
> >> > ----
> >> >
> >> > --
> >> > pammi
> >>
> >>
> >>
>
>

problem when using reporting service

Dear all,
i have installed reporting service a few days ago, but i encounter the
following problems,
my report server is in another machine(rather than localhost, like
most examples on the web), after teh installation, i have made rdl,
and deploy to the server, everything goes fine until i type
http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
directories, but dead link shown once i click on teh report.
strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
can see the report generated on teh screen. could anyone suggest ways
to solve it?
another problem is i tried to use render() to generate report in my
web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
error keep sending to me ( The request failed with HTTP status 401:
Access Denied.
), i have added a web reference already, it wont work even i type
http://xxx.xxx.xxx.xxx/retest2/.... in the full path
thank you for helping in advancecontrol your .config files on your server (specially under the reportmanager
folder)
in the .config file, you have the URL of the ReportServer http virtual
folder.
Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
"jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
a4075300.0409172006.526eb426@.posting.google.com...
> Dear all,
> i have installed reporting service a few days ago, but i encounter the
> following problems,
> my report server is in another machine(rather than localhost, like
> most examples on the web), after teh installation, i have made rdl,
> and deploy to the server, everything goes fine until i type
> http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> directories, but dead link shown once i click on teh report.
> strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> can see the report generated on teh screen. could anyone suggest ways
> to solve it?
> another problem is i tried to use render() to generate report in my
> web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> error keep sending to me ( The request failed with HTTP status 401:
> Access Denied.
> ), i have added a web reference already, it wont work even i type
> http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> thank you for helping in advance|||For the second problem set your WS proxy to DefaultCredentials.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23dmIqeanEHA.1800@.TK2MSFTNGP15.phx.gbl...
> control your .config files on your server (specially under the
reportmanager
> folder)
> in the .config file, you have the URL of the ReportServer http virtual
> folder.
> Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
>
> "jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
> a4075300.0409172006.526eb426@.posting.google.com...
> > Dear all,
> >
> > i have installed reporting service a few days ago, but i encounter the
> > following problems,
> >
> > my report server is in another machine(rather than localhost, like
> > most examples on the web), after teh installation, i have made rdl,
> > and deploy to the server, everything goes fine until i type
> > http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> > directories, but dead link shown once i click on teh report.
> >
> > strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> > can see the report generated on teh screen. could anyone suggest ways
> > to solve it?
> >
> > another problem is i tried to use render() to generate report in my
> > web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> > error keep sending to me ( The request failed with HTTP status 401:
> > Access Denied.
> > ), i have added a web reference already, it wont work even i type
> > http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> >
> > thank you for helping in advance
>|||thank you so much for the advice, i will try that later on.
if you have time ,would you see the wuestion i post entitled " 3(should be
2) different conputers problem)?
thanks so much
"Jéjé" wrote:
> control your .config files on your server (specially under the reportmanager
> folder)
> in the .config file, you have the URL of the ReportServer http virtual
> folder.
> Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
>
> "jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
> a4075300.0409172006.526eb426@.posting.google.com...
> > Dear all,
> >
> > i have installed reporting service a few days ago, but i encounter the
> > following problems,
> >
> > my report server is in another machine(rather than localhost, like
> > most examples on the web), after teh installation, i have made rdl,
> > and deploy to the server, everything goes fine until i type
> > http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> > directories, but dead link shown once i click on teh report.
> >
> > strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> > can see the report generated on teh screen. could anyone suggest ways
> > to solve it?
> >
> > another problem is i tried to use render() to generate report in my
> > web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> > error keep sending to me ( The request failed with HTTP status 401:
> > Access Denied.
> > ), i have added a web reference already, it wont work even i type
> > http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> >
> > thank you for helping in advance
>
>|||Thanks Teo,
i think i have done so by follow:
Dim rs As New reportservice.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
' Render the report as an HTML4.0 fragment using the Web service
Dim results As [Byte]()
results =rs.Render("http://xxx.xxx.xxx.xxx/ReportServer/retest2/testreport",
"HTML4.0", Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing, Nothing)
so...i think i have to check he computer setting before i move on...
please have a look to the topic (3 different computers problem)
thanks in advance.
"Teo Lachev" wrote:
> For the second problem set your WS proxy to DefaultCredentials.
> --
> Hope this helps.
> ----
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ----
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:%23dmIqeanEHA.1800@.TK2MSFTNGP15.phx.gbl...
> > control your .config files on your server (specially under the
> reportmanager
> > folder)
> > in the .config file, you have the URL of the ReportServer http virtual
> > folder.
> > Make sure this parameter = http://xxx.xxx.xxx.xxx/ReportServer/
> >
> >
> > "jasonymk" <jasonymk@.sinaman.com> a écrit dans le message de news:
> > a4075300.0409172006.526eb426@.posting.google.com...
> > > Dear all,
> > >
> > > i have installed reporting service a few days ago, but i encounter the
> > > following problems,
> > >
> > > my report server is in another machine(rather than localhost, like
> > > most examples on the web), after teh installation, i have made rdl,
> > > and deploy to the server, everything goes fine until i type
> > > http://xxx.xxx.xxx.xxx/Reports to access the report. i can browse the
> > > directories, but dead link shown once i click on teh report.
> > >
> > > strange thing is when i type http://xxx.xxx.xxx.xxx/ReportServer/, i
> > > can see the report generated on teh screen. could anyone suggest ways
> > > to solve it?
> > >
> > > another problem is i tried to use render() to generate report in my
> > > web site (that is localhost) using the server (xxx.xxx.xxx.xxx), but
> > > error keep sending to me ( The request failed with HTTP status 401:
> > > Access Denied.
> > > ), i have added a web reference already, it wont work even i type
> > > http://xxx.xxx.xxx.xxx/retest2/.... in the full path
> > >
> > > thank you for helping in advance
> >
> >
>
>

Problem when connect to SQL Server 2005 (SQL Native Client + Named instance)

Hi,
I have an application which previous connect to SQL Server 2000.
Now, I installed SQL Server 2005, and try to conncet to it.
The previous connection string is:
sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword);
In order to support SQL Native Client driver in SQL Server 2005, I
changed the connection string to:
sString.Format("Provider=SQLNCLI;
DataTypeCompatibility=80;DSN=%s;uid=%s;pwd=%s", sDb, sUser,
sPassword);
I have a default instance and a named instance in my database. So i
created two DSN:
(1) Use SQL Native Client as the driver and connect to the default
instance.
The application could work well under this configuration.
(2) Use SQL Native Client as the driver and connect to the named
instance.
The application could not work successfully under this
configuration.
It could not connect to the database.
I have started the SQL Server Browser service.
Why I could not connect to the database when i use SQL Native Client +
Named instance
Who can help me?
Thanks in advance.
Did you enable the Allow Remote Connections option? Have you run the
Surface Area Configurator and the SQL Server Configuration Manager?
Andrew J. Kelly SQL MVP
<yangrudy@.126.com> wrote in message
news:1140155887.725187.43270@.g44g2000cwa.googlegro ups.com...
> Hi,
> I have an application which previous connect to SQL Server 2000.
> Now, I installed SQL Server 2005, and try to conncet to it.
> The previous connection string is:
> sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword);
> In order to support SQL Native Client driver in SQL Server 2005, I
> changed the connection string to:
> sString.Format("Provider=SQLNCLI;
> DataTypeCompatibility=80;DSN=%s;uid=%s;pwd=%s", sDb, sUser,
> sPassword);
> I have a default instance and a named instance in my database. So i
> created two DSN:
> (1) Use SQL Native Client as the driver and connect to the default
> instance.
> The application could work well under this configuration.
> (2) Use SQL Native Client as the driver and connect to the named
> instance.
> The application could not work successfully under this
> configuration.
> It could not connect to the database.
> I have started the SQL Server Browser service.
> Why I could not connect to the database when i use SQL Native Client +
> Named instance
> Who can help me?
> Thanks in advance.
>

Problem when connect to SQL Server 2005 (SQL Native Client + Named instance)

Hi,
I have an application which previous connect to SQL Server 2000.
Now, I installed SQL Server 2005, and try to conncet to it.
The previous connection string is:
sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword);
In order to support SQL Native Client driver in SQL Server 2005, I
changed the connection string to:
sString.Format("Provider=SQLNCLI;
DataTypeCompatibility=80;DSN=%s;uid=%s;p
wd=%s", sDb, sUser,
sPassword);
I have a default instance and a named instance in my database. So i
created two DSN:
(1) Use SQL Native Client as the driver and connect to the default
instance.
The application could work well under this configuration.
(2) Use SQL Native Client as the driver and connect to the named
instance.
The application could not work successfully under this
configuration.
It could not connect to the database.
I have started the SQL Server Browser service.
Why I could not connect to the database when i use SQL Native Client +
Named instance
Who can help me?
Thanks in advance.Did you enable the Allow Remote Connections option? Have you run the
Surface Area Configurator and the SQL Server Configuration Manager?
Andrew J. Kelly SQL MVP
<yangrudy@.126.com> wrote in message
news:1140155887.725187.43270@.g44g2000cwa.googlegroups.com...
> Hi,
> I have an application which previous connect to SQL Server 2000.
> Now, I installed SQL Server 2005, and try to conncet to it.
> The previous connection string is:
> sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword);
> In order to support SQL Native Client driver in SQL Server 2005, I
> changed the connection string to:
> sString.Format("Provider=SQLNCLI;
> DataTypeCompatibility=80;DSN=%s;uid=%s;p
wd=%s", sDb, sUser,
> sPassword);
> I have a default instance and a named instance in my database. So i
> created two DSN:
> (1) Use SQL Native Client as the driver and connect to the default
> instance.
> The application could work well under this configuration.
> (2) Use SQL Native Client as the driver and connect to the named
> instance.
> The application could not work successfully under this
> configuration.
> It could not connect to the database.
> I have started the SQL Server Browser service.
> Why I could not connect to the database when i use SQL Native Client +
> Named instance
> Who can help me?
> Thanks in advance.
>

Problem Viewing reports in Report Manager

I have successfully installed the sql server reporting services on a windows
2003 server. I have been able to deploy several reports to the report
server. I have even been able to schedule a report to execute and send out
via email every morning of the week.
Here's the problem. When I try to view a report using the report manager I
get a
The page cannot be found
HTTP 404 - File not found
Internet Explorer
error. I just don't get it. I can perform every other function using the
report manager except view the report online. Which of course is a problem
because I want to send my customers to the site to be able to view and run
reports.
Thanks for any help.
--
Jon Clayton
Regions Financial CorporationSounds like a security issue or a malformed URL. It's very difficult (from
here) to determine how you access report manager differently than the online
version, but could you post a URL that worked, and a URL that failed?
Dwayne|||Thanks for your help.
Here is a link that works
http://Servername/Reports/Pages/Folder.aspx
This link of course brings up the default folders page
Click on a folder and go to the following url, which work
http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
Click on a report in that folder to view the report using the following url
fail
http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
The failure only occurs within the frame below. The header frame is still
displayed, therefore I am able to:
Click on the properties tab with the failed page displayed is successful
using the following ur
http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
I have given full access permissions to the ASPNET account on the local
machine to the two RS folders.
I am convinced that it is a permissions issue. As a matter of fact I had an
instance installed in my test invironment which is Windows 2000 which worked
fine. But ever since the latest security updates that machine is having the
same issue.
Thanks again for your help.
--
Jon Clayton
Regions Financial Corporation
"Dwayne J. Baldwin" wrote:
> Sounds like a security issue or a malformed URL. It's very difficult (from
> here) to determine how you access report manager differently than the online
> version, but could you post a URL that worked, and a URL that failed?
> Dwayne
>
>|||"Jon" wrote:
> Thanks for your help.
> Here is a link that works
> http://Servername/Reports/Pages/Folder.aspx
> This link of course brings up the default folders page
> Click on a folder and go to the following url, which works
> http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> Click on a report in that folder to view the report using the following url
> fails
> http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> The failure only occurs within the frame below. The header frame is still
> displayed, therefore I am able to:
> Click on the properties tab with the failed page displayed is successful
> using the following url
> http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> I have given full access permissions to the ASPNET account on the local
> machine to the two RS folders.
> I am convinced that it is a permissions issue. As a matter of fact I had an
> instance installed in my test invironment which is Windows 2000 which worked
> fine. But ever since the latest security updates that machine is having the
> same issue.
> Thanks again for your help.
> --
> Jon Clayton
> Regions Financial Corporation
>
> "Dwayne J. Baldwin" wrote:
> > Sounds like a security issue or a malformed URL. It's very difficult (from
> > here) to determine how you access report manager differently than the online
> > version, but could you post a URL that worked, and a URL that failed?
> >
> > Dwayne
> >
> >
> >
> > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.|||It appears that the entries in the config files are correct. Thanks for the
tip.
--
Jon Clayton
Regions Financial Corporation
"DLM" wrote:
>
> "Jon" wrote:
> > Thanks for your help.
> >
> > Here is a link that works
> > http://Servername/Reports/Pages/Folder.aspx
> > This link of course brings up the default folders page
> >
> > Click on a folder and go to the following url, which works
> > http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> >
> > Click on a report in that folder to view the report using the following url
> > fails
> > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> > The failure only occurs within the frame below. The header frame is still
> > displayed, therefore I am able to:
> >
> > Click on the properties tab with the failed page displayed is successful
> > using the following url
> > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> >
> > I have given full access permissions to the ASPNET account on the local
> > machine to the two RS folders.
> >
> > I am convinced that it is a permissions issue. As a matter of fact I had an
> > instance installed in my test invironment which is Windows 2000 which worked
> > fine. But ever since the latest security updates that machine is having the
> > same issue.
> >
> > Thanks again for your help.
> >
> > --
> > Jon Clayton
> > Regions Financial Corporation
> >
> >
> > "Dwayne J. Baldwin" wrote:
> >
> > > Sounds like a security issue or a malformed URL. It's very difficult (from
> > > here) to determine how you access report manager differently than the online
> > > version, but could you post a URL that worked, and a URL that failed?
> > >
> > > Dwayne
> > >
> > >
> > >
> > > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.|||Hi Jon,
I have exactly the same problem. Please advise what I need to check/do?
Thanks very much
Khat.
"Jon" wrote:
> It appears that the entries in the config files are correct. Thanks for the
> tip.
> --
> Jon Clayton
> Regions Financial Corporation
>
> "DLM" wrote:
> >
> >
> > "Jon" wrote:
> >
> > > Thanks for your help.
> > >
> > > Here is a link that works
> > > http://Servername/Reports/Pages/Folder.aspx
> > > This link of course brings up the default folders page
> > >
> > > Click on a folder and go to the following url, which works
> > > http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> > >
> > > Click on a report in that folder to view the report using the following url
> > > fails
> > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> > > The failure only occurs within the frame below. The header frame is still
> > > displayed, therefore I am able to:
> > >
> > > Click on the properties tab with the failed page displayed is successful
> > > using the following url
> > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> > >
> > > I have given full access permissions to the ASPNET account on the local
> > > machine to the two RS folders.
> > >
> > > I am convinced that it is a permissions issue. As a matter of fact I had an
> > > instance installed in my test invironment which is Windows 2000 which worked
> > > fine. But ever since the latest security updates that machine is having the
> > > same issue.
> > >
> > > Thanks again for your help.
> > >
> > > --
> > > Jon Clayton
> > > Regions Financial Corporation
> > >
> > >
> > > "Dwayne J. Baldwin" wrote:
> > >
> > > > Sounds like a security issue or a malformed URL. It's very difficult (from
> > > > here) to determine how you access report manager differently than the online
> > > > version, but could you post a URL that worked, and a URL that failed?
> > > >
> > > > Dwayne
> > > >
> > > >
> > > >
> > > > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.|||I am also having this same exact problem. I can run everything without issue
on our test server but production server is exhibiting this exact behavior?
I can do everything but view the report. I can even run the report on the
production server through code and through http://server/reportserver.
Navigate to the folder/report and viola. I can enter parameters and run it.
But not in the report manager gui' I get a 404 when I press the view
report button. If I press it a second time I then get an error in the lower
left hand corner of IE. If I open it up it states that on Line 50 permission
denied and url = http://server/reportserver...blah...blah...blah
Kevin
"Khat Liko" wrote:
> Hi Jon,
> I have exactly the same problem. Please advise what I need to check/do?
> Thanks very much
> Khat.
> "Jon" wrote:
> > It appears that the entries in the config files are correct. Thanks for the
> > tip.
> > --
> > Jon Clayton
> > Regions Financial Corporation
> >
> >
> > "DLM" wrote:
> >
> > >
> > >
> > > "Jon" wrote:
> > >
> > > > Thanks for your help.
> > > >
> > > > Here is a link that works
> > > > http://Servername/Reports/Pages/Folder.aspx
> > > > This link of course brings up the default folders page
> > > >
> > > > Click on a folder and go to the following url, which works
> > > > http://servername/Reports/Pages/Folder.aspx?ItemPath=%2fTeamWorkLoad&ViewMode=List
> > > >
> > > > Click on a report in that folder to view the report using the following url
> > > > fails
> > > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport
> > > > The failure only occurs within the frame below. The header frame is still
> > > > displayed, therefore I am able to:
> > > >
> > > > Click on the properties tab with the failed page displayed is successful
> > > > using the following url
> > > > http://servername/Reports/Pages/Report.aspx?ItemPath=%2fTeamWorkLoad%2fProblemReport&SelectedTabId=PropertiesTab
> > > >
> > > > I have given full access permissions to the ASPNET account on the local
> > > > machine to the two RS folders.
> > > >
> > > > I am convinced that it is a permissions issue. As a matter of fact I had an
> > > > instance installed in my test invironment which is Windows 2000 which worked
> > > > fine. But ever since the latest security updates that machine is having the
> > > > same issue.
> > > >
> > > > Thanks again for your help.
> > > >
> > > > --
> > > > Jon Clayton
> > > > Regions Financial Corporation
> > > >
> > > >
> > > > "Dwayne J. Baldwin" wrote:
> > > >
> > > > > Sounds like a security issue or a malformed URL. It's very difficult (from
> > > > > here) to determine how you access report manager differently than the online
> > > > > version, but could you post a URL that worked, and a URL that failed?
> > > > >
> > > > > Dwayne
> > > > >
> > > > >
> > > > >
> > > > > I had the same problem. The RSWebApplication.config file in the ReportServer bin folder has a URL setting which should be the same as your server.

Problem using Windows Authentication

Hello,
I have just installed Reporting Services and was able to figure out
pretty much everything, with the exception of using Windows
Authentication.
As I am an administrator on the machine on which Reporting Services is
running, I am able to successfully log in. However, no other accounts
are able to gain access even though these accounts are in the same
domain as the machine. Other people are simply prompted for a
username/password, and are denied access.
At first I thought that this was an issue with the way the
application's users were configured. I added a few accounts to tha
application via the Reporting Service's web interface and assigned
some roles. However, the same problem persists.
When I enable anonymous access to the application via IIS, everyone is
able to log in, so I know that the application is at least
accessible. Unfortunatly, anonymous access is not a viable option.
I readily admit that I am a novice, and I would not be surprised to
find that I have overlooked a simple configuration issue somewhere.
Please help!
Thanks,
tcbThey should not be getting prompted. First, does the machine running RS
using a fixed IP address?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"baker2g" <tcbakes@.gmail.com> wrote in message
news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
> Hello,
> I have just installed Reporting Services and was able to figure out
> pretty much everything, with the exception of using Windows
> Authentication.
> As I am an administrator on the machine on which Reporting Services is
> running, I am able to successfully log in. However, no other accounts
> are able to gain access even though these accounts are in the same
> domain as the machine. Other people are simply prompted for a
> username/password, and are denied access.
> At first I thought that this was an issue with the way the
> application's users were configured. I added a few accounts to tha
> application via the Reporting Service's web interface and assigned
> some roles. However, the same problem persists.
> When I enable anonymous access to the application via IIS, everyone is
> able to log in, so I know that the application is at least
> accessible. Unfortunatly, anonymous access is not a viable option.
> I readily admit that I am a novice, and I would not be surprised to
> find that I have overlooked a simple configuration issue somewhere.
> Please help!
> Thanks,
> tcb
>|||On Aug 13, 1:57 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> They should not be getting prompted. First, does the machine running RS
> using a fixed IP address?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "baker2g" <tcba...@.gmail.com> wrote in message
> news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
>
> > Hello,
> > I have just installed Reporting Services and was able to figure out
> > pretty much everything, with the exception of using Windows
> > Authentication.
> > As I am an administrator on the machine on which Reporting Services is
> > running, I am able to successfully log in. However, no other accounts
> > are able to gain access even though these accounts are in the same
> > domain as the machine. Other people are simply prompted for a
> > username/password, and are denied access.
> > At first I thought that this was an issue with the way the
> > application's users were configured. I added a few accounts to tha
> > application via the Reporting Service's web interface and assigned
> > some roles. However, the same problem persists.
> > When I enable anonymous access to the application via IIS, everyone is
> > able to log in, so I know that the application is at least
> > accessible. Unfortunatly, anonymous access is not a viable option.
> > I readily admit that I am a novice, and I would not be surprised to
> > find that I have overlooked a simple configuration issue somewhere.
> > Please help!
> > Thanks,
> > tcb- Hide quoted text -
> - Show quoted text -
Thanks for the response!
I don't think that the machine is using a fixed IP addresss. I have
deployed RS on my local box and have had people test it by using my IP
address (http://<ipaddress>/Reports). Although the IP address is not
static, it does not change frequently and should be fine while I am
playing aroung with RS. People were able to access the app when
anonymous access was turned on, so I know that people can access the
RS app when authentication is removed from the equation.
Thanks,
tcb|||I had a weird issue with a server of mine where it would prompt for username
and password when it should not have. The issue went away once I gave it a
fixed IP address. As far as anonymous working, well when anonymous it
doesn't care who you are so it is not doing the same actions.
If you can give it a fixed IP address and at least see if your being
prompted goes away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"baker2g" <tcbakes@.gmail.com> wrote in message
news:1187040249.518255.134720@.j4g2000prf.googlegroups.com...
> On Aug 13, 1:57 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> They should not be getting prompted. First, does the machine running RS
>> using a fixed IP address?
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "baker2g" <tcba...@.gmail.com> wrote in message
>> news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
>>
>> > Hello,
>> > I have just installed Reporting Services and was able to figure out
>> > pretty much everything, with the exception of using Windows
>> > Authentication.
>> > As I am an administrator on the machine on which Reporting Services is
>> > running, I am able to successfully log in. However, no other accounts
>> > are able to gain access even though these accounts are in the same
>> > domain as the machine. Other people are simply prompted for a
>> > username/password, and are denied access.
>> > At first I thought that this was an issue with the way the
>> > application's users were configured. I added a few accounts to tha
>> > application via the Reporting Service's web interface and assigned
>> > some roles. However, the same problem persists.
>> > When I enable anonymous access to the application via IIS, everyone is
>> > able to log in, so I know that the application is at least
>> > accessible. Unfortunatly, anonymous access is not a viable option.
>> > I readily admit that I am a novice, and I would not be surprised to
>> > find that I have overlooked a simple configuration issue somewhere.
>> > Please help!
>> > Thanks,
>> > tcb- Hide quoted text -
>> - Show quoted text -
> Thanks for the response!
> I don't think that the machine is using a fixed IP addresss. I have
> deployed RS on my local box and have had people test it by using my IP
> address (http://<ipaddress>/Reports). Although the IP address is not
> static, it does not change frequently and should be fine while I am
> playing aroung with RS. People were able to access the app when
> anonymous access was turned on, so I know that people can access the
> RS app when authentication is removed from the equation.
> Thanks,
> tcb
>