RE: Invalid authorization specification

From: Fany Vargas [MSFT] (fanyv_at_online.microsoft.com)
Date: 11/21/04


Date: Sun, 21 Nov 2004 06:47:16 GMT

Does your application use a DSN to connect to SQL Server? If so ensure this
DSN is setup correctly on the client machine.

This error is similar to the "login failed for user <usr>" Thus you should
troubleshoot it similarly. For instrance, try connecting from this client
using both SQL and NT authentication. To simplify troubleshooting, try
taking your application out of the picture by testing UDL file connections
and from odbc administrator(test dsn). Is the same error displayed when
testing connectivity using these client tools?

Also see KB: How to troubleshoot connectivity issues in SQL Server 2000 -
ID: 827422 9available at http://support.microsoft.com)

Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx



Relevant Pages

  • Re: Client applications
    ... and you'll find many ways to build a connection string without a DSN. ... I have been given the responsibility of upgrading a client application ... with database authentication with SQL Server. ...
    (comp.databases.ms-sqlserver)
  • Access front end creates many "sleeping" connection
    ... I have Access 2003 MDB file as front end to a SQL server database. ... that for each client, there is about 5 connection to SQL server. ... I also check to make sure that using DSN with connection pooling, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Better approach for common business problem ? (long post)
    ... If DSN Requested is always the same as DSN Used, ... The fact you have dimension security on your cube makes me think you might ... client, and how much data is moved over the network. ... months together into a level of six members, ...
    (microsoft.public.sqlserver.olap)