Error Rendering trough Web Service to WebArchivo format

Hi,
We are using the Reporting Services Web Service, in order to expose some
reports in our Web Application, right now I am trying to enable exporting the
report to the available formats in Reporting Services, and altough everything
seems to be working fine, when I try to render as Web Archive, I get the
following exception:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> The parameter is incorrect.
first I tough it was because of the device info configuration I was using,
since it was the same of the html format (which had things like turning off
the toolbar), thus I instead didnt pass any deviceinfo(null), in both cases
it works fine in all formats but it doesnt in Web Archive.
I have been searching for info about the error, but I havent found any ...
if anyone knows what is happening, I will be thankfull :) ... in the mean
time, I will keep trying, and if I find anything I will post it here.I have continued digging on the problem, I havent found anything on the
internet, and I have cleared out some things about the problem ...
so, here are some aditional info about the problem:
- it isnt only happening when I try to render the report trough the Web
Service, it also happens when I use url access.
- it is happening specifically in this report, there are other reports that
works well
- I am not using any totals/subtotals formulas (I say this, since I have
read this might cause trouble in certain rendering extensions)
- I just found something else (I have 3 reports):
- the report that is working doesnt receive any parameter
- the 2 reports that doesnt work receive 1 parameter, and additionaly have
a list of valid values ...
it looks like it were a bug, something along the lines that rendering
extension either ignores the parameters, or gets confused where there is a
list of valid values ...
Any help will be greatly appreciated ... in the mean time, I will be playing
with the reports definition, in order to find what is exactly happening, if I
dont find a solution soon I will restrict that rendering extension from being
used :(:(:( ...|||I am done with this, I am pretty certain is a bug, just not the type of bug I
tough ...
it is really weird, I played with the parameter options in the report and
the error kept happening, then I decided playing with the report design ...
well, whenever I put a third column in my report, the error happens when I
try to export it to web archive ... I put all types of definition in the
third column, to see if I managed to see anything making it fail, but didnt
arrive to anything, I tried from the simplest one (static text + no
formatting) all trough a "complex" one (formatting + dinamic text ...)

Error rendering report as HTML

I am rendering a report as HTML4.0 via Web Services interface and the report
appears...but only the first page. I notice a small yellow error icon on the
bottom of the page and if I double-click it reads:
Line: 20
Error: 'Report' is undefined
Code: 0
If I view the page source, around line 20 is the following:
function OnLoadReport()
{
var pageHits = null;
var rep = new Report(1, 155, pageHits, false, docMapIds);
if (parent != self) parent.OnLoadReport(rep);
}
What gives? This report works if I render as PDF. What am I doing wrong?
Thanks
- dwdw,
Take a look at the renderstream method: http://tinyurl.com/5q4qb
Bob
"dw" <dw@.discussions.microsoft.com> wrote in message
news:EE900282-8684-44A8-BDD5-780F9B071EF8@.microsoft.com...
> I am rendering a report as HTML4.0 via Web Services interface and the
report
> appears...but only the first page. I notice a small yellow error icon on
the
> bottom of the page and if I double-click it reads:
> Line: 20
> Error: 'Report' is undefined
> Code: 0
> If I view the page source, around line 20 is the following:
> function OnLoadReport()
> {
> var pageHits = null;
> var rep = new Report(1, 155, pageHits, false, docMapIds);
> if (parent != self) parent.OnLoadReport(rep);
> }
> What gives? This report works if I render as PDF. What am I doing wrong?
> Thanks
> - dw

Error Rendering PDF Files

If anyone can offer some suggestions for fixing this, I would be really
grateful.
I have a web page that shows reports a user can select. The rendering format
I use is PDF. When the user chooses to view the report for the first time,
they get an Adobe error message saying "There was an error opening this
document. The file cannot be found." The second attempt does not generate
this error. I also added a new report and it gets the Adobe error everytime.
If I let the format come out as native SQL Reporting, the error does not
happen at all. The user's would really like to have Adobe instead.
Can anyone tell me why this is happening and how to fix it? Thank you.I found the solution to this problem. Clearing the temporary internet files
enabled the Adobe error to go away.
"Mike Collins" wrote:
> If anyone can offer some suggestions for fixing this, I would be really
> grateful.
> I have a web page that shows reports a user can select. The rendering format
> I use is PDF. When the user chooses to view the report for the first time,
> they get an Adobe error message saying "There was an error opening this
> document. The file cannot be found." The second attempt does not generate
> this error. I also added a new report and it gets the Adobe error everytime.
> If I let the format come out as native SQL Reporting, the error does not
> happen at all. The user's would really like to have Adobe instead.
> Can anyone tell me why this is happening and how to fix it? Thank you.
>sql

error querying SQL Server from web page

We have a problem with an asp file retrieving data from SQL Server v7 databa
ses in
our test environment. The asp file opens a recordset to get a list of active
project
databases from another database table. The asp file loops through the record
set and
builds two SQL strings using the loop's current project database name to ret
rieve
counts from each project database. The counts are displayed in a table on a
web page.
Each SQL string is used to open a recordset against the loop's current proje
ct database.
The asp file worked fine until recently. Two new project databases were crea
ted by
backing up an existing database and restoring it with the new project names.
There
is a flag that we turn on to activate a project database. As soon as the new
projects
were turned on, the asp file failed with OLE DB error 0x80040E21. The error
message
indicated that the failure occurred when trying to open the first of the two
recordsets
associated with the two SQL strings that were being created. When we turned
off the new
projects, then everything worked fine again.
We started a trace in SQL Server and found that the SQL string being execute
d changed
when we added one of the new projects.
The SQL string for the old projects looked like:
N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE...
in which I have used 'server' to represent the SQL Server name and 'projectd
b' to
represent the project database name. The server name is always the same; onl
y the
project database name changes.
When one of the new projects was reached in the loop, the SQL string started
out the
same as above. But at some point the query changes to:
N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WH
ERE...
The query tanks and so does the asp file. A developer searched for postings
relating to the
OLE DB error and saw something about NULLs. Since it was possible for the qu
ery to return NULL,
he tried changing the query in the asp file to:
N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets WHERE
..
This fixed the problem as the query succeeded for all of the project databas
es, old and new.
The question is why this fixed the problem and how did the original query pi
ck up the additional
text "select * from". Because -
1. Upon checking the project databases, there were old project databases tha
t returned NULLs to the
queries. These project databases didn't have a problem when queried by the o
riginal asp file.
2. The new project databases were loaded with data so that they didn't retur
n NULLs. They still
caused the old asp file to fail.
3. In case the problem was with NULLs returned by an old project database pr
eceding or following
the new project database we varied which project databases were turned on. T
his didn't affect the
results at all as the asp file always failed when it came to a new project d
atabase.
So the isNull function somehow cleared up the problem even though the proble
m doesn't appear to
relate to whether NULLs are returned by the original queries.
Other things we tried that didn't help -
1. scripting the database install rather than backup\restore
2. logging on to the SQL Server box directly and installing the new database
rather than doing it
remotely with a SQL Server client
The web server and the database server are both running Windows 2000 Server
5.0.2195 SP4 Build 2195.
The SQL Server version is 7.00.624.
Can someone shed some light on this?That is a very interesting problem... I am curious, does the problem go
away if you do NOT use the 4 part name... SQL may do some strange things
when using the 4-part name because the data could be coming from a linked
server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Pat Hurst" <anonymous@.discussions.microsoft.com> wrote in message
news:98D3FE8E-D08A-4C8D-8614-8261C877687A@.microsoft.com...
> We have a problem with an asp file retrieving data from SQL Server v7
databases in
> our test environment. The asp file opens a recordset to get a list of
active project
> databases from another database table. The asp file loops through the
recordset and
> builds two SQL strings using the loop's current project database name to
retrieve
> counts from each project database. The counts are displayed in a table on
a web page.
> Each SQL string is used to open a recordset against the loop's current
project database.
> The asp file worked fine until recently. Two new project databases were
created by
> backing up an existing database and restoring it with the new project
names. There
> is a flag that we turn on to activate a project database. As soon as the
new projects
> were turned on, the asp file failed with OLE DB error 0x80040E21. The
error message
> indicated that the failure occurred when trying to open the first of the
two recordsets
> associated with the two SQL strings that were being created. When we
turned off the new
> projects, then everything worked fine again.
> We started a trace in SQL Server and found that the SQL string being
executed changed
> when we added one of the new projects.
> The SQL string for the old projects looked like:
> N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE...
> in which I have used 'server' to represent the SQL Server name and
'projectdb' to
> represent the project database name. The server name is always the same;
only the
> project database name changes.
> When one of the new projects was reached in the loop, the SQL string
started out the
> same as above. But at some point the query changes to:
> N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets
WHERE...
> The query tanks and so does the asp file. A developer searched for
postings relating to the
> OLE DB error and saw something about NULLs. Since it was possible for the
query to return NULL,
> he tried changing the query in the asp file to:
> N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets
WHERE...
> This fixed the problem as the query succeeded for all of the project
databases, old and new.
> The question is why this fixed the problem and how did the original query
pick up the additional
> text "select * from". Because -
> 1. Upon checking the project databases, there were old project databases
that returned NULLs to the
> queries. These project databases didn't have a problem when queried by the
original asp file.
> 2. The new project databases were loaded with data so that they didn't
return NULLs. They still
> caused the old asp file to fail.
> 3. In case the problem was with NULLs returned by an old project database
preceding or following
> the new project database we varied which project databases were turned on.
This didn't affect the
> results at all as the asp file always failed when it came to a new project
database.
> So the isNull function somehow cleared up the problem even though the
problem doesn't appear to
> relate to whether NULLs are returned by the original queries.
> Other things we tried that didn't help -
> 1. scripting the database install rather than backup\restore
> 2. logging on to the SQL Server box directly and installing the new
database rather than doing it
> remotely with a SQL Server client
> The web server and the database server are both running Windows 2000
Server 5.0.2195 SP4 Build 2195.
> The SQL Server version is 7.00.624.
> Can someone shed some light on this?|||May I congratulate you on your prescience. I removed the server name from th
e 2 queries in the asp file and omitted the IsNull function from both. The w
eb page came up without a hitch.
It appears that the code specifies the server name earlier in setting up a c
onnection object. This connection is used to open the 2 query recordsets so
I'm not sure why the server name was used in specifying the table in the que
ries. The developer who wro
te it is out of the office currently so I can't ask him.
Still I can't help wondering why only the two new databases created a proble
m.|||After tracking down a developer with access to the production system, I was
able to find out that production uses 2 database servers. The primary holds
the system's database and some of the project databases. The other holds a f
ew of the project databases
. The two are linked in SQL Server. So that's the rationale for four part na
mes.
Our test environment can only afford one database server so a four part name
is unnecessary as the projects are all on the server that the web page conn
ects to.

error querying SQL Server from web page

We have a problem with an asp file retrieving data from SQL Server v7 databases i
our test environment. The asp file opens a recordset to get a list of active project
databases from another database table. The asp file loops through the recordset and
builds two SQL strings using the loop's current project database name to retrieve
counts from each project database. The counts are displayed in a table on a web page.
Each SQL string is used to open a recordset against the loop's current project database
The asp file worked fine until recently. Two new project databases were created b
backing up an existing database and restoring it with the new project names. Ther
is a flag that we turn on to activate a project database. As soon as the new projects
were turned on, the asp file failed with OLE DB error 0x80040E21. The error message
indicated that the failure occurred when trying to open the first of the two recordsets
associated with the two SQL strings that were being created. When we turned off the new
projects, then everything worked fine again
We started a trace in SQL Server and found that the SQL string being executed changed
when we added one of the new projects
The SQL string for the old projects looked like
N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE..
in which I have used 'server' to represent the SQL Server name and 'projectdb' to
represent the project database name. The server name is always the same; only the
project database name changes
When one of the new projects was reached in the loop, the SQL string started out th
same as above. But at some point the query changes to
N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE..
The query tanks and so does the asp file. A developer searched for postings relating to the
OLE DB error and saw something about NULLs. Since it was possible for the query to return NULL
he tried changing the query in the asp file to
N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets WHERE..
This fixed the problem as the query succeeded for all of the project databases, old and new
The question is why this fixed the problem and how did the original query pick up the additiona
text "select * from". Because
1. Upon checking the project databases, there were old project databases that returned NULLs to the
queries. These project databases didn't have a problem when queried by the original asp file
2. The new project databases were loaded with data so that they didn't return NULLs. They still
caused the old asp file to fail
3. In case the problem was with NULLs returned by an old project database preceding or following
the new project database we varied which project databases were turned on. This didn't affect the
results at all as the asp file always failed when it came to a new project database
So the isNull function somehow cleared up the problem even though the problem doesn't appear to
relate to whether NULLs are returned by the original queries
Other things we tried that didn't help
1. scripting the database install rather than backup\restor
2. logging on to the SQL Server box directly and installing the new database rather than doing it
remotely with a SQL Server clien
The web server and the database server are both running Windows 2000 Server 5.0.2195 SP4 Build 2195
The SQL Server version is 7.00.624
Can someone shed some light on this?That is a very interesting problem... I am curious, does the problem go
away if you do NOT use the 4 part name... SQL may do some strange things
when using the 4-part name because the data could be coming from a linked
server...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Pat Hurst" <anonymous@.discussions.microsoft.com> wrote in message
news:98D3FE8E-D08A-4C8D-8614-8261C877687A@.microsoft.com...
> We have a problem with an asp file retrieving data from SQL Server v7
databases in
> our test environment. The asp file opens a recordset to get a list of
active project
> databases from another database table. The asp file loops through the
recordset and
> builds two SQL strings using the loop's current project database name to
retrieve
> counts from each project database. The counts are displayed in a table on
a web page.
> Each SQL string is used to open a recordset against the loop's current
project database.
> The asp file worked fine until recently. Two new project databases were
created by
> backing up an existing database and restoring it with the new project
names. There
> is a flag that we turn on to activate a project database. As soon as the
new projects
> were turned on, the asp file failed with OLE DB error 0x80040E21. The
error message
> indicated that the failure occurred when trying to open the first of the
two recordsets
> associated with the two SQL strings that were being created. When we
turned off the new
> projects, then everything worked fine again.
> We started a trace in SQL Server and found that the SQL string being
executed changed
> when we added one of the new projects.
> The SQL string for the old projects looked like:
> N'SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets WHERE...
> in which I have used 'server' to represent the SQL Server name and
'projectdb' to
> represent the project database name. The server name is always the same;
only the
> project database name changes.
> When one of the new projects was reached in the loop, the SQL string
started out the
> same as above. But at some point the query changes to:
> N'select * from SELECT Sum(StudentCount) FROM server.projectdb.dbo.Sheets
WHERE...
> The query tanks and so does the asp file. A developer searched for
postings relating to the
> OLE DB error and saw something about NULLs. Since it was possible for the
query to return NULL,
> he tried changing the query in the asp file to:
> N'SELECT Sum(isNull(StudentCount, 0)) FROM server.projectdb.dbo.Sheets
WHERE...
> This fixed the problem as the query succeeded for all of the project
databases, old and new.
> The question is why this fixed the problem and how did the original query
pick up the additional
> text "select * from". Because -
> 1. Upon checking the project databases, there were old project databases
that returned NULLs to the
> queries. These project databases didn't have a problem when queried by the
original asp file.
> 2. The new project databases were loaded with data so that they didn't
return NULLs. They still
> caused the old asp file to fail.
> 3. In case the problem was with NULLs returned by an old project database
preceding or following
> the new project database we varied which project databases were turned on.
This didn't affect the
> results at all as the asp file always failed when it came to a new project
database.
> So the isNull function somehow cleared up the problem even though the
problem doesn't appear to
> relate to whether NULLs are returned by the original queries.
> Other things we tried that didn't help -
> 1. scripting the database install rather than backup\restore
> 2. logging on to the SQL Server box directly and installing the new
database rather than doing it
> remotely with a SQL Server client
> The web server and the database server are both running Windows 2000
Server 5.0.2195 SP4 Build 2195.
> The SQL Server version is 7.00.624.
> Can someone shed some light on this?|||May I congratulate you on your prescience. I removed the server name from the 2 queries in the asp file and omitted the IsNull function from both. The web page came up without a hitch
It appears that the code specifies the server name earlier in setting up a connection object. This connection is used to open the 2 query recordsets so I'm not sure why the server name was used in specifying the table in the queries. The developer who wrote it is out of the office currently so I can't ask him
Still I can't help wondering why only the two new databases created a problem.

Error programaticaly rendering a report using Reporting Services Web Services

I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has few parameters that must be passed so I pass these parameters with code.

<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;

ParameterValue[] parameters = new ParameterValue[2];

parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";

parameters[1] = new ParameterValue();

parameters[1].Name = "pClass";

parameters[1].Value = "8";

ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;

byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>

Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():

<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>

I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.

Any help would be much appreciated.

I've done some (desperate) tests and changed the following line:
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
to
executionInfo = rs.SetExecutionParameters(parameters, "fr-ch");
I'm currently based in French Switzerland but our reports are written in english, besides, the documentation about this parameter is basically "A .Net language" which is not very helpful. So now it works but I'm afraid if I have to access a server that is of another culture it will fail.

error plz help

when i run my application using web parts on sql 2000 an error displayed (

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) can any one tell me why that error

)

Hi,

Please try this article on support.microsoft.com.

Article ID is 926929.

OR.

Make sure that the SQL Browser Service is started and make sure the password is correct, Because in my case customer had changed his passwords and we made sure that he changes his passwords from SSCM rather than
Services and then he was able to connect with no problems.

If you have any further issues please let me know on my e-mail ID.

Subject sould be Error code.

Thanks and Best Regards.

Farhat Nishat.

|||

i am sure that the SQL Browser Service is started and the password is correct i think that there steps done before running the web parts

because i think that web parts runs only on sql 2005 so do you know what to do to run web parts on sql2000 ?plz reply

|||

Can you check this blog? http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

If you still have problem, please copy/paste your connection string here?

Error permissions

I am getting the following error:

System.Web.Services.Protocols.SoapException: The permissions granted to user 'MachineName\IUSR_MachineName' are insufficient for performing this operation. >

I gave anonymous access via Inetmgr directory security and also gave the security permissions direct to folder to for ASPNET and iusr_machinename bith gave full access rights andf also under services gave log in permissions to my account name for reportserver under services.

I am so confused now , please can someone help.

Thank you very much for the information.

If you are trying to turn on anoymous access to RS you must be careful. When anonymous access is turned on every user is seen as the same and you lose the ability to set individual security on items.

That said, to do it, first turn back on Windows integrated security via IIS. As a local admin (Local to where RS is installed) go to the root folder in Report Manager and on the properties tab select Security. Add a new security identity, and give MachineName\IUSR_MachineName permissions that you want every user to have. You can then turn back on anonymous access to RS and you can browse the reports.

sql

Error opening reports on web browser

Hi All

i am very new to using sql reporting services. After installation of reporting services and configuration i get this error on the browser.

Can anyone highlight the problem in the configuration?

my system is configured as

Windows 2003 SP1 server

MSSQL 2005 sp1

Server Error in '/Reports' Application.
--

The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +3474107
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +226

[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426839
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149

--
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

thanks

ga

Hello ga,

I think what you need to do is to install your version of ASP.Net. You can acomplish this by following these steps.

Navigate to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727' via a command prompt.
Type aspnet_regiis.exe -i and hit enter.
You may need to restart your server, but I can't remember for sure.

Hope this helps.

Jarret

|||

ga,

Did this fix your issue?

Jarret

|||

Jarret

Thanks a lot for the tip!

ga

|||

Glad I could help, can you mark this one as answered so others can view the solution?

Jarret

sql

Error on VB Sample which is delivered by installation.

Hi,

after i try to build the web application "Web Development - Data Entry Form" i get the following error message. I already change the variable username to system which is defined in Machine.Config.

The Error messega is like following:
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Thanks,The username you see in machine.config is most likely not the username you want to provide in the connection string in your application. You need to provide a valid username and password for your SQL server. If you did not install the db server yourself, you should be able to get valid login info from the person who installed it.

If the db server is local, you might be able to get away with the following for your connection string: "server=localhost;TrustedConnection=true;database=YOUR_DB"

error on one machine and working on another

Dear sir this is a typical problem i am facing.

We have 4 web servers in out establishment.
this code works on some and does not work on some.

in all servers i have installed crystal reports the same way.

the database server is a separate server.

please help.

i must deploy this web page and the report on the one of the 2 servers( both hcl machines) allotted to me. the other 2 on which this code is working are ibm machines but i cannot deploy on them.

Error Type:
webReporting.dll (0x8004100F)
Logon failed. Details: ADO Error Code: 0x80040e21 Source: Provider Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Native Error: -2147217887 Error in File C:\WINNT\TEMP\{A687C3B5-8F52-40E2-9433-C2FF1D56D225}.rpt: Unable to connect: incorrect log on parameters.
/stores_crystal/expendable.asp, line 72

<%@. Language=VBScript %>
<!--#include file="connections.asp"-->
<!--#include file="userdate.asp"-->
<!--#include file="checkscriptfordatatype.asp"-->
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<center>
<form name=expendable method=post>
<%if request.form("dummy")="" then
set rs=server.CreateObject ("adodb.recordset")
q="sELECT item_code,item from exp_binmst order by item"
rs.Open q,conn_inventory
%>ITEM<select size=10 multiple name=eitem>
<%while not rs.eof
v="'"&rs(0)&"'"%>
<option value="<%=v%>"><%=rs(1)%></option>
<%rs.movenext
wend%>
</select>
<BR><BR><BR><BR><BR>From Date<%call urdate("mustbox-date/from date","from_date",date)%>
No From Date??<input type=checkbox name=No_From_date >
To Date<%call urdate("mustbox-date/to date","to_date",date)
%>
<BR><BR><BR><input type=submit value=show><input name=dummy value=dummy type=hidden>
<%else

dim objectfactory,htmlviewer,conInfo,coninfos
set objectfactory=createobject("crystalreports.objectfactory.2")
set htmlviewer=createobject("crystalreports.crystalreportviewer")
set conInfos=createobject("crystalreports.ConnectionInfos")
set conInfo=createobject("crystalreports.ConnectionInfo")

conInfo.UserName="sa"
conInfo.Password="3blind"
conInfos.Add(conInfo)

if Request.Form("no_from_date")="on" then
q="{Command.item_code} in ["&request.form("eitem")&"] and {Command.bin_dt} <=cdate('"&cdate(Request.Form("to_Date"))&"')"
else
q="{Command.item_code} in ["&request.form("eitem")&"] and {Command.bin_dt} >=cdate('"&cdate(request.form("from_Date"))&"') and {Command.bin_dt} <=cdate('"&cdate(Request.Form("to_Date"))&"')"
end if

with htmlviewer
.HasCrystalLogo=false
.HasExportButton=false
.HasGotoPageButton=false
.HasPageNavigationButtons=false
.HasPrintButton=false
.HasRefreshButton=false
.HasSearchButton=false
.HasToggleGroupTreeButton=false
.HasViewList=false
.HasZoomFactorList=false
.IsOwnForm=true
.IsOwnPage=true
.pageToTreeRatio=100
.ReportSource="expendable.rpt"
.EnableLogonPrompt=false
.DatabaseLogonInfos=conInfos
.SelectionFormula=q

end with

call htmlviewer.ProcessHttpRequest(request,Response,session)
'''' line no 72

end if%>

</BODY>
</HTML>
:(I encountered the same problem a couple of days before, it made me very hard to fix that, I found none solution provided on the line, finally I got the solution :
Just using ODBC connection instead of OLEDB.

Because the crystal versioning is very picky.

Error on Configure Web Synchronization Wizard

Got the following error on the last part of the wizard, after setting all the requirements:

Setting the snapshot share permissions (Error)

Messages

The operation completed successfully. (Exception from HRESULT: 0x80070000) (mscorlib)

Any tips thanks

Did you run Web Synchronization Wization upon Windows XP?

Thanks.

|||No, the machine where the publisher is located is running on Windows Server 2003... Thanks for the reply|||

Are you trying to add a domain account or a mahcine account?

Is the machine in a domain or in a workgroup?

|||

Mahesh Dudgikar - MSFT wrote:

Are you trying to add a domain account or a mahcine account?

Is the machine in a domain or in a workgroup?

Thanks for the reply.

The machine publishing the articles is just part of a workgroup.

error message when using SQL Server 7 Enterprise Manager

I have a question, that I could not find a solution for by searching the web
and this news group. Hopefully someone can make sense of this error I have
been receiving for the last few months.
Anyways, when I startup the enteprise manager on a SQL server 7 database
that is running on a windows 2000 advanced server, I get the following error
message when I click on the database icon and begin the connect process to
the databases that reside on this server:
SQL server \\srv2000 is not known to be running. Are you sure you wish to
connect?
The icon that represents the databases has a red lightening bolt through it.
When I do say yes to this question, the icon still has the lightening bolt,
but I can see the databases. I can connect and see the data. The clients
that access these databases can connect with no problems. I only see the
above error message when I connect through enterprise manager. The other
tools (DTS services and Query Analyser) has not problems connecting to the
same databases either locally or over the network.
What is causing this error message to pop up and what can I do about this
problem?
Edward Letenrdre.make sure your connecting to srv2000 and not \\srv2000 , also re-register a
sql server maybe even trying the ip address in stead.
Michael Evanchik.
www.michaelevanchik.com
"Edward Letendre" wrote:
> I have a question, that I could not find a solution for by searching the web
> and this news group. Hopefully someone can make sense of this error I have
> been receiving for the last few months.
> Anyways, when I startup the enteprise manager on a SQL server 7 database
> that is running on a windows 2000 advanced server, I get the following error
> message when I click on the database icon and begin the connect process to
> the databases that reside on this server:
> SQL server \\srv2000 is not known to be running. Are you sure you wish to
> connect?
> The icon that represents the databases has a red lightening bolt through it.
> When I do say yes to this question, the icon still has the lightening bolt,
> but I can see the databases. I can connect and see the data. The clients
> that access these databases can connect with no problems. I only see the
> above error message when I connect through enterprise manager. The other
> tools (DTS services and Query Analyser) has not problems connecting to the
> same databases either locally or over the network.
> What is causing this error message to pop up and what can I do about this
> problem?
> Edward Letenrdre.
>

error message

I finally installed MSDE and have the icon in my tray at the bottom of the screen.
When I try to connect to a database using the wizard in the web matrix program I get this message:
Unable to connect
SQL Server does not exist of access denied
Connection Open (Connect ())
What might be wrong??
Thanks for your help I'll get it soon (I hope)
Del Dobbswell, are you specifying the correct instance name? username? password?|||see this

http://support.microsoft.com/?kbid=328306

Error Message

I need help on this!
When I try to change the data from a table using Web Matrix, then I get this error message.

The table's data cannot be edited because the table does not contain modifiable columns.

As I need to edit the data's, how can I solve this?

Thanks for Your Help
MikelI solved the problem with restarting my ccomputer.

Regards Mikel