Very basic login question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grant Schenck - 18 Nov 2008 13:21 GMT

OK,

I set up SQL Server 2005 Express on an XP Pro workstation.

Then on a Windows 2003 server I installed SQL Server management studio
express (SSMSE).

Then from SSMSE I try to connect to my server.

It fails with error 18456 and when I examine the server's SQL log I see
this:
2008-11-18 07:49:45.32 Logon Error: 18456, Severity: 14, State: 11.
2008-11-18 07:49:45.32 Logon Login failed for user 'GRANTCPU\Guest'.
[CLIENT: 192.168.1.2]

In SSMSE I use a server name of grantcpu\SQLEXPRESS. The Authentication is
"Windows Authentication" and the User Name is grayed out and set to my login
name on the 2003 machine which is GSCHENCK-280/GSchenck.

However, the SQL log refers to GRANTCPU\Guest.

What do I need to do on my XP Pro box running SQL Express to allow me to log
in?

I'm thinking I need to somehow add GSCHENCK-280/GSchenck as a valid user on
the machine where SQL Server is running but if so, I don't know how to
actually do that.

Thanks!

Signature

Grant Schenck

Reply to this Message

Rick Byham, (MSFT) - 18 Nov 2008 16:56 GMT

I think you may have two issues here.
1) In order to use Windows Authentication the two computers have to be
members of the same domain or trusted domains. I suspect your two computers
are not members of some shared domain. Perhaps I'm wrong though. Are you
using the same domain login on both computers? If your computers are not
members of a domain, you can make the Windows user name the same on both
computers, and have the same password. Then you can use Windows
Authentication. (This is the same way you can connect to a printer on a home
network.)
2) Yes, you should have a login at the SQL Server on the XP Pro workstation.
Add domain_name\GSchenck as a login, not computer_name\GSchenck. Install
SSMS Express locally and use Object Explorer/Security/Logins to create a
login.
Or you can setup a SQL Server login.
I suspect you haven't followed all this but I'm not sure which part might be
causing you trouble.

Signature

Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

> OK,
>
[quoted text clipped - 25 lines]
>
> Thanks!

Reply to this Message

Grant Schenck - 19 Nov 2008 13:13 GMT

Thanks for responding!

Both computers are NOT members of a domain.

Signature

Grant Schenck

>I think you may have two issues here.
> 1) In order to use Windows Authentication the two computers have to be
[quoted text clipped - 41 lines]
>>
>> Thanks!

Reply to this Message