Connect to sql express 2008 database with VB.NET 2010

  • I hope I am in the right forum. I am running windows 7, 6 gig ram on 64 bit platfrom(laptop). I installed vb.net express and sql 2008 express r2. I created a sql database using Access database tool SQL serve whitch creates a sql database from an access database.

    Works fine. When i try to connect to the newly created database in vb.net express 2010 using the Database Explore it tells me I do not have permision to open it. I can access the database going through the Server Management Studio.

    Thanks Lon

  • I have never seen or used this Access database create tool, but it seems that you are connecting to your new database under two different contexts, the VB .NET express application must have credentials that differ from what you use in SSMS. Can you check and see what credentials each method uses and compare their access to your database? What authentication mode did you choose when you created the database?



    SQL Tips and Scripts
    SQLWorks Blog

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply