Re: Enterprise Manger Crash Creating user
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Wed, 17 May 2006 08:45:21 +0300
Patrick
Users and Logins are two different things
1)Logins are created to allow the person access to SQL Server .
2) Users are created to grant/allow access to the database/s located on the
server
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --------security
best practices
"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:21715426-1674-48EE-A782-0709C183E456@xxxxxxxxxxxxxxxx
Thx.
Q. Does a SQL Server User Id have be created on the NT Server on which
SQL
Server resides? Or can the NT user id be on another server?
"Uri Dimant" wrote:
Patrik
Open Query Analyzer and use
sp_adduser ,sp_dropuser system stored procedures
"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:899B491A-819F-4435-9CF5-6E5EB47BB13C@xxxxxxxxxxxxxxxx
Please can you help with this?
I created a new users for the first time in SQL Server 2000. While
doing
that, Enterprise Manager crashed....and:
1. If I try to add the user again, I get an error because the User
already
exists....yet I cannot see it on the console.
2. The user name does not show under Users (or Roles)
Any idea what I need to do to fix it - or what I might be doing
wrong???
Is there a problem with Enterprise manager, how can it be fixed?
(Looks
to
me like it fails while waiting for a response from NT...)
.
- References:
- Re: Enterprise Manger Crash Creating user
- From: Uri Dimant
- Re: Enterprise Manger Crash Creating user
- Prev by Date: Re: Changing login for dbo object (SQL Server 2000)
- Next by Date: Sql Server services
- Previous by thread: Re: Enterprise Manger Crash Creating user
- Next by thread: Changing login for dbo object (SQL Server 2000)
- Index(es):
Relevant Pages
|
|
