Mundy

IT Knowledge Base

User Tools

Site Tools


Sidebar

Contact me at dan@mundy.co for any feedback or suggestions.


My other sites:

Search all my sites:

microsoft_sql_server

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)