?
Solved

how can I change authentication type to sql server authentication on sql server express 2005

Posted on 2006-10-30
7
Medium Priority
?
3,173 Views
Last Modified: 2013-12-03
Hi, I have ms sql server express 2005

when I connect to sql server express 2005  using  user sa
it gives me this error

Cannot connect to pc-1\sqlexpress
Additional information
Login failed for user 'sa' The user is not associated with a trusted sql server connection

how can I change authentication type to sql server authentication instead of windows autheintication using sql server management studio express

can any body  help  in that

thanx
0
Comment
Question by:shang3000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 400 total points
ID: 17832292
RightClick on the server -> properties -> Security

Now you can select 'Wndows' authentication
0
 
LVL 8

Accepted Solution

by:
gena17 earned 1600 total points
ID: 17832301
I'm not sure about express, but it works for standard:
SQL Management Studio
Right click on your server instance
Properties
Security
Select your server authentication

Don't forget to restart after.
0
 
LVL 8

Expert Comment

by:gena17
ID: 17832303
Oooops :)
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 28

Expert Comment

by:imran_fast
ID: 17832314
RightClick on the server -> properties -> Security
select mixed mode
0
 

Author Comment

by:shang3000
ID: 17832337
I did what you said it gived me this error message

Cannot connect to pc-1\sqlexpress
a Connection was successfully established with the server, but then an error occurred during the login process(provider: shared memory provider error:0 - No process is on the other end of the pipe )(microsoft sql server , Error:233)

when I try the same steps again  it gives this error :

Cannot connect to pc-1\sqlexpress
Additional information
Login failed for user 'sa' The user is not associated with a trusted sql server connection (microsoft sql server, Error: 18452)
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 17832390
Did you restrat services after that .

0
 

Author Comment

by:shang3000
ID: 17832425
It worked I restarted the machine and it worked
Thanx guys
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question