Re: Very basic login question

Thanks for responding!

Both computers are NOT members of a domain.
--
Grant Schenck

"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8EB2AA0D-FEC5-4E7E-956F-6127BFBAFB71@xxxxxxxxxxxxxxxx
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.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Grant Schenck" <schenckg@xxxxxxxxxxxxx> wrote in message
news:%23yUHcCYSJHA.3880@xxxxxxxxxxxxxxxxxxxxxxx
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!
--
Grant Schenck





.

Relevant Pages