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

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
shang3000Asked:
Who is Participating?
 
gena17Connect With a Mentor Commented:
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
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
RightClick on the server -> properties -> Security

Now you can select 'Wndows' authentication
0
 
gena17Commented:
Oooops :)
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
imran_fastCommented:
RightClick on the server -> properties -> Security
select mixed mode
0
 
shang3000Author Commented:
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
 
imran_fastCommented:
Did you restrat services after that .

0
 
shang3000Author Commented:
It worked I restarted the machine and it worked
Thanx guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.