Connect to sql express 2008 database with VB.NET 2010

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Connect to sql express 2008 database with...

Connect to sql express 2008 database with VB.NET 2010

Rate Topic

Display Mode

Topic Options

Author

Message

lonhanner

Posted Thursday, September 20, 2012 5:29 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39, Visits: 141

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

SQLWorks

Posted Tuesday, October 09, 2012 10:27 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 6:43 AM
Points: 33, Visits: 183

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 »

Permissions