Re: Connecting to MS SQL Express from other PC

[top-posting fixed]

On Thu, 3 Apr 2008 21:59:00 -0700, Misha
<Misha@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
<AB5716E4-67DA-43ED-B2AE-0C4499B5AFFA@xxxxxxxxxxxxx>:


"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.

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.

You may not have been able to make it work in your situation, but that
doesn't mean that it can't work. I'm using such a setup here in my
office. Most likely you missed something during the process; it could
be any number of things from firewalls to security policies.

2. While installing, SQL express asking for Windows authentication or Mixed
Win/SQL Server authentication. There is no only SQL authentication option.

I didn't say that there was. I said that you can choose from two
authentication methods: Windows and SQL Server. You need to enable
mixed mode for SQL Server authentication to work.

--
Charles Calvert | Software Design/Development
Celtic Wolf, Inc. | Project Management
http://www.celticwolf.com/ | Technical Writing
(703) 580-0210 | Research
.

Relevant Pages

  • Re: Connecting to MS SQL Express from other PC
    ... to create Guest ... SQL express asking for Windows authentication or Mixed ... At SQL server I can give permision only as guest. ...
    (microsoft.public.sqlserver.connect)
  • Programmatically create DSN usind SQL Server Authentication
    ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication. ... is off-topic for my purpose because it only shows Windows authentication. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Install Microsoft SQL Server 2000 Desktop Engine
    ... wath autentication mode you choice to install? ... have two SQL Server Authentication or Windows Authentication ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Connexion to SSIS
    ... A way to verify it the account in question to the local admins and try ... If you do not want to, can use proxy accounts. ... only SQL Server authentication and use it to connect my remote client to the ... SQLServer Account by SQL Server Authentication? ...
    (microsoft.public.sqlserver.dts)
  • How to disable the Windows NT login authenticate at SQL-Server 2000 login Form ? @Thanks
    ... Use Ms SQL Server 2000, There are two way to login, The first is Windows NT ... Authentication, The second is SQL Server Authentication, If you choose ... I think the Database ...
    (microsoft.public.sqlserver.security)