Results 1 to 5 of 5

Thread: set username and password for local database in vb.net

  1. Jun 10th, 2018, 10:56 AM #1
    pooya1072
    pooya1072 is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2012
    Posts
    72

    set username and password for local database in vb.net

    Hello
    In Solution exploer , i right click on project name , click "Add" and select new Database .
    Now i want to know how can i set username and password for this database in vb.net ?
    Reply With Quote Reply With Quote
  2. Jun 10th, 2018, 12:57 PM #2
    wes4dbt
    wes4dbt is offline
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,206

    Re: set username and password for local database in vb.net

    What type of database?
    Reply With Quote Reply With Quote
  3. Jun 10th, 2018, 08:45 PM #3
    jmcilhinney
    jmcilhinney is online now
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,344

    Re: set username and password for local database in vb.net

    Quote Originally Posted by wes4dbt View Post
    What type of database?
    Only SQL Server MDF files are supported in that manner. SQL Server CE SDF files used to be supported but SQL Server CE has been deprecated.

    As far as I'm aware, SQL Server doesn't support file security, only instance security. That would be a question for the database development forum though, so I've asked the mods to move this thread there.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW) | C# (Sorting AlphaNumeric Strings Logically NEW, Binding a Data Reader in Windows Forms NEW)
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  4. Jun 10th, 2018, 09:38 PM #4
    pooya1072
    pooya1072 is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2012
    Posts
    72

    Re: set username and password for local database in vb.net

    Quote Originally Posted by jmcilhinney View Post
    Only SQL Server MDF files are supported in that manner. SQL Server CE SDF files used to be supported but SQL Server CE has been deprecated.

    As far as I'm aware, SQL Server doesn't support file security, only instance security. That would be a question for the database development forum though, so I've asked the mods to move this thread there.
    Thanks
    Reply With Quote Reply With Quote
  5. Jun 11th, 2018, 03:11 AM #5
    FunkyDexter
    FunkyDexter is offline
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,902

    Re: set username and password for local database in vb.net

    Moved

    What exactly do you mean by " username and password for this database in vb.net ?" do you mean you want to password protect the database file, similar to what you might do with Access? If so JM's correct, that's not how SQL Server works. The closest analogue I can think of would be managing the SA user. Or do you perhaps mean you want to create a user name and password your application will connect under? Or something else?
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width