Error: fcb::close-flush: Operating system error 21(The device is not ready.) encountered

We are using sql server 2005 Enterprise Edition with service pack1

I got the following error messages in the SQL log

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

I got these errors for about 2 hrs and after that I see these messages in the sql log

Starting up database ' ' 1 transactions rolled forward in database '' (). This is an informational message only. No user action is required. 0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required. Recovery is writing a checkpoint in database ' ' ( ). This is an informational message only. No user action is required. CHECKDB for database '' finished without errors on (local time). This is an informational message only; no user action is required.

Can anyone please help me in troubleshooting this issue. Why this migh have happened.

any help would be appreciated.

Thanks

This sounds like an IO subsystem issue, i.e. SQL Server is having difficulty talking to one of your drives. Are you using direct attached storage or a SAN?|||

Thanks for the reply. We have Netapp SCSI disk storage. Could you please tell me how do I troubleshoot this so that I wont get such errors in future.

Thanks

|||Based on this and what you describe in your other post, you really ought to give Microsoft PSS a call.|||

Do read this kb before contacting PSS. You might be running on an unsupported device.

http://support.microsoft.com/kb/304261

Error: CREATE ASSEMBLY for assembly

I am trying to deploy a Database Project with Visual Studio 2005 and SQL Server 2005 Standard.

I import “System.IO” and have therefore set the permission levels to EXTERNAL_ACCESS.

I am receiving the same error message that many folks have received.

CREATE ASSEMBLY for assembly 'Images' failed because assembly 'Images' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.

The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or attached this database, make sure the database owner is mapped to the correct login on this server. If not, use sp_changedbowner to fix the problem. Images.

My CLR access is “on”

I have tried

1) From master run: GRANT EXTERNAL ACCESS ASSEMBLY to [Builtin\Administrators].

2) From master run: GRANT EXTERNAL ACCESS ASSEMBLY to “My Windows Authentication ID”.

3) Run ALTER DATABASE MYDATABASE SET TRUSTWORTHY ON

4) In Visual Studio .NET 2005 Set the permission levels to ‘external’

5) Tried Builtin\Administrators and my SQL Server Windows Authenticated Login ID for the ASSEMBLY OWNER.

I can compile BUT NOT DEPLOY

Any help would be greatly appreciated.

Regards Steve

Who is the owner of the database ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Thanks for the reply.

I am running with Windows Authentication at the present moment , under the ID Administrator1 (running under windows Vista.(still would like to get reporting services to run ) . I did read the article on "Opening up the Administrator ID in Vista and installing SQL Server 2005 under that ID."

Re my current problem....

I managed to get it to deploy. I assigned Administrator1 as an "owner" of the database and gave the ID security administrator rights. I did the same with Builtin/Administrator.

I found something very interesting. I am able to deploy CLR stored precedures from the Visual Studio environment but not CLR functions. (EXTERNAL ACCESS) In order to deply functions I must compile the Dll and create SQL to CREATE the ASSEMBLYfrom within the SQL Server Environment. Any ideas why.?

Once again thanks for the help? Very much appreciated.

Steve

|||

OK Folks this took me about 3 hours to do BUT I have resolved the problem and it WORKS!!!

BTW I am using SQL Server 2005 Standard and Visual Studio.NET Enterprise

First create a Strong key as described in“The secret of strong naming”

DO NOT DODELAY SIGNING !!!!!!

http://www.ondotnet.com/pub/a/dotnet/2003/04/28/strongnaming.html

Sn – k MyKeyFile.snk

FIND OUT WHERE THE SNK FILE WAS COMPILED.

Go into VS2005 .NET and under project / properties in the signing page click the Sign the Assembly check box and browse to find MyKeyFile.snk

The database page

Mark the assembly for external access and leave the owner blank

Now we must go to the article

http://sqljunkies.com/WebLog/ktegels/archive/2006/08/14/safetydancelite.aspx

The text below comes from this article....

A kinder, lighter Safety Dance for the SQLCLR

A few months ago, I published a step-by-step procedure for using certificate to sign an assembly so an external access or unsafe assembly could be run without having to set the hosting database to trustworthy. The major problem with that process was its weight: a lot of steps and some still requirements in terms of certificate management. Turns out that yes, there is an easier way to make it work.

Part one -- preparing the master database

1. As needed, start a series of queries against the MASTER database.

2. Create the target database (meaning execute a CREATE DATABASE query).

3. Code and compile the assembly you want to deploy. Make sure you sign the assembly with a strong name key file. This can be done with a PFX file generated by Visual Studio.

4. Create an asymmetric key from from the compiled assembly using a statement like this: create asymmetric key <key_name> from executable file = '<path_to_dll_file>'

USE Master

GO

create asymmetric key imageskeyFile from executable file = 'C:\YEAR 2007\Images\Images\bin\Debug\Images.dll'

5. Create a login based on that asymmetric key using a statement like this: create login <login_name> from asymmetric key <key_name>

Use Master

Go

create login ImageMaker from asymmetric key imageskeyFile

6. Grant that login the right to create either or both an unsafe or external access assembly (as needed) using: grant unsafe assembly to <login_name>

Use Master

Go

grant EXTERNAL ACCESS assembly to ImageMaker

Part two -- preparing the hosting database

1. As needed, start a series of queries against the desired user database.

2. Create a user in that database mapped to the login created in part, step 5. (e.g. create user <db_user> from login <login_name>)

3. Give that user the right to catalog an assembly, e.g.: grant create assembly to <db_user>

4. Catalog the desired assembly using the now trusted asymmetric key with a statement like: create assembly <assembly_name> authorization <db_user> from '<path_to_dll_file>' with permission_set = unsafe or external access as shown below

SET QUOTED_IDENTIFIER OFF

USE YEAR2007

GO

CREATE ASSEMBLY Images

AUTHORIZATION ImageMaker

FROM "C:\YEAR 2007\Images\Images\bin\Debug\Images.dll"

WITH PERMISSION_SET = EXTERNAL_ACCESS

GO

Error: 5123 CREATE FILE encountered operating system error 5A(Access denied.)

HI ,

This is a problem I encountered when I had to detach a database file (type .mdf):

1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.

2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful

3) However when I tried reattaching the database file, I got this error:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?

Thanks much

Tonante

Dear Tonate,

Please, take a look on the following link and might be it will help you :)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120536&SiteId=1

|||

Hi Tonate,

I got the solution for this. I proud this is my first blog to provide the answer on internet

I got the same error too:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

the solution is:

set the Operating system permission on that .mdf file to full permission to 'Everyone' in new server.

this will helps me to attach the database in other server..

Have a Great Day..

vino...

|||

Well that could be a security issue, its better to give permission to the SQL Server account.

Error: 5123 CREATE FILE encountered operating system error 5A(Access denied.)

HI ,

This is a problem I encountered when I had to detach a database file (type .mdf):

1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.

2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful

3) However when I tried reattaching the database file, I got this error:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?

Thanks much

Tonante

Dear Tonate,

Please, take a look on the following link and might be it will help you :)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120536&SiteId=1

|||

Hi Tonate,

I got the solution for this. I proud this is my first blog to provide the answer on internet

I got the same error too:

CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\<databasename>.mdf'

the solution is:

set the Operating system permission on that .mdf file to full permission to 'Everyone' in new server.

this will helps me to attach the database in other server..

Have a Great Day..

vino...

|||Well that could be a security issue, its better to give permission to the SQL Server account.|||Greetings SQL Server users, I rarely post to forums but think I probably should start doing so. I know this problem was probably solved, but just in case it wasn't, this was my solution to the exact same problem when attempting to do exactly what you tried (detaching, zipping, then re-attaching the database file *.mdf) using SQL Server 2005 with Mgmt Server Studio. First, Stop all SQL services, Secondly, go to the sql folder (default: MSSQL) and right click on it and see if you can change your folder and all subfolder atrributes to NOT read only (unchecked). I noticed that on my server, the log and data files could not be changed. So I immediately went to those files *.ldf and *.mdf and took ownership of both of them (the permissions can easily get wacked). Once I did that, I was able to zip them and move them to safer ground. I then restarted all SQL Services, and was able to re-attach the *.mdf file. If you are like me, you probably log in using a few different usernames and move files around a lot. For some odd reason, our permissions get hosed up from time to time. I hope this helped.

Error: 17805, Severity: 20, State: 3

1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?
Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
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/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?
|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes away
> (In EM, Server Properties. Network Configuration, Restart the server)
> 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/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>
>

Error: 17805, Severity: 20, State: 3

====================================
Microsoft SQL Server 2000 (8.0.760).
Operating System: Microsoft Windows NT 5.2 (3790).
Platform: NT INTEL X86
====================================
We have got an error [Error: 17805, Severity: 20, State: 3]. It just occur
once last week and i am monitoring server, everything looks fine. What may
have caused this error and solutions
Thanks
ontario, canada
db,
http://support.microsoft.com/kb/818897 Need to install SP4
http://support.microsoft.com/kb/832977 DBCC PSS - Need to install SP4
http://support.microsoft.com/kb/827366 .NET programming problem
There are actually many similar problems focused on invalid or malformed
packets from a client. The following search will show you more notes:
http://search.microsoft.com/results.aspx?siteID=1&q=17805&mkt=&mkt=en-US
You are currently at SQL Server 2000 SP3, so upgrading to SP4 is probably
something you should investigate. (Support for SP3 ended in July 2007.)
RLF
"db" <db@.discussions.microsoft.com> wrote in message
news:3944A9A2-252E-437B-A9BD-E6C31F315B71@.microsoft.com...
> ====================================
> Microsoft SQL Server 2000 (8.0.760).
> Operating System: Microsoft Windows NT 5.2 (3790).
> Platform: NT INTEL X86
> ====================================
> We have got an error [Error: 17805, Severity: 20, State: 3]. It just occur
> once last week and i am monitoring server, everything looks fine. What may
> have caused this error and solutions
> Thanks
> --
> ontario, canada

Error: 17805, Severity: 20, State: 3

====================================
Microsoft SQL Server 2000 (8.0.760).
Operating System: Microsoft Windows NT 5.2 (3790).
Platform: NT INTEL X86
====================================
We have got an error [Error: 17805, Severity: 20, State: 3]. It just occ
ur
once last week and i am monitoring server, everything looks fine. What may
have caused this error and solutions
Thanks
ontario, canadadb,
http://support.microsoft.com/kb/818897 Need to install SP4
http://support.microsoft.com/kb/832977 DBCC PSS - Need to install SP4
http://support.microsoft.com/kb/827366 .NET programming problem
There are actually many similar problems focused on invalid or malformed
packets from a client. The following search will show you more notes:
http://search.microsoft.com/results...&mkt=&mkt=en-US
You are currently at SQL Server 2000 SP3, so upgrading to SP4 is probably
something you should investigate. (Support for SP3 ended in July 2007.)
RLF
"db" <db@.discussions.microsoft.com> wrote in message
news:3944A9A2-252E-437B-A9BD-E6C31F315B71@.microsoft.com...
> ====================================
> Microsoft SQL Server 2000 (8.0.760).
> Operating System: Microsoft Windows NT 5.2 (3790).
> Platform: NT INTEL X86
> ====================================
> We have got an error [Error: 17805, Severity: 20, State: 3]. It just o
ccur
> once last week and i am monitoring server, everything looks fine. What may
> have caused this error and solutions
> Thanks
> --
> ontario, canada

Error: 17805, Severity: 20, State: 3

1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
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/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed u
p
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes awa
y
> (In EM, Server Properties. Network Configuration, Restart the server)
> 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/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>
>

Error: 17805, Severity: 20, State: 3

1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
SP4,SQL2k SP4), the system can not run and got the error message in log
Error: 17805, Severity: 20, State: 3
Invalid buffer received from client.
Is this SQL2k SP4 new bug?Hi
No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
at network level, you end up with SQL Server receiving bad packets.
Setup SQL Server to only listen on TCP/IP and see if your problem goes away
(In EM, Server Properties. Network Configuration, Restart the server)
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/
"HB" <HB@.discussions.microsoft.com> wrote in message
news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
>1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> SP4,SQL2k SP4), the system can not run and got the error message in log
> Error: 17805, Severity: 20, State: 3
> Invalid buffer received from client.
> Is this SQL2k SP4 new bug?|||We have this exact issue to, we have got around one issue with inserting or
updating text/image columns by specifying an explicit SQLDbType. But we are
now getting the same issue with other stored procedures. If we amend the sql
client to talk named pipes the the problem goes away, but this is not an
option for us. Any help much appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No, I've seen those errors since SQL Server 6.0. If a packet gets messed up
> at network level, you end up with SQL Server receiving bad packets.
> Setup SQL Server to only listen on TCP/IP and see if your problem goes away
> (In EM, Server Properties. Network Configuration, Restart the server)
> 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/
> "HB" <HB@.discussions.microsoft.com> wrote in message
> news:50B3B161-06D7-4311-8D92-A3E13A5592C4@.microsoft.com...
> >1 system transfer from a server (Win2k SP4,SQL2k SP3) to a server (Win2k
> > SP4,SQL2k SP4), the system can not run and got the error message in log
> >
> > Error: 17805, Severity: 20, State: 3
> > Invalid buffer received from client.
> >
> > Is this SQL2k SP4 new bug?
>
>

Error: 17805, Severity: 20, State: 3

==================================== Microsoft SQL Server 2000 (8.0.760).
Operating System: Microsoft Windows NT 5.2 (3790).
Platform: NT INTEL X86
==================================== We have got an error [Error: 17805, Severity: 20, State: 3]. It just occur
once last week and i am monitoring server, everything looks fine. What may
have caused this error and solutions
Thanks
--
ontario, canadadb,
http://support.microsoft.com/kb/818897 Need to install SP4
http://support.microsoft.com/kb/832977 DBCC PSS - Need to install SP4
http://support.microsoft.com/kb/827366 .NET programming problem
There are actually many similar problems focused on invalid or malformed
packets from a client. The following search will show you more notes:
http://search.microsoft.com/results.aspx?siteID=1&q=17805&mkt=&mkt=en-US
You are currently at SQL Server 2000 SP3, so upgrading to SP4 is probably
something you should investigate. (Support for SP3 ended in July 2007.)
RLF
"db" <db@.discussions.microsoft.com> wrote in message
news:3944A9A2-252E-437B-A9BD-E6C31F315B71@.microsoft.com...
> ====================================> Microsoft SQL Server 2000 (8.0.760).
> Operating System: Microsoft Windows NT 5.2 (3790).
> Platform: NT INTEL X86
> ====================================> We have got an error [Error: 17805, Severity: 20, State: 3]. It just occur
> once last week and i am monitoring server, everything looks fine. What may
> have caused this error and solutions
> Thanks
> --
> ontario, canada

Error: 17059, Severity: 18, State: 0

What does this error mean? The next message was this:
Operating system error 10055: An operation on a socket could not be
performed because the system lacked sufficient buffer space or because a
queue was full...Please disregard. I found the answer here:
http://support.microsoft.com/kb/811274/en-us
"Ron Hinds" <__ron__dontspamme@.wedontlikespam_garageiq.com> wrote in message
news:OnNi9oxiGHA.4512@.TK2MSFTNGP04.phx.gbl...
> What does this error mean? The next message was this:
> Operating system error 10055: An operation on a socket could not be
> performed because the system lacked sufficient buffer space or because a
> queue was full...
>
>

Error: 17059, Severity: 18, State: 0

What does this error mean? The next message was this:
Operating system error 10055: An operation on a socket could not be
performed because the system lacked sufficient buffer space or because a
queue was full...Please disregard. I found the answer here:
http://support.microsoft.com/kb/811274/en-us
"Ron Hinds" < __ron__dontspamme@.wedontlikespam_garagei
q.com> wrote in message
news:OnNi9oxiGHA.4512@.TK2MSFTNGP04.phx.gbl...
> What does this error mean? The next message was this:
> Operating system error 10055: An operation on a socket could not be
> performed because the system lacked sufficient buffer space or because a
> queue was full...
>
>

Error: 17053, Severity: 16, State: 1. Exception 0xAE

I have recieved billions of:
2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
2006-09-22 02:07:06.76 spid11s High priority system task thread:
Operating system error Exception 0xAE encountered.
in my log and it has grown enormous. What is causing this, how can I stop it
and how can i cut my log file out so i can keep it running until we find a
solution?
Bryan
What version and service pack of SQL?
Look at sp_cycle_errorlog to restart the log...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>I have recieved billions of:
> 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
> 2006-09-22 02:07:06.76 spid11s High priority system task thread:
> Operating system error Exception 0xAE encountered.
> in my log and it has grown enormous. What is causing this, how can I stop
> it
> and how can i cut my log file out so i can keep it running until we find a
> solution?
> Bryan
|||It was on SP1 Enterprise Edition.
We called PSS and they recommended putting on hotfix 2153. It has not come
back since. We are still monitoring. Thanks for the tip about rotating the
log.
Bryan
"Kevin3NF" wrote:

> What version and service pack of SQL?
> Look at sp_cycle_errorlog to restart the log...
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>
>
|||Hotfix rollup .2187 is better and more stable. Surprised they didn't take
you there instead.
I assume you meant SQL 2000 sp4, not sp1
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...[vbcol=seagreen]
> It was on SP1 Enterprise Edition.
> We called PSS and they recommended putting on hotfix 2153. It has not come
> back since. We are still monitoring. Thanks for the tip about rotating the
> log.
> Bryan
> "Kevin3NF" wrote:
|||This is Sql 2005, not 2000. We still have the option to goto 2187 if we need
to. We don't have much information on it though.
Is where somewhere where we can get a list of fixes in 2187?
Bryan
"Kevin3NF" wrote:

> Hotfix rollup .2187 is better and more stable. Surprised they didn't take
> you there instead.
> I assume you meant SQL 2000 sp4, not sp1
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...
>
>
|||The only .2187 I know of is a post sp4 rollup.
But, I am completely ignorant in terms of 2005
Email whoever helped you in PSS. THey should answer that qestion without
any haslle, even if the case is already closed.
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:33727070-BAC8-49C3-8222-5AFF0B9738E5@.microsoft.com...[vbcol=seagreen]
> This is Sql 2005, not 2000. We still have the option to goto 2187 if we
> need
> to. We don't have much information on it though.
> Is where somewhere where we can get a list of fixes in 2187?
> Bryan
> "Kevin3NF" wrote:

Error: 17053, Severity: 16, State: 1. Exception 0xAE

I have recieved billions of:
2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
2006-09-22 02:07:06.76 spid11s High priority system task thread:
Operating system error Exception 0xAE encountered.
in my log and it has grown enormous. What is causing this, how can I stop it
and how can i cut my log file out so i can keep it running until we find a
solution?
BryanWhat version and service pack of SQL?
Look at sp_cycle_errorlog to restart the log...
--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>I have recieved billions of:
> 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
> 2006-09-22 02:07:06.76 spid11s High priority system task thread:
> Operating system error Exception 0xAE encountered.
> in my log and it has grown enormous. What is causing this, how can I stop
> it
> and how can i cut my log file out so i can keep it running until we find a
> solution?
> Bryan|||It was on SP1 Enterprise Edition.
We called PSS and they recommended putting on hotfix 2153. It has not come
back since. We are still monitoring. Thanks for the tip about rotating the
log.
Bryan
"Kevin3NF" wrote:

> What version and service pack of SQL?
> Look at sp_cycle_errorlog to restart the log...
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>
>|||Hotfix rollup .2187 is better and more stable. Surprised they didn't take
you there instead.
I assume you meant SQL 2000 sp4, not sp1
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...[vbcol=seagreen]
> It was on SP1 Enterprise Edition.
> We called PSS and they recommended putting on hotfix 2153. It has not come
> back since. We are still monitoring. Thanks for the tip about rotating the
> log.
> Bryan
> "Kevin3NF" wrote:
>|||This is Sql 2005, not 2000. We still have the option to goto 2187 if we need
to. We don't have much information on it though.
Is where somewhere where we can get a list of fixes in 2187?
Bryan
"Kevin3NF" wrote:

> Hotfix rollup .2187 is better and more stable. Surprised they didn't take
> you there instead.
> I assume you meant SQL 2000 sp4, not sp1
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...
>
>|||The only .2187 I know of is a post sp4 rollup.
But, I am completely ignorant in terms of 2005
Email whoever helped you in PSS. THey should answer that qestion without
any haslle, even if the case is already closed.
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:33727070-BAC8-49C3-8222-5AFF0B9738E5@.microsoft.com...[vbcol=seagreen]
> This is Sql 2005, not 2000. We still have the option to goto 2187 if we
> need
> to. We don't have much information on it though.
> Is where somewhere where we can get a list of fixes in 2187?
> Bryan
> "Kevin3NF" wrote:
>

Error: 17053, Severity: 16, State: 1. Exception 0xAE

I have recieved billions of:
2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
2006-09-22 02:07:06.76 spid11s High priority system task thread:
Operating system error Exception 0xAE encountered.
in my log and it has grown enormous. What is causing this, how can I stop it
and how can i cut my log file out so i can keep it running until we find a
solution?
BryanWhat version and service pack of SQL?
Look at sp_cycle_errorlog to restart the log...
--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>I have recieved billions of:
> 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
> 2006-09-22 02:07:06.76 spid11s High priority system task thread:
> Operating system error Exception 0xAE encountered.
> in my log and it has grown enormous. What is causing this, how can I stop
> it
> and how can i cut my log file out so i can keep it running until we find a
> solution?
> Bryan|||It was on SP1 Enterprise Edition.
We called PSS and they recommended putting on hotfix 2153. It has not come
back since. We are still monitoring. Thanks for the tip about rotating the
log.
Bryan
"Kevin3NF" wrote:
> What version and service pack of SQL?
> Look at sp_cycle_errorlog to restart the log...
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
> >I have recieved billions of:
> >
> > 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State: 1.
> > 2006-09-22 02:07:06.76 spid11s High priority system task thread:
> > Operating system error Exception 0xAE encountered.
> >
> > in my log and it has grown enormous. What is causing this, how can I stop
> > it
> > and how can i cut my log file out so i can keep it running until we find a
> > solution?
> >
> > Bryan
>
>|||Hotfix rollup .2187 is better and more stable. Surprised they didn't take
you there instead.
I assume you meant SQL 2000 sp4, not sp1
--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...
> It was on SP1 Enterprise Edition.
> We called PSS and they recommended putting on hotfix 2153. It has not come
> back since. We are still monitoring. Thanks for the tip about rotating the
> log.
> Bryan
> "Kevin3NF" wrote:
>> What version and service pack of SQL?
>> Look at sp_cycle_errorlog to restart the log...
>> --
>> Kevin Hill
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>>
>>
>> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
>> news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>> >I have recieved billions of:
>> >
>> > 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State:
>> > 1.
>> > 2006-09-22 02:07:06.76 spid11s High priority system task thread:
>> > Operating system error Exception 0xAE encountered.
>> >
>> > in my log and it has grown enormous. What is causing this, how can I
>> > stop
>> > it
>> > and how can i cut my log file out so i can keep it running until we
>> > find a
>> > solution?
>> >
>> > Bryan
>>|||This is Sql 2005, not 2000. We still have the option to goto 2187 if we need
to. We don't have much information on it though.
Is where somewhere where we can get a list of fixes in 2187?
Bryan
"Kevin3NF" wrote:
> Hotfix rollup .2187 is better and more stable. Surprised they didn't take
> you there instead.
> I assume you meant SQL 2000 sp4, not sp1
> --
> Kevin Hill
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
>
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...
> > It was on SP1 Enterprise Edition.
> >
> > We called PSS and they recommended putting on hotfix 2153. It has not come
> > back since. We are still monitoring. Thanks for the tip about rotating the
> > log.
> >
> > Bryan
> >
> > "Kevin3NF" wrote:
> >
> >> What version and service pack of SQL?
> >>
> >> Look at sp_cycle_errorlog to restart the log...
> >> --
> >> Kevin Hill
> >> 3NF Consulting
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >>
> >>
> >>
> >> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> >> news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
> >> >I have recieved billions of:
> >> >
> >> > 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16, State:
> >> > 1.
> >> > 2006-09-22 02:07:06.76 spid11s High priority system task thread:
> >> > Operating system error Exception 0xAE encountered.
> >> >
> >> > in my log and it has grown enormous. What is causing this, how can I
> >> > stop
> >> > it
> >> > and how can i cut my log file out so i can keep it running until we
> >> > find a
> >> > solution?
> >> >
> >> > Bryan
> >>
> >>
> >>
>
>|||The only .2187 I know of is a post sp4 rollup.
But, I am completely ignorant in terms of 2005
Email whoever helped you in PSS. THey should answer that qestion without
any haslle, even if the case is already closed.
--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:33727070-BAC8-49C3-8222-5AFF0B9738E5@.microsoft.com...
> This is Sql 2005, not 2000. We still have the option to goto 2187 if we
> need
> to. We don't have much information on it though.
> Is where somewhere where we can get a list of fixes in 2187?
> Bryan
> "Kevin3NF" wrote:
>> Hotfix rollup .2187 is better and more stable. Surprised they didn't
>> take
>> you there instead.
>> I assume you meant SQL 2000 sp4, not sp1
>> --
>> Kevin Hill
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>>
>>
>> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
>> news:5584B7BB-4211-4B2E-96AD-D5323CA959C1@.microsoft.com...
>> > It was on SP1 Enterprise Edition.
>> >
>> > We called PSS and they recommended putting on hotfix 2153. It has not
>> > come
>> > back since. We are still monitoring. Thanks for the tip about rotating
>> > the
>> > log.
>> >
>> > Bryan
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> What version and service pack of SQL?
>> >>
>> >> Look at sp_cycle_errorlog to restart the log...
>> >> --
>> >> Kevin Hill
>> >> 3NF Consulting
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >>
>> >>
>> >>
>> >> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:45F47E8B-4060-418F-8385-1081C52C8D18@.microsoft.com...
>> >> >I have recieved billions of:
>> >> >
>> >> > 2006-09-22 02:07:06.76 spid11s Error: 17053, Severity: 16,
>> >> > State:
>> >> > 1.
>> >> > 2006-09-22 02:07:06.76 spid11s High priority system task thread:
>> >> > Operating system error Exception 0xAE encountered.
>> >> >
>> >> > in my log and it has grown enormous. What is causing this, how can I
>> >> > stop
>> >> > it
>> >> > and how can i cut my log file out so i can keep it running until we
>> >> > find a
>> >> > solution?
>> >> >
>> >> > Bryan
>> >>
>> >>
>> >>
>>

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while performing Fullbackup after a filegroup restore.

System.Data.SqlClient.SqlError: The backup of the file or filegroup "CUSTBilling" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

I did a file group backup and restore of a database and then when I tried to perform a full backup I am getting the above error. Any thoughts. I indeed happen to see this error http://support.microsoft.com/default.aspx/kb/921106 but not sure if both errors are the same.

Santhosh
http://sqlspy.blogspot.comI assume that you did a backup and restore of the CUSTBilling file group? Did you ensure that the filegroup is back online after the restore completed?|||

According to the error message, not all of your filegroups were online when you attempted the full backup.

After your filegroup restore, were all of your filegroups online, or only some of them?

Backup cannot process offline filegroups, and a full backup is defined to process the whole database.

You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

The differential backup message is caused by the fact that you haven't successfully performed a full backup, and so the differential has no base on which to calculate the deltas.

Kevin

|||

I have the same problem.

I had a database on an SQL 2000 server and I copied the data into a new, SQL 2005 Express database that did not have fulltext indexing on. Now I'm trying to back up my database using the GUI, but I still get the error:

System.Data.SqlClient.SqlError: The backup of the file or filegroup is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

There is no setting in the GUI about FILEGROUPs, or if there is, I can't find it. Do I need to write code to backup the database, can't I use the SQL Studio?

Thanks,

Janos

|||I have the same problem.
In my case I detached from 2000 and attached to 2005. The full text is checked

When I try to backup I get this error
Failed-1073548784) Executing the query "BACKUP DATABASE [PublicWorks] TO

" failed with the following error:
"The backup of the file or filegroup "sysft_Plats" is not permitted because it is not online.
BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

How do I get the sysft_Plats on line?
If not what is the FILEGROUP or FILE clauses syntax?

Thanks in advance for your help.
|||Kevin,
How do you do that "You need to either bring all filegroups online, or back up only the online filegroups using the FILEGROUP clause in your BACKUP statement.

Can you tell me how to bring filegroups online?
OR
How to use the FILEGROUP clause?

Thanks in advance for your help

Tarig

Error while invoking AcquireConnections(null)

Hi, I have a windows service which is configured to login under the "local System Account". and the windows service is actually creating a SSIS package and running it. however, it was running good with out any problem. but we had to uninstall and again reinstall the windows service and after that it is generating an error "Exception from HRESULT: 0xC020801C" when ever it is invoking the

Instance.AcquireConnections(null);

The connection string that is given for the connection manager is as follows

Data Source=ORION\OFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;User Id=;Password=;Provider=SQLNCLI.1;Auto translate=false"

What is the wrong here-can any body kindly suggest? I have tried with the following too

Data Source=ORION\OFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto translate=false"

Does SSIS need to have a connection string with SSPI always? is there any way to use a sql authenlication for this purpose? like using sql user name and password in connection string? Please suggest me. I need it badly.

You can use SQL authentication in SSIS. Remove "Integrated Security = SSPI;", and replace it with "Uid=myUsername;Pwd=myPassword;"

Try this link for help with connection strings: http://www.connectionstrings.com/

|||Do you think I need to use the "provider=SQLNCLI.1 ; auto translate = false" when I will use the SQL authentications? I meant if I use the user id and password instead of "ntegrated Security = SSPI" should I remove the provider and auto translate attributes or I need to keep them?|||You'll need to keep them. The provider determines which OLEDB driver you are using - if you omit it, the connect string won't be valid. Auto translate is optional, but I'd leave it in there.|||

Thanks much!

Error while invoking AcquireConnections(null)

Hi, I have a windows service which is configured to login under the "local System Account". and the windows service is actually creating a SSIS package and running it. however, it was running good with out any problem. but we had to uninstall and again reinstall the windows service and after that it is generating an error "Exception from HRESULT: 0xC020801C" when ever it is invoking the

Instance.AcquireConnections(null);

The connection string that is given for the connection manager is as follows

Data Source=ORION\OFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;User Id=;Password=;Provider=SQLNCLI.1;Auto translate=false"

What is the wrong here-can any body kindly suggest? I have tried with the following too

Data Source=ORION\OFFICESERVERS;Initial Catalog=CDBDBase;Integrated Security=SSPI;Provider=SQLNCLI.1;Auto translate=false"

Does SSIS need to have a connection string with SSPI always? is there any way to use a sql authenlication for this purpose? like using sql user name and password in connection string? Please suggest me. I need it badly.

You can use SQL authentication in SSIS. Remove "Integrated Security = SSPI;", and replace it with "Uid=myUsername;Pwd=myPassword;"

Try this link for help with connection strings: http://www.connectionstrings.com/

|||Do you think I need to use the "provider=SQLNCLI.1 ; auto translate = false" when I will use the SQL authentications? I meant if I use the user id and password instead of "ntegrated Security = SSPI" should I remove the provider and auto translate attributes or I need to keep them?|||You'll need to keep them. The provider determines which OLEDB driver you are using - if you omit it, the connect string won't be valid. Auto translate is optional, but I'd leave it in there.|||

Thanks much!