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 get all databases on LocalDb installed by different users?
- How to move LocalDB mdf files
- Unable to connect to SQL Server LocalDB using TypeORM
- How can we save the data into the LocalDB in windows form
- Azure Cloud webapp&Database setup issue
- Run build_runner for existing sqlite database
- Using wrong version of SQLLocaldb on Windows-Latest Devops Build Agent - possibly?
- Unable to start MSSQLLocalDB due to error
- Command "Update-database" not connecting to SQL server
- Cannot open database aspnet requested by the login. The login failed. Login failed for user IIS APPPOOL
- python local databse mssql connection string
- How to connect the model to the local Microsoft database? (C# Razor MVC structure - MVS editor)
- What tools can be used to get an Office Add-in (web app) to get data from the localdb?
- How to automatically install SqlLocalDB after installing my C# app
- Problem accessing localDB when moving application to new folder
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.