Re: Cannot login to SQL Server 2005 using SQL Server Authentication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



By default SQL Server is installed to only accept Windows (SSPI) authentication credentials. You'll need to reconfigure (and restart) SQL Server to handle mixed-mode security.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Mike Polinske" <mikepolinske@xxxxxxxxx> wrote in message news:1187031553.693705.10860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... I think it is not a limitation in Windows 2000. ... access SQL server on Win2000 server by using Windows authenctication if I ... | I have noticed that when I try to log in using Windows Authentication ...
    (microsoft.public.sqlserver.connect)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)