Connecting to SQL Server 2008 using Application Compatibility Manager
-
Wednesday, March 14, 2012 9:24 PM
Hi,
I just installed SQL Server 2008 R2 Express so I could use the Application Compatibility Toolkit. I tried to begin the process by starting the Application Compatibility Manager and using the ACT Configuration Wizard. I selected "Enterprise edition", then went to the next screen and tried to "Browse" in order to specify the SQL Server. However, no instances appeared after browsing. I checked under All Programs >> Microsoft SQL Server 2008 R2 >> SQL Server Configuration Manager and I noticed that there were two SQL Services running - SQLEXPRESS and a named instance. Any ideas of how to get the Application Compatibility Manager to "see" these instances? Or any ideas of what I am doing wrong?
Thanks in advance!
Steve
All Replies
-
Wednesday, March 14, 2012 11:59 PM
what are you trying to achieve?
Windows MVP 2010-11, XP, Vista, 7. Expanding into Windows Server 2008 R2, SQL Server, SharePoint, Cloud, Virtualization etc. etc.
Hardcore Games, Legendary is the only Way to Play
Developer | Windows IT | Chess | Economics | Vegan Advocate | PC Reviews
-
Thursday, March 15, 2012 1:43 PM
Hi Vegan Fanatic,
I'm trying to test in-house applications for compatibility with Windows 7. We are migrating from Windows XP to Windows 7, and some of the applications will not run in Windows 7. I was hoping to find the problems using the Application Compatibility Toolkit.
Thanks!
-
Thursday, March 15, 2012 5:45 PM
Apparently I just needed to change the permissions on the SQL Server folders. After doing so, the instances that were running were available in the drop-down list.
- Marked As Answer by Diretiger Thursday, March 15, 2012 5:46 PM
.png)
