Create a new user

hi

im unable to create a new sql server authentication login

It is appreciated if anyone helps me

thanks in advance

It seems as though your login does not have permission to create a new login.

Log in as the administrator, and give your login the appropriate priviledges.

|||

What does "unable" eman in your case, you did not specify if you are getting an error or the login is just not working ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

hi jens,

thanks for your reply

I logged in with windows authentication and tried to create a new login for sql server authentication..it didnt work

then i logged in windows mode and tried to create tables...that also didnt work....then only i got the solution that i have to install SP 2 and while installing i can specify the authentication as windows (or) sql server (or) both....

so i installed and specified the authentication as mixed and it is working fine now

Thanks,

Poorani

Couple Issues Relating to SQL Server Security/Login

Hello,
Is it possible to tell SQL Server Express to only use SQL Authentication? I
would like it so that there is just an sa SQL account on a SQL Server
instance. Is it possible to script the SQL Server Express setup to do just
that? I certainly understand that it can be more secure to use Windows
Security over SQL Authentication, however the password is very strong (64
characters in length randomized).
Sincerely,
James Simpson
Straightway Technologies Inc.There are only two authentication modes to login to SQL Server.
1- Windows (only) Authentication
2- Mixed Authentication
There is no 3- SQL (only) Authentication.
However, you can delete Windows Logins from the Security node in SSMS, so,
only users who has SQL Login accounts will be able to login to your SQL
Server. However this is a little bit risky as you'll have only one sysadmin
("sa" in your case) and if you somehow lose its password or something then
you'll be locked yourself and can not get in to your SQL Server. You must be
very very careful about this operation.
Ekrem ?nsoy
"James Simpson" <JamesSimpson@.discussions.microsoft.com> wrote in message
news:481D3155-0061-46F2-912C-8003D6C4A950@.microsoft.com...
> Hello,
> Is it possible to tell SQL Server Express to only use SQL Authentication?
> I
> would like it so that there is just an sa SQL account on a SQL Server
> instance. Is it possible to script the SQL Server Express setup to do
> just
> that? I certainly understand that it can be more secure to use Windows
> Security over SQL Authentication, however the password is very strong (64
> characters in length randomized).
> Sincerely,
> James Simpson
> Straightway Technologies Inc.|||Fair enough. I am not worried about losing the password per se since it wil
l
be an application that will be logging into SQL Server for me.
Sincerely,
James Simpson
Straightway Technologies Inc.