Re: SA has no access

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.

.

Relevant Pages

  • Re: SA has no access
    ... If you are really getting an access denied message, it's more likely you just have the wrong SA password. ... default installation setting). ... generic SQL Server access) or use username/password pair of logging into SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: SA has no access
    ... the said MSDE only uses Windows authentication mode (which is ... default installation setting). ... generic SQL Server access) or use username/password pair of logging into SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: RDP Sessions not "disconnecting"
    ... You can logon to the Console as Admin and Disconnect instead of logging off and this will leave Admin logged on to Synch Act and will leave 2 more Remote slots open. ... The other choice is to disconnect from a normal session as Admin instead of Logging off and when you connect again you will resume your session. ... server based apps - she also hits it from remote. ...
    (microsoft.public.windows.server.sbs)
  • Re: NDR delivery delayed errors keep coming, any advice?
    ... I have turned on the logging as you requested, and when I get a DNR 4.4.7, I ... The sending server tried to ... Delivery status notifications in Exchange Server and in Small Business ... The SMTP logging files are located in ...
    (microsoft.public.windows.server.sbs)
  • Re: Login Errors Seem to indicate we are being hacked?
    ... As an example, my Sonicwall keeps a log that I can read from the regular UI, as well as having the ability to report to a syslog server or e-mail out the log info. ... thing on the box using that authentication package. ... The SMTP or IIS logs should answer everything. ... I'm not familiar with that particular router or its logging capabilities, ...
    (microsoft.public.windows.server.sbs)
Loading