Re: SQL User SID format?


"Laurentiu Cristofor [MSFT]" <Laurentiu.Cristofor@xxxxxxxxxx> wrote in message news:%23Q8o%23lldHHA.4696@xxxxxxxxxxxxxxxxxxxxxxx
What are you trying to achieve exactly?

The option of creating a login with a specified SID is provided for allowing SQL logins to be moved from one server instance to another - this means you already have access to a SID from the syslogins catalog; you don't need to generate one yourself.

Also, note that a SID and a GUID are different structures. It is true that SQL Login SIDs are actually GUIDs, but the SID you selected below is a SID, not a GUID. For SQL Logins, the catalog representation of the GUID reflects the in-memory representation of the GUID, rather than the textual representation with dashes that the GUID Generator provides.

Hope this helps

Thanks - basically our software uses a standard SQL User account to connect to the database. The problem occurs when a customer wants to take a backup and restore it to another server, or send the data to us for maintenance. Each time, we have to go through dropping the user off the database, and then re-selecting it to attach the Login that is on the server in question.
I am trying to write a small program that creates our default user with a standard SID so that this is less of an issue in future.
Still, your reply suggested I can probably just steal the one we already have on our own server and utilise that, so I will give it a go...
James.

.

Relevant Pages

  • Re: SQL User SID format?
    ... The option of creating a login with a specified SID is provided for allowing ... SQL logins to be moved from one server instance to another - this means you ... note that a SID and a GUID are different structures. ... I'm trying to create a user with a specified SID. ...
    (microsoft.public.sqlserver.security)
  • Re: Cleanup after manually removing a DC
    ... server name even if it uses the same guid? ... Once the DC is removed that GUID is no longer in use. ... DCs use the SID of the Domain and the GUID doesn't ... But it isn't an issue if you deleted the old DCs references. ...
    (microsoft.public.win2000.active_directory)
  • =?Utf-8?Q?Re:_Nach_Neuinstallation_k=C3=B6nnen_?= =?Utf-8?Q?verkn=C3=BCpfte_Kontakte_nicht_g
    ... Windows-Umgebung hat also auch immer eine eindeutige SID und wird dadurch ... Wenn nun auf dem Server sich ... einer alten SID mit Berechtigungen versehen wurde, ... "Sie haben wahrscheinlich versucht, den Kalender eines Benutzers ...
    (microsoft.public.de.outlook)
  • Re: Two different domains with same name - Problems?
    ... and yes, at this level (SID) the domains are distinct, however TTBOMK domain discovery happens by name so the 'foreign' PCs will _attempt_ to log onto the domain, causing more grief than I can imagine. ... Initial connections from Fred are parsed to get the domain/user SIDs and fail to match so fallback to PTA, at this time Fred@Domain1 will cause Fred@Domain2's account to be locked out due to auth failure. ... Windows Small Business Server 2008 Unleashed ...
    (microsoft.public.windows.server.sbs)
  • Re: ASP.NET User.Identity.Name value after a domain username chang
    ... Can you point me to any resources I can use about getting the SID of the ... WebRequest user without using the username as the base of a lookup (since I ... access a website on the server. ... I have a very confusing issue when the domain login of a user is changed ...
    (microsoft.public.dotnet.framework.aspnet.security)