Re: Very basic login question

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

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: Very basic login question
    ... Both computers are NOT members of a domain. ... In order to use Windows Authentication the two computers have to be ... you should have a login at the SQL Server on the XP Pro ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server 2005 login issure 2
    ... My programming knowlege is pretty rusty, but if you installed SQL Server ... if you installed with Windows Authentication and then ... ALTER LOGIN sa ENABLE; ... > If by any change you have read my original post titled "SQL Server 2005 ...
    (microsoft.public.sqlserver.connect)