By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,343 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

SQL Server authentication

100+
P: 270
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
Apr 7 '08 #1
Share this Question
Share on Google+
9 Replies


100+
P: 270
and also tell me how to change the name of the SQL Server.

I'm newbie in SQL 2005
Apr 7 '08 #2

100+
P: 142
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
Apr 7 '08 #3

ck9663
Expert 2.5K+
P: 2,878
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
Apr 7 '08 #4

100+
P: 270
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.
Apr 7 '08 #5

100+
P: 270
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.
Apr 7 '08 #6

100+
P: 270
Hey friends pls help!!!
Apr 7 '08 #7

ck9663
Expert 2.5K+
P: 2,878
You said "Every time i logon to server with windows authentication, that works fine". What are you using to connect?

-- CK
Apr 7 '08 #8

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

Apr 8 '08 #9

ck9663
Expert 2.5K+
P: 2,878
You're doing the right thing. There's no shortcut in adding each individual account aside from adding it manually.

-- CK
Apr 8 '08 #10

Post your reply

Sign in to post your reply or Sign up for a free account.