I try to connect by Wifi to Sql Server with Sql Server Management Studio from another computer but it failed.
I have a computer with Windows Seven & Sql Server 2008 (lets say the server computer). Next to it, I have a fresh installed computer with Windows Seven & Sql Server Management Studio (let's say the client computer).
What I do on the server computer:
- configure firewall by enabling port 1433
- enabled network protocols (TCP/IP) inside Sql Server Configuration Manager
- checked "Allow remote connections to this server" on server properties in Sql Server Management.
- started Sql Server Browser
- restarted services
(Sql Server Browser is stopped but I think it is not neccessary, isn't it?)
Next, I successfully tested a ping on the port 1433 from my client computer with a tool named tcping (ex: tcping 192.168.1.4 1433). But I still cannot connect from my client computer to Sql Server on my other computer.
Ok, something new on this problem: until now, I successfully connected to my "server computer" with Management Studio. What I do is typing 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... Nevermind.
Now my new challenge is to succeed connecting my VB6 application to this remote database located on my "computer server". 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 wrong?