Ms Sql Server Error 15006
item works according to its intended design. A more detailed explanation for the resolution of this particular item may have been provided is not a valid name because it contains invalid characters sql server 2008 in the comments section. 1 0 Sign into vote ID 749931 Comments create user is not a valid name because it contains invalid characters 1 Status Closed Workarounds 0 Type Bug Repros 0 Opened 6/19/2012 8:15:50 AM Access Restriction Public Description I've got a Case Sensitive DB that was restored to a Case Insensitive Server On the Server I have a login created from windows "DN\aaa" CREATE LOGIN [DN\aa] FROM WINDOWS WITH DEFAULT_DATABASE=[ABC] On the DB I have a login defined as uppercase CREATE USER [DN\AA] FOR LOGIN [DN\AA] When scripting this user out to reapply security elsewhere via TSQL we attempted to honor case sensitivity on both sides of the statement and scripted it as CREATE USER [DN\AA] FOR LOGIN [DN\aa] This generates the following error Msg 15006, Level 16, State 1, Line 1 ‘DN\AA' is not a valid name because it contains invalid characters. Creating the user with all upper user/login, or all lower user/login works as expected DETAILS ATTACH A FILE EDIT THIS ITEM Assign To Item can only be reassigned when it is active. Comments (1) | Workarounds (0) | Attachments (0) Sign in to post a comment. Please enter a comment. Submit Posted by Microsoft on 9/18/2012 at 5:07 PM Hello Allen,In SQL Server, if the name contains a '\' and the login name is provided, then the user name and login name should match. For collation which are case sensitive, SQL Server does a binary match for the user name and Login name strings else SQL Server ignores the case.In this particular example, SQL Server does a binary match and hence mismatch in the cases on the case sensitive database throws error.I am resolving this defect as by design.Please let us know if you have further concerns.Thanks,Rinku Sign in to post a workaround. Please enter a workaround. Submit Attach a file Microsoft Connect Terms of Use Trademarks Privacy Statement © 2016 Microsoft Please wait...
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 - General » Problems adding a new Login Problems adding a new Login Rate Topic Display Mode Topic Options Author Message Michael Lee-158245Michael Lee-158245 Posted Friday, December 24, 2010 8:35 AM SSC Rookie Group: General Forum Members Last Login: Monday, February 11, 2013 7:32 AM Points: 36, Visits: 120 Hi All,I'm having a issue adding a new https://connect.microsoft.com/SQLServer/feedback/details/749931/case-sensitive-user-login-creation-fails login only if I set it to SQL Server Authentication and I set the password. I'm trying to add a login that was created on our domain with admin security rights. Info:New User ID = FREEDOM\SqlAgentWorkerI get the following error TITLE: Microsoft SQL Server Management Studio------------------------------Create failed for Login 'FREEDOM\SqlAgentWorker'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL http://www.sqlservercentral.com/Forums/Topic1039121-391-1.aspx statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------'FREEDOM\SqlAgentWorker' is not a valid name because it contains invalid characters. (Microsoft SQL Server, Error: 15006)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=15006&LinkId=20476Please Note: If I add the user Id using Windows Authentication it works without any issues. I have not tried to remove the FREEDOM\ part, but I thought that it would be needed for proper identification. Since I could not get it to work right in SQL Management Studio, I tried the following command:CREATE LOGIN [FREEDOM\SqlAgentWorke] from WINDOWS WITH PASSWORD='91464502599'GOQuestions:A. Can I use "From Windows" and "with PASSWORD" in the same command. If not, How would I set the password, or does SQL Server use the password that was assigned when the domain account was created.Thanks for any suggestions. Post #1039121 Michael Lee-158245Michael Lee-158245 Posted Friday, December 24, 2010 8:37 AM SSC Rookie Group: General Forum Members Last Login: Monday, February 11, 2013 7:32 AM Points: 36, Visits: 120 BTW, I added this account to work with SQL Server Agent between some Linked servers I have. Post #1039122 Carl FederlCarl Federl Posted Friday, December 24, 2010 9:40 AM SSCrazy Group: General For
your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Login https://bytes.com/topic/sql-server/answers/82678-login-domain-account With Domain Account P: n/a Jason I doing some testing with security and ran into the following problem. I want to log into the SQL server (from Query Analyzer) using my http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=194927 domain account. To allow this, I went into Logins section in Enterprise Manager and added my user account as a Windows User. If I set Analyzer to use Windows authentication sql server I am to log in with no problems. But if it is set to SQL Server authentication and I type in my username (in the format domain\username or username@domain) and password I get a login error. Is there a way to login in to SQL using domain account without using windows authentication? Thanks, Jason Jul 20 '05 #1 Post Reply Share this is not a Question 2 Replies P: n/a John Bell Hi If you are wanting to use the windows accounts to log into the database server, then you will have to use windows authentication. John "Jason"
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) cant create a user when using iis appPool\ Reply to Topic Printer Friendly Author Topic barnsley Starting Member 34 Posts Posted-06/27/2014: 07:23:23 I am try to create a user in SQL 2008.It is for a DotNetNuke (DNN) CMS.I have put this problem on DNN forum, but nobody seems to understand the problem :- I think this is a SQL issue.we are using: windows 2008 r2, SQL 2008, ASP.net4, and IIS7.I believe that because we are using Windows 2008 r2 that we must prefix our username with iis appPool\ However, this results in an error when using the backslash...ERROR is something like this:"...iis apppool\[myUserName] is not a valid name because it contains invalid characters error code: 15006..."any ideas as to why this is please?mark. James K Flowing Fount of Yak Knowledge 3873 Posts Posted-06/27/2014: 10:40:13 The correct syntax is [apppool\myUserName], but I am not commenting on whether or not that is the correct username to provide.As an aside, in SQL, there is the concept of a login - which is a server level entity that allows someone to connect to the sever and then there are users which are entities associated with databases. A user can be associated with a login, which then would give that login access to the resources on the database accessible to that user. http://msdn.microsoft.com/en-us/library/ms181127.aspx barnsley Starting Member 34 Posts Posted-06/27/2014: 11:51:53 thanks,I tried both "iis apppool\myUserName"and"apppool\myUserName"I get the same error.It is for creating a new loginmark. James K Flowing Fount of Yak Knowledge 3873 Posts Posted-06/27/2014: 14:00:32 I suspect that neither of them is correct. SQL Server allows two types of authentications - SQL Authentication or Windows Authentication. The format I suggested earlier is for Windows Authentication. You can create a login for [DomainNa