SA has no access   

Hi all,

I've installed a program called Winfinance who saves it's data to
MSDE.
When i log on to the database with my credentials as a server
administrator i get access, however, when i try to log on as the "sa"
i get access denied.

Does anybody have a guess why i don't get access or a way that i can
get it?

Looking forward to hear from you.

date: 14 Mar 2007 04:47:41 -0700   author:   Tokatrash

Re: SA has no access   

Apparently, the said MSDE only uses Windows authentication mode (which is 
default installation setting). If you want to use SA account (bad idea for 
generic SQL Server access) or use username/password pair of logging into SQL 
Server/MSDE, you need to explicitly enable mixed security mode.

"Tokatrash"  wrote in message 
news:1173872861.095125.251680@l75g2000hse.googlegroups.com...
> Hi all,
>
> I've installed a program called Winfinance who saves it's data to
> MSDE.
> When i log on to the database with my credentials as a server
> administrator i get access, however, when i try to log on as the "sa"
> i get access denied.
>
> Does anybody have a guess why i don't get access or a way that i can
> get it?
>
> Looking forward to hear from you.
>

date: Wed, 14 Mar 2007 07:28:34 -0700   author:   Norman Yuan

Re: SA has no access   

On Mar 14, 3:28 pm, "Norman Yuan"  wrote:
> Apparently, the said MSDE only uses Windows authentication mode (which is
> default installation setting). If you want to use SA account (bad idea for
> generic SQL Server access) or use username/password pair of logging into SQL
> Server/MSDE, you need to explicitly enable mixed security mode.
>
> "Tokatrash"  wrote in message
>
> news:1173872861.095125.251680@l75g2000hse.googlegroups.com...
>
> > Hi all,
>
> > I've installed a program called Winfinance who saves it's data to
> > MSDE.
> > When i log on to the database with my credentials as a server
> > administrator i get access, however, when i try to log on as the "sa"
> > i get access denied.
>
> > Does anybody have a guess why i don't get access or a way that i can
> > get it?
>
> > Looking forward to hear from you.

I did not know that.

I will read up on the documentation and return.

Thank you so far.

date: 14 Mar 2007 08:35:45 -0700   author:   Tokatrash

Re: SA has no access   

While this is certainly a possible explanation, this would give you an error 
that said something about trusted connections.  If you are really getting an 
access denied message, it's more likely you just have the wrong SA password.

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Tokatrash"  wrote in message 
news:1173886545.683840.108840@p15g2000hsd.googlegroups.com...
> On Mar 14, 3:28 pm, "Norman Yuan"  wrote:
>> Apparently, the said MSDE only uses Windows authentication mode (which is
>> default installation setting). If you want to use SA account (bad idea 
>> for
>> generic SQL Server access) or use username/password pair of logging into 
>> SQL
>> Server/MSDE, you need to explicitly enable mixed security mode.
>>
>> "Tokatrash"  wrote in message
>>
>> news:1173872861.095125.251680@l75g2000hse.googlegroups.com...
>>
>> > Hi all,
>>
>> > I've installed a program called Winfinance who saves it's data to
>> > MSDE.
>> > When i log on to the database with my credentials as a server
>> > administrator i get access, however, when i try to log on as the "sa"
>> > i get access denied.
>>
>> > Does anybody have a guess why i don't get access or a way that i can
>> > get it?
>>
>> > Looking forward to hear from you.
>
> I did not know that.
>
> I will read up on the documentation and return.
>
> Thank you so far.
>

date: Wed, 14 Mar 2007 10:41:26 -0700   author:   Roger Wolter[MSFT]