Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)

From: Bill Hollinshead [MS] (billhol@online.microsoft.com)
Date: 10/02/02 

From: billhol@online.microsoft.com ("Bill Hollinshead [MS]")
Date: Wed, 02 Oct 2002 16:06:41 GMT

Hi Trevor,

I am afraid you cannot, and you should not, call or use get_sid() because
it is undocumented <g> (ie., it is not in BOL, not in MSDN, not in KB).
Get_sid was designed to solely interface with our internal undocumented
processes. Thus, if our interface needs to be changed in the future, we can
change get_sid's functionality (without advanced notice) because we are not
concerned about the effects upon customer's use of it (since customers
should not be using it <g>). If you need to get a sid within your own
stored procedures, then your code will last longer and be supported if you
were instead to call the GetAccountName and GetAccountSid API calls
(perhaps within an extended stored procedure). Thus, per your Premier
Case's NDA agreement, it is definitely time for that support case <g>.

WRT the old account name issue: NT caches credentials and a reboot will
flush that cache. I can look into this further (or better, your case's
support professional can consult with NT support). Thus the reboot can
account the problem disappearing

Good luck and thanks,

Bill Hollinshead
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no
rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Relevant Pages

  • Re: Product ID For Online Support
    ... >Not sure about support for the Home Use program since it ... >account will be deleted without reading. ... As I mentioned in my thread, OE and Outlook ...
    (microsoft.public.office.misc)
  • I am separately loud, so I decline you.
    ... Neil, have a far account. ... charge revolutionary bottles in support of the fond literary ... extreme conferences. ... Roxanne debates the egg as to hers and rigidly ...
    (sci.crypt)
  • Re: Cannot start services
    ... | Computer: COUNTYG ... see Help and Support Center at ... | A provider, PerfProv, has been registered in the WMI namespace, ... | will be run using the LocalSystem account. ...
    (microsoft.public.windows.server.general)
  • RE: performancecounter object and remote server
    ... you're using the .NET performance counter to open ... counters on remote machine, however, you got the following error, correct? ... running under a local account, has same username/password on both machine). ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.general)
  • Re: OFFICELIVE: How to access email in an Office Live Basic servic
    ... I am a fairly loyal Microsoft customer, but now I understand why some of the ... It took me three email exchanges with Office Live support before ... unsolicited mail sent to my personal account will be deleted without ...
    (microsoft.public.office.misc)