CODEWITHSUNDEEP
sql-serversql-server-2012database-connectionalmsql-server-2012-express
smashtest
smashtest

Reputation: 1

Connecting to SQL Database Server Remotely

I'll preface my question with: I am an absolute beginner with respects to the nature of MS SQL Server and have a layman's understanding of networking and 'computers' in general...

So, I'm trying to replicate an environment where:

  1. There is an 'application server' which hosts HPE's ALM
  2. This communicates with a database server with a Microsoft SQL Server DB

I currently have Microsoft SQL 2012 Server with a sample DB uploaded onto it on one laptop (Laptop 1) and the ALM software on the other laptop (Laptop 2). Both are connected to the same WiFi network.

Laptop 2 is asking me for Database parameters such as:

I have little idea of what I'm doing - I'd have thought it might be possible to connect to the DB through some sort of variant of the IP address of Laptop 1... but I'm unsure.

How can I connect to a MS SQL 2012 DB from one laptop to another? I realise this is probably a loaded question - I'd be happy if someone can point me in the right direction rather than an exact answer!

Thanks guys,

ST

Upvotes: 0

Views: 2197

Answers (1)

Slava Murygin
Slava Murygin

Reputation: 1955

I see two potential issues:

  • A corporate laptop might have firewall restrictions. So, you have to open port 1433 for SQL Server.
  • Possibly you are playing with SQL Express, which by default, does not have TCP/IP connection enabled. To enable it run "SQL Server configuration manager", go to Network configuration->Protocols->TCP/IP->Enable->restart SQL Server. Also check other properties. If static port 1433 is not set - set it.

Upvotes: 2

Related Questions