• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3177
  • Last Modified:

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
0
shang3000
Asked:
shang3000
  • 2
  • 2
  • 2
  • +1
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
RightClick on the server -> properties -> Security

Now you can select 'Wndows' authentication
0
 
gena17Commented:
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
 
gena17Commented:
Oooops :)
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now