 |
|
|
|
Next: Question Regarding '=ColumnHistory'
|
| Author |
Message |
External
Since: Nov 18, 2008
Posts: 2
|
(Msg. 1) Posted: Tue Nov 18, 2008 8:21 am
Post subject: Very basic login question
Archived from groups: microsoft>public>sqlserver>security (more info?)
|
|
|
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 |
|
| Back to top |
|
 | |
External
Since: Feb 06, 2008
Posts: 47
|
(Msg. 2) Posted: Tue Nov 18, 2008 8:56 am
Post subject: Re: Very basic login question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
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" wrote in message
> 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
>
> |
|
| Back to top |
|
| |
External
Since: Nov 18, 2008
Posts: 2
|
(Msg. 3) Posted: Wed Nov 19, 2008 8:13 am
Post subject: Re: Very basic login question [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Thanks for responding!
Both computers are NOT members of a domain.
--
Grant Schenck
"Rick Byham, (MSFT)" wrote in message
>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" wrote in message
>
>> 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
>>
>>
> >> Stay informed about: Very basic login question |
|
| Back to top |
|
| |
| Related Topics: | Can't login to SQL Server - Hello, I'm trying to migrate one SQL Server 2000 database to SQL Server Express, and I'm having the following issue. In the SQL Server 2000 database I have two users A and B. User A belongs to the sysadmin server fixed role, and user B belongs to the..
Winows NT Login - Hi, Can someone assist me with the creation of a specific login for a SQL Server 2005 setup, I have a network login of "NETWORK/HDesk" on a Windows NT network, what I want to do is grant this login access to 1 "table" in a Databa...
Recurring login failure message - I have a SQL server 2000 sp3 running on a very well patched Win 2K box. For some reason, every 30 minutes, I get the error "login failed for 'domain\computername$'". There are no jobs failing but this message is filling my logs. Any ideas...
sp_revoke login is not working as expected. - 1. I have many windows users, for whom access has been given for individual domain accounts (SQL2K5) 2. All of them are also a part of a windows group which has required access 3. I want to remove the individual domain logins (because a group is already...
Linked Server Authentication Help - Login Failed - Hi there. I've been trying to get linked servers set up on two servers. Here is what i have done in my test environment. I've got two servers. Test1 and Test2. They are Standard 2005 installs. I've got two user accounts set as local admin on both server... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
