Really basic question...

I have bumbled along and managed to install a SQL server
on my machine... and with the install I have created a
user "Admin" along with a password ( yay )
Anyways... what I would like to know now is how to create
other users and allow them access to the DB.
Thanks
MeHi,
SQL Server supports 2 types of authentications,
1. SQL Server
2. OS Level
If it is SQL Server , Login to server using Enterprise manager then select
the security tab.
1. Right click on logins and add a new login.
2. Provide the user name and select SQL server authentication
3. Give a password and select the required servide wide roles
4. Give the database that user need access.
If it is OS Level , you have to create the user at OS level and use the same
security tab to give the roles and access to databases.
Thanks
Hari
MCDBA
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...

quote:

---

> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me

---

|||Use a tool like Enterprise Manager to create users. You need to create
logins in SQL Server and then map these logins to databases.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...

quote:

---

> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me

---

|||Which should be the prefferred way to add users?
SQL Server or OS level

quote:

---

>--Original Message--
>Hi,
>SQL Server supports 2 types of authentications,
>1. SQL Server
>2. OS Level
>If it is SQL Server , Login to server using Enterprise

---

manager then select

quote:

---

>the security tab.
>1. Right click on logins and add a new login.
>2. Provide the user name and select SQL server

---

authentication

quote:

---

>3. Give a password and select the required servide wide

---

roles

quote:

---

>4. Give the database that user need access.
>If it is OS Level , you have to create the user at OS

---

level and use the same

quote:

---

>security tab to give the roles and access to databases.
>Thanks
>Hari
>MCDBA
>"me" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
server[QUOTE]
create[QUOTE]
>
>.
>

---