Restrict access during a few hours

While we update our datawarehouse we don't want the users
to be able to connect to the database and update
their reports.
So we want to block access during certain hours.
What is the best way fix this?
The users use a SqlServer login with permission to read
data.Hi
It easiest would be to set it to dbo use only (assuming your users do not
have dbo rights)
ALTER DATABASE northwind
SET RESTRICTED_USER
Regards
Mike
"Leif" wrote:

> While we update our datawarehouse we don't want the users
> to be able to connect to the database and update
> their reports.
> So we want to block access during certain hours.
> What is the best way fix this?
> The users use a SqlServer login with permission to read
> data.
>

Restrict access during a few hours

While we update our datawarehouse we don't want the users
to be able to connect to the database and update
their reports.
So we want to block access during certain hours.
What is the best way fix this?
The users use a SqlServer login with permission to read
data.
Hi
It easiest would be to set it to dbo use only (assuming your users do not
have dbo rights)
ALTER DATABASE northwind
SET RESTRICTED_USER
Regards
Mike
"Leif" wrote:

> While we update our datawarehouse we don't want the users
> to be able to connect to the database and update
> their reports.
> So we want to block access during certain hours.
> What is the best way fix this?
> The users use a SqlServer login with permission to read
> data.
>

restrict acces to server from lan

Hello,
I got a new SQL 2000 server running. Now we have some clients with local
msde's who are not allowed to connect to that server with their client. Can
this be done? they need network acces and they need to be able op connect to
that server using another application. So it's strictly their local engine
what they are not allowed to use to open that database on their local system
Sincerely
evbHi
I am not quite sure what you are asking here. You don't say how they are
connecting to the database server. Usually the connection string will
specify which server you are going to connect to. Access to your database
server/database will depend on the security that you put in place and you
can restrict the access to your own application by using an application
role.
If the MSDE instance does not contain a copy of your database then there
will not be able to run your application.
John
"E van Bergen" <evanbergen.no.spam@.modderkolk.no.spam.nl> wrote in message
news:co7cmj$jj$1@.reader08.wxs.nl...
> Hello,
> I got a new SQL 2000 server running. Now we have some clients with local
> msde's who are not allowed to connect to that server with their client.
> Can
> this be done? they need network acces and they need to be able op connect
> to
> that server using another application. So it's strictly their local engine
> what they are not allowed to use to open that database on their local
> system
>
> Sincerely
> evb
>sql

restriced access

HI,

how can i restrict the access for my sqlserver DB.
I can connect with any Connection STring.
What do i have to change so that u can only access the db with the correct username and password from an app?

thats my connString.
"Data Source=TURM21;Database=Db1;User id= kr; password=hahn; Trusted_connection= true;pooling=false;"

Is it a Property Setting in Sql Server? Where is this Setting?

GreetzHi

You have two security settings in SQL Server:
Windows Authenication Only and mixed (Windows and SQL Server). Make sure you are set to use both.

Your connection string includes:
Trusted_connection= true
This means that your NT log is used to access SQL Server. The username and password you supply are ignored. It is your NT account that is giving you access to the server. Remove this from your connection string and the SQL Server username and password you supply will be used to authenticate you.

BTW - MS recommend you access SQL Server using your NT credentials.

HTH|||ok i switched to mixed authentification.

my connection string is:

Data Source=TURM21;Database=Db1;User Id=kroete;password=hahn;pooling=false;

the user was createdlike this:

CREATE LOGIN kroete
WITH PASSWORD = 'hahn';
use Db1;
create User kroete;
GO

But now i get an SQLException: error during login;

I don't know what the problem is?

Cheers|||Apart from your userID changing from the first post? ;)

Double check your password (not what I'd describe as strong BTW). Try logging via QA with those credentials. If you succeed then it is probably the client code. If you fail then your username\ password are wong.

HTH|||no the user id is correct:)

Ok i tried to connect directly (Sql Server Management Stduio) wit Sql Server Authentification and i can not connect.

Is the way, I created the user correct?

CREATE LOGIN kroete
WITH PASSWORD = 'hahn';
use Db1;
create User kroete;
GO|||ok - what's the exception description then? :)|||You forgot FROM clause in your CREATE USER statement.|||From clause? Why? And how?
Will post the exception later. Don#T have it here.