Error 15407 Sql Server 2005
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 windows nt user or group not found sql server 2012 Server > SQL Server Database Engine Question 1 Sign in to vote error 15401 sql server 2012 I am very new to SQL server 2008. I installed SQL serever 2008 on my computer. I can windows nt user or group not found sql server 2014 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
Error 15401 Sql Server 2014
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, msg 15401 sql server 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. Select SQL Server Authentication. 5. Enter a password for the login.6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option. 7. Switch to Server Roles tab and User Mapping tab and grant the server role and database roles to the account.8. Click OK.If you have any more questions, please let me know.Thanks.***Xiao Min Tan***Microsoft O
SQL Server experts to answer whatever question you can come up with. Our new sp_revokelogin SQL Server Forums are live! Come on over! We've restricted the
Q322988
ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members |
Microsoft Sql Server Reported Sql Message 15401 Severity 16
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
Tips/Tricks Top Articles Beginner Articles Technical Blogs Posting/Update Guidelines Article Help Forum Article Competition Submit an article or http://www.codeproject.com/Questions/405474/How-can-I-create-a-new-user-in-MS-Sql-Server tip Post your Blog quick answersQ&A Ask a Question View Unanswered Questions View All Questions... C# questions Linux questions ASP.NET questions SQL questions VB.NET questions discussionsforums All Message Boards... Application Lifecycle> Running a Business Sales / Marketing Collaboration / Beta Testing Work Issues Design and Architecture ASP.NET JavaScript C / C++ / sql server MFC> ATL / WTL / STL Managed C++/CLI C# Free Tools Objective-C and Swift Database Hardware & Devices> System 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 15401 sql server 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 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,