Re: Connecting to MS SQL Express from other PC

"Mixed mode" authentication enables SQL Server authentication AND SSPI (Windows domain) authentication.
See Chapter 9. I also have a long whitepaper on connecting on my blog.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Misha" <Misha@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:AB5716E4-67DA-43ED-B2AE-0C4499B5AFFA@xxxxxxxxxxxxxxxx
So... Thank you for your help, but it is not working. I found solution.

1. Identical accounts do not works. There is only one way: to create Guest
user at PC where SQL express is installed. Every computer from workgroup will
be as guest and it is working.

2. While installing, SQL express asking for Windows authentication or Mixed
Win/SQL Server authentication. There is no only SQL authentication option.
So, this is also not working. We have to create Guest user first in order to
provide win server aunthentication first.



"Charles Calvert" wrote:

On Thu, 27 Mar 2008 12:53:01 -0700, Misha
<Misha@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
<B419B2CA-FA6A-46AA-A472-7FF874FF98B4@xxxxxxxxxxxxx>:

>I have two PCs with XP Home. One of them has MSSQL Express. The second >one
>uses Access. At SQL server I can give permision only as guest. And I can
>create new DB from Access and create tables - but I can't add any >records.
>
>I downloaded a free book on using MSSQL Express, but there describes how >to
>create logins using windows login from the same PC where server is >installed.
>How to create logins for connection from other PC's, I didn't find >anything.

You have a couple of choices. You can use Windows authentication or
SQL Server authentication.

If you use Windows authentication, you should have identical accounts
on both PCs (i.e. username and password are the same). Create the
user of the SQL Express instance as "THISPC\user", and it should work
for "THATPC\user", provided the usernames and passwords are the same.

If you use SQL Server authentication, then create the user accordingly
and pass the username and password when you connect from the other PC.

Note that SQL Server Express does not allow connections from other PCs
by default. You'll need to enable that feature via the Management
Studio.
--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research


.

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)