+ Reply to Thread
Results 1 to 10 of 10
  1. Senior Member
    Join Date
    Jan 2016
    Location
    Canada
    Posts
    188
    #1

    Default MS SQL2014 question

    Hello,

    I'm wondering if anyone could help me out with this as im having trouble. I use software that has a patient database and the same patients often comes back for multiple visits. I have the software on 3 computers though as some computers are in use by other people.(no assigned computers).

    I downloaded SQL 2014, exported the patient database as a .bak. Imported it in SQL and now I am trying to connect to it from another computer but no luck. Is it this simple or am I missing steps?

    Thanks.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,050

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #2
    Can you see the other computer on your network?
    Never let your fear decide your fate....
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    May 2006
    Posts
    2,021

    Certifications
    CISSP, CCSP, eJPT, ITIL,PA ACE,Qualys Certified Specialist, A+
    #3
    This might be helpful to you. You might need to do some configuration changes on the sql server in order to access it from a different machine.
    ://msdn.microsoft.com/en-us/library/ms345343.aspx
    Reply With Quote Quote  

  5. Senior Member TeKniques's Avatar
    Join Date
    Jul 2004
    Location
    Oregon, USA
    Posts
    1,250

    Certifications
    OSCP, CISA, CISSP, SSCP, MCSA 2008, MCSE 2003: Security, MCDST, MCP, Security+, Network+, A+, Project+, CCENT, CCNA
    #4
    If Windows firewall is enabled, ensure TCP 1433 is open on the SQL server. From the client, setting up an ODBC to the database server may be successful. When setting up the ODBC, you'll know if your firewall rule is working as you should be able to see the databases.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Jan 2016
    Location
    Canada
    Posts
    188
    #5
    Quote Originally Posted by scaredoftests View Post
    Can you see the other computer on your network?
    Yes I can see a couple other computers on the network, one being the file server.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Jan 2016
    Location
    Canada
    Posts
    188
    #6
    Quote Originally Posted by TeKniques View Post
    If Windows firewall is enabled, ensure TCP 1433 is open on the SQL server. From the client, setting up an ODBC to the database server may be successful. When setting up the ODBC, you'll know if your firewall rule is working as you should be able to see the databases.
    Firewall is enabled but even if all the computers are on the same subnet I would need to open port TCP1433?
    Reply With Quote Quote  

  8. Senior Member TeKniques's Avatar
    Join Date
    Jul 2004
    Location
    Oregon, USA
    Posts
    1,250

    Certifications
    OSCP, CISA, CISSP, SSCP, MCSA 2008, MCSE 2003: Security, MCDST, MCP, Security+, Network+, A+, Project+, CCENT, CCNA
    #7
    Yes, because that is the TCP port SQL listens on for connections. If you enable the SQL Browser service you'll also have to open the firewall for UDP 1434. However, ensure you're following best practices for security (i.e. use a low privileged account for the service).

    https://technet.microsoft.com/en-us/...=sql.110).aspx

    For SQL Browser info:
    https://technet.microsoft.com/en-us/...=sql.105).aspx
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    Jan 2016
    Location
    Canada
    Posts
    188
    #8
    Okay thanks! I'll give it a try
    Reply With Quote Quote  

  10. Junior Member
    Join Date
    Jul 2016
    Posts
    29

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #9
    On Proporties of instance (Connections page) in SQL Server Managament Studio must select option "allow remote connections to this server'.
    Reply With Quote Quote  

  11. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #10
    And since you are dealing with patient data, change the port from the default 1433 to something non-standard.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks