Results 1 to 11 of 11

Thread: [RESOLVED] How to put SQL database on a server and how to access it?

Threaded View

  1. #11

    Thread Starter
    Addicted Member
    Join Date
    Dec 2013
    Location
    Earth
    Posts
    230

    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
  •  



Click Here to Expand Forum to Full Width