I get the following error when running a particular query, although I know
for sure the server and network are working properly:
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken"
Is this a hint that something else might be wrong with my sql server?
Any funky characters in the query? If memory servers correctly thats the
message I got when I had a } one time.
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>I get the following error when running a particular query, although I know
> for sure the server and network are working properly:
>
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken"
>
> Is this a hint that something else might be wrong with my sql server?
>
>
|||Hi Chris,
Thank you very much for your reply. No, the query contains no funky
characters such as '{'. If it did that should return a different kind of
error, shouldn't it?
"ChrisR" wrote:
> Any funky characters in the query? If memory servers correctly thats the
> message I got when I had a } one time.
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>
>
|||Not sure as it's been a while...
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:14502176-0C71-4B79-941C-8EF965238B15@.microsoft.com...[vbcol=seagreen]
> Hi Chris,
> Thank you very much for your reply. No, the query contains no funky
> characters such as '{'. If it did that should return a different kind of
> error, shouldn't it?
> "ChrisR" wrote:
Showing posts with label particular. Show all posts
Showing posts with label particular. Show all posts
Sunday, February 26, 2012
Fake "Broken connection" error
Fake "Broken connection" error
I get the following error when running a particular query, although I know
for sure the server and network are working properly:
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckFor
Data
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken"
Is this a hint that something else might be wrong with my sql server?Any funky characters in the query? If memory servers correctly thats the
message I got when I had a } one time.
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>I get the following error when running a particular query, although I know
> for sure the server and network are working properly:
>
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckF
orData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken"
>
> Is this a hint that something else might be wrong with my sql server?
>
>|||Hi Chris,
Thank you very much for your reply. No, the query contains no funky
characters such as '{'. If it did that should return a different kind o
f
error, shouldn't it?
"ChrisR" wrote:
> Any funky characters in the query? If memory servers correctly thats the
> message I got when I had a } one time.
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>
>|||Not sure as it's been a while...
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:14502176-0C71-4B79-941C-8EF965238B15@.microsoft.com...[vbcol=seagreen]
> Hi Chris,
> Thank you very much for your reply. No, the query contains no funky
> characters such as '{'. If it did that should return a different kind
of
> error, shouldn't it?
> "ChrisR" wrote:
>
for sure the server and network are working properly:
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckFor
Data
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken"
Is this a hint that something else might be wrong with my sql server?Any funky characters in the query? If memory servers correctly thats the
message I got when I had a } one time.
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>I get the following error when running a particular query, although I know
> for sure the server and network are working properly:
>
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckF
orData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken"
>
> Is this a hint that something else might be wrong with my sql server?
>
>|||Hi Chris,
Thank you very much for your reply. No, the query contains no funky
characters such as '{'. If it did that should return a different kind o
f
error, shouldn't it?
"ChrisR" wrote:
> Any funky characters in the query? If memory servers correctly thats the
> message I got when I had a } one time.
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>
>|||Not sure as it's been a while...
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:14502176-0C71-4B79-941C-8EF965238B15@.microsoft.com...[vbcol=seagreen]
> Hi Chris,
> Thank you very much for your reply. No, the query contains no funky
> characters such as '{'. If it did that should return a different kind
of
> error, shouldn't it?
> "ChrisR" wrote:
>
Fake "Broken connection" error
I get the following error when running a particular query, although I know
for sure the server and network are working properly:
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken"
Is this a hint that something else might be wrong with my sql server?Any funky characters in the query? If memory servers correctly thats the
message I got when I had a } one time.
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>I get the following error when running a particular query, although I know
> for sure the server and network are working properly:
>
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken"
>
> Is this a hint that something else might be wrong with my sql server?
>
>|||Hi Chris,
Thank you very much for your reply. No, the query contains no funky
characters such as '{'. If it did that should return a different kind of
error, shouldn't it?
"ChrisR" wrote:
> Any funky characters in the query? If memory servers correctly thats the
> message I got when I had a } one time.
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
> >I get the following error when running a particular query, although I know
> > for sure the server and network are working properly:
> >
> >
> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> > (CheckforData()).
> > Server: Msg 11, Level 16, State 1, Line 0
> > General network error. Check your network documentation.
> >
> > Connection Broken"
> >
> >
> > Is this a hint that something else might be wrong with my sql server?
> >
> >
> >
>
>|||Not sure as it's been a while...
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:14502176-0C71-4B79-941C-8EF965238B15@.microsoft.com...
> Hi Chris,
> Thank you very much for your reply. No, the query contains no funky
> characters such as '{'. If it did that should return a different kind of
> error, shouldn't it?
> "ChrisR" wrote:
>> Any funky characters in the query? If memory servers correctly thats the
>> message I got when I had a } one time.
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>> >I get the following error when running a particular query, although I
>> >know
>> > for sure the server and network are working properly:
>> >
>> >
>> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
>> > (CheckforData()).
>> > Server: Msg 11, Level 16, State 1, Line 0
>> > General network error. Check your network documentation.
>> >
>> > Connection Broken"
>> >
>> >
>> > Is this a hint that something else might be wrong with my sql server?
>> >
>> >
>> >
>>
for sure the server and network are working properly:
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken"
Is this a hint that something else might be wrong with my sql server?Any funky characters in the query? If memory servers correctly thats the
message I got when I had a } one time.
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>I get the following error when running a particular query, although I know
> for sure the server and network are working properly:
>
> "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> Connection Broken"
>
> Is this a hint that something else might be wrong with my sql server?
>
>|||Hi Chris,
Thank you very much for your reply. No, the query contains no funky
characters such as '{'. If it did that should return a different kind of
error, shouldn't it?
"ChrisR" wrote:
> Any funky characters in the query? If memory servers correctly thats the
> message I got when I had a } one time.
>
> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
> >I get the following error when running a particular query, although I know
> > for sure the server and network are working properly:
> >
> >
> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
> > (CheckforData()).
> > Server: Msg 11, Level 16, State 1, Line 0
> > General network error. Check your network documentation.
> >
> > Connection Broken"
> >
> >
> > Is this a hint that something else might be wrong with my sql server?
> >
> >
> >
>
>|||Not sure as it's been a while...
"Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
news:14502176-0C71-4B79-941C-8EF965238B15@.microsoft.com...
> Hi Chris,
> Thank you very much for your reply. No, the query contains no funky
> characters such as '{'. If it did that should return a different kind of
> error, shouldn't it?
> "ChrisR" wrote:
>> Any funky characters in the query? If memory servers correctly thats the
>> message I got when I had a } one time.
>>
>> "Ken Abe" <KenAbe@.discussions.microsoft.com> wrote in message
>> news:42E86DB8-21EE-4D35-854A-0D73B416BF9B@.microsoft.com...
>> >I get the following error when running a particular query, although I
>> >know
>> > for sure the server and network are working properly:
>> >
>> >
>> > "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
>> > (CheckforData()).
>> > Server: Msg 11, Level 16, State 1, Line 0
>> > General network error. Check your network documentation.
>> >
>> > Connection Broken"
>> >
>> >
>> > Is this a hint that something else might be wrong with my sql server?
>> >
>> >
>> >
>>
Sunday, February 19, 2012
Failure Sending Mail
Hello all,
I have a particular problem with subscriptions when the subscription is
created by a user who is not an administrator. The problem points to a
permissions issue but I've tried several ways to resolve this without any
luck.
If the subscription is run only selecting a link to the report the
subscription works fine. I've gave the user the same role based permissions
as myself within the report server and set them up with Read & Execute, List
Folder Content and Read access on the Reports and ReportServer within IIS and
the folders are set to use Integrated Windows authentication.
The user can run the report OK and export to any of teh available options
from the list. Any help with this would be much appreciated.
Regards
MikeOn Feb 8, 6:52 am, MikeD <M...@.discussions.microsoft.com> wrote:
> Hello all,
> I have a particular problem with subscriptions when the subscription is
> created by a user who is not an administrator. The problem points to a
> permissions issue but I've tried several ways to resolve this without any
> luck.
> If the subscription is run only selecting a link to the report the
> subscription works fine. I've gave the user the same role based permissions
> as myself within the report server and set them up with Read & Execute, List
> Folder Content and Read access on the Reports and ReportServer within IIS and
> the folders are set to use Integrated Windows authentication.
> The user can run the report OK and export to any of teh available options
> from the list. Any help with this would be much appreciated.
> Regards
> Mike
I had an application that would create a subscription, and what I
found was this:
To create a subscription programmatically the user you are using to
create the subscription must have Content Manager permissions. This
is a System level role that is available under Site Settings on the
Home page, as opposed to the standard roles on the folders.|||Thanks for the info. The user in question has Content Manager role set but
the subscription is not being set programatically, the user is creating the
subscription via the Report Manager web page. As mentioned it only fails when
an attachment is done, it works OK when only a link to th report is included.
"DMcM" wrote:
> On Feb 8, 6:52 am, MikeD <M...@.discussions.microsoft.com> wrote:
> > Hello all,
> >
> > I have a particular problem with subscriptions when the subscription is
> > created by a user who is not an administrator. The problem points to a
> > permissions issue but I've tried several ways to resolve this without any
> > luck.
> >
> > If the subscription is run only selecting a link to the report the
> > subscription works fine. I've gave the user the same role based permissions
> > as myself within the report server and set them up with Read & Execute, List
> > Folder Content and Read access on the Reports and ReportServer within IIS and
> > the folders are set to use Integrated Windows authentication.
> >
> > The user can run the report OK and export to any of teh available options
> > from the list. Any help with this would be much appreciated.
> >
> > Regards
> >
> > Mike
> I had an application that would create a subscription, and what I
> found was this:
> To create a subscription programmatically the user you are using to
> create the subscription must have Content Manager permissions. This
> is a System level role that is available under Site Settings on the
> Home page, as opposed to the standard roles on the folders.
>
I have a particular problem with subscriptions when the subscription is
created by a user who is not an administrator. The problem points to a
permissions issue but I've tried several ways to resolve this without any
luck.
If the subscription is run only selecting a link to the report the
subscription works fine. I've gave the user the same role based permissions
as myself within the report server and set them up with Read & Execute, List
Folder Content and Read access on the Reports and ReportServer within IIS and
the folders are set to use Integrated Windows authentication.
The user can run the report OK and export to any of teh available options
from the list. Any help with this would be much appreciated.
Regards
MikeOn Feb 8, 6:52 am, MikeD <M...@.discussions.microsoft.com> wrote:
> Hello all,
> I have a particular problem with subscriptions when the subscription is
> created by a user who is not an administrator. The problem points to a
> permissions issue but I've tried several ways to resolve this without any
> luck.
> If the subscription is run only selecting a link to the report the
> subscription works fine. I've gave the user the same role based permissions
> as myself within the report server and set them up with Read & Execute, List
> Folder Content and Read access on the Reports and ReportServer within IIS and
> the folders are set to use Integrated Windows authentication.
> The user can run the report OK and export to any of teh available options
> from the list. Any help with this would be much appreciated.
> Regards
> Mike
I had an application that would create a subscription, and what I
found was this:
To create a subscription programmatically the user you are using to
create the subscription must have Content Manager permissions. This
is a System level role that is available under Site Settings on the
Home page, as opposed to the standard roles on the folders.|||Thanks for the info. The user in question has Content Manager role set but
the subscription is not being set programatically, the user is creating the
subscription via the Report Manager web page. As mentioned it only fails when
an attachment is done, it works OK when only a link to th report is included.
"DMcM" wrote:
> On Feb 8, 6:52 am, MikeD <M...@.discussions.microsoft.com> wrote:
> > Hello all,
> >
> > I have a particular problem with subscriptions when the subscription is
> > created by a user who is not an administrator. The problem points to a
> > permissions issue but I've tried several ways to resolve this without any
> > luck.
> >
> > If the subscription is run only selecting a link to the report the
> > subscription works fine. I've gave the user the same role based permissions
> > as myself within the report server and set them up with Read & Execute, List
> > Folder Content and Read access on the Reports and ReportServer within IIS and
> > the folders are set to use Integrated Windows authentication.
> >
> > The user can run the report OK and export to any of teh available options
> > from the list. Any help with this would be much appreciated.
> >
> > Regards
> >
> > Mike
> I had an application that would create a subscription, and what I
> found was this:
> To create a subscription programmatically the user you are using to
> create the subscription must have Content Manager permissions. This
> is a System level role that is available under Site Settings on the
> Home page, as opposed to the standard roles on the folders.
>
Labels:
administrator,
created,
database,
failure,
mail,
microsoft,
mysql,
oracle,
particular,
points,
sending,
server,
sql,
subscription,
subscriptions,
user
Subscribe to:
Posts (Atom)