Authentication

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.
__________________________________

"Adrian" <00@00.00> wrote in message
news:450ef207$0$751$5fc3050@dreader2.news.tiscali.nl...
>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.
>
>

Sorry, I wouldn't know how.
Could you please tell me?
Adrian.


"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:%23mCps112GHA.2176@TK2MSFTNGP04.phx.gbl...
> 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.
> __________________________________
>
> "Adrian" <00@00.00> wrote in message
> news:450ef207$0$751$5fc3050@dreader2.news.tiscali.nl...
> >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.
> >
> >
>
>

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.
__________________________________

"Adrian" <00@00.00> wrote in message
news:450f03d1$0$712$5fc3050@dreader2.news.tiscali.nl...
> Sorry, I wouldn't know how.
> Could you please tell me?
> Adrian.
>
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:%23mCps112GHA.2176@TK2MSFTNGP04.phx.gbl...
>> 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.
>> __________________________________
>>
>> "Adrian" <00@00.00> wrote in message
>> news:450ef207$0$751$5fc3050@dreader2.news.tiscali.nl...
>> >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.
>> >
>> >
>>
>>
>
>

Sleep well.

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:eHm7WT22GHA.4524@TK2MSFTNGP06.phx.gbl...
> 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.
> __________________________________
>
> "Adrian" <00@00.00> wrote in message
> news:450f03d1$0$712$5fc3050@dreader2.news.tiscali.nl...
> > Sorry, I wouldn't know how.
> > Could you please tell me?
> > Adrian.
> >
> >
> > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> > news:%23mCps112GHA.2176@TK2MSFTNGP04.phx.gbl...
> >> 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.
> >> __________________________________
> >>
> >> "Adrian" <00@00.00> wrote in message
> >> news:450ef207$0$751$5fc3050@dreader2.news.tiscali.nl...
> >> >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.
> >> >
> >> >
> >>
> >>
> >
> >
>
>
>

On Mon, 18 Sep 2006 21:22:47 +0200, "Adrian" <00@00.00> wrote:

¤ 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/v...dows/mixedmode/


Paul
~~~~
Microsoft MVP (Visual Basic)