Cannot login to SQL Server 2005 using SQL Server Authentication

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: [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=233&LinkId=20476[/url]
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
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@.gmail.com> wrote in message
news:1187031553.693705.10860@.l22g2000prc.googlegro ups.com...
>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:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=233&LinkId=20476[/url]
> --
> 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
>
|||On Aug 13, 3:12 pm, "William Vaughn" <billvaNoS...@.betav.com> wrote:
> 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 Speakerwww.betav.comwww.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.
> __________________________________
> Visitwww.hitchhikerguides.netto 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)
> ----X---
>
Thanks Bill, I was able to find the server properry under Security
that controls the authentication and it worked like a charm!!