You will need to either open SQL Config Manager or Computer Management on Main computer running the SQL server.
One there find the Protocols for SQL server and ensure TCP/IP & Named Pipes are both enabled. Like below.
After that you will need to setup a port for SQL server so that clients wanting to connect to the server can access it using the IP address and Port specified.
You can do this by right clicking TCP/IP and going to Properties>IP Addresses…
Scroll all the way down to the bottom. and under the part that says “IP All” Remove whatever is in TCP Dynamic Ports and under TCP Port. Type a relevant port. The one I use is 49170.
Then you may be required to allow the port through the windows firewall first.
After firewall setting is done, on your tablet test to first ensure you can ping the server machine local IP address such as 192.168.1.10 or whatever the local IP address is on the main machine. Another method for this is open Command Prompt and type ipconfig. You can find your local IP address under IP address Protocol Version 4
Then on your tablet your database string should look something like this…
You can also disable firewall to allow this to work too however I personally don’t recommend it as if you are allowing internet access on the systems, you are making your PC vulnerable to attacks.
I am using such an old tool because the computer I have is 32 bit and won’t install a newer version, and when I downloaded SQL it didn’t have the option to download the management tool. But now that I know I can use the config manager I won’t be using it anymore!
I did all of this using configuration manager on my host machine and it still connects fine. However my tablet still won’t connect (note I changed the database name the way you did involving the IP address instead). It gives me the same error as before. Do I have to do the same thing through configuration manager on my windows tablet?
Update: I am using TOAD to try to connect, but it is not working out for me, so I am not sure my server is set up right. Here are pictures from the host computer
Please do us a favor and take screenshots and paste them here pictures of a screen with a phone are hard to see and i certainly dont like tilting my head to read an error.
Press print screen then just simply paste it here.
Sorry. The only reason I was doing that is because the host machine is very old and slow, so it takes quite a while to compose and publish a post. Here is the error on the windows run tablet being used to connect to the host.
What kind of ip address is that? Isn’t ipv4 and doesn’t look like ipv6 either.
Did you do the trunks bit of the SQL tutorial? I’ve missed that step before.
I just went into CMD and typed ipconfig and used the address under IPv4 address. I’ve watched many tutorials on setting it up, but maybe I missed something. Is there a resource you can direct me to that shows me how to do that?