Sunday, February 12, 2012

AttachDBfilename

I was getting SQL Server errors trying to run the Time Tracker kit, soI tried to establish a connection with the timetracker.mdf from the
VWD Database Explorer - but no luck:

Data Source: Microsoft SQL Server Database File (SqlClient)

Database File name: Visual Studio2005\WebSites\TimeTracker1\App_Data\TimeTracker.mdf

Using either Windows or SQLServer authentication, they both fail when I test the connection.

Any ideas ? I gave myself and the ASPNET account every permission possible in SQLServer.Create a connection from a datasource control to test it or add a connection in VWD in server explorer ( i hope they have that hehe I use VS.NET 2005 pro ). Test the connection until it works. I had to play with it until I got it to work but I had the same problem. Make sure you are saying that you want a user instantce. First make a connection to your db and make sure that works. Then try to attach with the db.

No comments:

Post a Comment