how to enable a user account

I found the the status of guest account in model database is abnormal,but i don't know how to make it active.

any suggestions?

thanks

You can make it active using

use model

go

GRANT CONNECT to guest

Attention, all new databases created will have the guest active; remember if a login hasn't an user in a database it use guest to acces database objects.

|||

If you mean that is disabled (as Gigi Ciubuc suggested), then it is the default behavior. Please notice that enabling guest access to model DB is highly discouraged as it will grant guest access on model, but on any newly created DB (as GigiCiubuc also pointed out).

If our guess is incorrect regarding the description of your problem; can you please explain with more detail what do you mean with an abnormal guest account? Thanks a lot.

I hope your question was answer as expected, but let us know if you have any further questions or feedback.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

|||

thanks all.

The problem is solved . I just want to know how to enable user account

Although I can't find any way to enable the use in SQL SERVER Manage Studio, the "GRANT CONNECT to guest" command works

thanks