<div>
a mdb file is an Access file not a SQL Server<br />
<br />
but you can use OpenRowset as shown in <a href="http://msdn.microsoft.com/en-us/library/ms190312.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms190312.aspx</a><br />
<br />
SELECT *<br />
&nbsp; &nbsp;FROM OPENROWSET('Microsoft.Jet.<wbr />OLEDB.4.0'<wbr />,<br />
&nbsp; &nbsp; &nbsp; 'C:\BAND\player.mdb';<br />
&nbsp; &nbsp; &nbsp; 'admin';'',Customers);<br />
GO
</div>


a mdb file is an Access file not a SQL Server

but you can use OpenRowset as shown in http://msdn.microsoft.com/en-us/library/ms190312.aspx [http://msdn.microsoft.com/en-us/library/ms190312.aspx]

SELECT *
   FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
      'C:\BAND\player.mdb';
      'admin';'',Customers);
GO

<div>
I meant to connect it from SQL Server Management Studio.
</div>


I meant to connect it from SQL Server Management Studio.

<div>
if its from sql 2005 yes , sql 2000 probably<br />
<br />
sql 7 or earlier probably not...<br />
<br />
do you know which version created it?<br />
<br />
go into management studio right click databases and try attach database...
</div>


if its from sql 2005 yes , sql 2000 probably

sql 7 or earlier probably not...

do you know which version created it?

go into management studio right click databases and try attach database...

<div>
Yes, then you can attach to it..<br />
<br />

</div>


<div>
I followed a book by APRESS, the author use an example by SQL Server 2005 connect a mdb file on management Studio.<br />
However SQL Server 2005 is a legacy technology. You know, the popular is 2008.<br />
Then the question was arised.
</div>


I followed a book by APRESS, the author use an example by SQL Server 2005 connect a mdb file on management Studio.
However SQL Server 2005 is a legacy technology. You know, the popular is 2008.
Then the question was arised.

<div>
<div class="content wysiwyg-content">
Hello, I used SQL Server one years ago. Now I almaost forget everything. I have a file C:\BAND\player.mdb. How can I connect it by SQL Server 2008 R2?<br />
Suppose SQL Server Authentication is used.<br />
<br />
Thanks.
</div>
</div>


Hello, I used SQL Server one years ago. Now I almaost forget everything. I have a file C:\BAND\player.mdb. How can I connect it by SQL Server 2008 R2?
Suppose SQL Server Authentication is used.

Thanks.

Connect  a mdb file.

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.