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...
> 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...
> 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|||Click the folder Security and expand
Right Click the folder Logins and select "New User"
The rest you will need to read up on.
If you need a bit more advise then email me. In reverse
order(to stop autospammers) my email is
moc.liamtoh.em_yrewolf_elttil
J
PS Never give your Admin password out to anyone - Keep it
safe, Keep it Secret.
>--Original Message--
>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
>--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
>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...
>> 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
>
>.
>|||Thanks for all of the great help... Is there a way to do
this programmatically ?
Thanks
Me
>--Original Message--
>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
>.
>

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]
>
>.
>

---

Really basic question about inserting data into a SQL database

Hi everyone,

I'm new to programming, and trying to learn and can't seem to find a clear-cut answer on how to insert text from a textbox into a database as a new record. I have a textbox and a button that when the button_click even is fired, that it will insert the data from the textbox as a new record. Any help will be greatly appreciated!!

If it's SQL Server you can do something like this (in C#)

SqlConnection conn = new SqlConnection("Server=<servername>;Database=<dbName>;Integrated Security=true");

conn.Open();

string sql = "Insert into.... the rest of your insert statement";

SqlCommand cmd = new SqlCommand(sql, conn);

cmd.ExecuteNonQuery();

conn.Close();

Or you can modify that a bit and use a stored procedure if that suits your needs better. If you need to connect with a username/password just remove the integrated security part of the connection string and add the username/password.

Hope that helps.

|||

i'm using Visual Basic

to perform an insert

when a button add is pressed

its surpose to insert the data from a textbox to the database

the data type of the tables column is char(4)

its similar to the top code but u have to add some other stuff do u know what they are

Really basic question about inserting data into a SQL database

Hi everyone,

I'm new to programming, and trying to learn and can't seem to find a clear-cut answer on how to insert text from a textbox into a database as a new record. I have a textbox and a button that when the button_click even is fired, that it will insert the data from the textbox as a new record. Any help will be greatly appreciated!!

If it's SQL Server you can do something like this (in C#)

SqlConnection conn = new SqlConnection("Server=<servername>;Database=<dbName>;Integrated Security=true");

conn.Open();

string sql = "Insert into.... the rest of your insert statement";

SqlCommand cmd = new SqlCommand(sql, conn);

cmd.ExecuteNonQuery();

conn.Close();

Or you can modify that a bit and use a stored procedure if that suits your needs better. If you need to connect with a username/password just remove the integrated security part of the connection string and add the username/password.

Hope that helps.

|||

i'm using Visual Basic

to perform an insert

when a button add is pressed

its surpose to insert the data from a textbox to the database

the data type of the tables column is char(4)

its similar to the top code but u have to add some other stuff do u know what they are