RE: Login has all rigfhts but can login to sql
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng[MSFT])
- Date: Mon, 28 Aug 2006 06:34:08 GMT
From your description, you're getting the "Login name must be specified"error when try adding a sqlserver login into a database's users collection
and set its default scheme to dbo, correct?
Based on my research and the steps you mentioned, I think it is likely
caused by the "login name" value is not supplied when you add the user.
When adding a new user into SQL Server database, you need to supply two
**Username ----this is used for identify the user in the certain database
**Login name--- this is used for identity the login (windows or sqlserver)
of this database instance.
and Username is not required to be identical to the loginname. For your
scenario, you need to put the sql login's name in the "login name" textbox,
and also supply a "username" in the top textbox.
BTW, you can also configure the default schema of a sqlserver login in a
certain database through the Server logins configuration window. You can do
this by following below steps:
1. Select the login (sql or windows) in the database instance's
"security-->logins" list and rigth click to open properties dialog.
2. In the login properties dialog, choose "User Maping" setting in the left
3. You can then configure the mapped username and default schema in those
databases of this server instance.
I've attached two screenshots of the above approaches. You can get it by
using Outlook express to visit this message. If you feel it necessary, I
can send you through email also.
Please feel free to let me know if there is any other information you
Microsoft MSDN Online Support Lead
Get notification to my posts through email? Please refer to
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
This posting is provided "AS IS" with no warranties, and confers no rights.
Description: Binary data
- Prev by Date: Re: Sql Server - Basic Permissions Question
- Next by Date: Re: SQL Server 2005: Checking if Login is connected to any databas
- Previous by thread: Sql Server - Basic Permissions Question
- Next by thread: Re: linkedServer fails from client when logged-in with NT-auth sql2k c