Re: Username, Password at the Web Data Admin

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/29/04

  • Next message: Hari Prasad: "Re: Adding a database user" 
    Date: Fri, 28 May 2004 18:37:11 -0400

    Greg,

    I have never used the Web administrator but I assume it is asking for the
    login and passwords for SQL Server and not your machine. The easiest way is
    to probably just use Windows Authentication method and then all you should
    have to do is specify the server name. If you want to use SQL Logins you
    probably want to use sa for the login and whatever you chose for the sa
    password when you installed SQL Server. 

    -- 
Andrew J. Kelly
SQL Server MVP
"Greg" <anonymous@discussions.microsoft.com> wrote in message
news:1460201c444ed$cd743720$a601280a@phx.gbl...
> I placed SQL Server 2000 and the Web Data Adminstrator
> onto my "completely non-networked" laptop so that I could
> use the Web Data Administrator.  I have now gotten
> farther on the install.  I am now at this window:
> Welcome to the Web Data Administrator.
> Please enter your SQL Server credentials.
> Username
> Password
> Server
> Authentication Method
>
> I don't know any of the answers to these four questions.
>
> ~~Possible username
> Under User Accounts, the account that is the "Computer
> administrator" is "Greg new".
>
> ~~ Regarding password
> I'm 99% sure there is no password with this.  When I turn
> the computer on and "log in" I do not put a password with
> it.
>
> ~~ Server
> My computer is the "Dell 2ZV4T98".  When I get an error
> message after compiling (using Web Matrix)it says "Login
> failed for user 'DELL_2ZV4T98\Greg new".  Maybe that
> helps.
>
> ~~ Authentication method:
> They offer either "Windows Integrated" or "SQL login"
>
> Whatever you can tell me, thank you!
  • Next message: Hari Prasad: "Re: Adding a database user"

    Relevant Pages

    • Re: MSSQL$SBSMONITORING Login to Disabled Account?
      ... SQL Server installed, I can't have the tools you were using, can I? ... I still don't know what that process is doing trying to login to the ... Administrator account and I don't understand why this login attempt is ...
      (microsoft.public.windows.server.sbs)
    • Re: Domain Admin login failure.
      ... specific login in SQL Server. ... Then it won't need it's admin privileges. ... Rick Byham, SQL Server Books Online ... administrator, it will let my domain admin account login. ...
      (microsoft.public.sqlserver.security)
    • Re: Builtin Administrators Group and SQL Agent Jobs
      ... >gave that login full access to all SQL DB's. ... >group and rights to all the SQL Server databases. ... >Administrator Server role explicitly. ... >account that is a member of the DBA group and this group ...
      (microsoft.public.sqlserver.security)
    • Re: Windows Vista Enterprise and SQL Server 2005 Agent
      ... You just need to make sure that the login that you are using has it's own login in SQL Server, and that the login being used by the SQL Server Agent is a member of the SQL Server sysadmin fixed server role. ... It all seems to be related to security things, even though I am an administrator. ... I loaded SQL Server Management Studio the other day and decided to start the SQL Agent service. ...
      (microsoft.public.sqlserver.security)
    • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
      ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
      (microsoft.public.sqlserver.connect)