Login Times

Helo,
Is there any way I could grant or deny a user login based on the time of
day?
I'm running mad with this issue, since not everybody is a full time
employee, and for security reasons I would want to block their logins when
they are supposed to be out of the office.
Thanks in advance.Juan wrote:
> Helo,
> Is there any way I could grant or deny a user login based on the time
> of day?
There is no possibility in SQL Server, but if you use integrated security
you can use Active Directory Users and Computer to limit the logon hour of
each account

> Thanks in advance.
Bye
Luca Bianchi
Microsoft MVP - SQL Server
http://mvp.support.microsoft.com
http://italy.mvps.org

Login Problem

Hi everybody,
I'm a newbe on SQL Server;
Here my problem is:
In Server Explorer I create a Data Connection to Nortwind. After Creating
the connection I can reach tables of this database.
But: When I want to configure the dataAdapter the problem occurs:
In the configure wizard "Data Soure Login" window comes.
Altought I know the user "sa" password This error comes:
"Login Failed:Not Associated With a Trusted SQL Server Connection. Invalid
Connection String Attribute."
How can I overcome with this problem.
What may be the reason of this problem.
Thanks for any help.
Arif imen
Prowise Software.
Arif,
If your SQL Server is configured to accept Windows Authentication only, you
will get this error message when you attempt to use SQL authentication.
Please configure your DSN to use Windows Authentication and see if that
clear up the issue for you.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.

Login Problem

Hi everybody,
I'm a newbe on SQL Server;
Here my problem is:
In Server Explorer I create a Data Connection to Nortwind. After Creating
the connection I can reach tables of this database.
But: When I want to configure the dataAdapter the problem occurs:
In the configure wizard "Data Soure Login" window comes.
Altought I know the user "sa" password This error comes:
"Login Failed:Not Associated With a Trusted SQL Server Connection. Invalid
Connection String Attribute."
How can I overcome with this problem.
What may be the reason of this problem.
Thanks for any help.
Arif imen
Prowise Software.Arif,
If your SQL Server is configured to accept Windows Authentication only, you
will get this error message when you attempt to use SQL authentication.
Please configure your DSN to use Windows Authentication and see if that
clear up the issue for you.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.