Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    2

    Unanswered: Error: Cannot connect sql server 2008 database with vb 2010

    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. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    you dont have permission to access this file
    contact file owner or the administrator
    Suggest you Work with your administrators to set the proper permissions.

  3. #3
    Join Date
    Aug 2012
    Posts
    2
    How to access the permissions.
    What are the settings i need to do?

  4. #4
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    If you are not the system administrator, you need to work with them.

    What to do depends on how your system is set up. They will know.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Is this trying to attach a SQL Server database to an instance of SQL on your desk(lap)top? If the SQL Server is remote (on a separate machine), you would certainly not get file permissions denied.

Tags for this 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
  •