What is the name of my SQL/Server?

Question

I'm doing an exercise where I'm instructed to replace the following line with my SQL/Server name: 

http://<myserver>:8080/NorthwindDataCacheSyncService/

So what is the name of my server?  And what do I use as a port, is 8080 okay or should I use something else?  Thank you.

Answer 1

Unfortunately you don't provide enough info about what exercise you are doing so let me guess:

- based on the http link, I think you need to replace it with your computer name or IP and NOT the sql server name which may be different from the computer name.
- as for the computer name, use HOSTNAME or IPCONFIG from command prompt or go to Control Panel/System.
- port number 8080 is also configurable: it depends on what port has been specified when configuring it. Most likely it is the same port 8080.

Thanks,

---

Varsham Papikian, New England SQL Server User Group Executive Board, USA
New England SQL Server User Group; My LinkedIn page
Please remember to click the "Mark as Answer" button if a post helps you!

Answer 2

Try

select @@ServerName

---

Premature optimization is the root of all evil in programming. (c) by Donald Knuth

Naomi Nosonovsky, Sr. Programmer-Analyst

My blog

Answer 3

If I look at the resulting string, I think the server name (HOST_NAME()) needed:

select @@servername

http://SRV\INSTANCE:8080/NorthwindDataCacheSyncService/


SELECT HOST_NAME()

http://SRV:8080/NorthwindDataCacheSyncService/

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com