SQL server task fails-sql executive login failure- 
Author Message
 SQL server task fails-sql executive login failure-

The scheduled tasks stopped running . When I run the schedules "on demand" a
prompt indicates the following: "Task 'FriBackup' started successfully. When
the task finishes executing its completion status can be viewed in the 'Task
History' dialog." . But the History dialog doesn't show anything. I started the
SqlExecutive error log and these are some of the errors: "DBLib Message
Handler: Login failed-User: sa Reason. Not associated with a trusted SQL Server
connection." and also this one: "DBLib Error Handler: Login incorrect."; "There
are 0 task(s) in the task list". The server is set for standard
connectivity.The following is done on the server:

The Sql sa password was chsanged; the NT server logon prompt was disabled (by
using resource KIT utiliy).
Thank you for your help in advance.
Sean,



Fri, 11 May 2001 03:00:00 GMT
 SQL server task fails-sql executive login failure-

AGDAR,

SQLExecutive can apparently not make a trusted connection to SQL Server.

I don't know what you mean by "NT resource kit utility", but the account
that SQLExecutive is using must be able to get a trusted connection to SQL
Server....

--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please do not respond by e-mail unless explicitly asked for.



Sat, 12 May 2001 03:00:00 GMT
 SQL server task fails-sql executive login failure-
We always run SQL Server and SQL Executive under a Domain Administrator Account.
This account is always added to the Administrators Group on the SQL Server and thus

has full privs on the server as well as other resources on the network.

Much fewer headaches this way.

Francis

Quote:

> The scheduled tasks stopped running . When I run the schedules "on demand" a
> prompt indicates the following: "Task 'FriBackup' started successfully. When
> the task finishes executing its completion status can be viewed in the 'Task
> History' dialog." . But the History dialog doesn't show anything. I started the
> SqlExecutive error log and these are some of the errors: "DBLib Message
> Handler: Login failed-User: sa Reason. Not associated with a trusted SQL Server
> connection." and also this one: "DBLib Error Handler: Login incorrect."; "There
> are 0 task(s) in the task list". The server is set for standard
> connectivity.The following is done on the server:

> The Sql sa password was chsanged; the NT server logon prompt was disabled (by
> using resource KIT utiliy).
> Thank you for your help in advance.
> Sean,



Sat, 12 May 2001 03:00:00 GMT
 SQL server task fails-sql executive login failure-
Within resource kit for windows NT 4.0 there is an option when initiated asks
for a login name and a password for windows NT. Then whenever windows is
started the CTRL+ALT+DEL dialog and the login prompt for NT server is by
passed. I have a standard security on this server, could you tell me what you
mean by " trusted connection to SQL Server", and how do I achieve that.

Thank you



Sat, 12 May 2001 03:00:00 GMT
 SQL server task fails-sql executive login failure-
AGDAR,

What account are you starting the SQLExecutive task with ?  Try starting it
with administrator and see if this solves your problem.  Once you are happy
you can drop the account dont to a less privileged user.

Steve Robinson
SQLServer MVP


Quote:

>The scheduled tasks stopped running . When I run the schedules "on demand"
a
>prompt indicates the following: "Task 'FriBackup' started successfully.
When
>the task finishes executing its completion status can be viewed in the
'Task
>History' dialog." . But the History dialog doesn't show anything. I started
the
>SqlExecutive error log and these are some of the errors: "DBLib Message
>Handler: Login failed-User: sa Reason. Not associated with a trusted SQL
Server
>connection." and also this one: "DBLib Error Handler: Login incorrect.";
"There
>are 0 task(s) in the task list". The server is set for standard
>connectivity.The following is done on the server:

>The Sql sa password was chsanged; the NT server logon prompt was disabled
(by
>using resource KIT utiliy).
>Thank you for your help in advance.
>Sean,



Sat, 12 May 2001 03:00:00 GMT
 SQL server task fails-sql executive login failure-
I set up SqlExecutive service to start both as a system account and
administrator. SqlExecutive accont is part of the administrator group. I also
reset the Sqlexec account and password in the configuration dialog.


Sat, 12 May 2001 03:00:00 GMT
 SQL server task fails-sql executive login failure-
Trusted connection to SQL Server:
The application requests that SQL Server validates the connection through
some mapping (stored in the registry). Instead of checking loginid and
password sent to SQL Server, SQL Server checks the SID (or something) and if
this SID is mapped to a loginid. If there is a mapping, SQL Server ignore
the loginid and password sent to it.
SQLExecutive requests a trusted connection.

(When SQL Server is running in integrated security mode, it will only accept
trusted connections.)

You check if the mapping is done with SQL Security Manager. The account that
SQLExecutive is using must be mapped to sa.
--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please do not respond by e-mail unless explicitly asked for.

Quote:

>Within resource kit for windows NT 4.0 there is an option when initiated
asks
>for a login name and a password for windows NT. Then whenever windows is
>started the CTRL+ALT+DEL dialog and the login prompt for NT server is by
>passed. I have a standard security on this server, could you tell me what
you
>mean by " trusted connection to SQL Server", and how do I achieve that.

>Thank you



Sun, 13 May 2001 03:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. RPC login failure from SQL Executive

2. RPC login failure from SQL Executive

3. SQL Executive/ Tasks issue (SQL Server 6.5)

4. SQL Executive tasks on SQL Server 6.5.

5. SQL Executive Login Failed.....

6. Sql SErver Agent Reporting Failure Even tho Task Succeeds

7. [ODBC SQL Server Driver][SQL Server]Login failed

8. [ODBC SQL Server Driver][SQL Server]Login failed .

9. [ODBC SQL Server Driver][SQL Server]Login failed .

10. [Error=18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: guest

11. Login Failure/Not Trusted SQL Server Connection

12. ASP/SQL Server Login Failure


 
Powered by phpBB® Forum Software