RE: Urgent problem about SQL Server

Sean McCown (SeanMcCown@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I'm curious as to why you felt it necessary to try to call out my first
step as being wrong somehow. Is there something you're trying to prove
by coming on and telling me I'm wrong? What did you hope to gain by
specifically telling me I was wrong instead of just letting the answer
ride?

Because that I have seen more than one post which have indicated that people
have scratch their hair over usernames, authentication etc when they have
seen this message, being mislead by the "access is denied" part.

When you get this message, you are not able to reach SQL Server at all, and
it does not matter whether the username and password you entered are valid
or not.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • RE: Audit Table
    ... want to record and return the current login username to certain table in ... SQL Server, when you performed insert or update action. ... Which authentication do you choose to log on IIS? ... So far as I know, if we want to record the usernames used for SQL Server, ...
    (microsoft.public.sqlserver.security)
  • Re: object level permissions being lost when migrating
    ... shouldn't be an issue, but I have to wonder if it somehow is, because ... Sounds like you are not running SP2 of the tools. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Selecting alphanumeric combinations that do not exist already in table?????
    ... reserved for currently inactive customers. ... boss had was to create a table of unused usernames and randomly ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Is there any way to find out username pwd in Access
    ... If Access allowed obtaining the user's password through the programming ... for that reason. ... >for Sql server logon? ... >sql server usernames and passwords. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Selecting alphanumeric combinations that do not exist already in table?????
    ... generated username that is a 6 character, alphanumeric, field. ... usernames are randomly generated by code. ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)