home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,389 of 19,505   
   Anton Shepelev to All   
   Re: How to backup SQL Express 13   
   11 May 22 13:40:11   
   
   From: anton.txt@g{oogle}mail.com   
      
   Tim Ritberg:   
      
   > I dont want a windows user, because I dont want to install   
   > Kerberos.   
      
   Then the only alternative I know is an SQL user -- a user   
   with login and password registered inside an MSSQL instance.   
   You can pass his credentials via -U and -P.   
      
   > I  guees, I have to setup this user first.   
      
   I don't know.  Login to your MSSQL instance via Management   
   Studio and see what users are present under   
      
                  -> Security -> Logins   
      
   If there are no SQL users (which is strange) go ahead and   
   create one, with all the required permissions.  In my   
   experiece, however, there is always an administrator-user   
   `sa'.   
      
   > But I do not have any admin user. Could that be a local   
   > windows admin?   
      
   Since you said you do not want authentification by a Windows   
   user, it cannot.  Create a proper MSSQL user.   
      
   --   
   ()  ascii ribbon campaign - against html e-mail   
   /\  http://preview.tinyurl.com/qcy6mjc [archived]   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca