Cannot login to SQL Server 2005 using SQL Server Authentication

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

I am unable to login to Server Management Express using Server
Authentication. I am able to login using Windows Authentication
though. I setup a new logic using Server Authentication but get the
following message:

Cannot connect to MIKE-PC.
===================================
A connection was successfully established with the server, but then an
error occurred during the login process. (provider: Shared Memory
Provider, error: 0 - No process is on the other end of the pipe.)
(.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
------------------------------
Server Name: MIKE-PC
Error Number: 233
Severity: 20
State: 0

I am running SQL Server 2005 Express on my local PC and would like to
use the SQL Server Authentication so that a VB programcan access the
database.

Any idea where to look for more info to resolve this?

Thanks in advance,

Mike Polinske
Milwaukee, WI

.

Relevant Pages

  • Re: Directory Services, LDAP or similar
    ... In other projects, we managed the user authentication by creating tables that define all users and its allowed capacities, then the application queryies that data to verify if a user has access to some feature or not. ... The above ID and password are sent to the service at login time. ... They are using Novell eDirectory at the enterprise level; yes it's LDAP. ... We already do that for three different DB servers; ...
    (borland.public.delphi.non-technical)
  • Re: Is there malware on my Server?
    ... be exposing to the internet some means of authenticating to the server. ... Anonymous Access is checked and the login uses the ... Integrated Windows Authentication is checked. ... Administrador indicates hack attempts to log on with the Administrator ...
    (microsoft.public.windows.server.security)
  • Re: Directory Services, LDAP or similar
    ... we managed the user authentication by creating tables ... The above ID and password are sent to the service at login ... Novell eDirectory at the enterprise level; yes it's LDAP. ... servers; ...
    (borland.public.delphi.non-technical)
  • Re: I cant login to Sql no matter what i try! im ignorant and i need help :)
    ... It sounds like your server is configured for Windows authentication ... >requested in login 'T254DN_Staging'. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Authentication Sharing Across Apps
    ... For my part "B" question that I had (Login App was not returning ... authentication to calling app), I found the solution. ... Basically, in both the Login App and Calling App Web.Config, I did ... authenticated connection with SQL server. ...
    (microsoft.public.dotnet.framework.aspnet.security)