<div>
Ooooops! You where exactly correct! I was trying to select &quot;Microsoft SQL Server database file&quot;. Thank you!
</div>


Ooooops! You where exactly correct! I was trying to select "Microsoft SQL Server database file". Thank you!

<div>
<div class="content wysiwyg-content">
I am preparing for online training for “VS2010 C# access to an SQL 2008 R2 database&quot;. 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:<br />
<br />
Microsoft Visual Studio<br />
Unable to open the physical file &quot;D:\SQL Svr\MSSQL10_50.MSSQLSERVER<wbr />\MSSQL\DAT<wbr />A\DBD-Test<wbr /> .mdf&quot;. Operating system error 32: &quot;32(The process cannot access the file because it is being used by another process.)&quot;.<br />
An attempt to attach an auto-named database for file D:\SQL Svr\MSSQL10_50.MSSQLSERVER<wbr />\MSSQL\DAT<wbr />A\DBD-Test<wbr />.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.<br />

</div>
</div>


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.


OS 32 Connection Error

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

The Dynamic Host Configuration Protocol (DHCP) is an auto configuration protocol used on IP networks and an extension of the Bootstrap Protocol. DHCP allows for computers to be configured automatically to communicate with each other over an IP network without the need for manual setup by a network administrator. The implementation of DHCP relies on a DHCP server to hand out network configuration information to DHCP-capable clients that request an IP address (and other information required or useful in communicating with other devices on an IP network). In addition to an IP address, common configuration information served over DHCP includes a default gateway, subnet mask and DNS sever(s).

DHCP

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.