New to SQL 2005, need a little help

I come from a Sys Admin background so excuse my questions if their
simple in nature.
Anyways we purchase an e-mail system at our company that uses SQL
server as it's database. In the documentation, it states I need to
create a SQL account and give it a specific username and password. I
can create the account, but it doesn't ask for a password. Do SQL
account's usually have passwords, or could they be referring to the SA
password I used when installing SQL? Also, when creating a SQL account,
it asks for a user name and login name. I can specify the user name,
but I can only select from a small list login name's to use. If someone
can clarify what the login name is exactly I'd appreciate it (i believe
it's the windows security account which sql uses to gain access to the
server but i dont know).
Thanksbdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>
You are creating Windows Authentication logins, not SQL logins. SQL
Server supports both.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It might be useful for you to know more about SQL Server Security.
From SQL Server Management Studio, click on [Help], then [Contents], then
[SQL Server Books on Line], and find the topic [Security Considerations for
SQL Server]
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
<bdhenderson@.gmail.com> wrote in message
news:1152796948.762797.20070@.h48g2000cwc.googlegroups.com...
>I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>|||I think you are in the wrong section of the GUI. From what you
described in the GUI you connected to a server, and opened databases,
then opened a database, then opened security. You then right clicked
and selected new user.
What you actually need to do it after connecting to the server, leave
the databases folder closed. You should see a security folder. Open
that up, this will allow you to create a login and assign it a
password.
SQL Server has logins and users. Logins have passwords and allow you
to log into the database. Users are mapped to a login and give you the
right to see inside a single database on the server.
Denny
bdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thankssql

New to SQL 2005, need a little help

I come from a Sys Admin background so excuse my questions if their
simple in nature.
Anyways we purchase an e-mail system at our company that uses SQL
server as it's database. In the documentation, it states I need to
create a SQL account and give it a specific username and password. I
can create the account, but it doesn't ask for a password. Do SQL
account's usually have passwords, or could they be referring to the SA
password I used when installing SQL? Also, when creating a SQL account,
it asks for a user name and login name. I can specify the user name,
but I can only select from a small list login name's to use. If someone
can clarify what the login name is exactly I'd appreciate it (i believe
it's the windows security account which sql uses to gain access to the
server but i dont know).
Thanksbdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>
You are creating Windows Authentication logins, not SQL logins. SQL
Server supports both.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||It might be useful for you to know more about SQL Server Security.
From SQL Server Management Studio, click on [Help], then [Contents],
then
[SQL Server Books on Line], and find the topic [Security Considerati
ons for
SQL Server]
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
<bdhenderson@.gmail.com> wrote in message
news:1152796948.762797.20070@.h48g2000cwc.googlegroups.com...
>I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks
>|||I think you are in the wrong section of the GUI. From what you
described in the GUI you connected to a server, and opened databases,
then opened a database, then opened security. You then right clicked
and selected new user.
What you actually need to do it after connecting to the server, leave
the databases folder closed. You should see a security folder. Open
that up, this will allow you to create a login and assign it a
password.
SQL Server has logins and users. Logins have passwords and allow you
to log into the database. Users are mapped to a login and give you the
right to see inside a single database on the server.
Denny
bdhenderson@.gmail.com wrote:
> I come from a Sys Admin background so excuse my questions if their
> simple in nature.
> Anyways we purchase an e-mail system at our company that uses SQL
> server as it's database. In the documentation, it states I need to
> create a SQL account and give it a specific username and password. I
> can create the account, but it doesn't ask for a password. Do SQL
> account's usually have passwords, or could they be referring to the SA
> password I used when installing SQL? Also, when creating a SQL account,
> it asks for a user name and login name. I can specify the user name,
> but I can only select from a small list login name's to use. If someone
> can clarify what the login name is exactly I'd appreciate it (i believe
> it's the windows security account which sql uses to gain access to the
> server but i dont know).
> Thanks

NEW to SQL

hi everyone

right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.

Where can i gprogram SQL what are the software?
Creating database in Access is SQL?

Quote:

Originally Posted by OldSchool

hi everyone

right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.

Where can i gprogram SQL what are the software?
Creating database in Access is SQL?

Hi. A couple of things.
SQL is a high level database programming language. It will work with several relational database management systems (RDBMS) such as Microsoft SQL Server, Oracle and Access.|||

Quote:

Originally Posted by willakawill

Hi. A couple of things.
SQL is a high level database programming language. It will work with several relational database management systems (RDBMS) such as Microsoft SQL Server, Oracle and Access.

Thanks!

it is just a support not a real stand Alone Program?|||

Quote:

Originally Posted by OldSchool

Thanks!

it is just a support not a real stand Alone Program?

Correct. Access is a stand alone programme. SQL is a language that can be used to define and manipulate data in Access.|||

Quote:

Originally Posted by willakawill

Correct. Access is a stand alone programme. SQL is a language that can be used to define and manipulate data in Access.

thanks!
for example;
i have a table created in MS ACCESS;

Can you site a sample code using ACCESS and SQL?

thanks