Re: sqlclient fill gets Access denied Error

From: rseedle (rseedle_at_discussions.microsoft.com)
Date: 11/30/04


Date: Mon, 29 Nov 2004 16:05:02 -0800

Frank:
I checked, yes I do. It uses tcp/ip port 1433. In addition there Visual
Studio there is a shortcut created in the Server Explorer.

Randy

"Frank Hickman" wrote:

> 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: connect failed to project server from project profession
    ... You're welcome, Randy :-) ... >> I've installed project server 2003, sql server 2000 on a server ... >> SQL Server Error 1326 ...
    (microsoft.public.project)
  • Re: Obtaining connection information
    ... Yes, I'm using SQL Server, but the values which the function accepts are ... None of them are SERVER. ... on a System DSN connection. ... "Frank Hickman" wrote: ...
    (microsoft.public.vc.database)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)