Re: MS OLE DB Provider for SQL Server Error: Invalid authorization spe

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 21:38:45 +0000 (UTC)

AUMFC (AUMFC@discussions.microsoft.com) writes:
> MS OLE DB Provider for SQL Server Error: Invalid authorization
> specification
>
> This is a basic 3-tier system, front end, data broker, database. The
> front end software is written in VB 6. There are many front end users.
> The middle tier uses SQL OLE DB to talk to the database. This error is
> coming up on one computer only. No users can access the database
> through the software from this machine. But, all users can access the
> database through the software from all other machines. This machine is
> WinXP.
>
> Any ideas where to look? The software and connection code is the same
> on all machines. What could have changed on this one machine (because
> it did work before) that would cause only it to stop working properly?

So how does the part of the connect where the connection string is set
up look like? 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages

  • Re: SqlServer 2005 Transfer Flame
    ... database between the two servers. ... I do understand your concerns with SQL Server 2005. ... Drag a OLE DB Destination to the panel; ...
    (microsoft.public.sqlserver.dts)
  • Re: merge field only shows 28 of 30 characters
    ... I've tried both OLE DB and ODBC connections, and both the old SQL Server client and the newer Native Client. ... If you are actually seeing two question marks at the end instead of the two characters you expect, the problem probably results from the "character translation" settings. ... for the database concerned. ...
    (microsoft.public.word.mailmerge.fields)
  • OLE DB: IRowsetChange on an >>unindexed<< view
    ... I have a database implementing row-level security with views and ... OLE DB can ... and a non-deterministic SQL Server function SUSER_SNAME). ... OLE DB API level, or SQL Server 2005 database level) to use a ...
    (microsoft.public.data.oledb)
  • HELP!! SSMSE and Windows VISTA
    ... I can not create a new database with SQL SERVER MANAGEMENT STUDY ... (Micorosoft SQL Server Error: 262) ...
    (microsoft.public.sqlserver.connect)
  • SSMSE and Windows VISTA
    ... I can not create a new database with SQL SERVER MANAGEMENT STUDY ... (Micorosoft SQL Server Error: 262) ...
    (microsoft.public.sqlserver.setup)