OS 32 Connection Error

I am preparing for online training for “VS2010 C# access to an SQL 2008 R2 database". I created a test DB and populated it using SQL Server Management Studio. When I try to view it from VS2010 an OS err 32 occurs. No other process is connected and I disconnected SQL SMS and closed it before I attempted to connect using the VS2010 Server Explorer. This is all taking place on my standalone XP LAB workstation. The full dialog box message is as follows:

Microsoft Visual Studio
Unable to open the physical file "D:\SQL Svr\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DBD-Test .mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
An attempt to attach an auto-named database for file D:\SQL Svr\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DBD-Test.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Dennis DahlmanVPITAsked:
Who is Participating?
 
mordiCommented:
Hi,
The error says that you are trying to open a database data file from VSS.
To view the dabase from server explorer first  create a connection to the database by "add connection" and  don't select  "Microsoft SQL Server database file". You select  "Microsoft SQL Server".
0
 
Dennis DahlmanVPITAuthor Commented:
Ooooops! You where exactly correct! I was trying to select "Microsoft SQL Server database file". Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.