0
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
2
Views
5 Years
Discussion Span
Last Post by M.Waqas Aslam
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.