I tried to connect over WiFi to SQL Server with SQL Server Management Studio from another computer, but it failed.
I have a computer with Windows 7 & SQL Server 2008 (lets say the server computer). Next to it I have a freshly installed computer with Windows 7 & SQL Server Management Studio (let's say the client computer).
What I did on the server computer:
- Configure firewall by enabling port 1433
- Enabled network protocols (TCP/IP) inside SQL Server Configuration Manager
Allow remote connections to this serverin server properties in the SQL Server Management application.
- Started SQL Server Browser
- Restarted services
(SQL Server Browser is stopped at this point, but I don't think it is necessary. Is it?)
Next, I successfully tested a ping on the port 1433 from my client computer with a tool named
tcping 192.168.1.4 1433). But I still cannot connect from my client computer to SQL Server on my server computer.
Ok, something new with this problem: Until now, I successfully connected to my "server computer" with Management Studio. What I did is type the computer name in the server name field in the connection window of Management Studio. My previous (failed) attempt was to type the computer name followed by the instance of SQL server (ex:
COMPUTER_NAME\SQL2008). I don't know why I only have to type the computer name.
Now my new challenge is to be successful in connecting my VB6 application to this remote database located on my "server computer". I have a connection string for this but it failed to connect.
Here is my connection string:
"Provider=SQLOLEDB.1;Password=mypassword;User ID=sa;Initial Catalog=TPB;Data Source=THIERRY-HP\SQL2008"
Any idea what's going wrong?