.net - C# :Does Client machine need SQL Server installed on it while connecting to other machine having SQL Server installed on it (the Server machine) -


i have written c# windows application form runs on client machine , connects sql server on machine.while building connection in c# have used dlls like

1)microsoft.sqlserver.management.smo. 2)microsoft.sqlserver.management.connectioninfo 3)microsoft.sqlserver.management.sdk.sfc

the client machine on aplication built having sql server installed on it. importing , accessing dlls not problem.

however on other client machine on going run c# windows application not having sql server installed on it.

so cause problem.will connection fail on client machine due absence of sql server.

if yes, way around solve problem without installing sql server on client machine.

ps: asking beforehand avoid last minute hassle on day of installation.

the pieces needed connect sql server built .net framework. long used when coding client piece can connect sql database without mssql installed on client.

using system.data; using system.data.sqlclient; 

sqlclient

ps: asking beforehand avoid last minute hassle on day of installation.

you should test locally first. can probally hands on random test machine verify go.


Comments

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -