IT Knowledge Base

User Tools

Site Tools


Contact me at for any feedback or suggestions.

My other sites:

Search all my sites:


Microsoft SQL Server

Show the file locations of all databases

Right-click on the instance in SQL Server Management Studio > New Query

SELECT name, physical_name AS current_file_location
FROM sys.master_files

SQL SERVER - Find Current Location of Data and Log File of All the Database - Journey to SQL Authority with Pinal Dave

Network Configuration

  • To enable TCP and/or Named Pipes: SQL Server Configuration Manager > SQL Server Network Configuration > Protocols. Set the desired protocols to “Enabled”
  • Windows Firewall: Default port is 1433 (TCP), you will need to add a rule into Windows Firewall. (more info)

Port Numbers

  • Only the default instance listens on port 1433
  • Named instances use dynamic port allocation
    • This relies on the SQL Server Browser service on the server. Make sure it's running and set to auto-start.
    • OBDC needs to connect to SERVERNAME\INSTANCENAME instead of just SERVERNAME
microsoft_sql_server.txt · Last modified: 2018/04/09 09:56 (external edit)