Too many reports because report button is too convenient Could the atmosphere be compressed and put into bottles? Then you can create the link between the web server, off the domain, and the SQL server on the domain.Plus hosting the SQL server on the same box as the web I have tried management studio, sp_grantlogin etc but i get the same error. Thanks for the reply.
Nupur Dave is a social media enthusiast and and an independent consultant. Any ideas on a cause and long term fix??Thanks, Post #977618 « Prev Topic | Next Topic » Permissions You cannot post new topics. Join Now For immediate help use Live now!
http://support.microsoft.com/kb/324321/en-us 0 Message Author Comment by:Slider_ict2010-03-25 Comment Utility Permalink(# a28632909) I have looked at that kb but it did not help. Appearance of a boggart to someone who is most afraid of boggarts What is the adverb form of event? Previous versions of SQL server allowed you to search the sys procs to determine how it was deciding if a user was a Windows user or not - i.e. Microsoft Sql Server Reported Sql Message 15401 Severity 16 In the end I found the problem to be computer SID duplication and therefore required a Sysprep (WITH GENERALIZE OPTION) and then it all worked fine after readding the computer back
If you are trying to add a local account from the local computer that is running SQL Server, view the following Microsoft Knowledge Base article for the correct steps: 322988 sp_grantlogin Windows Nt User Or Group Administrators Not Found Check The Name Again Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Due to this, each user that is to access the application needs their own user creating against the SQL instance that the applications database is on, so that the user can
Check the name again.Reply David April 13, 2009 4:45 pmHi,I have one suggestion, now that it works for me. Q322988 Photos / Graphics Software Windows 7 Advertise Here 685 members asked questions and received personalized solutions in the past 7 days. PDF Downloads SQL Coding Standards SQL FAQ DownloadDownload SQL SERVER 2016 (FREE)Exclusive Newsletter SQL Interview Q & ASearch © 2016 All rights reserved. I like to add another user to existing window user service account in sql server 2008.
Doesn't work… lost hours (maybe I'm to stupid). When you add a Windows login as a SQL Server login, the SID is stored in a system table in SQL Server. Sql Server 2012 Error 15401 You cannot edit your own posts. Error 15401 Sql Server 2014 Fired because your skills are too far above your coworkers Mountaineering with a 6-year-old kid in winter Shortest code to throw SIGILL Output tab character on terminal window Why do most
There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within… MS SQL Server MS SQL Server 2005 MS SQL http://projectdataline.com/sql-server/use-the-sql-server-configuration-manager-tool-to-allow-sql-server-to-accept-remote-connections.html Check the name again. (Microsoft SQL Server, Error: 15401)o The SQL Server can ping the DMZ Domain Controller (and can be pinged from the DMZ Domain Controller.o I can add the Is there a way to get the Win 2k box to at least recognize the domain without physically joining the domain tree through system properties settings?I have scoured the net for share|improve this answer answered Jun 16 '14 at 3:20 Komengem 2,23932349 add a comment| up vote 1 down vote Do you change the case of the login name before using sp_grantlogin? Sp_revokelogin
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Sp_grantlogin asked 5 years ago viewed 5683 times active 2 years ago Related 6cannot add a user to sysadmin role in SQL Server0Accessing SQL 2008 server remotely3Mirroring database in sql server 20081SQL I suspected that the Active Directory information had not yet propagated.
share|improve this answer edited Feb 26 '13 at 15:25 answered Feb 26 '13 at 15:17 muhmud 3,5011515 no, the actual login name is being set into a variable and If someone hacks the web server they then have direct access to the SQL server and your stored data. 0Votes Share Flag Collapse - RE: The server must be on domain Leave new Nebu June 8, 2008 5:23 pmpls slove this errorWindows NT user or group ‘username’ not found. Xp_logininfo Adding local users works OK.
Any ideas? Click Find Now with all fields as is. For any SQL Server Performance Tuning Issue send email at pinal @ sqlauthority.com . Check This Out It may succeed to.
Your network administrator may have removed the Windows login for specific reasons, and you may not be able to grant that login access to the SQL Server.Verify that you are spelling WSUS Windows 7 Windows 8 Windows Server 2012 Windows Server 2008 Windows Live Movie Maker Overview (Part 1) Video by: Faizan This Micro Tutorial will give you a introduction in two is there any method in sql server .row level sequrity .or any user management method thanks in advanceReply Pinal Dave January 15, 2010 5:27 pmHello Mike,SQL Server 2008 introduced encryption methods