Re: "Login failed for user '(null)' reason: not associated...
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/04/03
- Next message: Jeff: "Queries run against database"
- Previous message: Jeff Clausius: "Re: SQL Server goes down when internet is disconnected"
- In reply to: carlos aguero: ""Login failed for user '(null)' reason: not associated..."
- Next in thread: Rand Boyd [MS]: "RE: "Login failed for user '(null)' reason: not associated..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 04 Nov 2003 08:34:13 -0700
You'd want to consider using DSN-less connections in your
application. Then the DSN or login prompts are not the issue
and it's just a matter of the correct code in the
application. What to code depends on the servers
authentication mode and somewhat on your application. You
can use Windows Authentication or SQL login depending on the
authentication mode of your server. Another option if you
are controlling all of this through your application is to
use Application roles.
You can find more information on Authentication and
applications roles in books online. If you are using ADO to
connect to SQL Server, you can find sample connection
strings at:
http://www.able-consulting.com/ADO_Conn.htm
-Sue
On Tue, 4 Nov 2003 06:55:57 -0800, "carlos aguero"
<anonymous@discussions.microsoft.com> wrote:
>"Login failed for user '(null)'reason: not associated with
>a truested SQL server.
>Does anyone know what this is all about? This is the
>problem. I run sql server 7 in machine A. I run an
>application on machine B. I created an ODBC in machine B.
>But when running the app....sql server requires a login
>name.
>One answer is to tell the sql server not to request a
>login name at all. I control the access to the data within
>my application. Now, How do I do that? To set up SQL
>server to not request login name.
>Any help will be appreciated!!
>Carlos Aguero
- Next message: Jeff: "Queries run against database"
- Previous message: Jeff Clausius: "Re: SQL Server goes down when internet is disconnected"
- In reply to: carlos aguero: ""Login failed for user '(null)' reason: not associated..."
- Next in thread: Rand Boyd [MS]: "RE: "Login failed for user '(null)' reason: not associated..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
