Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 687
  • Last Modified:

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.
0
Dennis Dahlman
Asked:
Dennis Dahlman
1 Solution
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now