Hi,
We seperated out our web server (IIS) from our SQL Server recently. Things
have gone well, except one thing. Intermittently, we get the message "SQL
Server does not exist or access denied" when users try to get to the site.
The two machines are connected via a 1GBps direct connection. We've seen
high usage of that connection at times when this has happened, but not
always. Does anyone have any ideas?
Here's the connection string...
"Provider=SQLOLEDB;User ID=our_db_user;Initial
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
rd"
Thanks in advance.
JoshNo one has any ideas?
"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> Hi,
> We seperated out our web server (IIS) from our SQL Server recently.
Things
> have gone well, except one thing. Intermittently, we get the message
"SQL
> Server does not exist or access denied" when users try to get to the site.
> The two machines are connected via a 1GBps direct connection. We've seen
> high usage of that connection at times when this has happened, but not
> always. Does anyone have any ideas?
> Here's the connection string...
> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>
Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
> rd"
> Thanks in advance.
> Josh
>|||Try the following troubleshooting article:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>No one has any ideas?
>"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> Hi,
>> We seperated out our web server (IIS) from our SQL Server recently.
>Things
>> have gone well, except one thing. Intermittently, we get the message
>"SQL
>> Server does not exist or access denied" when users try to get to the site.
>> The two machines are connected via a 1GBps direct connection. We've seen
>> high usage of that connection at times when this has happened, but not
>> always. Does anyone have any ideas?
>> Here's the connection string...
>> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passwo
>> rd"
>> Thanks in advance.
>> Josh
>>
>|||Thanks for the info, Sue.
I think most of those are for cases where you can't EVER connect.
Unfortunately, ours is only intermittant. It seems like the number of
connections jumps up when it happens, too. Any thoughts?
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
> Try the following troubleshooting article:
> INF: Potential Causes of the "SQL Server Does Not Exist or
> Access Denied" Error Message
> http://support.microsoft.com/?id=328306
> -Sue
> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
> <josh@.sparkpeople.com> wrote:
> >No one has any ideas?
> >
> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
> >> Hi,
> >>
> >> We seperated out our web server (IIS) from our SQL Server recently.
> >Things
> >> have gone well, except one thing. Intermittently, we get the message
> >"SQL
> >> Server does not exist or access denied" when users try to get to the
site.
> >> The two machines are connected via a 1GBps direct connection. We've
seen
> >> high usage of that connection at times when this has happened, but not
> >> always. Does anyone have any ideas?
> >>
> >> Here's the connection string...
> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
> >>
>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
o
> >> rd"
> >>
> >> Thanks in advance.
> >> Josh
> >>
> >>
> >
>|||You can still have intermittent problems with some of the
network related issues sited in the article. You may also
want to check the Windows event logs on both servers for any
network related issues.
-Sue
On Thu, 23 Oct 2003 14:42:31 GMT, "Josh Knepfle"
<josh@.sparkpeople.com> wrote:
>Thanks for the info, Sue.
>I think most of those are for cases where you can't EVER connect.
>Unfortunately, ours is only intermittant. It seems like the number of
>connections jumps up when it happens, too. Any thoughts?
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:1bbdpv0fav02hrlbqum3lg8m17la8frpva@.4ax.com...
>> Try the following troubleshooting article:
>> INF: Potential Causes of the "SQL Server Does Not Exist or
>> Access Denied" Error Message
>> http://support.microsoft.com/?id=328306
>> -Sue
>> On Wed, 22 Oct 2003 14:15:26 GMT, "Josh Knepfle"
>> <josh@.sparkpeople.com> wrote:
>> >No one has any ideas?
>> >
>> >"Josh Knepfle" <josh@.sparkpeople.com> wrote in message
>> >news:rGWjb.75792$uJ2.12329@.fe3.columbus.rr.com...
>> >> Hi,
>> >>
>> >> We seperated out our web server (IIS) from our SQL Server recently.
>> >Things
>> >> have gone well, except one thing. Intermittently, we get the message
>> >"SQL
>> >> Server does not exist or access denied" when users try to get to the
>site.
>> >> The two machines are connected via a 1GBps direct connection. We've
>seen
>> >> high usage of that connection at times when this has happened, but not
>> >> always. Does anyone have any ideas?
>> >>
>> >> Here's the connection string...
>> >> "Provider=SQLOLEDB;User ID=our_db_user;Initial
>> >>
>>Catalog=our_db;Network=DBMSSOCN;Address=192.168.0.1,1433;Password=our_passw
>o
>> >> rd"
>> >>
>> >> Thanks in advance.
>> >> Josh
>> >>
>> >>
>> >
>sql
Showing posts with label iis. Show all posts
Showing posts with label iis. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
intermitent connection problem asp to sql2000
I have an asp page (w2003 IIS) which grabs a very small amount of data from
a table on our
sql server (sql2000).
Most of the time the page works fine, with no problems. However
intermitently it falls over with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/MIS/Searches/main_search.asp, line 8
this is the connection and query which brings back about 300 records:
Dim MM_uLiveDatabase_STRING
MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
Dim getID
Dim getID_numRows
Set getID = Server.CreateObject("ADODB.Recordset")
getID.ActiveConnection = MM_uLiveDatabase_STRING
getID.Source = "select fltf_value from caps_users left join
caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
Replace(getID__theUser, "'", "''") + "'"
getID.CursorType = 0
getID.CursorLocation = 2
getID.LockType = 1
getID.Open()
THis is rapidly becoming a major problem! Anyone got any ideas?
john
You'd want to start by monitoring for locking, blocking
issues in SQL Server when you experience the timeouts. You
can monitor for these issues using sp_who2, sp_lock and
querying master..sysprocesses.
-Sue
On Tue, 1 Feb 2005 17:43:41 -0000, "John" <john@.home.com.uk>
wrote:
>I have an asp page (w2003 IIS) which grabs a very small amount of data from
>a table on our
>sql server (sql2000).
>Most of the time the page works fine, with no problems. However
>intermitently it falls over with:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>/MIS/Searches/main_search.asp, line 8
>
>this is the connection and query which brings back about 300 records:
>Dim MM_uLiveDatabase_STRING
>MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
>Dim getID
>Dim getID_numRows
>Set getID = Server.CreateObject("ADODB.Recordset")
>getID.ActiveConnection = MM_uLiveDatabase_STRING
>getID.Source = "select fltf_value from caps_users left join
>caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
>on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
>Replace(getID__theUser, "'", "''") + "'"
>getID.CursorType = 0
>getID.CursorLocation = 2
>getID.LockType = 1
>getID.Open()
>
>THis is rapidly becoming a major problem! Anyone got any ideas?
>john
>
a table on our
sql server (sql2000).
Most of the time the page works fine, with no problems. However
intermitently it falls over with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/MIS/Searches/main_search.asp, line 8
this is the connection and query which brings back about 300 records:
Dim MM_uLiveDatabase_STRING
MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
Dim getID
Dim getID_numRows
Set getID = Server.CreateObject("ADODB.Recordset")
getID.ActiveConnection = MM_uLiveDatabase_STRING
getID.Source = "select fltf_value from caps_users left join
caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
Replace(getID__theUser, "'", "''") + "'"
getID.CursorType = 0
getID.CursorLocation = 2
getID.LockType = 1
getID.Open()
THis is rapidly becoming a major problem! Anyone got any ideas?
john
You'd want to start by monitoring for locking, blocking
issues in SQL Server when you experience the timeouts. You
can monitor for these issues using sp_who2, sp_lock and
querying master..sysprocesses.
-Sue
On Tue, 1 Feb 2005 17:43:41 -0000, "John" <john@.home.com.uk>
wrote:
>I have an asp page (w2003 IIS) which grabs a very small amount of data from
>a table on our
>sql server (sql2000).
>Most of the time the page works fine, with no problems. However
>intermitently it falls over with:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>/MIS/Searches/main_search.asp, line 8
>
>this is the connection and query which brings back about 300 records:
>Dim MM_uLiveDatabase_STRING
>MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
>Dim getID
>Dim getID_numRows
>Set getID = Server.CreateObject("ADODB.Recordset")
>getID.ActiveConnection = MM_uLiveDatabase_STRING
>getID.Source = "select fltf_value from caps_users left join
>caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
>on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
>Replace(getID__theUser, "'", "''") + "'"
>getID.CursorType = 0
>getID.CursorLocation = 2
>getID.LockType = 1
>getID.Open()
>
>THis is rapidly becoming a major problem! Anyone got any ideas?
>john
>
intermitent connection problem asp to sql2000
I have an asp page (w2003 IIS) which grabs a very small amount of data from
a table on our
sql server (sql2000).
Most of the time the page works fine, with no problems. However
intermitently it falls over with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/MIS/Searches/main_search.asp, line 8
this is the connection and query which brings back about 300 records:
Dim MM_uLiveDatabase_STRING
MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
Dim getID
Dim getID_numRows
Set getID = Server.CreateObject("ADODB.Recordset")
getID.ActiveConnection = MM_uLiveDatabase_STRING
getID.Source = "select fltf_value from caps_users left join
caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
Replace(getID__theUser, "'", "''") + "'"
getID.CursorType = 0
getID.CursorLocation = 2
getID.LockType = 1
getID.Open()
THis is rapidly becoming a major problem! Anyone got any ideas'
johnYou'd want to start by monitoring for locking, blocking
issues in SQL Server when you experience the timeouts. You
can monitor for these issues using sp_who2, sp_lock and
querying master..sysprocesses.
-Sue
On Tue, 1 Feb 2005 17:43:41 -0000, "John" <john@.home.com.uk>
wrote:
>I have an asp page (w2003 IIS) which grabs a very small amount of data from
>a table on our
>sql server (sql2000).
>Most of the time the page works fine, with no problems. However
>intermitently it falls over with:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>/MIS/Searches/main_search.asp, line 8
>
>this is the connection and query which brings back about 300 records:
>Dim MM_uLiveDatabase_STRING
>MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
>Dim getID
>Dim getID_numRows
>Set getID = Server.CreateObject("ADODB.Recordset")
>getID.ActiveConnection = MM_uLiveDatabase_STRING
>getID.Source = "select fltf_value from caps_users left join
>caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
>on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
>Replace(getID__theUser, "'", "''") + "'"
>getID.CursorType = 0
>getID.CursorLocation = 2
>getID.LockType = 1
>getID.Open()
>
>THis is rapidly becoming a major problem! Anyone got any ideas'
>john
>
a table on our
sql server (sql2000).
Most of the time the page works fine, with no problems. However
intermitently it falls over with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/MIS/Searches/main_search.asp, line 8
this is the connection and query which brings back about 300 records:
Dim MM_uLiveDatabase_STRING
MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
Dim getID
Dim getID_numRows
Set getID = Server.CreateObject("ADODB.Recordset")
getID.ActiveConnection = MM_uLiveDatabase_STRING
getID.Source = "select fltf_value from caps_users left join
caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
Replace(getID__theUser, "'", "''") + "'"
getID.CursorType = 0
getID.CursorLocation = 2
getID.LockType = 1
getID.Open()
THis is rapidly becoming a major problem! Anyone got any ideas'
johnYou'd want to start by monitoring for locking, blocking
issues in SQL Server when you experience the timeouts. You
can monitor for these issues using sp_who2, sp_lock and
querying master..sysprocesses.
-Sue
On Tue, 1 Feb 2005 17:43:41 -0000, "John" <john@.home.com.uk>
wrote:
>I have an asp page (w2003 IIS) which grabs a very small amount of data from
>a table on our
>sql server (sql2000).
>Most of the time the page works fine, with no problems. However
>intermitently it falls over with:
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>/MIS/Searches/main_search.asp, line 8
>
>this is the connection and query which brings back about 300 records:
>Dim MM_uLiveDatabase_STRING
>MM_uLiveDatabase_STRING = "dsn=database;uid=username;pwd=password
>Dim getID
>Dim getID_numRows
>Set getID = Server.CreateObject("ADODB.Recordset")
>getID.ActiveConnection = MM_uLiveDatabase_STRING
>getID.Source = "select fltf_value from caps_users left join
>caps_user_filters on uflt_for_user = user_id inner join caps_filter_fields
>on fltf_filter_flt = uflt_filter_flt where user_ref like '" +
>Replace(getID__theUser, "'", "''") + "'"
>getID.CursorType = 0
>getID.CursorLocation = 2
>getID.LockType = 1
>getID.Open()
>
>THis is rapidly becoming a major problem! Anyone got any ideas'
>john
>
Monday, March 19, 2012
InteractiveHeigt and 6.000 rows on first HTML page?
First the good news:
A Matrix receives around 55.000 Datarows and produces 1.300 pages of PDF.
This happens in:
- SQL-Query: 5 Seconds
- IIS rendering: 10 Seconds for the first HTML-page
- PDF export: 120 seconds
Really great product.
OK, now the problem:
When the data of a customer in the database is rendered with:
- this customer has around 6.000 rows in the matrix
- AND the first column in the Matrix is continuous
(that means: all other about 10 columns are subdata to the first column)
--> it happens the unexpected:
ALL the 6.000 rows appear on the first HTML-page
Changes in InteractiveHeight do not affect this HTML-Rendering on this first
page.
The InteractiveHeight works perfectly from the second page as expected, but
not on this first.
What happens:
Case 1 in IE (6 or 7):
- SQL-Query 5 Seconds
(sqlserv.exe goes up to 150 MB)
- IIS rendering: 10 seconds
(w3wp.exe goes up to 135 MB)
- IExplorer.exe runs for 60 seconds with 100% CPU-usage
(iexplorer.exe memory footprint 100 MB)
After this the first page appears and all is almost well.
Because of 6.000 rows in one IE-page, scrolling is worse than on an Intel
286, but exporting to PDF is no pain.
Case 2 the same in ReportViewerControl (Redistributable 2005):
- SQL-Query 5 Seconds as above
(sqlserv.exe goes up to 150 MB)
- IIS rendering: indefinitely <-- = the problem
w3wp.exe consumes indefinitely 250 MB
- ReportViewer-Control message after 10 minutes:
"The request was aborted: The operation has timed out."
I can shut down the ReportViewer-Control WinApp, IIS continues with 250 MB
and 100% CPU. Poor Windows Enterpise Server 2003R2
----
Questions:
A: How do I achieve pagebreaks for the first 6.000 rows in the Matrix
despite the first column being continuous?
(There is a bug in the HTML-Render-Engine that doesn't accept
InteractiveHeight in this case.)
B: Please supply me with the newest ReportViewer.exe Redistributable March
2007
(it's ready, but will only be distributed to the public in one week
because of the need to write a KB-article)
We need to know, if this will remedy our problem!
(There is probably a bug in the SOAP implementation or the render-engine
of the old ReportViewer-Control.)
Thanks in advance, HenryHello Henry,
I will answer your second question first.
We did not have the new Redistributable package for public now. I will
provide you the download link once I got the information from the internal
team.
As for the first question,
I would like to get the report definition so that I can provide further
assistance on this.
Could you please send the report to me?
To reach me, please remove the ONLINE in my display email address.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hallo Wei Lu,
any news about the thousands of rows in the first HTML page?
Greetings, Henry|||Hi Wei Lu,
new Info:
Test with the new Microsoft Report Viewer Redistributable 2005 SP1,
published on 03/27/2007 under
http://www.microsoft.com/downloads/details.aspx?FamilyId=35F23B3C-3B3F-4377-9AE1-26321F99FDF0&displaylang=en
unfortunately did NOT alleviate the problem.
Greetings, Henry|||Hello Henry,
Since I did not have the datasource, I could not reproduce this issue.
My suggestion is that you may increase the page Size of the report.
The page size of the report is the InteractiveSize plus the Margins. So
since your interactivesize is 29.7cm * 21cm, and your margin setting is 1cm
top and 0.5cm bottom, could you please increase your Page Size to 29.7cm *
22.5cm to have a try?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Dear Wei Lu,
thanks for the tip with the page size, but it didn't work.
I've made lots of test with varying page sizes and different combinations of
ReportViewer-Control Versions (042=original DLLs, 762=VSSP1 and 817=Report
Viewer Distr.2005 SP1) and SQL-Server 2005-Versions (SP1 and SP2).
No way.
I've compiled a test-RDL with Access-DB that I've sent you by e-mail.
Did you receive it?
Yours Henry|||Hello Herry,
I reproduce this issue that the HTML render will cost a long time and only
one page are generated.
Currently, I found a workaround is that you may try to add a group
expression in the matrix1_intCustomerID group.
=Int((RowNumber(nothing)-1)/30)
And I use the following in the statement
select * from t0blhbu1502 order by intCustomerID,
intInvoiceNo,DtmInvoiceDate,intOrderNo
Then the report will only show 30 records in one page. You could modify the
setting to allow more records.
Hope this helps!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
thank you very much for this information.
Weeks ago I already tried this but couldn't achieve what I'd have liked and
abandoned it.
I thought it'd exist some shortcut or official way.
Since there's not, I returned to dig in this grouping direction.
In our case we use a matrix inside a list with subtotals, so your proposal
didn't work.
After another lots of hours fighting with variable scope problems, I figured
it finally out, how to get it done.
Put the following Expression to group on it in the first matrix column:
=code.setRowAggregate()
The associated function:
Function setRowAggregate() As Integer
Static Dim a As Integer = 0
Static Dim b As Integer = 1
If a < 100 Then
a += 1
Else
a = 1
b += 1
End If
Return b
End Function
and yapadapadu it is finally working.
Saludos, Henry|||Hi Henry,
Glad to hear you resolved this issue. And your detailed information of your
resolution is helpful.
If you have any question, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
A Matrix receives around 55.000 Datarows and produces 1.300 pages of PDF.
This happens in:
- SQL-Query: 5 Seconds
- IIS rendering: 10 Seconds for the first HTML-page
- PDF export: 120 seconds
Really great product.
OK, now the problem:
When the data of a customer in the database is rendered with:
- this customer has around 6.000 rows in the matrix
- AND the first column in the Matrix is continuous
(that means: all other about 10 columns are subdata to the first column)
--> it happens the unexpected:
ALL the 6.000 rows appear on the first HTML-page
Changes in InteractiveHeight do not affect this HTML-Rendering on this first
page.
The InteractiveHeight works perfectly from the second page as expected, but
not on this first.
What happens:
Case 1 in IE (6 or 7):
- SQL-Query 5 Seconds
(sqlserv.exe goes up to 150 MB)
- IIS rendering: 10 seconds
(w3wp.exe goes up to 135 MB)
- IExplorer.exe runs for 60 seconds with 100% CPU-usage
(iexplorer.exe memory footprint 100 MB)
After this the first page appears and all is almost well.
Because of 6.000 rows in one IE-page, scrolling is worse than on an Intel
286, but exporting to PDF is no pain.
Case 2 the same in ReportViewerControl (Redistributable 2005):
- SQL-Query 5 Seconds as above
(sqlserv.exe goes up to 150 MB)
- IIS rendering: indefinitely <-- = the problem
w3wp.exe consumes indefinitely 250 MB
- ReportViewer-Control message after 10 minutes:
"The request was aborted: The operation has timed out."
I can shut down the ReportViewer-Control WinApp, IIS continues with 250 MB
and 100% CPU. Poor Windows Enterpise Server 2003R2
----
Questions:
A: How do I achieve pagebreaks for the first 6.000 rows in the Matrix
despite the first column being continuous?
(There is a bug in the HTML-Render-Engine that doesn't accept
InteractiveHeight in this case.)
B: Please supply me with the newest ReportViewer.exe Redistributable March
2007
(it's ready, but will only be distributed to the public in one week
because of the need to write a KB-article)
We need to know, if this will remedy our problem!
(There is probably a bug in the SOAP implementation or the render-engine
of the old ReportViewer-Control.)
Thanks in advance, HenryHello Henry,
I will answer your second question first.
We did not have the new Redistributable package for public now. I will
provide you the download link once I got the information from the internal
team.
As for the first question,
I would like to get the report definition so that I can provide further
assistance on this.
Could you please send the report to me?
To reach me, please remove the ONLINE in my display email address.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hallo Wei Lu,
any news about the thousands of rows in the first HTML page?
Greetings, Henry|||Hi Wei Lu,
new Info:
Test with the new Microsoft Report Viewer Redistributable 2005 SP1,
published on 03/27/2007 under
http://www.microsoft.com/downloads/details.aspx?FamilyId=35F23B3C-3B3F-4377-9AE1-26321F99FDF0&displaylang=en
unfortunately did NOT alleviate the problem.
Greetings, Henry|||Hello Henry,
Since I did not have the datasource, I could not reproduce this issue.
My suggestion is that you may increase the page Size of the report.
The page size of the report is the InteractiveSize plus the Margins. So
since your interactivesize is 29.7cm * 21cm, and your margin setting is 1cm
top and 0.5cm bottom, could you please increase your Page Size to 29.7cm *
22.5cm to have a try?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Dear Wei Lu,
thanks for the tip with the page size, but it didn't work.
I've made lots of test with varying page sizes and different combinations of
ReportViewer-Control Versions (042=original DLLs, 762=VSSP1 and 817=Report
Viewer Distr.2005 SP1) and SQL-Server 2005-Versions (SP1 and SP2).
No way.
I've compiled a test-RDL with Access-DB that I've sent you by e-mail.
Did you receive it?
Yours Henry|||Hello Herry,
I reproduce this issue that the HTML render will cost a long time and only
one page are generated.
Currently, I found a workaround is that you may try to add a group
expression in the matrix1_intCustomerID group.
=Int((RowNumber(nothing)-1)/30)
And I use the following in the statement
select * from t0blhbu1502 order by intCustomerID,
intInvoiceNo,DtmInvoiceDate,intOrderNo
Then the report will only show 30 records in one page. You could modify the
setting to allow more records.
Hope this helps!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
thank you very much for this information.
Weeks ago I already tried this but couldn't achieve what I'd have liked and
abandoned it.
I thought it'd exist some shortcut or official way.
Since there's not, I returned to dig in this grouping direction.
In our case we use a matrix inside a list with subtotals, so your proposal
didn't work.
After another lots of hours fighting with variable scope problems, I figured
it finally out, how to get it done.
Put the following Expression to group on it in the first matrix column:
=code.setRowAggregate()
The associated function:
Function setRowAggregate() As Integer
Static Dim a As Integer = 0
Static Dim b As Integer = 1
If a < 100 Then
a += 1
Else
a = 1
b += 1
End If
Return b
End Function
and yapadapadu it is finally working.
Saludos, Henry|||Hi Henry,
Glad to hear you resolved this issue. And your detailed information of your
resolution is helpful.
If you have any question, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Monday, March 12, 2012
Interactive data access through firewall
Hi there!
I am facing this problem:
I have server A (SQL Server 2005) in LAN and server B (IIS 6) in DMZ.
Due to security policies, server A can initiate communications to B through a firewall; server B cannot initiate any communication to server A.
A web application on server B needs to interactively read/write data stored on server A.
I was reading something about repication, sql everywhere, service broker and something else.
Is there some integrated functionality in SQL Server 2005 that can help in this scenario, or should I develop some sort of sync application?
Thank you.
Bye!
Well, I would not suggest you to implement a sync mechanism on your own. Either use a local database which is replicated to the main server or open the firewall on the dedicated port and restrict the access to the IP of the web server and implement certain security rules like IPSec , using certificate based communication, encryption etc. to prevent any attack to your server.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
Thank you for your answer.
I don't know exactly why, but they don't want data to be stored on the published server, nor in any other server in DMZ.
Since I have not much experience in firewalling and network rules, I am trying to adapt my software solution to the existing environment.
I developed a semi-interactive communication app based on asynchronous webservices, where server A polls from server B for queries that should be executed, and returns the resultsets. It's much like Exchange's "Direct Push Emails".
I am just wondering if this is the best solution, or if I should simply pretend some ports be opened on the firewall...
Interactive data access through firewall
Hi there!
I am facing this problem:
I have server A (SQL Server 2005) in LAN and server B (IIS 6) in DMZ.
Due to security policies, server A can initiate communications to B through a firewall; server B cannot initiate any communication to server A.
A web application on server B needs to interactively read/write data stored on server A.
I was reading something about repication, sql everywhere, service broker and something else.
Is there some integrated functionality in SQL Server 2005 that can help in this scenario, or should I develop some sort of sync application?
Thank you.
Bye!
Well, I would not suggest you to implement a sync mechanism on your own. Either use a local database which is replicated to the main server or open the firewall on the dedicated port and restrict the access to the IP of the web server and implement certain security rules like IPSec , using certificate based communication, encryption etc. to prevent any attack to your server.
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
Thank you for your answer.
I don't know exactly why, but they don't want data to be stored on the published server, nor in any other server in DMZ.
Since I have not much experience in firewalling and network rules, I am trying to adapt my software solution to the existing environment.
I developed a semi-interactive communication app based on asynchronous webservices, where server A polls from server B for queries that should be executed, and returns the resultsets. It's much like Exchange's "Direct Push Emails".
I am just wondering if this is the best solution, or if I should simply pretend some ports be opened on the firewall...
Sunday, February 19, 2012
integrated windows authentication
Hello,
In my report application, I had to remove anonymous
authentication and set integrated windows authentication
in IIS manager, in this case,
http://localhost/ReportServer?%2fReport+Project1%
2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
4b71-8511-c7e08926c50a
works fine, but in the same computer,
http://myserverName/ReportServer?%2fReport+Project1%
2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
4b71-8511-c7e08926c50a
asks me use id and password when I use myServerName
instead of localhost. Wow can I get windows authentication
works without asking username password?
Thanks,
Jim.Hi Jim,
JIM.H. wrote:
> http://localhost/ReportServer?%2fReport+Project1%
> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
> 4b71-8511-c7e08926c50a
> works fine, but in the same computer,
> http://myserverName/ReportServer?%2fReport+Project1%
> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
> 4b71-8511-c7e08926c50a
> asks me use id and password when I use myServerName
> instead of localhost. Wow can I get windows authentication
> works without asking username password?
I believe that localhost works because it is considered an Intranet site.
You could try adding http://myserverName to your list of Local Intranet
sites (IE, Tools | Internet Options, Security tab, Local Intranet, Sites,
Advanced). That should suppress the dialog and pass your Windows
authentication through automatically.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Thanks Jake,
It works fine when myServerName is in trusted list. Now, I
have another problem, I have a report application:
http://myServerName/ReportServer?%2fReport+Project1%
2fReport1&rs:Command=Render. This is working fine in any
computer. I also have an asp.net application that has this
report embedded as a report viewer, so
http://myServerName/App/WebForm1.aspx works fine and bring
report in myServerName server. However when I do
http://myServerName/App/WebForm1.aspx in any other
computer other than myServerName, report viewer is not
showing in IE.
I am not sure what repoet viewer parameters should be but
I am using ReportPath as /Report Project1/Report1,
ServerUrl as http:// myServerName /reportserver.
What is problem?
Thanks,
Jim.
>--Original Message--
>Hi Jim,
>JIM.H. wrote:
>> http://localhost/ReportServer?%2fReport+Project1%
>> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-
9098-
>> 4b71-8511-c7e08926c50a
>> works fine, but in the same computer,
>> http://myserverName/ReportServer?%2fReport+Project1%
>> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-
9098-
>> 4b71-8511-c7e08926c50a
>> asks me use id and password when I use myServerName
>> instead of localhost. Wow can I get windows
authentication
>> works without asking username password?
>I believe that localhost works because it is considered
an Intranet site.
>You could try adding http://myserverName to your list of
Local Intranet
>sites (IE, Tools | Internet Options, Security tab, Local
Intranet, Sites,
>Advanced). That should suppress the dialog and pass your
Windows
>authentication through automatically.
>--
>Regards,
>Jake Marx
>MS MVP - Excel
>www.longhead.com
>[please keep replies in the newsgroup - email address
unmonitored]
>.
>
In my report application, I had to remove anonymous
authentication and set integrated windows authentication
in IIS manager, in this case,
http://localhost/ReportServer?%2fReport+Project1%
2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
4b71-8511-c7e08926c50a
works fine, but in the same computer,
http://myserverName/ReportServer?%2fReport+Project1%
2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
4b71-8511-c7e08926c50a
asks me use id and password when I use myServerName
instead of localhost. Wow can I get windows authentication
works without asking username password?
Thanks,
Jim.Hi Jim,
JIM.H. wrote:
> http://localhost/ReportServer?%2fReport+Project1%
> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
> 4b71-8511-c7e08926c50a
> works fine, but in the same computer,
> http://myserverName/ReportServer?%2fReport+Project1%
> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-9098-
> 4b71-8511-c7e08926c50a
> asks me use id and password when I use myServerName
> instead of localhost. Wow can I get windows authentication
> works without asking username password?
I believe that localhost works because it is considered an Intranet site.
You could try adding http://myserverName to your list of Local Intranet
sites (IE, Tools | Internet Options, Security tab, Local Intranet, Sites,
Advanced). That should suppress the dialog and pass your Windows
authentication through automatically.
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Thanks Jake,
It works fine when myServerName is in trusted list. Now, I
have another problem, I have a report application:
http://myServerName/ReportServer?%2fReport+Project1%
2fReport1&rs:Command=Render. This is working fine in any
computer. I also have an asp.net application that has this
report embedded as a report viewer, so
http://myServerName/App/WebForm1.aspx works fine and bring
report in myServerName server. However when I do
http://myServerName/App/WebForm1.aspx in any other
computer other than myServerName, report viewer is not
showing in IE.
I am not sure what repoet viewer parameters should be but
I am using ReportPath as /Report Project1/Report1,
ServerUrl as http:// myServerName /reportserver.
What is problem?
Thanks,
Jim.
>--Original Message--
>Hi Jim,
>JIM.H. wrote:
>> http://localhost/ReportServer?%2fReport+Project1%
>> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-
9098-
>> 4b71-8511-c7e08926c50a
>> works fine, but in the same computer,
>> http://myserverName/ReportServer?%2fReport+Project1%
>> 2fReport1&rs%3aClearSession=true&rc%3aView=9d451448-
9098-
>> 4b71-8511-c7e08926c50a
>> asks me use id and password when I use myServerName
>> instead of localhost. Wow can I get windows
authentication
>> works without asking username password?
>I believe that localhost works because it is considered
an Intranet site.
>You could try adding http://myserverName to your list of
Local Intranet
>sites (IE, Tools | Internet Options, Security tab, Local
Intranet, Sites,
>Advanced). That should suppress the dialog and pass your
Windows
>authentication through automatically.
>--
>Regards,
>Jake Marx
>MS MVP - Excel
>www.longhead.com
>[please keep replies in the newsgroup - email address
unmonitored]
>.
>
Integrated Security with local SQL & IIS
I have SQL RS running on a Win 2K (dev only) machine with IIS on the same local machine. I am trying to access the reports from another computer, but am getting an error An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source '<Shared Data Source Name>'. (rsErrorOpeningConnection) Get Online Help Login failed for user '<DOMAINNAME>\Guest'.
IIS and the Datasource are setup for integrated security and the Datasource is aimed at the local SQL DB. Anonymous access is turned off in IIS and it prompts for the login info when trying to access it via the web. My understanding is that this should work without problems due to IIS & SQL being on the same machine, but I can't seem to get it to work. Is there a doc somewhere or anything that goes thru the settings so I can see what I'm missing? Or does anyone have any ideas?
Thanks.
Does it work if you access the reports locally? How about using stored windows credentials for hte data source instead of integrated security?|||Yes, the reports work fine locally. I just can't access them from another machine. I need to use integrated security due to needing the windows login to lookup the correct info in the report and to know the type of user (admin, basic, etc).
Thanks for your help.
|||Probably a kerberos configuration issue. Try forcing NTLM. See the workaround in http://support.microsoft.com/default.aspx?scid=kb;en-us;871179
Subscribe to:
Posts (Atom)