dcsimg
Results 1 to 5 of 5

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

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2012
    Posts
    70

    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 ?

  2. #2
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    3,739

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

    What type of database?

  3. #3
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    99,788

    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 | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Aug 2012
    Posts
    70

    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

  5. #5
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    6,926

    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?
    You can depend upon the Americans to do the right thing. But only after they have exhausted every other possibility - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width