Using the above .NET 2005 Project, you can connect to your SQL Server Default Instance and test the connection.
Possible issues:
1. Unable to connect to SQL server or MSDE 2000 from remote machine/another machine.
2. Unable to connect to SQL Server or MSDE 2000 from Code.
Resolution:
Change your firewall settings and add an exception to the port 1433. Or turn off firewall. And then follow these steps.
Step 1: Open SQL Server Configuration Manager
Step 2: Enable TCP/IP Connections
Step 3: Start Menu => Run
Step 4: Type services.msc and press OK
Step 5: Restart SQL Server
No comments:
Post a Comment