Authentication

  • Thread starter Thread starter Adrian
  • Start date Start date
A

Adrian

I have my SQL Server 2005 Express set up for Windows authentication. An
application I want to run uses SQL Server Authentication. How can I
reconfigure my SQL Server 2005 Express to allow for that?

Adrian.
 
You need to make sure the user's credentials are in the SQLEXPRESS
instance's Logins. That is, unless you're using User Instance=True. In this
case, the User is considered to be the SA and is granted full rights to the
special instance created just for the user.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Sorry, no more time today.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Sleep well.

William (Bill) Vaughn said:
Sorry, no more time today.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Click to expand...
 
¤ I have my SQL Server 2005 Express set up for Windows authentication. An
¤ application I want to run uses SQL Server Authentication. How can I
¤ reconfigure my SQL Server 2005 Express to allow for that?

You can configure SQL Server to support both types of authentication:

http://www.hostmysite.com/support/vps/windows/mixedmode/


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top