Ms Sql Error 15407
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Add another user on SQL server 2008 on login screen SQL Server > SQL Server Database Engine Question 1 Sign in to vote I am very new to SQL server 2008. I installed SQL serever 2008 on my computer. I can log in with my user name. I like to create another user. so another person can log in to my computer database with different user name. I tried many times from security option. It creates user but cann't login as new user. It keep asking about domain name. I don't know what to do? could some one help me.ThanksSKK Wednesday, June 24, 2009 4:10 PM Reply | Quote Answers 1 Sign in to vote Hi Kumar,Firstly, you need to change server authentication mode to SQL Server and Windows Authentication mode.1.In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.1. On the Security page, under Server authentication, select the SQL Server and Windows Authentication mode, and then click OK.2. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.3. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.Then create a SQL Server login that uses SQL Server Authentication.1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.2. Right-click the Security folder, point to New, and then click Login.3. On the General page, enter a name for the new login in the Login name box.4. S
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 2012 Forums SQL Server Administration (2012) New https://social.msdn.microsoft.com/Forums/sqlserver/en-US/77cc320b-f53b-44c9-89e4-ad7a8dd22ecc/add-another-user-on-sql-server-2008-on-login-screen?forum=sqldatabaseengine DBA Questions Reply to Topic Printer Friendly Author Topic DatabaseStudent Yak Posting Veteran 71 Posts Posted-12/07/2014: 17:19:03 I have SQL Server 2012 that is set to Windows Authentication. I have an admin access to my account and I also want to have a program write to my database. When I tried to create http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=197673 a new login for it in Management Studio, I am getting a 15407 error. May I please get some advice from an experienced DBA on this? I want to make sure my database is secure and want the program to be able to only write and get into a specific database and not have access to everything. ahmeds08 Aged Yak Warrior India 737 Posts Posted-12/09/2014: 07:57:07 is it a windows login that you are trying to create?Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 DatabaseStudent Yak Posting Veteran 71 Posts Posted-12/09/2014: 09:59:36 A new login for SQL Server 2012 with Windows Authentication. tkizer Almighty SQL Goddess USA 38200 Posts Posted-12/09/2014: 12:38:15 Please post the text of the error message, the entire string including the error number and other numbers that appear. We need the entire thing.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ DatabaseStudent Yak Posting Veteran 71 Posts Posted-12/09/2014: 22:02:24 TITLE: Microsoft SQL Server Management Studio------------------------------Create failed for Login 'MyLogin'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.5058.0+((SQL11_PCU_Main).140514-1820+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionT
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or tip Post your Blog quick answersQ&A Ask a Question View http://www.codeproject.com/Questions/405474/How-can-I-create-a-new-user-in-MS-Sql-Server Unanswered Questions View All Questions... Linux questions C# questions ASP.NET questions SQL questions fabric questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta http://www.errbay.com/?r=MSFT-SQL-2014&c=Error+15407 Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System ms sql Admin Hosting and Servers Java .NET Framework Android iOS Mobile SharePoint Silverlight / WPF Visual Basic Web Development Site Bugs / Suggestions Spam and Abuse Watch features Competitions News The Insider Newsletter The Daily Build Newsletter Newsletter archive Surveys Product Showcase Research Library CodeProject Stuff communitylounge Who's Who Most Valuable Professionals The Lounge The Insider News The Weird & The Wonderful ms sql error The Soapbox Press Releases Non-English Language > General Indian Topics General Chinese Topics help What is 'CodeProject'? General FAQ Ask a Question Bugs and Suggestions Article Help Forum Site Map Advertise with us About our Advertising Employment Opportunities About Us Ask a Question All Questions All Unanswered FAQ How can I create a new user in MS-Sql Server 2005 Rate this: Please Sign up or sign in to vote. See more: C#2.0 C#3.0 C# ASP.NET ADO.NET , + USE [master] GO CREATE LOGIN [shi] FROM WINDOWS WITH DEFAULT_DATABASE=[master] GO EXEC master..sp_addsrvrolemember @loginame = N'shi', @rolename = N'sysadmin' GO USE [SMS2] GO CREATE USER [shi] FOR LOGIN [shi] GO USE [SMS2] GO ALTER USER [shi] WITH DEFAULT_SCHEMA=[dbo] GO Getting Exception: Msg 15407, Level 16, State 1, Line 1 'shi' is not a valid Windows NT name. Give the complete name: