Results 1 to 4 of 4

Thread: login

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Unanswered: login

    what is the login procedure for sql server?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    usually i just enter my username and password into the appropriate fields and press enter

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by r937
    usually i just enter my username and password into the appropriate fields and press enter

    And you claim not to be a DBA
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There are literally dozens of ways to log in to SQL Server, depending on how the security has been set up. When you add the complexity of user developed front ends, the number of ways to log in goes into the tens of thousands.

    Considering only Microsoft's Query Analyzer, I can go for the short list. Keep in mind that if your configuration requires C2 hardware tokens, you must have them recognized BEFORE you can launch Query Analyzer in C2 mode.

    1. In a simple, Windows authenticated and AD managed configuration, you double click the Query Analyzer icon and you're done. Nothing more is needed.

    2. In a conventional Windows Authenticated configuration, double click query analyser, then enter or select your server name and press Ok.

    3. In a SQL Authenticated configuration, enter your server, login name, and password, then click Ok.

    4. In any of the "developer" configurations, contact the appropriate developer. These choices are endless!

    You really need to discuss this whole process in more detail with the administrator(s) of the SQL Server you are trying to access. Depending on how they've configured SQL Server's security, there could be lots of issues preventing you from connecting, some of which have nothing at all to do with security!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •