RE: Windows Authtication problem?
From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 04/05/04
- Next message: Jonathan McKinney: "grouping problem..."
- Previous message: PeyoQuintero: "DB architecture"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 05 Apr 2004 02:58:32 GMT
Hello,
How is the issue going on your side? I learned you are able to add in
"LocalMachineName\test" login using SEM without any problem, but failed to
login SQL using Query Analyzer. Please make sure you double-checked the
name of the Server you connect to.
Can you connect to SQL Server using "LocalMachineName\test" account via
SEM? If so, how did you connect to? Is there any difference of connecting
configuration between Query Analyzer and SEM?
In addition, please perform the following steps in QA to allow the Windows
NT user LocalMachineName\test to connect to SQL Server.
EXEC sp_grantlogin ' LocalMachineName\test'
Once it is granted successfully, please try connecting using Windows
authentication via QA and see if that helps.
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
- Next message: Jonathan McKinney: "grouping problem..."
- Previous message: PeyoQuintero: "DB architecture"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
