I hope you're all doing well. I'm creating a Desktop Application for a friend using C#, which will be installed on 2 different PCs. Both users will need to connect to a Database, but the problem is that they don't have SQL Server installed on their machines. I'm thinking of creating a LocalDb with Visual Studio and put it on a WORKGROUP Network which gathers both machines so that they can connect to it remotely. I still did not try it, I want to know first if it's possible or not. Thank you in advance for your answers.
Is it possible to put the LocalDb on WORKGROUP network and connect remotely with a C# application?
91 Views Asked by Mehdi Ennajem At
2
There are 2 best solutions below
0
Walter Verhoeven
On
just use one of the 2 computers as the host for the SQL server and open the firewall port allowing for TCP connections when from the LAN network
You can use the computer name to connect if you enabled network discovery, else you will need to use the IP address (make sure it always has the same)
Related Questions in C#
- Passing arguments to main in C using Eclipse
- kernel module does not print packet info
- error C2016 (C requires that a struct or union has at least one member) and structs typedefs
- Drawing with ncurses, sockets and fork
- How to catch delay-import dll errors (missing dll or symbol) in MinGW(-w64)?
- Configured TTL for A record(s) backing CNAME records
- Allocating memory for pointers inside structures in functions
- Finding articulation point of undirected graph by DFS
- C first fgets() is being skipped while the second runs
- C std library don't appear to be linked in object file
- gcc static library compilation
- How to do a case-insensitive string comparison?
- C programming: Create and write 2D array of files as function
- How to read a file then store to array and then print?
- Function timeouts in C and thread
Related Questions in VISUAL-STUDIO
- The current .NET SDK does not support targeting .NET Core 6.0. Brand new WPF Project VS Community 2022 17.9.5
- Dotnet Run is not working but the application is running in Visual Studio
- Is there a way to support Tailwind @apply in Visual Studio?
- How can I eliminate compile warnings using ZLib in Visual Studio
- C++(or Visual Studio) saving the file will not preserve the original file contents
- VS Community 2022 cannot install dotnet-ef when i try to publish
- Visual Studio 2022 convert spaces to tabs on checkout and back to spaces on checkin
- What should I do if Visual Studio has a restriction on creating files with a long name or a long path to these files?
- Command line error D8036 - not allowed with multiple source files with node-gyp and VS2022
- Migrate Old VS 2015 .suo file to the New VS 2022 DocumentLayout.json
- How to make one executable visual studio, that users can run?
- Use tabs instead of spaces in .csproj file in Visual Studio 2022
- Unity - scrollview/dragging breaks after specific scene inactivity
- How to make Visual Studio 2022 project launch Windows Terminal instead of PowerShell?
- Why is 'EDITBIN /STACK:2097152 w3wp.exe' cmd is giving me an LNK1342 error?
Related Questions in LOCALDB
- How to deploy Windows app with SQL Server database?
- How can I use 2014 (782) version of localDB in visual studio 2013
- Having trouble saving changes in Dataset to SQL LocalDB
- c# to vb using Sync Framework strange error
- Connecting to localdb with Visual Studio and NUnit
- Embedding SqlLocalDb in NSIS installer script
- Placing a LocalDB Database into AppData via Installer
- C# entity framework MVC second run error
- Why is my MVC 5 application trying to access Local DB
- How to detect SQL Server installation?
- Same local database from different assemblies not working
- Django + pyodbc + MS LocalDB ghost instance
- Cannot host use LocalDB in web app when hosting on IIS (Windows 10)
- Connect LocalDB to ASP.net Project
- Can I connect remote sql server database without management studio
Related Questions in WORKGROUP
- How to create local user accounts by PowerShell on remote computers
- what does exactly the function barrier do in GLSL?
- (InvalidRequestException) when calling the StartQueryExecution operation: WorkGroup is not found
- Can you not delete the primary workgroup in aws athena after its been created? I would like to make sure im not getting charged for the resource
- How to use python to check if a computer is in a domain or is in workgroup
- Is it possible to put the LocalDb on WORKGROUP network and connect remotely with a C# application?
- WMIC unjoindomainorworkgroup gives positive result, but won't unjoin domain
- Service Certificate WCF Service
- WCF un-domain system
- WCF on a workgroup
- Can't access to shared drive in workgroup
- How do I get my pc's windows Workgroup name in python
- Sql Server replication setup in a high availability clustering system running on a workgroup
- Module heptio/workgroup moved to projectcontour/contour/internal/workgroup
- LogonUser API doesn't work correctly with Domain from Workstation
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Not possible, just use SQL Server Express.
Localdb uses named pipes only.