Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
Thanks
Hi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks
|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
Showing posts with label address. Show all posts
Showing posts with label address. Show all posts
Monday, March 19, 2012
Access Violation occurred writing address
Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
Access Violation occurred writing address
Hi folks,
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
It seems for the last few days my SQL Server has been producing memory dumps
(with errors) about three times a day.
The main error seems to be the following :-
Computer type is AT/AT COMPATIBLE.
Current time is 22:11:16 09/20/05.
1 Intel x86 level 15, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 75%
Total Physical = 991 MB
Available Physical = 240 MB
Total Page File = 2926 MB
Available Page File = 2269 MB
Total Virtual = 2047 MB
Available Virtual = 980 MB
*Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0029.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 09/20/05 22:11:16 spid 0
*
* Exception Address = 004093CA
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000807
This error with differing memory address happens twice a day at various
times of the day, I had hoped it was linked to server usage however this
doesnt seem the case.
This SQL Server is used as the backend of an Online Web Browser game, and
typically its most active in the evenings however it seems to produce these
errors at any time of the day.
Although if it errors in the morning it wont do it in the evening ... but
then if it errors in the evening it doesnt do it in the morning.
Its almost like SQL is playing up for attention but its not speaking a
language I know.
Does anyone have any Ideas, any help greatly appreciated.
ThanksHi
We had this for a while on one of our servers.
We rebuilt all the indexes on all the databases and the problem went away.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Daniel Paull" <DanielPaull@.discussions.microsoft.com> wrote in message
news:7B5217FF-4635-47DC-8F0C-4208A21E99C4@.microsoft.com...
> Hi folks,
> It seems for the last few days my SQL Server has been producing memory
> dumps
> (with errors) about three times a day.
> The main error seems to be the following :-
> Computer type is AT/AT COMPATIBLE.
> Current time is 22:11:16 09/20/05.
> 1 Intel x86 level 15, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 75%
> Total Physical = 991 MB
> Available Physical = 240 MB
> Total Page File = 2926 MB
> Available Page File = 2269 MB
> Total Virtual = 2047 MB
> Available Virtual = 980 MB
> *Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0029.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 09/20/05 22:11:16 spid 0
> *
> * Exception Address = 004093CA
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000807
> This error with differing memory address happens twice a day at various
> times of the day, I had hoped it was linked to server usage however this
> doesnt seem the case.
> This SQL Server is used as the backend of an Online Web Browser game, and
> typically its most active in the evenings however it seems to produce
> these
> errors at any time of the day.
> Although if it errors in the morning it wont do it in the evening ... but
> then if it errors in the evening it doesnt do it in the morning.
> Its almost like SQL is playing up for attention but its not speaking a
> language I know.
> Does anyone have any Ideas, any help greatly appreciated.
> Thanks|||Hi thanks for the reply,
Did you use DBCC DBREINDEX or physically drop and recreate the indexes ?
Access violation
Hi,
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
DanielAccess violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
>> Hi,
>> I'm having a problem with a particular address location.
>> I'm using MS SQL Server 2000
>> I checked the server logs and I see some stack dumps now and then.
>> I checked the stack dumps and all of them seem to have the same problem.
>> * BEGIN STACK DUMP:
>> * 06/14/05 23:18:37 spid 0
>> *
>> * Exception Address = 258B6EF6
>> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>> * Access Violation occurred reading address 77BEC370
>> All the stack dumps shows error reading the address 77BEC370
>> Is this because of a faulty memory?
>> Daniel|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>|||alright. thanks for your help. :)
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
>> so it has nothing to do with buggy programming? As i am using the db with
>> ASP.
>> Thanks,
>> Daniel|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
DanielAccess violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
>> Hi,
>> I'm having a problem with a particular address location.
>> I'm using MS SQL Server 2000
>> I checked the server logs and I see some stack dumps now and then.
>> I checked the stack dumps and all of them seem to have the same problem.
>> * BEGIN STACK DUMP:
>> * 06/14/05 23:18:37 spid 0
>> *
>> * Exception Address = 258B6EF6
>> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
>> * Access Violation occurred reading address 77BEC370
>> All the stack dumps shows error reading the address 77BEC370
>> Is this because of a faulty memory?
>> Daniel|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>|||alright. thanks for your help. :)
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
>> so it has nothing to do with buggy programming? As i am using the db with
>> ASP.
>> Thanks,
>> Daniel|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>
Access violation
Hi,
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
Daniel
Access violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post
|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>
|||alright. thanks for your help.
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
Daniel
Access violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post
|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>
|||alright. thanks for your help.
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:
|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>
Access violation
Hi,
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
DanielAccess violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>|||alright. thanks for your help.
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>
I'm having a problem with a particular address location.
I'm using MS SQL Server 2000
I checked the server logs and I see some stack dumps now and then.
I checked the stack dumps and all of them seem to have the same problem.
* BEGIN STACK DUMP:
* 06/14/05 23:18:37 spid 0
*
* Exception Address = 258B6EF6
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 77BEC370
All the stack dumps shows error reading the address 77BEC370
Is this because of a faulty memory?
DanielAccess violations are usually down to one of three things:
1) Faulty hardware
2) Buggy drivers
3) A bug in SQL Server
You would be best advised to call Microsoft Support to discover the
cause, if it's a bug in SQL Server you will get your support call refunded.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>|||so it has nothing to do with buggy programming? As i am using the db with
ASP.
Thanks,
Daniel
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:OrotFVYcFHA.1392@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Access violations are usually down to one of three things:
> 1) Faulty hardware
> 2) Buggy drivers
> 3) A bug in SQL Server
> You would be best advised to call Microsoft Support to discover the cause,
> if it's a bug in SQL Server you will get your support call refunded.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:|||"Daniel Chen" <lifehalo@.yahoo.com.sg> wrote in message
news:d8orha$tli$1@.nobel.pacific.net.sg...
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
Yes ;)
This is internal SQL Server error, the causes Mark Allsion give in previous
post|||*This time* it's not your buggy programming, but could be your buggy
drivers or faulty hardware, or MS's buggy programming. ;-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Daniel Chen wrote:
> so it has nothing to do with buggy programming? As i am using the db with
> ASP.
> Thanks,
> Daniel
>|||alright. thanks for your help.
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:ua59M$YcFHA.2840@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> *This time* it's not your buggy programming, but could be your buggy
> drivers or faulty hardware, or MS's buggy programming. ;-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Daniel Chen wrote:|||I recently had an issue similiar to this where the developers introduced a
READPAST hint into several code bases. I was getting this access violation
and Support recommended a patch (which I couldn't do because I had 36
clusters and couldn't afford to have something different on a few) or put a
clustered index instead of a non-clustered index on the table where the
READPAST hint was being used. That worked like a charm. Don't know if
that's your issue, but thought I'd mention it.
"Daniel Chen" wrote:
> Hi,
> I'm having a problem with a particular address location.
> I'm using MS SQL Server 2000
> I checked the server logs and I see some stack dumps now and then.
> I checked the stack dumps and all of them seem to have the same problem.
> * BEGIN STACK DUMP:
> * 06/14/05 23:18:37 spid 0
> *
> * Exception Address = 258B6EF6
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 77BEC370
> All the stack dumps shows error reading the address 77BEC370
> Is this because of a faulty memory?
> Daniel
>
>
Saturday, February 25, 2012
Access Reports using IP Address
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>
Friday, February 24, 2012
Access Reports using IP Address
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
> >I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web
I
> > get
> > nothing back. I can access Folders List and other properties of any
> > selected
> > report but not able to view the
> > reports from web. I am using a static ip address to access the website
for
> > now.
> >
> > I deployed the reports using the IP address. Any ideas on what could be
> > wrong here?
> >
> > by
> > Raj
> >
> >
>
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
> >I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web
I
> > get
> > nothing back. I can access Folders List and other properties of any
> > selected
> > report but not able to view the
> > reports from web. I am using a static ip address to access the website
for
> > now.
> >
> > I deployed the reports using the IP address. Any ideas on what could be
> > wrong here?
> >
> > by
> > Raj
> >
> >
>
Access Reports using IP Address
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for[vbcol=seagreen]
>
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for[vbcol=seagreen]
>
Access Reports using IP Address
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
Raj
In reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>
|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
I[vbcol=seagreen]
for
>
Access Reports using IP Address
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
> >I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web
I
> > get
> > nothing back. I can access Folders List and other properties of any
> > selected
> > report but not able to view the
> > reports from web. I am using a static ip address to access the website
for
> > now.
> >
> > I deployed the reports using the IP address. Any ideas on what could be
> > wrong here?
> >
> > by
> > Raj
> >
> >
>
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
report but not able to view the
reports from web. I am using a static ip address to access the website for
now.
I deployed the reports using the IP address. Any ideas on what could be
wrong here?
by
RajIn reporting services there is a config setting that tells report manager
where to find report server.
By default it is located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\RSWebApplication.config
You need to change the ReportServerURL element to point to something that
you can 'see' externally. If you cannot see this external URL internally
thiswill break your internal reports.
"MSRS" <Mahashares@.yahoo.com> wrote in message
news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
>I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access Folders List and other properties of any
> selected
> report but not able to view the
> reports from web. I am using a static ip address to access the website for
> now.
> I deployed the reports using the IP address. Any ideas on what could be
> wrong here?
> by
> Raj
>|||Thanks joe.
It is working.
by
Raj
"Joe" <noemail@.noemail.com> wrote in message
news:#nrmssygFHA.3940@.tk2msftngp13.phx.gbl...
> In reporting services there is a config setting that tells report manager
> where to find report server.
> By default it is located at:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\RSWebApplication.config
> You need to change the ReportServerURL element to point to something that
> you can 'see' externally. If you cannot see this external URL internally
> thiswill break your internal reports.
>
> "MSRS" <Mahashares@.yahoo.com> wrote in message
> news:uMfvfkygFHA.3868@.TK2MSFTNGP14.phx.gbl...
> >I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web
I
> > get
> > nothing back. I can access Folders List and other properties of any
> > selected
> > report but not able to view the
> > reports from web. I am using a static ip address to access the website
for
> > now.
> >
> > I deployed the reports using the IP address. Any ideas on what could be
> > wrong here?
> >
> > by
> > Raj
> >
> >
>
Subscribe to:
Posts (Atom)