How To Find Out The Reason For Error 17883?

Sep 26, 2007

Hello, ereryone

I use MSDE in my system, and sometimes the following error occurs in MSDE. After that, I can not even access MSDE with the osql command.

Can anyone give some advice as how to deal with this kind of error or how to find the real reason? I have checked MS homepage, but I can not get the details of it.

Error: 17883, Severity: 1, State: 0 The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x003B70F8

Thanks in advance.

View 1 Replies


Error: 17883 ?

Jan 18, 2007

I have been looking at this error 17883

Error: 17883 - Process %1!ld!:%2!ld! (%3!lx!) UMS Context 0x%4!p! appears to be non-yielding on Scheduler %5!ld!

2003-03-21 08:22:20.27 server Error: 17883, Severity: 1, State: 0
2003-03-21 08:22:20.27 server Process 51:0 (dbc) UMS Context 0x018DA930 appears to be non-yielding on Scheduler 0.
2003-03-21 08:22:22.45 server Stack Signature for the dump is 0x00000000

From this artical
its telling me that SP4 fixes this issue. But the server is at 2000 SP4 so I guess SP4 didnt fix the issue.

Any ideas?

Thanks for your time.

View 1 Replies View Related

Error 17883

Apr 13, 2006

I have read the other threads that discuss error 17883. I have a SQL 2000 server with SP 3a on a Windows 2000 server SP4. I get the following error in my SQL log...

Process 429:0 (ad4) UMS Context 0x06BA8D30 appears to be non-yielding on Scheduler 0.

Then ...

Error: 17883, Severity: 1, State: 0

When this error occurs my users are forced to close and reopen the application. Once the users log back in they are good to go.

I just started getting this error 2 weeks ago about 1 error a week. Now I am getting them everyday...At first I thought it was due to a database Log file autogrow, but my log files haven't gotten autogrown in the last week.

Has anyone else seen this specific version of Error 17883?

View 1 Replies View Related

Error 17883

May 5, 2004

I am getting the following error: Error 17883 on my new sql server. I am looking everywhere on the net, put I cannot find a way to resolve this issue. Does anyone know what causes this, and possibly how to fix it. Thanks for the help in advance.

View 3 Replies View Related

Error: 17883 - The Scheduler 0 Appears To Be Hung.

May 6, 2004

Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
I end up in error 17883.
I am aware that the solution is to apply this patch:
821277 MS03-031:Security Patch for SQL Server 2000 Service Pack 3.
I am also aware that after you install this cumulative patch you will end up in this problem:
826161 FIX: You are prompted for password after you change a standard SQL Server login.
After reading this one I found that there are 2 possibility to solve this problem, one if you have already installed the security patch from MS03-031 and another one if you do NOT have installed this patch.
Do I only need to apply this last one (is it also cumulative?) or do I need to first apply MS03-031 and then later the FIX 826161?
Please advise.
Kind regards.

View 1 Replies View Related

Sqlcmd: Error: Internal Error At FormatRowset (Reason: Ox80040e4e).

Feb 14, 2008

I get this after dumping about 2GB and 885800 rows X 2 columns from a simple query to a file.

The command line is simple:

sqlcmd -b -h -1 -S "sindb05" -d ACT -E -Q "select date, data from data_strings with (nolock) where date > '2008-01-20 12:00:00' and date < dateadd(hour, +1, '2008-01-20 12:00:00')" -o out.txt

How can I work around this error?

View 2 Replies View Related

Sql 2005 Error: Unable To Read Local Eventlog (reason: 87).

Oct 10, 2005

on the same machine both 2000 and 2005.

View 13 Replies View Related

Getting Error:Login Failed For User'(null)' .Reason: Not Associated With A Trusted SQL Server Connection.

Aug 11, 2005

can any one help

View 3 Replies View Related

Error 18452, Login Failed For User Reason: Not Associated With A Trusted SQL Server Connection.

Sep 5, 2005

Hi all,

View 14 Replies View Related

Error String: [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed For User '(null)'. Reason: Not Associated With A Trus

May 14, 2008

Hi all

This Job ran yester day fine,to day It got failed with this error

any suggestion to troubleshoot problem is appreciated.

DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814)

Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)

Help file: SQLDMO80.hlp

Help context: 1131

Error Detail Records:

Error: 0 (0); Provider Error: 0 (0)

Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)

Help file: SQLDMO80.hlp

Help context: 1131

DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1

DTSRun: Package execution complete.

View 3 Replies View Related

17883 From SQL Server SP4 On Windows 2003 Server

Feb 27, 2007

I have a bit of a strange problem, I'll attempt to describe it as best I can. Any directions to other resources would be appreciated.

Sunday, the 25th, at 3:00am, the server installed the timezone patch (kb931836).
at 4:00am, ntbackup.exe started a system state backup.
at 4:01am, SQL server started filling it's errorlog file with the following:
2007-02-25 04:01:15.87 server Error: 17883, Severity: 1, State: 0
2007-02-25 04:01:15.87 server Process 97:0 (8c0) UMS Context 0x05A9C478 appears to be non-yielding on Scheduler 0.
2007-02-25 04:01:15.89 server Error: 17883, Severity: 1, State: 0
2007-02-25 04:01:15.89 server Process 82:0 (e78) UMS Context 0x05A977F8 appears to be non-yielding on Scheduler 1.

These continued several times a second. During that time, I could not connect to SQL server. Profiler or enterprise manager would just hang. Some applications would get responses to queries, but it appeared to be random. We rebooted the server and the errors continued. SQL server was usable for about 10 minutes after the reboot and then went back to hanging. The errors continued to fill the errorlogs.

The problem was finally "corrected" by uninstalling the patch for kb931836. I'm puzzled by that because it doesn't seem to have anything to do with SQL.


View 5 Replies View Related

[help] SQL Error - I/O Error 2 (The System Cannot Find The File Specified)

May 13, 2004

Windows 2000 Server SP4 + SQL Server 2000 Enterprise Editon SP3,RAID5.

the windows event log give the following error information:

I/O error 2(The system cannot find the file specified) detected during write at offset 0x0000010c6c4000 in file 'D:Program FilesMicrosoft SQL ServerMSSQLdataGJSZBANK_Data.MDF'.

I have searched microsoft knowledge base and got this article:;EN-US;828339

but don't understand some contents in the topic:

For example, if you encounter the following error message in the SQL Server Errorlog file, SQL Server encountered operating system error 2 when it uses a Windows API call to write to the tempdb primary database file:

Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000000284000 in file 'D:Program FilesMicrosoft SQL ServerMSSQLdata empdb.mdf'

Because SQL Server has already successfully opened the file and did not receive an “Invalid Handle” error, the error is likely being raised in a lower-level kernel software component, such as the file system or a device driver. This problem does not indicate a problem in SQL Server, and it must be investigated as an issue with the file system or a device driver that is associated with the file.

Does that mean this is not a SQL Server error?
Does that mean something wrong with my operating system? or something wrong with my hard disk?

View 1 Replies View Related

Reason To Not Use SELECT *

Apr 22, 2004

Or when to use it...

Any comment appreciated...I'll add to the list as well


View 14 Replies View Related

What's The Reason To Use OLE DB Command?

Dec 27, 2007

When I design package under ssis, I always use execute sql task to replace OLE DB Command. Normally, I use staging tables to get all data from data source,then modify or generate some columns on the staging tables according to bussiness rules using execute sql task, Finally,transfer to data destination. And execute sql task is more effiecient than OLE DB Command. I suppose there's reason for using
OLE DB Command. But I don't know. So what's the reason to use OLE DB Command?

View 1 Replies View Related

Deadlock Reason?

Apr 24, 2008

I am having difficulty in identify my deadlock reason. So, please give me some hints.

In my application, I have 2 standard functions. One for transaction creation and one for reporting. The strange problem is I seldom / never got any deadlock witht the transaction creation. Instead, I got deadlock problem with the reporting.

In the reporting function, I only use select and aggregate function. Why will deadlock be raised? Can someone give me an example why such deadlock happened?

Thanks in advance.

View 1 Replies View Related

My Agent Was Down With No Reason

Apr 8, 2008

Hello everyone, I need your help. I have SQL*Server 2000 in a Windows 2000 advanced server service pack 4. My SQL*Server has the path 4. Yesterday I had this message and then my database was down.
SQL Server is terminating due to 'stop' request from Service Control Manager.
Any help?

View 13 Replies View Related

Help, Pkg Does Not Run From Job - No Obvious Reason

May 6, 2008


I have a package that just won't run from a job.

To test the problem, I created a very simple package. All it does is load a simple text file to a table on the local server.

I set protection level to "encrypt sensitive with password", and set the password. I changed the creator name to the SQL Server Agent Account. (don't know how to change the GUID?)

It runs fine from BIDS and msdb storage. But if I run it from the job, it fails with:
Executed as user: DOMAINUSERNAME. The package execution failed. The step failed.

No logging occurs, even though I have set the package to log, which seems to indicate it's not even getting as far as starting the package. I've restarted all the services.

I tried running this package from a job on ANOTHER server and it works, no problem. There's just something going on with this other server where it won't run from the job... both servers use the same SQL Server Agent account.

I've consulted and it talks about this problem but I have everything set correctly... never had this problem before... seriously.


View 7 Replies View Related


Mar 23, 2008

hy all

this is my second post on this issue, and I'm hoping to solve it now.

I got this error msg: DTS_E_PRODUCTLEVELTOLOW

when tring to run SSIs package with load data from File source (simple one) to DB on SQL2005 and the package is stored and exec on the SSIS server.

We installed the SSIS server with the Database engine on the same machine.

when running from my workstation it work fine, but when the package was uploaded to the MSDB and executed from there - it failed.

help, anyone.

Oh, by the way - microsoft issues on that problems didnt helpd - i got the enteprise edition installed and there is a match between the versions of all the components: BIDS, Server SSIS and SQL2005


View 1 Replies View Related

Can't Find Error- Help?

Dec 27, 2007

Msg 102, Level 15, State 1, Line 6 which is around the comment line where is shows monthly and other. Getting message incorrect systax near '/'.

-- 'M' = Monthly, 'O' = Other
@FiscalPeriod smallint,

set nocount on


SET @DateFrom = CASE @Frequency
WHEN 'M' THEN convert(varchar,(SELECT efsc_from_date
FROM rs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHERE efsc_to_date = (SELECT max(efsc_to_date)
FROM rs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHERE efsc_to_date < getdate())),101) + ' 00:00:00'
WHEN 'O' THEN convert(varchar,(SELECT efsc_from_date
FROM rs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHERE efsc_fiscal_year = @FiscalYear and efsc_fiscal_period = @FiscalPeriod),101) + ' 00:00:00'
ELSE convert(varchar,getdate()-1,101)

SET @DateTo = Case @Frequency
WHEN 'M' THEN convert(varchar,(SELECT efsc_to_date
FROM rs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHERE efsc_to_date = (SELECT max(efsc_to_date)
FROM rs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHERE efsc_to_date < getdate())),101) + ' 23:59:59'
WHEN 'O' THEN convert(varchar,(SELECT efsc_to_date
FROM rs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHERE efsc_fiscal_year = @FiscalYear and efsc_fiscal_period = @FiscalPeriod),101) + ' 00:00:00'
ELSE convert(varchar,getdate()-1,101)

SET@FiscalPeriod =CASE @Frequency
WHEN 'O' THEN@FiscalPeriod
ELSE (SELECTefsc_fiscal_period
FROMrs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHEREefsc_to_date = (SELECTmax(efsc_to_date)
FROMrs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHEREefsc_to_date < getdate()

SET@FiscalYear =CASE @Frequency
WHEN 'O' THEN@FiscalYear
FROMrs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHEREefsc_to_date = (SELECTmax(efsc_to_date)
FROMrs3_reporting.dbo.rs_entity_fiscal (NOLOCK)
WHEREefsc_to_date < getdate()

View 2 Replies View Related

Reason To Use Optimizer Hints

Aug 5, 1999

While investigating performance problems within an application recently I carried out some tests using SET SHOWPLAN ON.

I had a query like this within a stored procedure:


Where @MYVAR was passed in. I discovered that SQL Server did a Table Scan even when Z had an index on it. A problem with 200,000 rows!

If I said


(i.e., used a constant instead of a variable) SQL Server did use the index correctly and did not do a table scan.

I got around this by rewriting my statement:


in other words by manually specifying the index I had created on the Z column.

Hope this helps someone.

View 2 Replies View Related

Can't Load The Php Sqlsrv.dll For Some Reason

Feb 5, 2008

Running MS2k3 webserver with IIS and PHP 5.2.5

my php.ini is in the Windows folder containing among other things these 2 entries:

extension_dir ="C:PHPext"

and the file php.sqlsrv.dll is located in the PHPext directory

I've restarted the IIS server with php running and working just fine. Is there anything else I could still check ?

Code Snippet

if (!extension_loaded('sqlsrv')) {
echo("NOT LOADED");

Produces: not loaded.

Dug up some logs:
The description for Event ID ( 2 ) in Source ( PHP-5.2.5 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: php[2144]; PHP Warning: PHP Startup: Unable to load dynamic library 'C:PHPextphp_sqlsrv.dll' - The specified module could not be found.
in Unknown on line 0.

View 1 Replies View Related

Error:ADO Could Not Find The Specified Driver

Aug 4, 1999

I installed SQL7 on my windows 95 desktop for testing. When I try to open the tables for the Northwind database, I get the message box "ado could not find the specified driver". No records are displayed.

Any suggestions?


View 1 Replies View Related

Error: Could Not Find SP Upd.sp_MSrepl_xxx_xxxxxx_1

May 3, 2007

Trying to set up replication as follows:

SQL2000 publisher , acting as it's own distributor (v8.0.760)

Transactional Replication with updateable subscriptions

SQL2005 subscriber (v9.00.3042)

Push subscription with immediate updating from distributor to subscriber and queued updating from subscriber to distributor

The set-up went smoothly and changes in the publication db flow down to the subscriber as expected. However, changes at the subscriber fail to flow up to the publisher.

The Queue Reader agent reports the error "Server MyServer, Database publisher_db : ODBC Error: Could not find stored procedure "upd.sp_MSrepl_ins_mytable_1"

The SP 'sp_MSrepl_ins_mytable_1' exists in the publisher db but the owner is 'dbo' not 'upd' (there is no such login as 'upd' on the server)

The only useful article I have found on the net suggests that this could be caused by a bug (jn SP3?) but the situation described in that article and the fix/workaround for it don't seem to apply for me.

The problem and fix in that article was: table MSsubscription agents in the subscriber db had a queue_id value of 'mssqlqueue' and the fix was to set it to 'mssqlqueuev2'.
However, it is already ''mssqlqueuev2' in my subscription db so I'm at a loss to explain why it's still generating calls looking for SPs owned by 'upd'.

other info:
Just to see if it would work around my immediate peoblem I tried creating a user called 'upd' and duplicating the SPs.
This worked up to a point. Changes replicated up to my publisher ok. However, when I created a conflict (changed same row on publisher and subscriber at same time)
the Queue Reader fell over with error: "Server MyServer, Database publisher_db : ODBC Error: Could not find stored procedure "upd.1".

Investigated the stored procdure sys.sp_replqueuemonitor in my subscription database and found statements like this:
select publisher, publisher_db, publication, queue_server, queue_id
from dbo.MSsubscription_agents
publisher = case when @publisher is NULL then publisher else UPPER(@publisher) end AND
publisher_db = case when @publisherdb is NULL then publisher_db else @publisherdb end AND
publication = case when @publication is NULL then publication else @publication end AND
update_mode IN (2,3) AND
queue_id != N'mssqlqueue'
note that the queue_id is is looking for is 'mssqlqueue'.
If I manually run sys.sp_replqueuemonitor I get no results (unsurprising since the data in dbo.MSsubscription_agents has queue_id='mssqlqueuev2'.

It looks to me as if some of the SPs created when the publication and/or subscription was set up are incorrect...???

Any advice or suggestions on how to approach this problem?

View 8 Replies View Related Me To Find Out The Error In The Code

Jan 5, 2007


when i tried to run the following code , the code keeps on running without creating the required table...............

pls can anyone help me to figure out the problem........

waiting for your replies...

int row_head = 3;

int col_head = 3;

TextBox[] columns1=new TextBox[5];

TextBox[] rows = new TextBox[2];

for (int i = 0; i < 3; i++)

columns1[ i ] = new TextBox();

for (int i = 0; i < 2; i++)

rows[ i ] = new TextBox();

columns1[0].Text = "col1";

columns1[1].Text = "col2";

columns1[2].Text = "col3";

rows[0].Text = "rowh1";

rows[1].Text = "rowh2";

String[] description=new string[10];

for (int k = 0; k < 10; k++)

description[k] = k.ToString();

int index_value = 0;

int des_index = 0;

string datatype = "";

string command = "";

SqlConnection sqlCN = new SqlConnection(connectionString);

for (int i = 0; i < col_head + 1; i++)


if (i == 0)

datatype += "(col " + i + " varchar(20),";

else if (i + 1 == col_head+1)

datatype += "col" + i + " varchar(20))";


datatype += "col" + i + " varchar(20),";



MessageBox.Show("create table " + textBox1.Text + " " + datatype);

string selectCommandText = "create table " + textBox1.Text +datatype;




SqlCommand sqlCmd = new SqlCommand(selectCommandText, sqlCN);


MessageBox.Show("open ");

// the following command is not executed.....


MessageBox.Show("open and execu");

for (int i = 0; i < row_head + 1; i++)



if (i == 0)


command="' ',";

for(int j=0;j<col_head;j++)










command = "'"+rows[index_value++].Text+"',";

for (int j = des_index; j < des_index + col_head; j++)


if (j +1== des_index+col_head)

command += "'" + description[j] + "'";


command += "'" + description[j] + "',";


des_index = des_index + col_head;


MessageBox.Show("INSERT INTO " + textBox1.Text + " values(" + command + ")");

sqlCmd.CommandText = "INSERT INTO " + textBox1.Text + " values("+command+")";




selectCommandText = "SELECT * FROM " + textBox1.Text;

sqlCmd = new SqlCommand(selectCommandText, sqlCN);


SqlDataAdapter sqlDA = new SqlDataAdapter(selectCommandText, sqlCN);

DataSet DS = new DataSet();


MessageBox.Show("fini 2");

DataGridView1.DataSource = DS.Tables[0].DefaultView;


catch (Exception eio)

{ }}


View 6 Replies View Related

Going Into Single User Mode For No Reason?

Feb 19, 2001

Dear All,
I have some user databases that go into single user mode
for no apparent reason. Is there any reason that SQL
Server 7 would set a database in single user mode
by itself? NB They are not being set single user by anyone
else here, they would not know how.

Many Thanks in Advance,

View 2 Replies View Related

Blocking SPID ... No Apparent Reason

Jun 14, 2004

I hava a JAVA application that updates a SQL2000 (SP3a)database.
The application handles different types of "jobs" which effectively update the DB.

One job in particular appears to block all subsequent jobs. It comprises of a large amount of inserts/updates in a single transaction. This is necessary as it is an "all or nothing" scenario - so we cannot break the transaction into smaller ones. The transaction appears to succeed as it reaches the COMMIT TRAN statement without error.
However the records do not get written to the database.
EM indicates a large number of locks held on the tables accessed by the transaction and these do not get released.

Using the SP sp_blocker_pss80, the blocking SPID has a waittime of 0 and a waittype of 0x0000 - the lastwaittype is WRITELOG and its status is AWAITING COMMAND

I am using MS SQLSERVER JDBC Driver SP2 (considering using jTDS)

I have tried
- increasing Transaction Log size
- Moving Transaction Log to a separate Disk
- Reducing Isolation Mode to Read Uncommitted
- Set AutoCOMMIT to true
- set Close Cursor on COMMIT
- set SelectMethod to Direct - (we use Cursor by default)

None of these have succeeded in fixing the issue.

The job will succeed if it is the first/only job to access the database.
But if another job precedes it - then the blocking occurs.
I have verified that the preceding job only holds shared dataabase locks
before the blocking job is run.

Each job will use its own JDBC connections to access the database for reading
purposes, but all of the writing goes through the blocking SPID.

Any ideas?
Thanks, Liam

View 4 Replies View Related

I Hate New Management Studio For 1 Reason...

Dec 27, 2007

...and it is because...
when i drag and drop my script file into query window unlike query analyzer which selects the current database, new MSSMS selects the users 'default' database.

we maintain 1 script file for each sp/function and ddl/views groupe related stuff in 1 or more files

in query analyzer I just have to select DB where i want to deploy scripts and drag and drop the files from explorer and then then
1) press F5 (to run)
2) press CTL + F4 (to close window)
3) repeat till all scripts are deployed

and now in MSSMS

1) select db (this step is really painful especially when i have to deploy more than 1 script/file)
2) press F5
3) press CTL + F4
4) repeat

is there any settings that could change the behavior of SMS2K5 like old QA2K?

well what i cant do here is change default db to the tartget db before deploying and switch back after deploying (but not a true solution)

thanks in advance

View 9 Replies View Related

Using Where..IN In Update Query.. Not Working For Some Reason

Jul 20, 2005

Hi folks,Hopefully this is a simple fix, but I keep getting Syntax error withthis statement in an MS SQL DTS statement and in Query Analyzer:Update A Set A.deptcode = A.deptcode,A.type = A.Type,a.TotalExpenseUnit = (a.LaborExpenseUnit + a.OtherExpenseUnit)Where a.Type in ('FYTD04', 'Prior Year','Budget')From Data_Unsorted A Join Data_Unsorted B OnA.deptcode = B.deptcode and A.type = B.TypeBelow is the error from Query Analyzer:Server: Msg 156, Level 15, State 1, Line 5Incorrect syntax near the keyword 'From'.Where do I place my Where..In statement since I only want to limit theUpdate to run for items where a.type is FYTD04, Prior Year, or Budget?Thanks,Alex.

View 3 Replies View Related

Transaction Log File Disappearing Without Reason

Apr 17, 2007

Hi team,

At one of our SQL2005 servers we've got a really strange problem. The transaction logfile of one of our databases is suddenly disappearing without a reason. From that moment on the event log (application) is being filled up with SQLserver event 9001

Event Type: Error
Event Category: (2)
Event ID: 9001
Date: 16/04/2007
Time: 12:31:40
User: N/A
Computer: PBVSRV
The log for database 'Putboringen' is not available. Check the event log for related error messages. Resolve any errors and restart the database.

For more information, see Help and Support Center at
0000: 29 23 00 00 15 00 00 00 )#......
0008: 12 00 00 00 50 00 42 00 ....P.B.
0010: 56 00 53 00 52 00 56 00 V.S.R.V.
0018: 5c 00 53 00 51 00 4c 00 .S.Q.L.
0020: 45 00 58 00 50 00 52 00 E.X.P.R.
0028: 45 00 53 00 53 00 00 00 E.S.S...
0030: 07 00 00 00 6d 00 61 00 ....m.a.
0038: 73 00 74 00 65 00 72 00 s.t.e.r.
0040: 00 00 ..

We already had this a few times before and really are unable to find the root cause for this. Can you help us out?

The server is a Dell PE1900 running SBS2003R2. Database is stored on a seperate volume (R5 configuration). Environment is +-5 workstations



View 8 Replies View Related

FTP Task Fails For No Good Reason

Jan 11, 2008


I have a package that has several FTP tasks in sequence:

[ftp task 1]->[ftp task 2]->[ftp task 3]->[ftp task 4]

[Ftp task 4] fails about 20% of the time, for no apparent reason. This is the error message I receive:

[FTP Task] Error: Unable to receive files using "FTP Connection Manager".

The problem is, it works most of the time (80%), but every 4 or 5 tries, it fails. This makes NO sense to me. Is this a bug perhaps?

Please help... should we use an ftp script instead, as the ftp task seems rather unreliable.


View 5 Replies View Related

Reason To Back Up Database Master Key?

Aug 17, 2006

I can backup this key using something like:

BACKUP MASTER KEY TO FILE = 'c:TestEncryptionMasterKey.key'


but why would I need to do it as the DBMK is stored in the databases itself ( in sys.symmetric_keys) and we dump all databases nightly. Just "in case"?



View 1 Replies View Related

Reason: Invalid Login Information

Mar 25, 2008

I can log in to a database with administrator account, but not with an user account.
I am getting "Invalid login information" error message. What will be the likely cause for this?
I am using Winodws authentication.

View 5 Replies View Related

How Can I Find The Exact Error Line ?

Jan 6, 2006

Hi all,
i have an insert function using stored procedure with parameters. At some point while assigning parameters i make a casting problem but all i get is:
String was not recognized as a valid Boolean.
how can i find the exact line causing the error?
thank you

View 6 Replies View Related

Copyrights 2005-15, All rights reserved