KDC Problem: applications

Showing posts with label applications. Show all posts

Friday, March 30, 2012

Knowledge Base Article - 815154 Configure SQL Server Security for .NET Applications

SEE: http://support.microsoft.com/defaul...kb;en-us;815154
I get through this article and come to a dead stop not understanding
the best way to implement Step 14. Click (and apply) Permissions
to the objects in the database.
Do I as the admin have to check each and every object one at a time?
Do I as the admin have to do all of these steps to each and every database
I would want to configure for access by ASP.NET applications?
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@.REMOVETHISTEXTmetromilwaukee
.com
URL http://www.metromilwaukee.com/clintongallagher/> Do I as the admin have to check each and every object one at a time?
> Do I as the admin have to do all of these steps to each and every database
> I would want to configure for access by ASP.NET applications?
Best practices dictate that you should grant permissions on only those
objects needed by your application. SQL Server doesn't know which objects
your application references nor what permissions (SELECT, UPDATE, etc.) are
required. Consequently, there is no real shortcut for the task.
If your application reads from *all* tables and views directly, you can add
the user to the fixed db_datareader database role. If your application
writes to *all* tables and views, you can add the user to the fixed
db_datarwriter database role. You'll still need to assign stored procedure
execute permissions individually since there is currently no fixed database
role for this.
Your admin might find it easier execute permission scripts using Query
Analyzer rather than the Enterprise Manager if you have a lot of
objects/databases. The script below will generate GRANT statements for all
database objects. You can tweak the script to fit your needs and/or remote
unneeded GRANTs from the generated script.
SET NOCOUNT ON
DECLARE @.Permissions TABLE (Permission nvarchar(10))
INSERT INTO @.Permissions VALUES('SELECT')
INSERT INTO @.Permissions VALUES('INSERT')
INSERT INTO @.Permissions VALUES('UPDATE')
INSERT INTO @.Permissions VALUES('DELETE')
INSERT INTO @.Permissions VALUES('EXECUTE')
SELECT
N'GRANT ' +
[p].[Permission] +
N' ON ' +
QUOTENAME(USER_NAME([o].[uid])) +
N'.' +
QUOTENAME([o].[name]) +
N' TO MyUser'
FROM sysobjects o
CROSS JOIN @.Permissions p
WHERE
OBJECTPROPERTY([o].[id], 'IsMSShipped') = 0 AND
((OBJECTPROPERTY([o].[id], 'IsProcedure') = 1 AND
[p].[Permission] = N'EXECUTE') OR
(OBJECTPROPERTY([o].[id], 'IsUserTable') = 1 AND
[p].[Permission] <> N'EXECUTE') OR
(OBJECTPROPERTY([o].[id], 'IsView') = 1 AND
[p].[Permission] <> N'EXECUTE') OR
(OBJECTPROPERTY([o].[id], 'IsTableFunction') = 1 AND
[p].[Permission] <> N'EXECUTE') OR
(OBJECTPROPERTY([o].[id], 'IsInlineFunction') = 1 AND
[p].[Permission] = N'EXECUTE') OR
(OBJECTPROPERTY([o].[id], 'IsScalarFunction') = 1 AND
[p].[Permission] = N'EXECUTE'))
ORDER BY
[p].[Permission],
USER_NAME([o].[uid]),
[o].[name]
Hope this helps.
Dan Guzman
SQL Server MVP
"clintonG" < csgallagher@.REMOVETHISTEXT@.metromilwauke
e.com> wrote in message
news:OrW5lboJEHA.428@.TK2MSFTNGP11.phx.gbl...
> SEE: http://support.microsoft.com/defaul...kb;en-us;815154
> I get through this article and come to a dead stop not understanding
> the best way to implement Step 14. Click (and apply) Permissions
> to the objects in the database.
> Do I as the admin have to check each and every object one at a time?
> Do I as the admin have to do all of these steps to each and every database
> I would want to configure for access by ASP.NET applications?
> --
> <%= Clinton Gallagher
> A/E/C Consulting, Web Design, e-Commerce Software Development
> Wauwatosa, Milwaukee County, Wisconsin USA
> NET csgallagher@.REMOVETHISTEXTmetromilwaukee
.com
> URL http://www.metromilwaukee.com/clintongallagher/
>|||Yes, your comments helped Dan, thank you. I didn't know the
db_ roles were inclusive in this context and I'll find the script very
useful.
I'm planning to include SQL Server as one of my MCAD electives
but for now remain quite clueless about how to resolve security issues.
For example, why my ASP.NET code can connect to the SQL Server
when using Integrated Security or sa but not when using any other user id
despite the presence of a SQL Server user I thought I had created
correctly.
In fact, I'm starting to understand the entire security model on my
development machine is probably FUBAR as my ASP.NET
applications all seem to run as the NT Authority rather than via the
ASPNET worker process.
Are there any papers you could recommend I read that document
what may be a base security configuration?
<%= Clinton Gallagher
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:OkePvntJEHA.2376@.tk2msftngp13.phx.gbl...
database[vbcol=seagreen]
> Best practices dictate that you should grant permissions on only those
> objects needed by your application. SQL Server doesn't know which objects
> your application references nor what permissions (SELECT, UPDATE, etc.)
are
> required. Consequently, there is no real shortcut for the task.
> If your application reads from *all* tables and views directly, you can
add
> the user to the fixed db_datareader database role. If your application
> writes to *all* tables and views, you can add the user to the fixed
> db_datarwriter database role. You'll still need to assign stored
procedure
> execute permissions individually since there is currently no fixed
database
> role for this.
> Your admin might find it easier execute permission scripts using Query
> Analyzer rather than the Enterprise Manager if you have a lot of
> objects/databases. The script below will generate GRANT statements for
all
> database objects. You can tweak the script to fit your needs and/or
remote
> unneeded GRANTs from the generated script.
> SET NOCOUNT ON
> DECLARE @.Permissions TABLE (Permission nvarchar(10))
> INSERT INTO @.Permissions VALUES('SELECT')
> INSERT INTO @.Permissions VALUES('INSERT')
> INSERT INTO @.Permissions VALUES('UPDATE')
> INSERT INTO @.Permissions VALUES('DELETE')
> INSERT INTO @.Permissions VALUES('EXECUTE')
> SELECT
> N'GRANT ' +
> [p].[Permission] +
> N' ON ' +
> QUOTENAME(USER_NAME([o].[uid])) +
> N'.' +
> QUOTENAME([o].[name]) +
> N' TO MyUser'
> FROM sysobjects o
> CROSS JOIN @.Permissions p
> WHERE
> OBJECTPROPERTY([o].[id], 'IsMSShipped') = 0 AND
> ((OBJECTPROPERTY([o].[id], 'IsProcedure') = 1 AND
> [p].[Permission] = N'EXECUTE') OR
> (OBJECTPROPERTY([o].[id], 'IsUserTable') = 1 AND
> [p].[Permission] <> N'EXECUTE') OR
> (OBJECTPROPERTY([o].[id], 'IsView') = 1 AND
> [p].[Permission] <> N'EXECUTE') OR
> (OBJECTPROPERTY([o].[id], 'IsTableFunction') = 1 AND
> [p].[Permission] <> N'EXECUTE') OR
> (OBJECTPROPERTY([o].[id], 'IsInlineFunction') = 1 AND
> [p].[Permission] = N'EXECUTE') OR
> (OBJECTPROPERTY([o].[id], 'IsScalarFunction') = 1 AND
> [p].[Permission] = N'EXECUTE'))
> ORDER BY
> [p].[Permission],
> USER_NAME([o].[uid]),
> [o].[name]
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "clintonG" < csgallagher@.REMOVETHISTEXT@.metromilwauke
e.com> wrote in
message
> news:OrW5lboJEHA.428@.TK2MSFTNGP11.phx.gbl...
database[vbcol=seagreen]
>|||> Are there any papers you could recommend I read that document
> what may be a base security configuration?
Check out Building Secure ASP.NET Applications
<http://msdn.microsoft.com/library/d...n-us/dnnetsec/h
tml/secnetlpMSDN.asp?frame=true>.
Hope this helps.
Dan Guzman
SQL Server MVP
"clintonG" < csgallagher@.REMOVETHISTEXT@.metromilwauke
e.com> wrote in message
news:OLt8MuvJEHA.3216@.tk2msftngp13.phx.gbl...
> Yes, your comments helped Dan, thank you. I didn't know the
> db_ roles were inclusive in this context and I'll find the script very
> useful.
> I'm planning to include SQL Server as one of my MCAD electives
> but for now remain quite clueless about how to resolve security issues.
> For example, why my ASP.NET code can connect to the SQL Server
> when using Integrated Security or sa but not when using any other user id
> despite the presence of a SQL Server user I thought I had created
> correctly.
> In fact, I'm starting to understand the entire security model on my
> development machine is probably FUBAR as my ASP.NET
> applications all seem to run as the NT Authority rather than via the
> ASPNET worker process.
> Are there any papers you could recommend I read that document
> what may be a base security configuration?
> <%= Clinton Gallagher
>
>
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:OkePvntJEHA.2376@.tk2msftngp13.phx.gbl...
> database
objects[vbcol=seagreen]
> are
> add
> procedure
> database
> all
> remote
> message
> database
>|||That article looks good. Thanks again Dan.
<%= Clinton Gallagher
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:enSrNK0JEHA.4072@.TK2MSFTNGP12.phx.gbl...
> Check out Building Secure ASP.NET Applications
>
<http://msdn.microsoft.com/library/d...n-us/dnnetsec/h
> tml/secnetlpMSDN.asp?frame=true>.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "clintonG" < csgallagher@.REMOVETHISTEXT@.metromilwauke
e.com> wrote in
message
> news:OLt8MuvJEHA.3216@.tk2msftngp13.phx.gbl...
id[vbcol=seagreen]
> objects
etc.)[vbcol=seagreen]
can[vbcol=seagreen]
for[vbcol=seagreen]
Development[vbcol=seagreen]
>

Monday, February 20, 2012

KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on data

Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
|||Looks like MS issued a hot fix for this on the 9th.
http://support.microsoft.com/kb/944099
"Carlos Mendon?a" wrote:

> Hello,
> I work at a Hosting Company in Brazil and we have been experiencing issues
> with managed applications using .NET Framework 2.0 that connect to SQL
> Server 2005 databases with a failover partner. These issues started
> happening after we have applied KB928365
> (http://support.microsoft.com/KB/928365).
> The issue is an System.InvalidOperationException that is thrown every once
> in a while when connecting to the databases. The message is 'Internal .Net
> Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
> databases (SQL Server 2005) are up to date, including all Security Updates
> and Service Packs.
> Although not many use failover partners to be able to reproduce the issue,
> we have identified people with similar problems while searching for the
> exception message in the major search engines. Additionally, the same
> problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
> it has been suggested that KB928365 should be removed, which is not an
> option for us considering the security concerns involved.
> I am posting in the newsgroups in hope of reaching someone from the .NET
> team to report this issue. I think it may be a bug, but it could also be
> some configuration requirement that KB928365 introduced. In either case, it
> is an issue that affect big databases and I believe that we should pay
> special attention to the case.
> I am not familiar with the process of reporting an issue to the .NET and/or
> SQL Server teams and I would appreciate if someone could give me a hint.
> I thank you in advance.
> Carlos Mendon?a
>
>
|||Great news! I will ask for some testing and post the results later.
Thanks a lot,
Carlos
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:93BE8F7C-A008-4096-A570-4264AAAF7B83@.microsoft.com...[vbcol=seagreen]
> Looks like MS issued a hot fix for this on the 9th.
> http://support.microsoft.com/kb/944099
>
> "Carlos Mendona" wrote:
issues[vbcol=seagreen]
once[vbcol=seagreen]
..Net[vbcol=seagreen]
and[vbcol=seagreen]
Updates[vbcol=seagreen]
issue,[vbcol=seagreen]
but[vbcol=seagreen]
it[vbcol=seagreen]
and/or[vbcol=seagreen]
|||The fix is not publically available. You have to get it from MS directly.
-Hank
In article <#VFla#qMIHA.4228@.TK2MSFTNGP02.phx.gbl>, "Carlos Mendona"
<carlos.mendonca@.locaweb.com.br> wrote:
>Great news! I will ask for some testing and post the results later.
>Thanks a lot,
>Carlos
>"Mark" <Mark@.discussions.microsoft.com> wrote in message
>news:93BE8F7C-A008-4096-A570-4264AAAF7B83@.microsoft.com...
>issues
>once
>..Net
>and
>Updates
>issue,
>but
>it
>and/or
>
|||Did anyone already receive and test this hotfix ?
I also noticed the kb944099 is talking about version 2.0.50727.948 of
system.data.dll
Today I received Microsoft .NET Framework 2.0 SP1 on Windows update, this
Service pack contains version 2.0.50727.1433 of system.dat.dll and is
superseding KB928365. So this sould also fix this problem.
Anyone already tried 1 of this solutions ?
Kind regrards
Tom
"Mark" wrote:
[vbcol=seagreen]
> Looks like MS issued a hot fix for this on the 9th.
> http://support.microsoft.com/kb/944099
>
> "Carlos Mendon?a" wrote:
|||We did and we confirm it does work. MS indeed solved the problem.
Regards,
Carlos Mendona
"treg" <treg@.discussions.microsoft.com> wrote in message
news:61E93D99-B384-43CB-BCD2-1BF49895AD1D@.microsoft.com...[vbcol=seagreen]
> Did anyone already receive and test this hotfix ?
> I also noticed the kb944099 is talking about version 2.0.50727.948 of
> system.data.dll
> Today I received Microsoft .NET Framework 2.0 SP1 on Windows update, this
> Service pack contains version 2.0.50727.1433 of system.dat.dll and is
> superseding KB928365. So this sould also fix this problem.
> Anyone already tried 1 of this solutions ?
> Kind regrards
> Tom
>
> "Mark" wrote:
issues[vbcol=seagreen]
once[vbcol=seagreen]
..Net[vbcol=seagreen]
2003) and[vbcol=seagreen]
Updates[vbcol=seagreen]
issue,[vbcol=seagreen]
the[vbcol=seagreen]
'microsoft.public.dotnet.framework.adonet', but[vbcol=seagreen]
..NET[vbcol=seagreen]
be[vbcol=seagreen]
case, it[vbcol=seagreen]
and/or[vbcol=seagreen]
hint.[vbcol=seagreen]
|||We are still seeing this intermittently. The web server reporting the error,
along with the live and mirror database servers, all have .NET 2.0 SP1,
System.Data.dll version 2.0.507272.1433. KB944099 talks of a hotfix version
2.0.507272.948 and I would assume that SP1 includes this fix, but it appears
not to have fixed the problem in our case.
Any suggestions?
|||We raised this with MS PSS. They confirmed it was not fixed in SP1 and they
gave us the hotfix, which appears to have fixed it.

KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on data

Hello,
I work at a Hosting Company in Brazil and we have been experiencing issues
with managed applications using .NET Framework 2.0 that connect to SQL
Server 2005 databases with a failover partner. These issues started
happening after we have applied KB928365
(http://support.microsoft.com/KB/928365).
The issue is an System.InvalidOperationException that is thrown every once
in a while when connecting to the databases. The message is 'Internal .Net
Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
databases (SQL Server 2005) are up to date, including all Security Updates
and Service Packs.
Although not many use failover partners to be able to reproduce the issue,
we have identified people with similar problems while searching for the
exception message in the major search engines. Additionally, the same
problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
it has been suggested that KB928365 should be removed, which is not an
option for us considering the security concerns involved.
I am posting in the newsgroups in hope of reaching someone from the .NET
team to report this issue. I think it may be a bug, but it could also be
some configuration requirement that KB928365 introduced. In either case, it
is an issue that affect big databases and I believe that we should pay
special attention to the case.
I am not familiar with the process of reporting an issue to the .NET and/or
SQL Server teams and I would appreciate if someone could give me a hint.
I thank you in advance.
Carlos MendonçaThis probably occurred a while back for you. Were you able to see any
resolution? I am seeing the same symptoms as you.
Thank you.
Kevin Burton
"Carlos MendonÃ§a" wrote:
> Hello,
> I work at a Hosting Company in Brazil and we have been experiencing issues
> with managed applications using .NET Framework 2.0 that connect to SQL
> Server 2005 databases with a failover partner. These issues started
> happening after we have applied KB928365
> (http://support.microsoft.com/KB/928365).
> The issue is an System.InvalidOperationException that is thrown every once
> in a while when connecting to the databases. The message is 'Internal .Net
> Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
> databases (SQL Server 2005) are up to date, including all Security Updates
> and Service Packs.
> Although not many use failover partners to be able to reproduce the issue,
> we have identified people with similar problems while searching for the
> exception message in the major search engines. Additionally, the same
> problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
> it has been suggested that KB928365 should be removed, which is not an
> option for us considering the security concerns involved.
> I am posting in the newsgroups in hope of reaching someone from the .NET
> team to report this issue. I think it may be a bug, but it could also be
> some configuration requirement that KB928365 introduced. In either case, it
> is an issue that affect big databases and I believe that we should pay
> special attention to the case.
> I am not familiar with the process of reporting an issue to the .NET and/or
> SQL Server teams and I would appreciate if someone could give me a hint.
> I thank you in advance.
> Carlos MendonÃ§a
>
>|||--
Ian H
"Carlos MendonÃ§a" wrote:
> Hello,
> I work at a Hosting Company in Brazil and we have been experiencing issues
> with managed applications using .NET Framework 2.0 that connect to SQL
> Server 2005 databases with a failover partner. These issues started
> happening after we have applied KB928365
> (http://support.microsoft.com/KB/928365).
> The issue is an System.InvalidOperationException that is thrown every once
> in a while when connecting to the databases. The message is 'Internal .Net
> Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
> databases (SQL Server 2005) are up to date, including all Security Updates
> and Service Packs.
> Although not many use failover partners to be able to reproduce the issue,
> we have identified people with similar problems while searching for the
> exception message in the major search engines. Additionally, the same
> problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
> it has been suggested that KB928365 should be removed, which is not an
> option for us considering the security concerns involved.
> I am posting in the newsgroups in hope of reaching someone from the .NET
> team to report this issue. I think it may be a bug, but it could also be
> some configuration requirement that KB928365 introduced. In either case, it
> is an issue that affect big databases and I believe that we should pay
> special attention to the case.
> I am not familiar with the process of reporting an issue to the .NET and/or
> SQL Server teams and I would appreciate if someone could give me a hint.
> I thank you in advance.
> Carlos MendonÃ§a
>
>
Hi Carlos,
I am experiencing this very same problem. Have you had any luck working out
what it is?
Thanks
Ian|||Unfortunately we have still not found any solution to the problem. One thing
I would suggest, though, would be to set up Counter Logs in the client, the
server and the database server to trace the following objects:
SQL Server: General Statistics Login/sec and Logout/sec
SQL Server: General Statistics User Connections
.NET CLR Data : SqlClient: Current # of pooled and non pooled connections
.NET CLR Data : SqlClient: Current # pooled connections
.NET CLR Data : SqlClient: Current # connection pools
.NET CLR Data : SqlClient: Peak # pooled connections
.NET CLR Data : SqlClient: Total # failed connects
The reason for this is that if you analyze the stack trace of the exception,
you will see that it is being raised in the CreateObject method right after
it checks whether the connection can be pooled (use a disassembler such as
Reflector to open the
System.Data.ProviderBase.DbConnectionPool.CreateObject() method @.
System.Data.dll). In other words, the KB928365 *MAY* have changed number of
default pools or the way they are allocated or whatever and by tracing them,
it may be possible to see if fine tuning the connection string could solve
the problem we're experiencing.
Of course, Microsoft could always shed a light on this issue since more and
more people are finding out about it...
Yours,
Carlos Mendonça
"Ian Hannah" <IanHannah@.discussions.microsoft.com> wrote in message
news:35DF7C2A-62F9-489E-8470-10CD3A8E60A1@.microsoft.com...
> --
> Ian H
>
> "Carlos Mendonça" wrote:
> > Hello,
> >
> > I work at a Hosting Company in Brazil and we have been experiencing
issues
> > with managed applications using .NET Framework 2.0 that connect to SQL
> > Server 2005 databases with a failover partner. These issues started
> > happening after we have applied KB928365
> > (http://support.microsoft.com/KB/928365).
> >
> > The issue is an System.InvalidOperationException that is thrown every
once
> > in a while when connecting to the databases. The message is 'Internal
.Net
> > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
and
> > databases (SQL Server 2005) are up to date, including all Security
Updates
> > and Service Packs.
> >
> > Although not many use failover partners to be able to reproduce the
issue,
> > we have identified people with similar problems while searching for the
> > exception message in the major search engines. Additionally, the same
> > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
but
> > it has been suggested that KB928365 should be removed, which is not an
> > option for us considering the security concerns involved.
> >
> > I am posting in the newsgroups in hope of reaching someone from the .NET
> > team to report this issue. I think it may be a bug, but it could also be
> > some configuration requirement that KB928365 introduced. In either case,
it
> > is an issue that affect big databases and I believe that we should pay
> > special attention to the case.
> >
> > I am not familiar with the process of reporting an issue to the .NET
and/or
> > SQL Server teams and I would appreciate if someone could give me a hint.
> >
> > I thank you in advance.
> >
> > Carlos Mendonça
> >
> >
> >
> Hi Carlos,
> I am experiencing this very same problem. Have you had any luck working
out
> what it is?
> Thanks
> Ian|||We have been experiencing the exact same issue and currently have an open
support ticket with Microsoft to try and resolve the problem.
Interestingly, if you check the application event logs on the failover sql
server you should see an event like this (at the exact time of the .Net error
6):
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 4/09/2007
Time: 1:59:39 PM
The event log entry also reports the client IP address and the username that
tried to connect but for security reasons I'm not including that information
here.
We have 4 installations that use database mirroring and all of them are
experiencing this issue. I don't believe we have installed KB928365 due to
strict testing policy on windows updates prior to rollout on production
servers.
Jason.
"Carlos MendonÃ§a" wrote:
> Hello,
> I work at a Hosting Company in Brazil and we have been experiencing issues
> with managed applications using .NET Framework 2.0 that connect to SQL
> Server 2005 databases with a failover partner. These issues started
> happening after we have applied KB928365
> (http://support.microsoft.com/KB/928365).
> The issue is an System.InvalidOperationException that is thrown every once
> in a while when connecting to the databases. The message is 'Internal .Net
> Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
> databases (SQL Server 2005) are up to date, including all Security Updates
> and Service Packs.
> Although not many use failover partners to be able to reproduce the issue,
> we have identified people with similar problems while searching for the
> exception message in the major search engines. Additionally, the same
> problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
> it has been suggested that KB928365 should be removed, which is not an
> option for us considering the security concerns involved.
> I am posting in the newsgroups in hope of reaching someone from the .NET
> team to report this issue. I think it may be a bug, but it could also be
> some configuration requirement that KB928365 introduced. In either case, it
> is an issue that affect big databases and I believe that we should pay
> special attention to the case.
> I am not familiar with the process of reporting an issue to the .NET and/or
> SQL Server teams and I would appreciate if someone could give me a hint.
> I thank you in advance.
> Carlos MendonÃ§a
>
>|||Dear Jason,
We too confirm that the event is being reported in the Application log in
the exact same way you saw it. It doesn't say much more regarding the
problem, though. What has been Microsoft's position regarding this issue so
far? Has there been any progress whatsoever in the ticket you have opened?
Thanks,
Carlos Mendonça
"Jason Coombes" <Jason Coombes@.discussions.microsoft.com> wrote in message
news:93115343-E17E-452B-982A-78DC4EDC353D@.microsoft.com...
> We have been experiencing the exact same issue and currently have an open
> support ticket with Microsoft to try and resolve the problem.
> Interestingly, if you check the application event logs on the failover sql
> server you should see an event like this (at the exact time of the .Net
error
> 6):
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 18456
> Date: 4/09/2007
> Time: 1:59:39 PM
> The event log entry also reports the client IP address and the username
that
> tried to connect but for security reasons I'm not including that
information
> here.
> We have 4 installations that use database mirroring and all of them are
> experiencing this issue. I don't believe we have installed KB928365 due
to
> strict testing policy on windows updates prior to rollout on production
> servers.
> Jason.
> "Carlos Mendonça" wrote:
> > Hello,
> >
> > I work at a Hosting Company in Brazil and we have been experiencing
issues
> > with managed applications using .NET Framework 2.0 that connect to SQL
> > Server 2005 databases with a failover partner. These issues started
> > happening after we have applied KB928365
> > (http://support.microsoft.com/KB/928365).
> >
> > The issue is an System.InvalidOperationException that is thrown every
once
> > in a while when connecting to the databases. The message is 'Internal
.Net
> > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
and
> > databases (SQL Server 2005) are up to date, including all Security
Updates
> > and Service Packs.
> >
> > Although not many use failover partners to be able to reproduce the
issue,
> > we have identified people with similar problems while searching for the
> > exception message in the major search engines. Additionally, the same
> > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
but
> > it has been suggested that KB928365 should be removed, which is not an
> > option for us considering the security concerns involved.
> >
> > I am posting in the newsgroups in hope of reaching someone from the .NET
> > team to report this issue. I think it may be a bug, but it could also be
> > some configuration requirement that KB928365 introduced. In either case,
it
> > is an issue that affect big databases and I believe that we should pay
> > special attention to the case.
> >
> > I am not familiar with the process of reporting an issue to the .NET
and/or
> > SQL Server teams and I would appreciate if someone could give me a hint.
> >
> > I thank you in advance.
> >
> > Carlos Mendonça
> >
> >
> >|||Hi Carlos,
The person handling the support ticket has been in daily contact with me
(experience of MS tech support has been excellent) but nothing to report so
far. I did find an application which had accidentally been configured so
that the 2nd server was being connected to first instead of as a failover.
This has made it harder for me to prove my case but now that has been
resolved connections are still hitting the 2nd db server.
Am expecting another call back tomorrow when we will review the logs again
and see if any further connections have been rejected.
Jason.
"Carlos MendonÃ§a" wrote:
> Dear Jason,
> We too confirm that the event is being reported in the Application log in
> the exact same way you saw it. It doesn't say much more regarding the
> problem, though. What has been Microsoft's position regarding this issue so
> far? Has there been any progress whatsoever in the ticket you have opened?
> Thanks,
> Carlos MendonÃ§a
> "Jason Coombes" <Jason Coombes@.discussions.microsoft.com> wrote in message
> news:93115343-E17E-452B-982A-78DC4EDC353D@.microsoft.com...
> > We have been experiencing the exact same issue and currently have an open
> > support ticket with Microsoft to try and resolve the problem.
> >
> > Interestingly, if you check the application event logs on the failover sql
> > server you should see an event like this (at the exact time of the .Net
> error
> > 6):
> >
> > Event Type: Failure Audit
> > Event Source: MSSQLSERVER
> > Event Category: (4)
> > Event ID: 18456
> > Date: 4/09/2007
> > Time: 1:59:39 PM
> >
> > The event log entry also reports the client IP address and the username
> that
> > tried to connect but for security reasons I'm not including that
> information
> > here.
> >
> > We have 4 installations that use database mirroring and all of them are
> > experiencing this issue. I don't believe we have installed KB928365 due
> to
> > strict testing policy on windows updates prior to rollout on production
> > servers.
> >
> > Jason.
> >
> > "Carlos MendonÃ§a" wrote:
> >
> > > Hello,
> > >
> > > I work at a Hosting Company in Brazil and we have been experiencing
> issues
> > > with managed applications using .NET Framework 2.0 that connect to SQL
> > > Server 2005 databases with a failover partner. These issues started
> > > happening after we have applied KB928365
> > > (http://support.microsoft.com/KB/928365).
> > >
> > > The issue is an System.InvalidOperationException that is thrown every
> once
> > > in a while when connecting to the databases. The message is 'Internal
> ..Net
> > > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
> and
> > > databases (SQL Server 2005) are up to date, including all Security
> Updates
> > > and Service Packs.
> > >
> > > Although not many use failover partners to be able to reproduce the
> issue,
> > > we have identified people with similar problems while searching for the
> > > exception message in the major search engines. Additionally, the same
> > > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
> but
> > > it has been suggested that KB928365 should be removed, which is not an
> > > option for us considering the security concerns involved.
> > >
> > > I am posting in the newsgroups in hope of reaching someone from the .NET
> > > team to report this issue. I think it may be a bug, but it could also be
> > > some configuration requirement that KB928365 introduced. In either case,
> it
> > > is an issue that affect big databases and I believe that we should pay
> > > special attention to the case.
> > >
> > > I am not familiar with the process of reporting an issue to the .NET
> and/or
> > > SQL Server teams and I would appreciate if someone could give me a hint.
> > >
> > > I thank you in advance.
> > >
> > > Carlos MendonÃ§a
> > >
> > >
> > >
>
>|||We are also experiencing the exact same issue. Please let us know the
resolution. Many Many thanks...!
Cheers
Andy
"Jason Coombes" wrote:
> Hi Carlos,
> The person handling the support ticket has been in daily contact with me
> (experience of MS tech support has been excellent) but nothing to report so
> far. I did find an application which had accidentally been configured so
> that the 2nd server was being connected to first instead of as a failover.
> This has made it harder for me to prove my case but now that has been
> resolved connections are still hitting the 2nd db server.
> Am expecting another call back tomorrow when we will review the logs again
> and see if any further connections have been rejected.
> Jason.
> "Carlos MendonÃ§a" wrote:
> > Dear Jason,
> >
> > We too confirm that the event is being reported in the Application log in
> > the exact same way you saw it. It doesn't say much more regarding the
> > problem, though. What has been Microsoft's position regarding this issue so
> > far? Has there been any progress whatsoever in the ticket you have opened?
> >
> > Thanks,
> >
> > Carlos MendonÃ§a
> >
> > "Jason Coombes" <Jason Coombes@.discussions.microsoft.com> wrote in message
> > news:93115343-E17E-452B-982A-78DC4EDC353D@.microsoft.com...
> > > We have been experiencing the exact same issue and currently have an open
> > > support ticket with Microsoft to try and resolve the problem.
> > >
> > > Interestingly, if you check the application event logs on the failover sql
> > > server you should see an event like this (at the exact time of the .Net
> > error
> > > 6):
> > >
> > > Event Type: Failure Audit
> > > Event Source: MSSQLSERVER
> > > Event Category: (4)
> > > Event ID: 18456
> > > Date: 4/09/2007
> > > Time: 1:59:39 PM
> > >
> > > The event log entry also reports the client IP address and the username
> > that
> > > tried to connect but for security reasons I'm not including that
> > information
> > > here.
> > >
> > > We have 4 installations that use database mirroring and all of them are
> > > experiencing this issue. I don't believe we have installed KB928365 due
> > to
> > > strict testing policy on windows updates prior to rollout on production
> > > servers.
> > >
> > > Jason.
> > >
> > > "Carlos MendonÃ§a" wrote:
> > >
> > > > Hello,
> > > >
> > > > I work at a Hosting Company in Brazil and we have been experiencing
> > issues
> > > > with managed applications using .NET Framework 2.0 that connect to SQL
> > > > Server 2005 databases with a failover partner. These issues started
> > > > happening after we have applied KB928365
> > > > (http://support.microsoft.com/KB/928365).
> > > >
> > > > The issue is an System.InvalidOperationException that is thrown every
> > once
> > > > in a while when connecting to the databases. The message is 'Internal
> > ..Net
> > > > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
> > and
> > > > databases (SQL Server 2005) are up to date, including all Security
> > Updates
> > > > and Service Packs.
> > > >
> > > > Although not many use failover partners to be able to reproduce the
> > issue,
> > > > we have identified people with similar problems while searching for the
> > > > exception message in the major search engines. Additionally, the same
> > > > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
> > but
> > > > it has been suggested that KB928365 should be removed, which is not an
> > > > option for us considering the security concerns involved.
> > > >
> > > > I am posting in the newsgroups in hope of reaching someone from the .NET
> > > > team to report this issue. I think it may be a bug, but it could also be
> > > > some configuration requirement that KB928365 introduced. In either case,
> > it
> > > > is an issue that affect big databases and I believe that we should pay
> > > > special attention to the case.
> > > >
> > > > I am not familiar with the process of reporting an issue to the .NET
> > and/or
> > > > SQL Server teams and I would appreciate if someone could give me a hint.
> > > >
> > > > I thank you in advance.
> > > >
> > > > Carlos MendonÃ§a
> > > >
> > > >
> > > >
> >
> >
> >|||On Oct 5, 11:39 am, Andy <A...@.discussions.microsoft.com> wrote:
> We are also experiencing the exact same issue. Please let us know the
> resolution. Many Many thanks...!
> Cheers
> Andy
> "Jason Coombes" wrote:
> > Hi Carlos,
> > The person handling the support ticket has been in daily contact with me
> > (experience of MS tech support has been excellent) but nothing to repor=t so
> > far. I did find an application which had accidentally been configured =so
> > that the 2nd server was being connected to first instead of as a failov=er.
> > This has made it harder for me to prove my case but now that has been
> > resolved connections are still hitting the 2nd db server.
> > Am expecting another call back tomorrow when we will review the logs ag=ain
> > and see if any further connections have been rejected.
> > Jason.
> > "Carlos Mendon=E7a" wrote:
> > > Dear Jason,
> > > We too confirm that the event is being reported in the Application lo=g in
> > > the exact same way you saw it. It doesn't say much more regarding the
> > > problem, though. What has been Microsoft's position regarding this is=sue so
> > > far? Has there been any progress whatsoever in the ticket you have op=ened?
> > > Thanks,
> > > Carlos Mendon=E7a
> > > "Jason Coombes" <Jason Coom...@.discussions.microsoft.com> wrote in me=ssage
> > >news:93115343-E17E-452B-982A-78DC4EDC353D@.microsoft.com...
> > > > We have been experiencing the exact same issue and currently have a=n open
> > > > support ticket with Microsoft to try and resolve the problem.
> > > > Interestingly, if you check the application event logs on the failo=ver sql
> > > > server you should see an event like this (at the exact time of the =.Net
> > > error
> > > > 6):
> > > > Event Type: Failure Audit
> > > > Event Source: MSSQLSERVER
> > > > Event Category: (4)
> > > > Event ID: 18456
> > > > Date: 4/09/2007
> > > > Time: 1:59:39 PM
> > > > The event log entry also reports the client IP address and the user=name
> > > that
> > > > tried to connect but for security reasons I'm not including that
> > > information
> > > > here.
> > > > We have 4 installations that use database mirroring and all of them= are
> > > > experiencing this issue. I don't believe we have installed KB92836=5 due
> > > to
> > > > strict testing policy on windows updates prior to rollout on produc=tion
> > > > servers.
> > > > Jason.
> > > > "Carlos Mendon=E7a" wrote:
> > > > > Hello,
> > > > > I work at a Hosting Company in Brazil and we have been experienci=ng
> > > issues
> > > > > with managed applications using .NET Framework 2.0 that connect t=o SQL
> > > > > Server 2005 databases with a failover partner. These issues start=ed
> > > > > happening after we have applied KB928365
> > > > > (http://support.microsoft.com/KB/928365).
> > > > > The issue is an System.InvalidOperationException that is thrown e=very
> > > once
> > > > > in a while when connecting to the databases. The message is 'Inte=rnal
> > > ..Net
> > > > > Framework Data Provider error 6.'. Both Operating System (Windows= 2003)
> > > and
> > > > > databases (SQL Server 2005) are up to date, including all Security
> > > Updates
> > > > > and Service Packs.
> > > > > Although not many use failover partners to be able to reproduce t=he
> > > issue,
> > > > > we have identified people with similar problems while searching f=or the
> > > > > exception message in the major search engines. Additionally, the =same
> > > > > problem has been reported at 'microsoft.public.dotnet.framework.a=donet',
> > > but
> > > > > it has been suggested that KB928365 should be removed, which is n=ot an
> > > > > option for us considering the security concerns involved.
> > > > > I am posting in the newsgroups in hope of reaching someone from t=he .NET
> > > > > team to report this issue. I think it may be a bug, but it could =also be
> > > > > some configuration requirement that KB928365 introduced. In eithe=r case,
> > > it
> > > > > is an issue that affect big databases and I believe that we shoul=d pay
> > > > > special attention to the case.
> > > > > I am not familiar with the process of reporting an issue to the .=NET
> > > and/or
> > > > > SQL Server teams and I would appreciate if someone could give me =a hint.
> > > > > I thank you in advance.
> > > > > Carlos Mendon=E7a
I had the same issue, and found a fix for it. In my case i was running
the app on the same server as the principal database. Application
referenced to itself via hostname and caused an issue, unless you
specify an IP of machine instead, and/or move the app to a completely
different server.|||That's not our case. Thanks for the tip, though.
Carlos Mendonça
<alexey.volochenko@.gmail.com> wrote in message
news:1192551324.006100.106030@.e34g2000pro.googlegroups.com...
On Oct 5, 11:39 am, Andy <A...@.discussions.microsoft.com> wrote:
> We are also experiencing the exact same issue. Please let us know the
> resolution. Many Many thanks...!
> Cheers
> Andy
> "Jason Coombes" wrote:
> > Hi Carlos,
> > The person handling the support ticket has been in daily contact with me
> > (experience of MS tech support has been excellent) but nothing to report
so
> > far. I did find an application which had accidentally been configured
so
> > that the 2nd server was being connected to first instead of as a
failover.
> > This has made it harder for me to prove my case but now that has been
> > resolved connections are still hitting the 2nd db server.
> > Am expecting another call back tomorrow when we will review the logs
again
> > and see if any further connections have been rejected.
> > Jason.
> > "Carlos Mendonça" wrote:
> > > Dear Jason,
> > > We too confirm that the event is being reported in the Application log
in
> > > the exact same way you saw it. It doesn't say much more regarding the
> > > problem, though. What has been Microsoft's position regarding this
issue so
> > > far? Has there been any progress whatsoever in the ticket you have
opened?
> > > Thanks,
> > > Carlos Mendonça
> > > "Jason Coombes" <Jason Coom...@.discussions.microsoft.com> wrote in
message
> > >news:93115343-E17E-452B-982A-78DC4EDC353D@.microsoft.com...
> > > > We have been experiencing the exact same issue and currently have an
open
> > > > support ticket with Microsoft to try and resolve the problem.
> > > > Interestingly, if you check the application event logs on the
failover sql
> > > > server you should see an event like this (at the exact time of the
.Net
> > > error
> > > > 6):
> > > > Event Type: Failure Audit
> > > > Event Source: MSSQLSERVER
> > > > Event Category: (4)
> > > > Event ID: 18456
> > > > Date: 4/09/2007
> > > > Time: 1:59:39 PM
> > > > The event log entry also reports the client IP address and the
username
> > > that
> > > > tried to connect but for security reasons I'm not including that
> > > information
> > > > here.
> > > > We have 4 installations that use database mirroring and all of them
are
> > > > experiencing this issue. I don't believe we have installed KB928365
due
> > > to
> > > > strict testing policy on windows updates prior to rollout on
production
> > > > servers.
> > > > Jason.
> > > > "Carlos Mendonça" wrote:
> > > > > Hello,
> > > > > I work at a Hosting Company in Brazil and we have been
experiencing
> > > issues
> > > > > with managed applications using .NET Framework 2.0 that connect to
SQL
> > > > > Server 2005 databases with a failover partner. These issues
started
> > > > > happening after we have applied KB928365
> > > > > (http://support.microsoft.com/KB/928365).
> > > > > The issue is an System.InvalidOperationException that is thrown
every
> > > once
> > > > > in a while when connecting to the databases. The message is
'Internal
> > > ..Net
> > > > > Framework Data Provider error 6.'. Both Operating System (Windows
2003)
> > > and
> > > > > databases (SQL Server 2005) are up to date, including all Security
> > > Updates
> > > > > and Service Packs.
> > > > > Although not many use failover partners to be able to reproduce
the
> > > issue,
> > > > > we have identified people with similar problems while searching
for the
> > > > > exception message in the major search engines. Additionally, the
same
> > > > > problem has been reported at
'microsoft.public.dotnet.framework.adonet',
> > > but
> > > > > it has been suggested that KB928365 should be removed, which is
not an
> > > > > option for us considering the security concerns involved.
> > > > > I am posting in the newsgroups in hope of reaching someone from
the .NET
> > > > > team to report this issue. I think it may be a bug, but it could
also be
> > > > > some configuration requirement that KB928365 introduced. In either
case,
> > > it
> > > > > is an issue that affect big databases and I believe that we should
pay
> > > > > special attention to the case.
> > > > > I am not familiar with the process of reporting an issue to the
.NET
> > > and/or
> > > > > SQL Server teams and I would appreciate if someone could give me a
hint.
> > > > > I thank you in advance.
> > > > > Carlos Mendonça
I had the same issue, and found a fix for it. In my case i was running
the app on the same server as the principal database. Application
referenced to itself via hostname and caused an issue, unless you
specify an IP of machine instead, and/or move the app to a completely
different server.|||Our app server and database servers are on different boxes. We do have the
failover setup on the database though.
Anyone has the solution?
"alexey.volochenko@.gmail.com" wrote:
> On Oct 5, 11:39 am, Andy <A...@.discussions.microsoft.com> wrote:
> > We are also experiencing the exact same issue. Please let us know the
> > resolution. Many Many thanks...!
> >
> > Cheers
> > Andy
> >
> > "Jason Coombes" wrote:
> > > Hi Carlos,
> >
> > > The person handling the support ticket has been in daily contact with me
> > > (experience of MS tech support has been excellent) but nothing to report so
> > > far. I did find an application which had accidentally been configured so
> > > that the 2nd server was being connected to first instead of as a failover.
> > > This has made it harder for me to prove my case but now that has been
> > > resolved connections are still hitting the 2nd db server.
> >
> > > Am expecting another call back tomorrow when we will review the logs again
> > > and see if any further connections have been rejected.
> >
> > > Jason.
> >
> > > "Carlos MendonÃ§a" wrote:
> >
> > > > Dear Jason,
> >
> > > > We too confirm that the event is being reported in the Application log in
> > > > the exact same way you saw it. It doesn't say much more regarding the
> > > > problem, though. What has been Microsoft's position regarding this issue so
> > > > far? Has there been any progress whatsoever in the ticket you have opened?
> >
> > > > Thanks,
> >
> > > > Carlos MendonÃ§a
> >
> > > > "Jason Coombes" <Jason Coom...@.discussions.microsoft.com> wrote in message
> > > >news:93115343-E17E-452B-982A-78DC4EDC353D@.microsoft.com...
> > > > > We have been experiencing the exact same issue and currently have an open
> > > > > support ticket with Microsoft to try and resolve the problem.
> >
> > > > > Interestingly, if you check the application event logs on the failover sql
> > > > > server you should see an event like this (at the exact time of the ..Net
> > > > error
> > > > > 6):
> >
> > > > > Event Type: Failure Audit
> > > > > Event Source: MSSQLSERVER
> > > > > Event Category: (4)
> > > > > Event ID: 18456
> > > > > Date: 4/09/2007
> > > > > Time: 1:59:39 PM
> >
> > > > > The event log entry also reports the client IP address and the username
> > > > that
> > > > > tried to connect but for security reasons I'm not including that
> > > > information
> > > > > here.
> >
> > > > > We have 4 installations that use database mirroring and all of them are
> > > > > experiencing this issue. I don't believe we have installed KB928365 due
> > > > to
> > > > > strict testing policy on windows updates prior to rollout on production
> > > > > servers.
> >
> > > > > Jason.
> >
> > > > > "Carlos MendonÃ§a" wrote:
> >
> > > > > > Hello,
> >
> > > > > > I work at a Hosting Company in Brazil and we have been experiencing
> > > > issues
> > > > > > with managed applications using .NET Framework 2.0 that connect to SQL
> > > > > > Server 2005 databases with a failover partner. These issues started
> > > > > > happening after we have applied KB928365
> > > > > > (http://support.microsoft.com/KB/928365).
> >
> > > > > > The issue is an System.InvalidOperationException that is thrown every
> > > > once
> > > > > > in a while when connecting to the databases. The message is 'Internal
> > > > ..Net
> > > > > > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
> > > > and
> > > > > > databases (SQL Server 2005) are up to date, including all Security
> > > > Updates
> > > > > > and Service Packs.
> >
> > > > > > Although not many use failover partners to be able to reproduce the
> > > > issue,
> > > > > > we have identified people with similar problems while searching for the
> > > > > > exception message in the major search engines. Additionally, the same
> > > > > > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
> > > > but
> > > > > > it has been suggested that KB928365 should be removed, which is not an
> > > > > > option for us considering the security concerns involved.
> >
> > > > > > I am posting in the newsgroups in hope of reaching someone from the .NET
> > > > > > team to report this issue. I think it may be a bug, but it could also be
> > > > > > some configuration requirement that KB928365 introduced. In either case,
> > > > it
> > > > > > is an issue that affect big databases and I believe that we should pay
> > > > > > special attention to the case.
> >
> > > > > > I am not familiar with the process of reporting an issue to the .NET
> > > > and/or
> > > > > > SQL Server teams and I would appreciate if someone could give me a hint.
> >
> > > > > > I thank you in advance.
> >
> > > > > > Carlos MendonÃ§a
> I had the same issue, and found a fix for it. In my case i was running
> the app on the same server as the principal database. Application
> referenced to itself via hostname and caused an issue, unless you
> specify an IP of machine instead, and/or move the app to a completely
> different server.
>|||I'm posting the stack trace we've captured. Please reply below if you have
captured something different.
System.InvalidOperationException: Internal .Net Framework Data Provider
error 6.
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at (..) <-- our propetary code begins here
The error code comes from the System.Data.Common.ADP.InternalErrorCode
enumerator (value NewObjectCannotBePooled = 6).
Unfortunately, this problem still has no solution and Microsoft is yet to
disclose some information regarding this issue. Up until now, as far as I
know, they haven't acknowledged nor identified the error.
Carlos
"Carlos Mendonça" <carlos.mendonca@.locaweb.com.br> wrote in message
news:%23vZY99r3HHA.4880@.TK2MSFTNGP03.phx.gbl...
> Hello,
> I work at a Hosting Company in Brazil and we have been experiencing issues
> with managed applications using .NET Framework 2.0 that connect to SQL
> Server 2005 databases with a failover partner. These issues started
> happening after we have applied KB928365
> (http://support.microsoft.com/KB/928365).
> The issue is an System.InvalidOperationException that is thrown every once
> in a while when connecting to the databases. The message is 'Internal .Net
> Framework Data Provider error 6.'. Both Operating System (Windows 2003)
and
> databases (SQL Server 2005) are up to date, including all Security Updates
> and Service Packs.
> Although not many use failover partners to be able to reproduce the issue,
> we have identified people with similar problems while searching for the
> exception message in the major search engines. Additionally, the same
> problem has been reported at 'microsoft.public.dotnet.framework.adonet',
but
> it has been suggested that KB928365 should be removed, which is not an
> option for us considering the security concerns involved.
> I am posting in the newsgroups in hope of reaching someone from the .NET
> team to report this issue. I think it may be a bug, but it could also be
> some configuration requirement that KB928365 introduced. In either case,
it
> is an issue that affect big databases and I believe that we should pay
> special attention to the case.
> I am not familiar with the process of reporting an issue to the .NET
and/or
> SQL Server teams and I would appreciate if someone could give me a hint.
> I thank you in advance.
> Carlos Mendonça
>|||Looks like MS issued a hot fix for this on the 9th.
http://support.microsoft.com/kb/944099
"Carlos MendonÃ§a" wrote:
> Hello,
> I work at a Hosting Company in Brazil and we have been experiencing issues
> with managed applications using .NET Framework 2.0 that connect to SQL
> Server 2005 databases with a failover partner. These issues started
> happening after we have applied KB928365
> (http://support.microsoft.com/KB/928365).
> The issue is an System.InvalidOperationException that is thrown every once
> in a while when connecting to the databases. The message is 'Internal .Net
> Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
> databases (SQL Server 2005) are up to date, including all Security Updates
> and Service Packs.
> Although not many use failover partners to be able to reproduce the issue,
> we have identified people with similar problems while searching for the
> exception message in the major search engines. Additionally, the same
> problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
> it has been suggested that KB928365 should be removed, which is not an
> option for us considering the security concerns involved.
> I am posting in the newsgroups in hope of reaching someone from the .NET
> team to report this issue. I think it may be a bug, but it could also be
> some configuration requirement that KB928365 introduced. In either case, it
> is an issue that affect big databases and I believe that we should pay
> special attention to the case.
> I am not familiar with the process of reporting an issue to the .NET and/or
> SQL Server teams and I would appreciate if someone could give me a hint.
> I thank you in advance.
> Carlos MendonÃ§a
>
>|||Great news! I will ask for some testing and post the results later.
Thanks a lot,
Carlos
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:93BE8F7C-A008-4096-A570-4264AAAF7B83@.microsoft.com...
> Looks like MS issued a hot fix for this on the 9th.
> http://support.microsoft.com/kb/944099
>
> "Carlos Mendonça" wrote:
> > Hello,
> >
> > I work at a Hosting Company in Brazil and we have been experiencing
issues
> > with managed applications using .NET Framework 2.0 that connect to SQL
> > Server 2005 databases with a failover partner. These issues started
> > happening after we have applied KB928365
> > (http://support.microsoft.com/KB/928365).
> >
> > The issue is an System.InvalidOperationException that is thrown every
once
> > in a while when connecting to the databases. The message is 'Internal
.Net
> > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
and
> > databases (SQL Server 2005) are up to date, including all Security
Updates
> > and Service Packs.
> >
> > Although not many use failover partners to be able to reproduce the
issue,
> > we have identified people with similar problems while searching for the
> > exception message in the major search engines. Additionally, the same
> > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
but
> > it has been suggested that KB928365 should be removed, which is not an
> > option for us considering the security concerns involved.
> >
> > I am posting in the newsgroups in hope of reaching someone from the .NET
> > team to report this issue. I think it may be a bug, but it could also be
> > some configuration requirement that KB928365 introduced. In either case,
it
> > is an issue that affect big databases and I believe that we should pay
> > special attention to the case.
> >
> > I am not familiar with the process of reporting an issue to the .NET
and/or
> > SQL Server teams and I would appreciate if someone could give me a hint.
> >
> > I thank you in advance.
> >
> > Carlos Mendonça
> >
> >
> >|||The fix is not publically available. You have to get it from MS directly.
-Hank
In article <#VFla#qMIHA.4228@.TK2MSFTNGP02.phx.gbl>, "Carlos Mendonça"
<carlos.mendonca@.locaweb.com.br> wrote:
>Great news! I will ask for some testing and post the results later.
>Thanks a lot,
>Carlos
>"Mark" <Mark@.discussions.microsoft.com> wrote in message
>news:93BE8F7C-A008-4096-A570-4264AAAF7B83@.microsoft.com...
>> Looks like MS issued a hot fix for this on the 9th.
>> http://support.microsoft.com/kb/944099
>>
>> "Carlos Mendonça" wrote:
>> > Hello,
>> >
>> > I work at a Hosting Company in Brazil and we have been experiencing
>issues
>> > with managed applications using .NET Framework 2.0 that connect to SQL
>> > Server 2005 databases with a failover partner. These issues started
>> > happening after we have applied KB928365
>> > (http://support.microsoft.com/KB/928365).
>> >
>> > The issue is an System.InvalidOperationException that is thrown every
>once
>> > in a while when connecting to the databases. The message is 'Internal
>..Net
>> > Framework Data Provider error 6.'. Both Operating System (Windows 2003)
>and
>> > databases (SQL Server 2005) are up to date, including all Security
>Updates
>> > and Service Packs.
>> >
>> > Although not many use failover partners to be able to reproduce the
>issue,
>> > we have identified people with similar problems while searching for the
>> > exception message in the major search engines. Additionally, the same
>> > problem has been reported at 'microsoft.public.dotnet.framework.adonet',
>but
>> > it has been suggested that KB928365 should be removed, which is not an
>> > option for us considering the security concerns involved.
>> >
>> > I am posting in the newsgroups in hope of reaching someone from the .NET
>> > team to report this issue. I think it may be a bug, but it could also be
>> > some configuration requirement that KB928365 introduced. In either case,
>it
>> > is an issue that affect big databases and I believe that we should pay
>> > special attention to the case.
>> >
>> > I am not familiar with the process of reporting an issue to the .NET
>and/or
>> > SQL Server teams and I would appreciate if someone could give me a hint.
>> >
>> > I thank you in advance.
>> >
>> > Carlos Mendonça
>> >
>> >
>> >
>|||Did anyone already receive and test this hotfix ?
I also noticed the kb944099 is talking about version 2.0.50727.948 of
system.data.dll
Today I received Microsoft .NET Framework 2.0 SP1 on Windows update, this
Service pack contains version 2.0.50727.1433 of system.dat.dll and is
superseding KB928365. So this sould also fix this problem.
Anyone already tried 1 of this solutions ?
Kind regrards
Tom
"Mark" wrote:
> Looks like MS issued a hot fix for this on the 9th.
> http://support.microsoft.com/kb/944099
>
> "Carlos MendonÃ§a" wrote:
> > Hello,
> >
> > I work at a Hosting Company in Brazil and we have been experiencing issues
> > with managed applications using .NET Framework 2.0 that connect to SQL
> > Server 2005 databases with a failover partner. These issues started
> > happening after we have applied KB928365
> > (http://support.microsoft.com/KB/928365).
> >
> > The issue is an System.InvalidOperationException that is thrown every once
> > in a while when connecting to the databases. The message is 'Internal .Net
> > Framework Data Provider error 6.'. Both Operating System (Windows 2003) and
> > databases (SQL Server 2005) are up to date, including all Security Updates
> > and Service Packs.
> >
> > Although not many use failover partners to be able to reproduce the issue,
> > we have identified people with similar problems while searching for the
> > exception message in the major search engines. Additionally, the same
> > problem has been reported at 'microsoft.public.dotnet.framework.adonet', but
> > it has been suggested that KB928365 should be removed, which is not an
> > option for us considering the security concerns involved.
> >
> > I am posting in the newsgroups in hope of reaching someone from the .NET
> > team to report this issue. I think it may be a bug, but it could also be
> > some configuration requirement that KB928365 introduced. In either case, it
> > is an issue that affect big databases and I believe that we should pay
> > special attention to the case.
> >
> > I am not familiar with the process of reporting an issue to the .NET and/or
> > SQL Server teams and I would appreciate if someone could give me a hint.
> >
> > I thank you in advance.
> >
> > Carlos MendonÃ§a
> >
> >
> >|||We did and we confirm it does work. MS indeed solved the problem.
Regards,
Carlos Mendonça
"treg" <treg@.discussions.microsoft.com> wrote in message
news:61E93D99-B384-43CB-BCD2-1BF49895AD1D@.microsoft.com...
> Did anyone already receive and test this hotfix ?
> I also noticed the kb944099 is talking about version 2.0.50727.948 of
> system.data.dll
> Today I received Microsoft .NET Framework 2.0 SP1 on Windows update, this
> Service pack contains version 2.0.50727.1433 of system.dat.dll and is
> superseding KB928365. So this sould also fix this problem.
> Anyone already tried 1 of this solutions ?
> Kind regrards
> Tom
>
> "Mark" wrote:
> > Looks like MS issued a hot fix for this on the 9th.
> >
> > http://support.microsoft.com/kb/944099
> >
> >
> > "Carlos Mendonça" wrote:
> >
> > > Hello,
> > >
> > > I work at a Hosting Company in Brazil and we have been experiencing
issues
> > > with managed applications using .NET Framework 2.0 that connect to SQL
> > > Server 2005 databases with a failover partner. These issues started
> > > happening after we have applied KB928365
> > > (http://support.microsoft.com/KB/928365).
> > >
> > > The issue is an System.InvalidOperationException that is thrown every
once
> > > in a while when connecting to the databases. The message is 'Internal
.Net
> > > Framework Data Provider error 6.'. Both Operating System (Windows
2003) and
> > > databases (SQL Server 2005) are up to date, including all Security
Updates
> > > and Service Packs.
> > >
> > > Although not many use failover partners to be able to reproduce the
issue,
> > > we have identified people with similar problems while searching for
the
> > > exception message in the major search engines. Additionally, the same
> > > problem has been reported at
'microsoft.public.dotnet.framework.adonet', but
> > > it has been suggested that KB928365 should be removed, which is not an
> > > option for us considering the security concerns involved.
> > >
> > > I am posting in the newsgroups in hope of reaching someone from the
.NET
> > > team to report this issue. I think it may be a bug, but it could also
be
> > > some configuration requirement that KB928365 introduced. In either
case, it
> > > is an issue that affect big databases and I believe that we should pay
> > > special attention to the case.
> > >
> > > I am not familiar with the process of reporting an issue to the .NET
and/or
> > > SQL Server teams and I would appreciate if someone could give me a
hint.
> > >
> > > I thank you in advance.
> > >
> > > Carlos Mendonça
> > >
> > >
> > >|||We are still seeing this intermittently. The web server reporting the error,
along with the live and mirror database servers, all have .NET 2.0 SP1,
System.Data.dll version 2.0.507272.1433. KB944099 talks of a hotfix version
2.0.507272.948 and I would assume that SP1 includes this fix, but it appears
not to have fixed the problem in our case.
Any suggestions?|||We are seeing this problem almost once or twice per hour. We also have SP1
and of course could not install the hot fix as it fixes pre-SP1 code. Can
someone from MS please advise. We need a solution.
Thank you
Val|||We raised this with MS PSS. They confirmed it was not fixed in SP1 and they
gave us the hotfix, which appears to have fixed it.|||David,
What was the hotfix? Was it 928365?
Thanks
Chris
"David Brazier" <DavidBrazier@.discussions.microsoft.com> wrote in message
news:D9DF446F-68FF-47D3-8AC5-6A08548036BF@.microsoft.com...
> We raised this with MS PSS. They confirmed it was not fixed in SP1 and
> they
> gave us the hotfix, which appears to have fixed it.|||It was the hotfix described in KB 944099.
http://support.microsoft.com/kb/944099
"Chris Wood" wrote:
> What was the hotfix? Was it 928365?|||So David what is the new version of this DLL? 948 or 1433?
Chris
"David Brazier" <DavidBrazier@.discussions.microsoft.com> wrote in message
news:EB5872A8-2068-417A-BE7D-314D1C749D55@.microsoft.com...
> It was the hotfix described in KB 944099.
> http://support.microsoft.com/kb/944099
> "Chris Wood" wrote:
>> What was the hotfix? Was it 928365?
>|||Our System.Data.dll is now version 2.0.50727.1813 after the hotfix. Looking
at the KB article again, I see that says the fixed version is 2.0.50727.948.
But that was pre-SP1 and I am guessing that they had to apply a new fix
post-SP1, as it didn't make it into SP1 itself.
"Chris Wood" wrote:
> So David what is the new version of this DLL? 948 or 1433?|||David,
SO MS provided the fix when you reported the problem. Maybe they have a post
SP1 version and have not updated the KB article.
Chris
"David Brazier" <DavidBrazier@.discussions.microsoft.com> wrote in message
news:8AB78D88-26DD-4449-9815-E21C67866662@.microsoft.com...
> Our System.Data.dll is now version 2.0.50727.1813 after the hotfix.
> Looking
> at the KB article again, I see that says the fixed version is
> 2.0.50727.948.
> But that was pre-SP1 and I am guessing that they had to apply a new fix
> post-SP1, as it didn't make it into SP1 itself.
> "Chris Wood" wrote:
>> So David what is the new version of this DLL? 948 or 1433?
>|||Yes, we reported it to MS support & they provided the hotfix. You're right,
the KB article should have been updated or replaced post-SP1.
"Chris Wood" wrote:
> SO MS provided the fix when you reported the problem. Maybe they have a post
> SP1 version and have not updated the KB article.|||http://support.microsoft.com/kb/948815

Friday, March 30, 2012

Knowledge Base Article - 815154 Configure SQL Server Security for .NET Applications

Monday, February 20, 2012

KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on data

KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on data

KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on data

KB928365 and 'Internal .Net Framework Data Provider error 6' issue with .NET 2.0 on data

KDC Problem

Blog Archive

About Me