We have to interface with a legacy MSDE database. I cannot install the database on Windows 7, so for development I installed the database in a VM. To detect port number:
Run C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
Select General Tab, highlight TCP/IP, click Properties.. button
Make an exception on the firewall for this port and then, from Windows 7 client connect using Studio Express with the following server name:
tcp:<ip address>,<port number>\<db name>
No comments:
Post a Comment