Member Avatar for balamithra 
Hi,
    *I have installed sql server 2008 management studio with "use sql server authentication".
    *I have created a database with
        database name:stock
        owner:<default>
    *In Vb.net 
    created a windows application;clicked on Add datasource;changed d datasource to microsoft sql server database file(SqlClient);clicked on option button use sql server authentication n then provided d user name and password;
    browsed d database and clecked on open;This is when i get a error.
    This is the error:
    "Select sql server database file
    stock.
    you dont have permission to access this file
    contact file owner or the administrator"

    Plz let me knw the cause of d error and how to solve it
  • 2 Contributors
  • 1 Reply
  • 244 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by M.Waqas Aslam
Member Avatar for M.Waqas Aslam

you dont have select permission for this database , try to use windows athentication in vb.net or you can call it trusted connection string , in that string there is no need to give id and pass .

Click Here at this site you can get connection string.

Regards

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.