Re: sqlclient fill gets Access denied Error

From: Frank Hickman (fhickman_NOSP_at_M_noblesoft.com)
Date: 11/28/04 

Date: Sun, 28 Nov 2004 01:10:18 -0500

Do you have an alias setup for your connection string in the Client Network
Utility? 

-- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"rseedle" <rseedle@discussions.microsoft.com> wrote in message 
news:454D879A-F5E4-4A8F-8ACD-8C6F1B9C94E1@microsoft.com...
>I have been trying to get sqlclient to fill a dataset. It connects ok but
> when it gets to the fill method it throws an exception with the message:
>
> SQL Server is not installed or access denied.
>
> Well SQL Server is installed on this machine. Its not like I'm trying go
> across the network or something. The configuration string tool finds the
> Northwind database ok and ole db seems to work all right. Any ideas ?
>
> Randy

Relevant Pages

  • RE: How do I configure Analysis Services for Excel 2003 users?
    ... they had had Office 2003 installed AFTER SQL Server. ... > I have been preparing a set of cubes in Analysis Services 2005 to be viewed ... > Excel reports have been designed as pivot tables based on AS cubes, ... > Surely it must be that the connection string is incorrect but I seem to have ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem connecting to an SQL 2005 Express Instance in RANU mod
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I'm using SQL2005 Express User Instance Feature. ... attaching an MDB file with the following connection string: ...
    (microsoft.public.sqlserver.connect)
  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How can I trap an error on a "CommitTrans" command in VB6 using ADO and SQL Server 2000?
    ... always use SQLOLEDB for accessing SQL server rather than MSDASQL. ... Try creating a UDL file and using this for your connection string. ... > adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection) ... > client-side cursor and still be able to trap such a critical error. ...
    (microsoft.public.vb.database.ado)
  • RE: SQL server does not allow remote connections error
    ... Server 2005 however another web application could connect to the SQL Server ... use the alias in your connection string to connect to your SQL Server. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.connect)