Need to create SQL-logon-user, any VB code avalable?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Gijs Beukenoot (Gijs.DOT.Beukenoot_at_AT@Wanadoo.DOT.nl)
Date: 02/09/05 

Date: Wed, 09 Feb 2005 22:39:23 +0100

Hi all,

I'm trying to automate the installation of MSDE in my app. So far, so
good but now I need to create a user that I will use to start the SQL
server service. For a few reasons, including using replication, I need
the SQL server account on all machines to be exactly the same. So, I
want to use my 'firsttime' routine to create an NT user on the local
(XP) machine, add that user to the administrators group and use that
user to modify the SQL service (MSSQLSERVER).

I've looked and Googled around, but I haven't found anything yet,
anyone kind enough to point me in the right direction please?

Thanks

GB 

-- 
Your eyes are weary from staring at the CRT. You feel sleepy. Notice 
how restful it is to watch the cursor blink. Close your eyes. The 
opinions stated above are yours. When I snap my fingers, you cannot 
imagine why you ever felt otherwise. <snap>

Relevant Pages

  • Re: Search SQL String is being shortened
    ... > I tried your suggestion, and the SQL string is concatenated correctly, ... > and this means that the WHERE part of my SQL string can get quite long. ... Your eyes are weary from staring at the CRT. ... When I snap my fingers, ...
    (microsoft.public.access.formscoding)
  • Re: SMS Administrator Console
    ... my SMS server is also running SQL. ... local admin or even a power user (at least on the 2 machines that are ...
    (microsoft.public.sms.admin)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.windows.group_policy)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.sqlserver.security)
  • Re: Many Installations of MSSQLSERVER.
    ... drop to a cmd prompt, cd to the MBSA install dir, and issue ... You can provide list of target machines in file, ... this does not of course address the majority of SQL ... pretty hard to not have license allowing dev version of SQL, ...
    (microsoft.public.win2000.security)