Re: MSDE Osql accessed denied

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 02/21/04 

Date: Sat, 21 Feb 2004 20:05:49 GMT

Hi

Have you tried naming the server explicitly with the -S option? What does
osql -L return?

John

"Sue White" <swhite@awwarf.org> wrote in message
news:uw1q0LK%23DHA.3816@TK2MSFTNGP09.phx.gbl...
> I'm using VisualStudio 2003. MSDE is installed and I have verified that
my instance of MsSqlServer is running. I can build an asp.net form, open
ServerExplorer and drag the table onto the form. All the fields display.
But when I run the page, my browser reports "login failed for user
'instancename\ASPNET'".
>
> I go to a command prompt and type:
> C:\>Osql -E
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> C:\>
>
> Why am I unable to login? Thanks in advance for any help. I've been
looking for an answer for hours.
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

Relevant Pages

  • How to Replicate using OSQL?
    ... I've installed a MSDE 2000 in a remote Computer. ... and set subscriber from OSQL? ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
    (microsoft.public.sqlserver.msde)
  • Re: Tools for Sql Server Desktop Engine
    ... i want to import access database into MSDE using osql. ... See the command-line switches to be used by typing in osql ... > "Tarundeep Singh Kalra" wrote in message ... >>> There are a number of products out there and one of them is MSDE ...
    (microsoft.public.dotnet.faqs)
  • Re: MSDE Instanz Installieren und Nutzen
    ... Dabei habe ich den Benutzer sa angelegt mit dem ... Wie kann ich jetzt auf die MSDE Instanz ... der Zugriff auf eine MSDE ist per OSQL möglich, ... Mit diesen Tools kann man auch auch auf eine MSDE ...
    (microsoft.public.de.sqlserver)
  • Re: Sharepoint Upgrade from MSDE to SQL 2000 after SP1 fails! Nee
    ... "John C" wrote: ... >>> Indexing, the upgrade fails. ... >>> to turn on the Indexing server, message stating that it is MSDE still. ... Sharepoint is still running on MSDE. ...
    (microsoft.public.windows.server.sbs)
  • RE: IHttpHandlerFactory interaction with VisualStudio
    ... John H Clark ... > requests for real items... ... >> This results in a situation created when I start my solution in VisualStudio. ... >> John H Clark ...
    (microsoft.public.dotnet.framework.aspnet)