New to SQL 2005, need a little help  
Author Message
HagarTheHorrible





PostPosted: Thu Jul 13 08:29:56 CDT 2006 Top

SQL Server >> 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).

Thanks

SQL Server271  
 
 
Tracy





PostPosted: Thu Jul 13 08:29:56 CDT 2006 Top

SQL Server >> 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).
>
> Thanks
>

You are creating Windows Authentication logins, not SQL logins. SQL
Server supports both.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
 
 
Arnie





PostPosted: Thu Jul 13 09:09:39 CDT 2006 Top

SQL Server >> New to SQL 2005, need a little help 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."





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


 
 
mrdenny





PostPosted: Thu Jul 13 17:30:55 CDT 2006 Top

SQL Server >> New to SQL 2005, need a little help 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



> 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