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: copy database wizard

SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
ACCOUNT.
YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.
Hi,
Yes, The copy database wizard requires the write permissions in destination
server folder. So you should start the SQL Server in both the servers using
domain user which got write access to the destination server folder.
How to change the startup SQL server account:-
1. Go to Control Panel -- Admin tools -- Services
2, Double click MSSQL server services
3. Go to Log on option and change the start up account and password to a
domain user.
4. Do the same for both servers
5. restart both sql servers.
(I feel like you are starting SQL server in Local system account.)
Thanks
Hari
MCDBA
"new" <anonymous@.discussions.microsoft.com> wrote in message
news:a8ce01c4368d$098b76c0$a401280a@.phx.gbl...
> SQL SERVER SERVICE IS RUNNING UNDER THE LOCAL SYSTEM
> ACCOUNT.
> YOU NEED TO CHANGE YOUR SQL SERVER SERVICE ACCOUNT TO
> HAVE THE RIGHTS TO COPY FILES OVER THE NETWORK.

Error: An error occurred due to no connection

This error is for Nov RTM running under "NETWORK SERVICE" account.

I created a data source "MyDataSource". It looks like:
<DataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" xsi:type="RelationalDataSource" dwd:design-time-name="2d2b4fc8-af5c-4314-9155-384afd11fb70" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ID>MyDataSource</ID>
<Name>MyDataSource</Name>
<CreatedTimestamp>0001-01-01T05:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T05:00:00Z</LastSchemaUpdate>
<ConnectionString>Provider=SQLOLEDB.1;Data Source=dbserver\my_instance;Integrated Security=SSPI;Initial Catalog=MyDataSource</ConnectionString>
<ConnectionStringSecurity>Unchanged</ConnectionStringSecurity>
<ImpersonationInfo>
<ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>
<ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
</ImpersonationInfo>
<Timeout>PT0S</Timeout>
</DataSource>

In my package, I obtain a new connection from the data source (test connection succeeds). I use a data flow task. Inside the data flow task I have a flat file source and an Ole Db Destination. For configuring OleDbDestination, I can see in the drop-down a list of tables in my database. When I select the desired table and click "preview", I get:
TITLE: Microsoft Visual Studio

Error at Data Flow Task - my task [OLE DB Destination [831]]: An error occurred due to no connection. A connection is required when requesting metadata.

--
ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC0202022 (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

OK
TIA,
Nitesh

Can you please check that you are not working with "Work Offline" settings.

error: 40 - Could not open a connection

I am developing a web service that uses a sql data connection.

The sql database is on a server, and the development version of my web service is on my pc.

I can connect/access the data accross my network when I run the service on my PC, but as soon as I put the web service onto the server(with the sql) it displays, the service wont function - error: 40 - could not open a connection....

I presume that sql is configured correctly as I am recieving data back when I request it accross the network. I dont understand why it wont work when I have the service on the server with the sql?

Any help will be appreciated.

Do you mean your web service and SQL server are on the same machine? Can you post your connection string here? On which account your web service is running?|||

Yes they are both on the same server

"Data Source=SV1;Initial Catalog=SiteVisitSQL;Integrated security=sspi"

My web service is running on IUSR_SV1, I have created an account for the database/user in Microsoft SQL Server Management Studio Express

Ive never configured anything like this before so any help is much appreciated.

|||

Thanks for all your help

I solved this by adding a user for NT AUTHORITY\NETWORK SERVICE in SQL Management studio

Error: 18456 Severity: 14, State: 10

I have SQL 2005 Expess installed on Windows Server 2003 SP1.

My application is running as a service and is set to depend on SQL Server instance...
During the startup my app attempts to connect to the databes and it fails to do so,
after 30 retries (1second appart). SQL Server log has this error msg:
Error: 18456 "Severity: 14, State: 10"

Once the server has started, I cam manually start my application and it then sucesfully
opens a connection to the database.

What does this error mean?

Srdjan

Hi Srdjan,

Looks like you are getting a login failed error:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

How is your app connecting to your db? If you are using Windows authentication, it could be that the service account you are using when running your app as a service does not have permission to log on to the database.

Sung

|||

This error seems to only be reachable when using SQL Authentication, but I'm not sure what could cause it.

You can start SQL Server with "-y 18456", to produce a dump when the error occurs. As the dump will happen during authentication, the login password might appear in it, so you should use a bogus test password for the purpose of the creating this dump, just in case. Once you have the dump, please open a report at https://connect.microsoft.com/feedback/default.aspx?SiteID=68, attach the dump, and mention my name in the report, so it will get assigned to me.

If you can repro this issue with a smaller application that attempts the same connection on startup, you could attach that application as well, so we can attempt to repro the issue in our labs.

Thanks
Laurentiu

|||tried a couple of times to post a bug report...
but getting errors from the web site.

Anyway, new information:

if I run using Windows authentication, error is the ame but
state is now 16.

Still, after loging in - I have no problem starting the same service that failed during automatic startup.

Even the simplest windows servce that just opens connection
behaves the same...

Thanks,
Srdjan|||

State 16 means there was an error in determining the database to be used by the connection. Can you still connect if you start your application manually?

Thanks
Laurentiu

|||yes, as soon as I log in, I can start my application manually.
During Startup my application fails to start because of the unhandled exception thrown from Sql.Client:

System.Data.SqlClient.SqlException: Cannot open database "Db_260" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
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()

Also here are couple of lines from the SQL errorlog file during machine startup:
2006-07-15 13:56:39.67 spid8s Clearing tempdb database.
2006-07-15 13:56:39.71 Logon Error: 18456, Severity: 14, State: 16.
2006-07-15 13:56:39.71 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2006-07-15 13:56:39.95 Logon Error: 18456, Severity: 14, State: 16.
2006-07-15 13:56:39.95 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2006-07-15 13:56:40.34 spid8s Starting up database 'tempdb'.
2006-07-15 13:56:40.45 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-07-15 13:56:40.46 spid11s The Service Broker protocol transport is disabled or not configured.
2006-07-15 13:56:40.46 spid11s The Database Mirroring protocol transport is disabled or not configured.
2006-07-15 13:56:40.56 spid11s Service Broker manager has started.
2006-07-15 13:56:44.78 spid51 Starting up database 'ReportServer$TRBR'.
2006-07-15 13:56:45.09 spid52 Starting up database 'Db_260'.
2006-07-15 13:57:38.96 Server Server resumed execution after being idle 25 seconds: user activity awakened the server. This is an informational message only. No user action is required.

Srdjan|||

You are trying to connect to database Db_260, but the database has not been started up yet. If you will look in the log, you'll see that the server is accepting connections before starting up the database Db_260, so the requests that you make before the database startup will fail. You should take this into account and retry to connect after a delay, to give time to the server to start up the database.

Thanks
Laurentiu

|||Laurentiu,

My code actually retries until it gets connection succesfully.
The problem is that after a couple of failed atempts, I actally get a success, but then it is the the next attempt to connect to database fails with the exception:

Login Failed for user 'NT AUTHORITY SYSTEM'...

Now, I've tried to postpone the first call to database for up to
3 minutes (more is not practical) and nothing really changes,
I get the same behaviour (System.Data.SqlClient.SqlException) on the second call to database...

Srdjan

|||

Are you saying that you get login failure errors after the database is started up? The log excerpt from your previous message doesn't show that. Can you post your errorlog from beginning up to and including the first couple of login failures that you get AFTER the Db_260 database was started up?

Thanks
Laurentiu

|||Laurentiu,

I managed to get around this problem...
My original code that was checking if SQL is ready was simply opening a connection but didn't execute any dabase commands.

For some reason at one point one of these attempts would successed, but then on the first real database access, exception was thrown.

So, I now do retries on the first real access to datbase and that seems to work.

I appreciate your help.

Srdjan
|||

Hi Laurentiu,

I am having a similar problem when after programmatically creating a database I try to create a table, if I do not put an arbitrarily large delay before issuing the create table statement, I get this same "Error: 18456, Severity: 14, State: 16."

Is there any way to issue a SQL statement and block on the call until a new database has been fully initialized and started before continuing? Alternatively, is there a way to get a callback once the DB is online?, Finally, if neither of the previous are possible, is there any entry in the master DB that one could poll to see when the new DB is up and running? I've tried the ovbious state in sys.databases, and Database.Status in DMO with no luck.

Any ideas? Thanks in advance!

GDM

|||

If you are getting a login failed message, it sounds like you are executing the CREATE DATABASE and CREATE TABLE statements on two different connections. Have you considered executing these statements using the same connection? If you would execute the CREATE TABLE after the CREATE DATABASE, on the same connection, you would not see such a failure.

The state you can query is state_desc in sys.databases - if it is ONLINE, it means the database was started.

Thanks
Laurentiu

|||How do i start sql server with "-y 18456"|||

Start->Run...->services.msc

Then go to the SQL Server service and stop it. Then Click <Properties> and in the <Start Parameters> field enter -y 18456. You can then click <Start> to restart the server with that parameter and then press cancel to exit without saving the parameter, so that future restarts won't use it. If you press OK, then the server will be restarted with that parameter - you probably don't want that.

Thanks
Laurentiu

|||

Ok I have an issue here....I am trying to do a full system recovery and this is what I am getting...

File/minint/system32/biosinfo.inf could not be loaded the error is code 14 ?

And I do NOT have the Windows XP Disk either...so if theres a way around this please by all means help me .......

can some please help me with this please

Error: 18456 Severity: 14, State: 10

I have SQL 2005 Expess installed on Windows Server 2003 SP1.

My application is running as a service and is set to depend on SQL Server instance...
During the startup my app attempts to connect to the databes and it fails to do so,
after 30 retries (1second appart). SQL Server log has this error msg:
Error: 18456 "Severity: 14, State: 10"

Once the server has started, I cam manually start my application and it then sucesfully
opens a connection to the database.

What does this error mean?

Srdjan

Hi Srdjan,

Looks like you are getting a login failed error:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

How is your app connecting to your db? If you are using Windows authentication, it could be that the service account you are using when running your app as a service does not have permission to log on to the database.

Sung

|||

This error seems to only be reachable when using SQL Authentication, but I'm not sure what could cause it.

You can start SQL Server with "-y 18456", to produce a dump when the error occurs. As the dump will happen during authentication, the login password might appear in it, so you should use a bogus test password for the purpose of the creating this dump, just in case. Once you have the dump, please open a report at https://connect.microsoft.com/feedback/default.aspx?SiteID=68, attach the dump, and mention my name in the report, so it will get assigned to me.

If you can repro this issue with a smaller application that attempts the same connection on startup, you could attach that application as well, so we can attempt to repro the issue in our labs.

Thanks
Laurentiu

|||tried a couple of times to post a bug report...
but getting errors from the web site.

Anyway, new information:

if I run using Windows authentication, error is the ame but
state is now 16.

Still, after loging in - I have no problem starting the same service that failed during automatic startup.

Even the simplest windows servce that just opens connection
behaves the same...

Thanks,
Srdjan|||

State 16 means there was an error in determining the database to be used by the connection. Can you still connect if you start your application manually?

Thanks
Laurentiu

|||yes, as soon as I log in, I can start my application manually.
During Startup my application fails to start because of the unhandled exception thrown from Sql.Client:

System.Data.SqlClient.SqlException: Cannot open database "Db_260" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
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()

Also here are couple of lines from the SQL errorlog file during machine startup:
2006-07-15 13:56:39.67 spid8s Clearing tempdb database.
2006-07-15 13:56:39.71 Logon Error: 18456, Severity: 14, State: 16.
2006-07-15 13:56:39.71 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2006-07-15 13:56:39.95 Logon Error: 18456, Severity: 14, State: 16.
2006-07-15 13:56:39.95 Logon Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: <local machine>]
2006-07-15 13:56:40.34 spid8s Starting up database 'tempdb'.
2006-07-15 13:56:40.45 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-07-15 13:56:40.46 spid11s The Service Broker protocol transport is disabled or not configured.
2006-07-15 13:56:40.46 spid11s The Database Mirroring protocol transport is disabled or not configured.
2006-07-15 13:56:40.56 spid11s Service Broker manager has started.
2006-07-15 13:56:44.78 spid51 Starting up database 'ReportServer$TRBR'.
2006-07-15 13:56:45.09 spid52 Starting up database 'Db_260'.
2006-07-15 13:57:38.96 Server Server resumed execution after being idle 25 seconds: user activity awakened the server. This is an informational message only. No user action is required.

Srdjan|||

You are trying to connect to database Db_260, but the database has not been started up yet. If you will look in the log, you'll see that the server is accepting connections before starting up the database Db_260, so the requests that you make before the database startup will fail. You should take this into account and retry to connect after a delay, to give time to the server to start up the database.

Thanks
Laurentiu

|||Laurentiu,

My code actually retries until it gets connection succesfully.
The problem is that after a couple of failed atempts, I actally get a success, but then it is the the next attempt to connect to database fails with the exception:

Login Failed for user 'NT AUTHORITY SYSTEM'...

Now, I've tried to postpone the first call to database for up to
3 minutes (more is not practical) and nothing really changes,
I get the same behaviour (System.Data.SqlClient.SqlException) on the second call to database...

Srdjan

|||

Are you saying that you get login failure errors after the database is started up? The log excerpt from your previous message doesn't show that. Can you post your errorlog from beginning up to and including the first couple of login failures that you get AFTER the Db_260 database was started up?

Thanks
Laurentiu

|||Laurentiu,

I managed to get around this problem...
My original code that was checking if SQL is ready was simply opening a connection but didn't execute any dabase commands.

For some reason at one point one of these attempts would successed, but then on the first real database access, exception was thrown.

So, I now do retries on the first real access to datbase and that seems to work.

I appreciate your help.

Srdjan
|||

Hi Laurentiu,

I am having a similar problem when after programmatically creating a database I try to create a table, if I do not put an arbitrarily large delay before issuing the create table statement, I get this same "Error: 18456, Severity: 14, State: 16."

Is there any way to issue a SQL statement and block on the call until a new database has been fully initialized and started before continuing? Alternatively, is there a way to get a callback once the DB is online?, Finally, if neither of the previous are possible, is there any entry in the master DB that one could poll to see when the new DB is up and running? I've tried the ovbious state in sys.databases, and Database.Status in DMO with no luck.

Any ideas? Thanks in advance!

GDM

|||

If you are getting a login failed message, it sounds like you are executing the CREATE DATABASE and CREATE TABLE statements on two different connections. Have you considered executing these statements using the same connection? If you would execute the CREATE TABLE after the CREATE DATABASE, on the same connection, you would not see such a failure.

The state you can query is state_desc in sys.databases - if it is ONLINE, it means the database was started.

Thanks
Laurentiu

|||How do i start sql server with "-y 18456"|||

Start->Run...->services.msc

Then go to the SQL Server service and stop it. Then Click <Properties> and in the <Start Parameters> field enter -y 18456. You can then click <Start> to restart the server with that parameter and then press cancel to exit without saving the parameter, so that future restarts won't use it. If you press OK, then the server will be restarted with that parameter - you probably don't want that.

Thanks
Laurentiu

|||

Ok I have an issue here....I am trying to do a full system recovery and this is what I am getting...

File/minint/system32/biosinfo.inf could not be loaded the error is code 14 ?

And I do NOT have the Windows XP Disk either...so if theres a way around this please by all means help me .......

can some please help me with this please

sql

Error with Neural Network Viewer

I have read the threads regarding the Neural Network Viewer and I think I have a similar problem. I do have Service Pack 2 installed and I'm running the x64 version of SQL 2005.

I'm building a model from a single relational CASE table. Granted the table has many columns summarized at the customer level but there are it is well formed and has no NULL values (plenty of zero or blank values though). The only time I can get the NN Viewer to work is when I accept the attribute recommendations. It seems once I stray from these recommendation, even if there is still correlation with an attribute, I cannot view the model using the NN Viewer. My latest error message says:

"The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value."

I get this message even when all input attributes are Continuous so I'm not sure what String column it is referring to.

Any help is greatly appreciated. I'm in a time crunch and I have sold the client on SQL Server 2005 capabilities. It's a bit embarrasing if I can't get this resolved.

-- Steve

P.S.: I don't recall having any issues with the NN Viewer prior to Service Pack 2 (although others have). Have you done regression testing to test this issue?

Hello,

Is it possible for you to export your model and send it to us? You can send to tatyanam "at" microsoft "dot" com.

Thanks,

Tatyana

|||

Hi Tatyana

Per our joint discovery, it appears that dates that are too far out into the future (e.g., 12/31/9999) are causing this problem. The solution is to either use earlier default dates (e.g., 12/31/2999) or discretize the date fields. This eliminates the specific NN Viewer problem I was experiencing.

Thanks.

Error with basic authentication - Reporting Service Add In for Sharepoint

Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?i'm having this issue, too. help?

Error with basic authentication - Reporting Service Add In for Sharepoint

Maybe someone can help me. I am running the reporting service add in for Sharepoint and we have only Basic Authentication running on our site (it is on SSL). When i try and open a report in sharepoint it errors out on me. When i go back into IIS and set Windows and Basic authentication it works, but it requires me to enter our domain and username. We need to only use Basic so it will not need the domain. Anyone have any suggestions on what i can do to make this work?i'm having this issue, too. help?

Error while trying to start sql server agent

As I am trying to start the Sql Server Agent on Sql Server 2000, I am
getting the following error:
An error 1069 - (The service did not start due to login failure) occurred
while performing this service operation on the Sql Server Agent service.
Any suggestion/advise will be of great help. Thanks.
What account is your SQLSERVERAGENT service set to run with? If not
LocalSystem, has the password for this account been changed?
R
"John" <John@.discussions.microsoft.com> wrote in message
news:E8D4E836-031F-4402-B6C5-D726DC9AED1C@.microsoft.com...
> As I am trying to start the Sql Server Agent on Sql Server 2000, I am
> getting the following error:
> An error 1069 - (The service did not start due to login failure) occurred
> while performing this service operation on the Sql Server Agent service.
> Any suggestion/advise will be of great help. Thanks.
>
>

Error while trying to start sql server agent

As I am trying to start the Sql Server Agent on Sql Server 2000, I am
getting the following error:
An error 1069 - (The service did not start due to login failure) occurred
while performing this service operation on the Sql Server Agent service.
Any suggestion/advise will be of great help. Thanks.What account is your SQLSERVERAGENT service set to run with? If not
LocalSystem, has the password for this account been changed?
R
"John" <John@.discussions.microsoft.com> wrote in message
news:E8D4E836-031F-4402-B6C5-D726DC9AED1C@.microsoft.com...
> As I am trying to start the Sql Server Agent on Sql Server 2000, I am
> getting the following error:
> An error 1069 - (The service did not start due to login failure) occurred
> while performing this service operation on the Sql Server Agent service.
> Any suggestion/advise will be of great help. Thanks.
>
>

error while starting MSDTC service

hey experts!!
I got this from Microsoft Management Console when starting the MSDTC service.
Could not start the Distributed Transaction Coordinator Service on local computer
Error 1067: The process terminated unexpectedly.
Can someone plz tell me wht the hell this means and how can i fix it. it does not gives any other info.
thankscan someone plz help me here. if you need more information
at least derect me somewhere as i am new to this sql and
ms dtc stuff.
thnks

Error while Running SQL Reporting Services

Hi,
I have recently installed SQL Reporting Service for SQL 2005 and started using it. I have one existing code that was using reporting services. But when now I try to run application it gives following error:
=============================================================
The request failed with HTTP status 503: Service Unavailable.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The request failed with HTTP status 503: Service Unavailable.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[WebException: The request failed with HTTP status 503: Service Unavailable.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +533199
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204
Ti.Dosa.Reports.ReportingServices.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) +175
Ti.UIWeb.NDD.ReportViewer.RenderReport(String[] reportParmsStr, String reportLocation, String reportFormat) +525
Ti.UIWeb.NDD.ReportViewer.Page_Load(Object sender, EventArgs e) +467
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
--
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
=============================================================
Please let me know what might be the problem.

Thanks,
Deepak

sounds to me like your website is running.

Did you run the ssrs setup tool?

|||Yes, Web Site is running but when I try access functionality which is using Reporting Services the mentioned error is popping up and yes, I have executed ssrs setup tool

--Deepak

Error while running service

Hi,
I have created .net windows service for running an exe. Exe is running
fine. It is used for inserting xml data in sql server database.
My service mode is automatic. Whenevr i start my computer it is
throwing me an error below :-
"An unhandled exception of type 'system.data.sqlclient.sqlexception'
occured in system.data.dll.
Additinal information : A connection was successfully established with
the server.but then an error occured during prelogin handshake.
(provider - SSL provider , error : 0 - the messege or signature
provided for verification has been altered"
When i start service in manual mode it runs perfectly fine. Can
someone please help me in this regard?
Arati
On Jul 31, 8:33 am, JPD <nos...@.nospamplease.com> wrote:
> Hi Arati,
> I've seen a similar problem just last week. In that case we deleted all
> certificates on the server and everything worked perfectly.
> Jonathan
>
> Arati wrote:
>
>
>
> - Show quoted text -
Hi,
Are you talking about server certificates for IIS or sql server?
Regards,
Arati
|||On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Arati,
> You have delete all existing certificates on the server no matter what
> purpose they are serving. In the case I encountered last week the
> problem certificate was for SharePoint.
> Jonathan
>
> Arati wrote:
>
>
>
> - Show quoted text -
Hi,
There are no certificates for IIS server. And I don't know where I can
find certificate for sql server. Do you have any idea on this?
Regards,
Arati

Error while running service

Hi,
I have created .net windows service for running an exe. Exe is running
fine. It is used for inserting xml data in sql server database.
My service mode is automatic. Whenevr i start my computer it is
throwing me an error below :-
"An unhandled exception of type 'system.data.sqlclient.sqlexception'
occured in system.data.dll.
Additinal information : A connection was successfully established with
the server.but then an error occured during prelogin handshake.
(provider - SSL provider , error : 0 - the messege or signature
provided for verification has been altered"
When i start service in manual mode it runs perfectly fine. Can
someone please help me in this regard?
AratiHi Arati,
I've seen a similar problem just last week. In that case we deleted all
certificates on the server and everything worked perfectly.
Jonathan
Arati wrote:
> Hi,
> I have created .net windows service for running an exe. Exe is running
> fine. It is used for inserting xml data in sql server database.
> My service mode is automatic. Whenevr i start my computer it is
> throwing me an error below :-
> "An unhandled exception of type 'system.data.sqlclient.sqlexception'
> occured in system.data.dll.
> Additinal information : A connection was successfully established with
> the server.but then an error occured during prelogin handshake.
> (provider - SSL provider , error : 0 - the messege or signature
> provided for verification has been altered"
> When i start service in manual mode it runs perfectly fine. Can
> someone please help me in this regard?
> Arati
>|||On Jul 31, 8:33 am, JPD <nos...@.nospamplease.com> wrote:
> Hi Arati,
> I've seen a similar problem just last week. In that case we deleted all
> certificates on the server and everything worked perfectly.
> Jonathan
>
> Arati wrote:
>
>
>
>
>
>
> - Show quoted text -
Hi,
Are you talking about server certificates for IIS or sql server?
Regards,
Arati|||Hi Arati,
You have delete all existing certificates on the server no matter what
purpose they are serving. In the case I encountered last week the
problem certificate was for SharePoint.
Jonathan
Arati wrote:
> On Jul 31, 8:33 am, JPD <nos...@.nospamplease.com> wrote:
> Hi,
> Are you talking about server certificates for IIS or sql server?
> Regards,
> Arati
>|||On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
<nos...@.nospamplease.com> wrote:
> Hi Arati,
> You have delete all existing certificates on the server no matter what
> purpose they are serving. In the case I encountered last week the
> problem certificate was for SharePoint.
> Jonathan
>
> Arati wrote:
>
>
>
>
>
>
> - Show quoted text -
Hi,
There are no certificates for IIS server. And I don't know where I can
find certificate for sql server. Do you have any idea on this?
Regards,
Arati|||Hi,
Open an MMC console. Go to File | Add/Remove Snap-in. Click on Add and
select Certificates. Choose Computer Account and then Local Computer.
Click Finish, Close, OK.
In the tree on the left expand Certificates (Local Computer), then click
on Personal. You need to delete all certificates that appear in the
details pane.
Jonathan
Arati wrote:
> On Aug 2, 6:30 am, Jonathan Psaila-Depasquale
> <nos...@.nospamplease.com> wrote:
> Hi,
> There are no certificates for IIS server. And I don't know where I can
> find certificate for sql server. Do you have any idea on this?
> Regards,
> Arati
>

Error while linking server to Active Directory service (advance)

I read that I can ignore this problem (it's normal!),
but I have another error.
I run SQL Server service with my domain account, I add my SQL Server istance
to Active directory inside Enterprise Manager, I create the linked server ho
w
documented with access by my domain account.
Finally, I execute this query in Query Analyzer:
SELECT * FROM OpenQuery( ADSI, 'SELECT *
FROM "LDAP://" ')
having this error:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14]
Any suggests to solve this issue?

> I need to retrieve information from LDAP in SQL Server 2000.
> I have installed SQL Server 2000 on a machine with Windows XP Professional
> (SP2).
> When I execute this script inside Query Analyzer:
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and then I open tables or views of linked server this error appears:
> "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject
'
> a necessary interface..."
> Can I solve this issue?
> Where I can find a good documentation about SQL Server 2000 and LDAP?
> Many thanks
>The right error message is:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prep
are
returned 0x80040e14].
Sorry!
[vbcol=seagreen]
> I read that I can ignore this problem (it's normal!),
> but I have another error.
> I run SQL Server service with my domain account, I add my SQL Server istan
ce
> to Active directory inside Enterprise Manager, I create the linked server
how
> documented with access by my domain account.
> Finally, I execute this query in Query Analyzer:
> SELECT * FROM OpenQuery( ADSI, 'SELECT *
> FROM "LDAP://" ')
> having this error:
> Message 7321, Level 16, State 2, Row 1
> OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
> returned 0x80040e14]
> Any suggests to solve this issue?
>

Error while linking server to Active Directory service (advance)

I read that I can ignore this problem (it's normal!),
but I have another error.
I run SQL Server service with my domain account, I add my SQL Server istance
to Active directory inside Enterprise Manager, I create the linked server how
documented with access by my domain account.
Finally, I execute this query in Query Analyzer:
SELECT * FROM OpenQuery( ADSI, 'SELECT *
FROM "LDAP://" ')
having this error:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14]
Any suggests to solve this issue?

> I need to retrieve information from LDAP in SQL Server 2000.
> I have installed SQL Server 2000 on a machine with Windows XP Professional
> (SP2).
> When I execute this script inside Query Analyzer:
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and then I open tables or views of linked server this error appears:
> "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
> a necessary interface..."
> Can I solve this issue?
> Where I can find a good documentation about SQL Server 2000 and LDAP?
> Many thanks
>
The right error message is:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
Sorry!
[vbcol=seagreen]
> I read that I can ignore this problem (it's normal!),
> but I have another error.
> I run SQL Server service with my domain account, I add my SQL Server istance
> to Active directory inside Enterprise Manager, I create the linked server how
> documented with access by my domain account.
> Finally, I execute this query in Query Analyzer:
> SELECT * FROM OpenQuery( ADSI, 'SELECT *
> FROM "LDAP://" ')
> having this error:
> Message 7321, Level 16, State 2, Row 1
> OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
> returned 0x80040e14]
> Any suggests to solve this issue?
>

Error while linking server to Active Directory service

I need to retrieve information from LDAP in SQL Server 2000.
I have installed SQL Server 2000 on a machine with Windows XP Professional
(SP2).
When I execute this script inside Query Analyzer:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
GO
and then I open tables or views of linked server this error appears:
"Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
a necessary interface..."
Can I solve this issue?
Where I can find a good documentation about SQL Server 2000 and LDAP?
Many thanksI read that I can ignore this problem (it's normal!),
but I have another error.
I run SQL Server service with my domain account, I add my SQL Server istance
to Active directory inside Enterprise Manager, I create the linked server how
documented with access by my domain account.
Finally, I execute this query in Query Analyzer:
SELECT * FROM OpenQuery( ADSI, 'SELECT *
FROM "LDAP://" ')
having this error:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14]
Any suggests to solve this issue?
> I need to retrieve information from LDAP in SQL Server 2000.
> I have installed SQL Server 2000 on a machine with Windows XP Professional
> (SP2).
> When I execute this script inside Query Analyzer:
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and then I open tables or views of linked server this error appears:
> "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
> a necessary interface..."
> Can I solve this issue?
> Where I can find a good documentation about SQL Server 2000 and LDAP?
> Many thanks
>|||The right error message is:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
Sorry!
> I read that I can ignore this problem (it's normal!),
> but I have another error.
> I run SQL Server service with my domain account, I add my SQL Server istance
> to Active directory inside Enterprise Manager, I create the linked server how
> documented with access by my domain account.
> Finally, I execute this query in Query Analyzer:
> SELECT * FROM OpenQuery( ADSI, 'SELECT *
> FROM "LDAP://" ')
> having this error:
> Message 7321, Level 16, State 2, Row 1
> OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
> returned 0x80040e14]
> Any suggests to solve this issue?
>
> > I need to retrieve information from LDAP in SQL Server 2000.
> > I have installed SQL Server 2000 on a machine with Windows XP Professional
> > (SP2).
> > When I execute this script inside Query Analyzer:
> > EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> > 'ADSDSOObject', 'adsdatasource'
> > GO
> > and then I open tables or views of linked server this error appears:
> > "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
> > a necessary interface..."
> >
> > Can I solve this issue?
> > Where I can find a good documentation about SQL Server 2000 and LDAP?
> >
> > Many thanks
> >

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!