At my home, I have 2 PCs from our client company (I don't have better windows images and I would prefer not changing them, at least the windows 10 image/PC):
| PC | Windows | SQL server | SSMS | IP |
|---|---|---|---|---|
| 1 | 7, version 6.1, build 7601 sp1 | 2014 (installation in progress) | not yet | 192.168.0.10 |
| 2 | 10, version1803, build17134.345 | 2017 | 18.1 | 192.168.0.105 |
The final goal: to have the PC1 act as a sql server and PC2 as a client (that can access the server's dbs). Update1: I want an application from PC2 to be able to change data from the PC1's db.
The problem: I don't know what the username/PC/workgroup should look like in the Database Engine Configuration screen (especially in the SQL Server administration section). I had tried the followings:
- WORKGROUP\(PC2 username) I get: an object cannot be found
- (PC2Name)\(PC2 username) I get: an object cannot be found
- \\(PC2Name)\(PC2 username) I get: the following name is not valid... To specify an object on a computer, use the following format: computer\item. To specify a computer, use the following format: \\computer UPDATE1: Would this (addition of a user from PC2) suffice in order to allow applications from PC2 to change data on PC1?
Q: Why are the machines so different? A: That's all I get for the moment from our client company. (I'm trying to access the inferior with something superior, which I believe/hope it should work)
As side notes:
- although I have the file and printer sharing started on both machines, when ping-ing the PC2 from PC1 I get "Reply from 192.168.0.10: Destination host unreachable" - I don't know how/if this will influence the ability for the PC2 to connect to PC1.
- both PCs are in the same workgroup (right click on PC > Properties);
- on both PCs I had shared some folders and I can see them from the other PC;
- these 2 PCs are in a separate network at my home (they are both connected only to a router, which is not connected to internet)
Thank you!
R
