Member Avatar for Jihad

I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this change in the connection type?
Thank you

  • 3 Contributors
  • 3 Replies
  • 176 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by Rapish
Member Avatar for Nige Ridd

In SQL Server Management Studio, connect to your server. Then right mouse click on the Server in on Object Explorer window and select Properties.
This should show a new dialog, and a 'Select a page' panel on the left - choose Security and the you should see the settings to change the Authentication mode.
As the option is SQL server and windows authentication - I can't see it affecting your existing work. Just be careful that things don't just work as it's you logged into windows!
Nige

Member Avatar for Jihad

Thanks for the help Nige. Its that I am using windows auth in the connection string in my website. I want to change it to server auth, but in my server its windows server auth mode.
I can login as windows auth, but i cann't as server auth. I don't know how to make that database that I am working on be logged on as server auth, and how to get the admin pass if it ever existed to change it.
I have no experience in server security, I need a help to setup the server auth.I mean how to login if I dunno what the password ad username for the first time and where to change it.

Thank you

Member Avatar for Rapish

try this information on:
http://msdn.microsoft.com/en-us/library/ms188670.aspx

after applying steps on the previous link, if it doesn't work
To enable the sa login by using Management Studio

1.

In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
2.

On the General page, you might have to create and confirm a password for the sa login, check in (Map to Credential).
3.

On the Status page, in the Login section, click Enabled, and then click OK.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.