accessing data base from remote computer

we have sql 2005 standard edition. i was trying ( unsuccessfully ) to configure RAS on server 2003 to allow the server to authentificate vpn requests. i don't know how but the next day people started complaining about their mapped network drives being disconnected, and now no one can connect to the database via the network, eventhough they still have access to the server, and the network drives were remapped.

Any errors or information in event log for such behaviour?

http://www.microsoft.com/technet/community/chats/trans/windowsnet/win0608.mspx & http://www.tacteam.net/isaserverorg/vpnkitbeta2/vpnclientbrowsing.htm fyi.

I believe this is more based on Windows side question than to SQL Server related.

|||actually now that you mention it, there is a message that keeps showing up since about the time i started playing around with RAS. it is from NfsSvr. it says mapping information could not be obtained from user mapping. another attempt will be made in 30 minutes. this message first appeared about noon on fri. however we started having trouble late thur. the message repeats itself every 30 minutes.

accessing data base from remote computer

we have sql 2005 standard edition. i was trying ( unsuccessfully ) to configure RAS on server 2003 to allow the server to authentificate vpn requests. i don't know how but the next day people started complaining about their mapped network drives being disconnected, and now no one can connect to the database via the network, eventhough they still have access to the server, and the network drives were remapped.

Any errors or information in event log for such behaviour?

http://www.microsoft.com/technet/community/chats/trans/windowsnet/win0608.mspx & http://www.tacteam.net/isaserverorg/vpnkitbeta2/vpnclientbrowsing.htm fyi.

I believe this is more based on Windows side question than to SQL Server related.

|||actually now that you mention it, there is a message that keeps showing up since about the time i started playing around with RAS. it is from NfsSvr. it says mapping information could not be obtained from user mapping. another attempt will be made in 30 minutes. this message first appeared about noon on fri. however we started having trouble late thur. the message repeats itself every 30 minutes.

Access to Table Cells (Textboxes) Outside the Table

Hi,
I have two tables and would like to base another textbox aggregate
(outside of both tables), on the aggregate result cells from each
table. I don't think this is possible, but if anyone knows how please
let me know.
Table A (using DataSet A)
Table B (using DataSet B)
I want a textbox with an aggregate (Sum) which equals: #1) a Textbox in
Table A (which is a group aggregate) + #2) a Textbox in Table B (which
is another group aggregate).
Thanks,What you should do is set it to an expression and use the expression builder
and base it on an aggregate of the dataset aggregates. I.e. the sum of the
two sums.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Curtis" <curtis.johnstone@.gmail.com> wrote in message
news:1163719396.108142.238140@.k70g2000cwa.googlegroups.com...
> Hi,
> I have two tables and would like to base another textbox aggregate
> (outside of both tables), on the aggregate result cells from each
> table. I don't think this is possible, but if anyone knows how please
> let me know.
> Table A (using DataSet A)
> Table B (using DataSet B)
> I want a textbox with an aggregate (Sum) which equals: #1) a Textbox in
> Table A (which is a group aggregate) + #2) a Textbox in Table B (which
> is another group aggregate).
> Thanks,
>|||I re-architected my report using multiple datasets and aggregates and
query parameters. It all worked great except (for one record queries)
but there is a significant problem: For each record in dataset A, I
need to show a table based on dataset B and another table from dataset
C. I originally was using a list item for dataset A with two embedded
tables (using the other datasets). I was having difficulty and then
discovered that you cannot nest data regions that use different
datasets - doah! What is the best way to overcome that limiation? Can
you nest subreports?
The only other option I see is to get all of the data from one dataset
and use subqueries that return the aggregates.
Curtis
Bruce L-C [MVP] wrote:
> What you should do is set it to an expression and use the expression builder
> and base it on an aggregate of the dataset aggregates. I.e. the sum of the
> two sums.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Curtis" <curtis.johnstone@.gmail.com> wrote in message
> news:1163719396.108142.238140@.k70g2000cwa.googlegroups.com...
> > Hi,
> >
> > I have two tables and would like to base another textbox aggregate
> > (outside of both tables), on the aggregate result cells from each
> > table. I don't think this is possible, but if anyone knows how please
> > let me know.
> >
> > Table A (using DataSet A)
> > Table B (using DataSet B)
> >
> > I want a textbox with an aggregate (Sum) which equals: #1) a Textbox in
> > Table A (which is a group aggregate) + #2) a Textbox in Table B (which
> > is another group aggregate).
> >
> > Thanks,
> >