Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connect to sql express 2008 database with VB.NET 2010 Expand / Collapse
Author
Message
Posted Thursday, September 20, 2012 5:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 12, 2013 7:25 AM
Points: 39, Visits: 144
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
Post #1362381
Posted Tuesday, October 9, 2012 10:27 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 7:17 AM
Points: 34, Visits: 194
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
Post #1370480
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse