Hi all,
I am using Visual Studio 2010 and SQL Server 2008 R2 Express edition installed on my PC. I would like to establish a remote database connection. For this, I attached my database to SQLServer2008R2 instance via SQL Server Management Studio successfully.
Then, through SQL Configuration Management, I enabled the TCP/IP for the SQLServer2008R2 instance and then in IP Addresses tab inserted 1433 in the TCP Port field for all IP version 1-9 and cleared 0 in the TCP Dynamic Ports as well. Additionally, I enabaled
all those IP versions. Finally, I restarted the SQL Server and SQL Server Explorer services. After that, I created an Inbound rule within Windows Firewall with the specific port of 1433 for both local and remote ports. I am woundering why VS
2010's Database Explorer does not display Microsoft SQL Server within the Data Source list when attempting to create a connection.
It may be of help that I installed an ...
Go to the complete details ...