"Steve Bugden" <SteveBugden@discussions.microsoft.com> wrote in message
news:EC39D6D1-341C-4F81-913F-2575785D5BF1@microsoft.com...
> Hi,
>
> Could someone please tell me what I would need to install if anything on a
> client machine to access an SQL Server 2005 database from a .Net
> component?
>
> Is it sufficient just to have the database files (.mdf and .ldf) and
> access
> them via ADO.NET?
>
> I only have a development machine and therefore can't properly test this
> without deinstalling/reinstalling sql server.
>
> Thanks
>
> Steve.

"William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
news:Om6omo4sHHA.400@TK2MSFTNGP02.phx.gbl...
> It really depends on your architecture. SQL Server is a service-based
> DBMS. You need to be running this service on the same system as the .MDF.
> The client need not host either the .MDF or the service, but it can.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Steve Bugden" <SteveBugden@discussions.microsoft.com> wrote in message
> news:EC39D6D1-341C-4F81-913F-2575785D5BF1@microsoft.com...
>> Hi,
>>
>> Could someone please tell me what I would need to install if anything on
>> a
>> client machine to access an SQL Server 2005 database from a .Net
>> component?
>>
>> Is it sufficient just to have the database files (.mdf and .ldf) and
>> access
>> them via ADO.NET?
>>
>> I only have a development machine and therefore can't properly test this
>> without deinstalling/reinstalling sql server.
>>
>> Thanks
>>
>> Steve.
>
>

"RobinS" <RobinS@NoSpam.yah.none> wrote in message
news:3aidna3jjszAuufbnZ2dnUVZ_sSmnZ2d@comcast.com...
>I test this sort of thing by setting up a VM (I use VMWare -- the (free)
>server version) and accessing the SQLServer running on my machine from
>within the VM.
>
> Robin S.
> ----------------------
> "William (Bill) Vaughn" <billvaRemoveThis@betav.com> wrote in message
> news:Om6omo4sHHA.400@TK2MSFTNGP02.phx.gbl...
>> It really depends on your architecture. SQL Server is a service-based
>> DBMS. You need to be running this service on the same system as the .MDF.
>> The client need not host either the .MDF or the service, but it can.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "Steve Bugden" <SteveBugden@discussions.microsoft.com> wrote in message
>> news:EC39D6D1-341C-4F81-913F-2575785D5BF1@microsoft.com...
>>> Hi,
>>>
>>> Could someone please tell me what I would need to install if anything on
>>> a
>>> client machine to access an SQL Server 2005 database from a .Net
>>> component?
>>>
>>> Is it sufficient just to have the database files (.mdf and .ldf) and
>>> access
>>> them via ADO.NET?
>>>
>>> I only have a development machine and therefore can't properly test this
>>> without deinstalling/reinstalling sql server.
>>>
>>> Thanks
>>>
>>> Steve.
>>
>>
>
>