473,320 Members | 1,949 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL Server authentication

270 100+
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
9 1901
NitinSawant
270 100+
and also tell me how to change the name of the SQL Server.

I'm newbie in SQL 2005
Apr 7 '08 #2
balame2004
142 100+
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
2,878 Expert 2GB
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
NitinSawant
270 100+
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
NitinSawant
270 100+
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
NitinSawant
270 100+
Hey friends pls help!!!
Apr 7 '08 #7
ck9663
2,878 Expert 2GB
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
NitinSawant
270 100+
I'm using SQL server management studio, and i want sql server authentication to users for logging in.

Apr 8 '08 #9
ck9663
2,878 Expert 2GB
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

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

Similar topics

3
by: dale zhang | last post by:
Hi, I write an asp.net web application. It has a “Contact Us” page, where users fill in their email, subject and text and hit send. Then the email will go to my hard coded yahoo email...
4
by: Ravikanth[MVP] | last post by:
Hi It is possible that IIS and SQL Server can reside on Seperate Machines and you can use Integrated Windows Authentication to connect. Ravikanth >-----Original Message-----
2
by: Lior Amar | last post by:
Hey All, Trying to understand why I can not get SQL server to trust my IIS server. I have two machines set up, 1 App and 1 DB, and I'm trying to validate the applications access to the DB server...
2
by: news.microsoft.com | last post by:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I guess I get this because, my pages are hosted on WinXP IIS and the sql server is on Win2k3. ...
8
by: Nils Magnus Englund | last post by:
Hello, I am having trouble using Integrated Windows Authentication between our intranet server and our database server, both of which are on our local domain. Windows authentication works for...
7
by: Alice Wong | last post by:
I am setting up my Web ASP.net application to connect to Sql server using windows authentication. I set up IIS to have integrated windows authenication and sql to allow Windows authentication....
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
18
by: troywalker | last post by:
I am new to LDAP and Directory Services, and I have a project that requires me to authenticate users against a Sun Java System Directory Server in order to access the application. I have found...
4
by: Preben Zacho | last post by:
Hi there The scenario I got is this: I have created a Windows application in VS and I want to deploy it to another machine running Windows Vista. Since I have no control over this other machine,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shllpp 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.