Invalid authorization specification

From: Dan C. (danc@nospam.com)
Date: 02/05/03 

From: "Dan C." <danc@nospam.com>
Date: Tue, 4 Feb 2003 15:01:43 -0800

This used to work but something happened (perhaps SQL SP
3)...

I have an application (.NET/C#) that accesses a remote SQL
Server 6.5 using OleDbConnection. Whenever it tries to
open a connection I get an exception:

System.Data.OleDb.OleDbException: Invalid authorization
specification

However, I can use Query Analyzer and connect to the
database just fine using the same account. Here is my
connection string:

Provider=SQLOLEDB;Server=myserver;Initial
Catalog=mydatabase

Some other facts:
1) Using Windows authentication
2) I have SQL Server 2000 running on my local machine and
I recently upgraded it SP 3. However the app is not using
it (6.5 is on another server).

Any idea what is wrong?

Thanks in advance.

Dan

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)