SQL Server authentication

[NitinSawant]

Hi friends i have some problems:

Every time i logon to server with windows authentication, that works fine,
i want to logon to server using username "sa" and password "password",
when i try to logon with "sa" it says "Login failed for user sa"
pls tell me how to add user "sa" to sql server authentication user list

[NitinSawant]

and also tell me how to change the name of the SQL Server.

I'm newbie in SQL 2005

[balame2004]

Hi,

I think you intsalled sql server 2005 with windows authentication mode that is why it doesn't allow you to login in sql server authentication mode. Please uninstall sql server 2005(Control Panel->Add Remove Programs - > Remove Sql server softwares) and install sql server with sql server authentication mode.

Regards,
Balaji U

[ck9663]

On your Enterprise Manager, try to connect to your server. Once the connection wizard shows up, change the server name to your server name. On the Authentication drop box, change Authentication from Windows Authentication to SQL Server Authentication.

Type user name and password, then login.

-- CK

[NitinSawant]

Hi,

I think you intsalled sql server 2005 with windows authentication mode that is why it doesn't allow you to login in sql server authentication mode. Please uninstall sql server 2005(Control Panel->Add Remove Programs - > Remove Sql server softwares) and install sql server with sql server authentication mode.

Regards,
Balaji U

Isn't there any other way to achieve this, b'coz i need to add 35 more accounts to my sql server authentication list, so wat to do??? actually every time adding a user ,i cannot reinstall it. It will be more time consuming.

[NitinSawant]

On your Enterprise Manager, try to connect to your server. Once the connection wizard shows up, change the server name to your server name. On the Authentication drop box, change Authentication from Windows Authentication to SQL Server Authentication.

Type user name and password, then login.

-- CK

thanx for replying,
but what's Enterprise Manager??
how to open it??


Hey bros pls help me i'm totally newbie :-)

Thanx in advance.

[NitinSawant]

Hey friends pls help!!!

[ck9663]

You said "Every time i logon to server with windows authentication, that works fine". What are you using to connect?

-- CK

[NitinSawant]

I'm using SQL server management studio, and i want sql server authentication to users for logging in.

[ck9663]

You're doing the right thing. There's no shortcut in adding each individual account aside from adding it manually.

-- CK