|
-
Nov 20th, 2016, 02:36 AM
#11
Thread Starter
Addicted Member
Re: How to put SQL database on a server and how to access it?
If you don't want your users to have to do that as part of your deployment though, you can use SQLCMD instead
Hi, and thanks for that information! I've been trying to do that now. The server works on my own computer, and I can connect to the database, but my other computer in the same wifi will not connect to it. I've tried messing around with the connection strings to no avail.
Right now I have:
Server=Toshiba-Nic\SQLEXPRESS;Database=NameAndEmail;Trusted_Connection=True;
And I'm getting error 26 (error locating server/instance).
This looks right, right? What's going on?
Thanks!
~Nic
EDIT:
I realized that I needed to allow a ton of stuff through the firewall. I found a detailed tutorial here. Manual link:
www.sqlshack.com/how-to-connect-to-a-remote-sql-server
It works now! Thanks, everyone who helped.
Last edited by NinjaNic; Nov 20th, 2016 at 02:52 AM.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|