ChuckDoherty Posted July 19, 2003 Posted July 19, 2003 Just recently, my server explorer stopped recognizing any of the connection I had established. Attempts to create new connections resulted in an error box with a message stating; "Unable to add Data Connection. Some program files are not properly registered on your machine. Run the Setup program again" After this, I removed and reinstalled both the SQL Server 2000 (SP3), and the entire VS.NET development environment. No change. I am able to access the database fine from the applications, through the SQL Enterprose Manager, and via the Query Analizer. However, the server explorer will not connect. I assume that some program or dll associated with the server explorer needs to be registered properly, but I do not know which one. Any help or advice would be most appreciated. Thanks in advance. cd Quote
Moderators Robby Posted July 20, 2003 Moderators Posted July 20, 2003 It may be a security issue or possibly a firewall thing. I can't really think of anything else. Quote Visit...Bassic Software
ChuckDoherty Posted July 20, 2003 Author Posted July 20, 2003 I am quite certain that it is not that. Everything is local anyway (no firewalls involved), and the data is accessabe fine from everything else including the apps themselves. This problem has something to do with the registration of some part of the server explorer itself, but I don't know what programs or dll's are associated with it. Quote
Moderators Robby Posted July 20, 2003 Moderators Posted July 20, 2003 Local or not, security is always involved. Can you right-click on 'Server' and 'Add server' ? Quote Visit...Bassic Software
ChuckDoherty Posted July 20, 2003 Author Posted July 20, 2003 Yes I can. But the instance appears with the red "X" on it. When adding a connection, I see the server just fine, and "test connection" works fine. It even stops at that point if I supply an invalid login. But with a valid login, it fails at the nest stage in the process, saying that "some program files are not properly registered." While I agree that security is a factor in any server connection, I am quite confident that this particular problem is not related to security. Quote
TomGehrke Posted July 27, 2003 Posted July 27, 2003 I'm having the exact same problem on two separate machines. A third machine works correctly so I assume that the server side is configured correctly. But maybe not. This one is really driving me crazy. Tom PS: Pleased to meet everyone. ;) Quote
ChuckDoherty Posted July 27, 2003 Author Posted July 27, 2003 Solution found! I just found the fix for this! Copy the two DLLs; MSVCR71.DLL and MSVCP71.DLL from the directory Program Files\Microsoft Office\OFFICE11\VS Runtime into your [Windows]\System32 directory. That should set things straight for you - itr did for me anyway! cd Quote
TomGehrke Posted July 27, 2003 Posted July 27, 2003 Confirmed! Awesome! How on earth did you figure that out?! Quote
TomGehrke Posted July 27, 2003 Posted July 27, 2003 BTW, this problem seems to be caused by the application of the Office 2003 Beta 2 Technical Refresh. Quote
Moderators Robby Posted July 27, 2003 Moderators Posted July 27, 2003 In case you're interested: Here are the products that shipped those DLLs... http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=271718 http://support.microsoft.com/servicedesks/fileversion/moreinfo.asp?Id=271719 Quote Visit...Bassic Software
ChuckDoherty Posted July 27, 2003 Author Posted July 27, 2003 via Google, I happened upon the email address of someone at Microsoft who had posted something related to the visual database support tools. I wrote to him, and he was very helpful. After a few emails back and forth for more info, he sent along the solution. I do think that this is something that should find its way onto the MS knowledge base, and I hope they post it there for others. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.