Re: SA has no access
- From: "Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 14 Mar 2007 10:41:26 -0700
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" <martin@xxxxxxxxx> wrote in message news:1173886545.683840.108840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 14, 3:28 pm, "Norman Yuan" <NotR...@xxxxxxxxxxx> 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" <mar...@xxxxxxxxx> wrote in message
news:1173872861.095125.251680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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.
.
- References:
- SA has no access
- From: Tokatrash
- Re: SA has no access
- From: Norman Yuan
- Re: SA has no access
- From: Tokatrash
- SA has no access
- Prev by Date: Re: SA has no access
- Next by Date: Re: DB size limit on SQL2k Personal Edition
- Previous by thread: Re: SA has no access
- Next by thread: Re: DB size limit on SQL2k Personal Edition
- Index(es):
Relevant Pages
|
Loading
