SQL server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Billyboy (peter_at_visors.com.hk)
Date: 08/08/04 

Date: Mon, 9 Aug 2004 02:03:22 +0800

Hi,

I have setup SQL2000 that comes along with my Windows 2000 SBS server.

When I setup it up, it asked me for the user name and password that I wanted
to set, but it did not show the username as "SA" rather it showed it as the
"Administrator" and it wanted me to type my "Administrator" password.

Afterwards, it asked me what mode I wanted. I selected Windows mode of
authentication. Now I find that I can only connect with Windows
authentication from my OBDC drivers.

Did I setup my SQL server the wrong way?

Where is the part that asks me for the "SA" account and password?

Thanks.

Peter

Relevant Pages

  • Re: IIS / OWA
    ... Windows integrated authentication will not work in some ... use Basic + SSL should serve your security ... I have IIS setup with Integrated ...
    (microsoft.public.inetserver.iis.security)
  • Windows XP 802.1x / MAC authentication
    ... I'm trying to setup a 802.1x network. ... I want to have port based authentication. ... How can I setup this in Windows XP? ...
    (microsoft.public.windowsxp.network_web)
  • Event ID 537 Digest Authentication
    ... I am using a Windows 2003 SP1 server to setup a new website that will ... I have the only authentication for that web site set ...
    (microsoft.public.inetserver.iis.security)
  • Re: Auto log in Windows 2003 Server
    ... Hank Arnold ... >I just setup a Windows 2003 SBS server and it asked to login automatically. ...
    (microsoft.public.windows.server.general)
  • Duplicate Printers
    ... I have Windows 2003 SBS server that requires a printer to be setup more than ... We have several apps that need to use the printer in different ways, ...
    (microsoft.public.windows.server.sbs)