'You may need to recreate view manually' error, Resolving Connection Issues Caused by TCP/IP Port Mismatch in SQL Server
Hi all,
If you get an error “You may need to recreate view manually”, it could be due to many reasons. A likely cause is a TCP/IP port mismatch. Below mentioned steps can be taken to possibly fix this error.
Follow the steps below to verify and correct the TCP/IP port settings for your SQL Server instance.
Step 1: Verify the Port Number in the Windows Registry
- Open the Registry Editor by typing regedit in the Start menu and hitting Enter.
- Navigate to:
- HKEY_LOCAL_MACHINE\Software\WOW6432Node\Config\[Your Instance Name]
- Locate and note the TCP port configured for your database instance.
Step 2: Check SQL Server Network Configuration
- Open SQL Server Configuration Manager (specific to your SQL Server version, e.g., SQL Server Configuration Manager 2019).
- In the left panel, expand SQL Server Network Configuration, and select the instance you are using (e.g., Protocols for MSSQLSERVER).
- Enable TCP/IP:
- Make sure that TCP/IP is enabled. If it is not, right-click on TCP/IP and select Enable.
- Check TCP/IP Port:
- Right-click on TCP/IP, select Properties, and go to the IP Addresses tab.
- Scroll to the bottom section labeled IPAll and note the TCP Port specified here.
️ The port number found in this step must match the one noted in Step 1. If there is a mismatch, update the port settings so that both values are consistent (commonly port 1433 for default instances).
Step 3: Restart SQL Server Service
Once the ports are aligned:
- In SQL Server Configuration Manager, go to SQL Server Services.
- Locate your SQL Server instance (e.g., SQL Server (MSSQLSERVER01) — not the agent).
- Right-click the service and select Restart to apply the changes.
Step 4: Perform an IIS Reset
To complete the configuration changes:
- Open Command Prompt as Administrator.
- Run the following command: IISRESET
Hope this helps!
Kind Regards,
Seema Singla