15006 Sql Error
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From is not a valid name because it contains invalid characters sql server 2008 My Forums Answered by: Create New Login Error 15006 SQL create user is not a valid name because it contains invalid characters Server > SQL Server Data Access Question 0 Sign in to vote Hey, I'm trying to create New Login under the MSSM but i'm get this error can you please help me TITLE: Microsoft SQL Server Management Studio ------------------------------ Create failed for Login 'JAY-PC\SOna'. (Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ 'JAY-PC\SOna' is not a valid name because it contains invalid characters. (Microsoft SQL Server, Error: 15006) Friday, January 20, 2012 7:32 PM Reply | Quote Answers 0 Sign in to vote JAY-PC\SOna isthe format ofWindows login. (Windows authentication on the General page when creating a new login) This user will have to exist on your pc before you can use it. JAY-PC\SOnacannot be used for a SQL loginname as \ is not allowed. (SQL Server authentication on the General page when creating a new login). Edited by KevinNicholas Friday, January 20, 2012 11:07 PM Marked as answer by KJian_ Thursday, February 02, 2012 3:28 AM Friday, January 20, 2012 11:02 PM Reply | Quote All replies 0 Sign in to vote When you are creating the Login are you using the below WINDOWS syntax e.g CREATE LOGIN [JAY-PC\SOna] FROM WINDOWS .... Friday, January 20, 2012 8:17 PM Reply | Quote 0 Sign in to vote Forgot to mention if you're using ss
up 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 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2e3c7a10-a648-4d0a-8b85-97908e8a2cf5/create-new-login-error-15006?forum=sqldataaccess 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 login only if I set it to SQL Server http://www.sqlservercentral.com/Forums/Topic1039121-391-1.aspx 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 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'GOQue
your question and get tips & solutions from a community of 418,416 IT Pros & Developers. It's quick & easy. Login With Domain Account P: n/a Jason I doing some testing with security and ran into the following problem. I https://bytes.com/topic/sql-server/answers/82678-login-domain-account want to log into the SQL server (from Query Analyzer) using my 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 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 is not a way to login in to SQL using domain account without using windows authentication? Thanks, Jason Jul 20 '05 #1 Post Reply Share this 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"