My bruh, very clean video but it could have been way more time efficient: 1) Enable all features from SQL configuration manager 2) Add 1433 to all ports of TCP/IP properties 3) Add inbound rule for port 1433 to Firewall 4) Try PC_NAME if PC_NAME/SQLEXPRESS isnt working
Suppose 2 PC's connected with each other through LAN and SQL server are installed in both PC's, 1 PC's instance is server\sqlexpress which is main PC and another PC's instance is local1\sqlexpress, so now if you want to connect server\sqlexpress from local1\sqlexpress then all configuration should set or enabled in server\sqlexpress PC's not for local1\sqlexpress
I m gettin this error TITLE: Connect to Server Cannot connect to ADMIN-PC\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
My bruh, very clean video but it could have been way more time efficient:
1) Enable all features from SQL configuration manager
2) Add 1433 to all ports of TCP/IP properties
3) Add inbound rule for port 1433 to Firewall
4) Try PC_NAME if PC_NAME/SQLEXPRESS isnt working
Suppose 2 PC's connected with each other through LAN and SQL server are installed in both PC's, 1 PC's instance is server\sqlexpress which is main PC
and another PC's instance is local1\sqlexpress, so now if you want to connect server\sqlexpress from local1\sqlexpress then all configuration should set or enabled in server\sqlexpress PC's not for local1\sqlexpress
very clear and descriptive video.Thank you
Thank you. You saved me from trouble.
Thanks Bro, it's connected now
Nice Video and Explaination. 👍😘
I m gettin this error
TITLE: Connect to Server
Cannot connect to ADMIN-PC\SQLEXPRESS.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
Admin-pc\sqlexpress is another PC or your PC?
How can i connect my desktop to sql server LAN another computer
Enable settings (given in this video) for your computer
You have connected to the local pc not to the networked pc...
Don't make fools🙄
local PC but not networked? They are in the same IPv4 range. What else is required for networked?
All PC's connected through each other using LAN/Wi-Fi
your making a fool of yourself 😂