November 24, 2009 at 7:31 am
Two Vista Home Premium machines setup. SQL Express 2005 is successfully installed on the first machine along with our application. Our application is able to browse and connectthe SQL Express. However, the other machine is unable to browse or see the SQL Server. What could be the issue??
Another thing, in order to test the connection, I tried creating a UDL file on the machine that wont connect.And it does not recognize the .udl extension. Why so?
Kindly help.
November 24, 2009 at 8:12 am
Two Vista Home Premium machines setup. SQL Express 2005 is successfully installed on the first machine along with our application. Our application is able to browse and connectthe SQL Express. However, the other machine is unable to browse or see the SQL Server. What could be the issue??
Vista is technically not compatible with both SQL Server 2005 and VS2005 but you can run it with Admin permissions. I think the reason you cannot see the other Vista is your browser service and TCP/IP and Named Pipes may be disabled. So you need to spend time with SAC(surface area configuration) tool and enable all that is needed. And the home premium comes without Windows authentication in IIS7 so you cannot run the SQL Server 2005 full version in it because SSRS in 2005 is IIS dependent.
Another thing, in order to test the connection, I tried creating a UDL file on the machine that wont connect.And it does not recognize the .udl extension. Why so?
Vista cannot recognize UDL file because it comes with new data access and I think UDL is MDAC dependent so you may have to manually reference MDAC in your UDL file.
I know you could manually reference MDAC in Visual Studio for older Access or Excel related development.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply