I need to access a SQL Server database which is installed on one machine and I want to access it from another machine. I have tried below options and nothing work
- I have enabled TCPIP with IPALL as 1433 in SQL Server Configuration manager
- SQL Server and SQL Server Browser services are running, restarted after modified the configuration
- Added SQL Server and TCP port to Windows firewall (allowed apps) as domain and public
Used
sqlcmd -S servername,portname -U username -P password -d database
What am I missing? On my local machine, it is working
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…