Article ID: 942246
Article Last Modified on 11/19/2007
APPLIES TO
- Microsoft Visual Studio 2005 Professional Edition
SYMPTOMS
When you try to open a database connection to Microsoft SQL Server 2008 November Community Technology Preview (CTP) by using the Microsoft Visual Studio 2005 design tools, you may receive the following error message:
RESOLUTION
To resolve this problem, install the Visual Studio 2005 Community Technology Preview (CTP). This CTP lets developers use Visual Studio 2005 together with SQL Server 2008 November CTP.
How to obtain the Visual Studio 2005 CTP
The following file is available for download from the Microsoft Download Center:
![[GRAPHIC: Download]](/wiki/index.php?title=File:Download.gif){kind=small}
Download the package now.
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
Features
After you install the Visual Studio 2005 CTP, you can use the following Visual Studio features together with SQL Server 2008 November CTP:
- Server Explorer
Note You can use Server Explorer to connect to SQL Server 2008 November CTP. You can view and edit some database objects in Visual Studio 2005. For example, you can view and edit stored procedures and table data in Visual Studio 2005.
- SQL Server common language runtime (CLR) projects
Note You can create and then deploy the SQL Server CLR projects to SQL Server 2008 November CTP.
- Transact-SQL debugging
- SQL Server CLR debugging
- DataSet Designer
- Data Sources
- Data binding
Note You can use the data binding features in client projects and in Web projects.
After you install the Visual Studio 2005 CTP, you cannot use the following Visual Studio 2005 features together with SQL Server 2008 November CTP:
- You cannot create or edit the table schemas in the Visual Studio Table Designer or in SQL Server Management Studio database diagrams.
To create and to edit the table schemas in SQL Server 2008 November CTP, use Table Designer in SQL Server Management Studio in SQL Server 2008 November CTP. To obtain SQL Server Management Studio, follow these steps:
- Download and then install SQL Server 2008 Developer Edition November CTP.
- During the installation, install the SQL Server Management Tools from the feature tree.
- After the installation is complete, start SQL Server Management Studio.
- Connect to the instance of SQL Server to which the database is attached.
- Use Visual Studio 2005 Team Edition for Database Professionals together with SQL Server 2008 November CTP.
System Requirements
- Windows Server 2003 Service Pack 1, Windows Vista, or Windows XP Service Pack 2
- Visual Studio 2005 Service Pack 1
- Access to a running instance of SQL Server 2008 November CTP.
- The English version of Visual Studio 2005 Professional Edition or the English version of Visual Studio 2005 Team System Editions
Known Issues
- After you enable SQL Server CLR debugging in the SQL Server CLR project and on the server, you cannot step into or click the breakpoint in the project code. To work around this problem, make sure that the Assemblies node is expanded in Server Explorer.
- When you uninstall the Visual Studio 2005 CTP on a computer that is running Windows Vista, you may receive the following error message: To work around this problem, provide the Visual Studio installation media. Or, provide the installation network location.
Restart requirement
You must restart the computer after you apply this CTP.
File information
The English version of this CTP has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
| File name | File version | File size | Date | Time |
|---|---|---|---|---|
| Microsoft.Data.ConnectionUI.Dialog.dll | 8.0.50727.935 | 393,216 | 18-Sep-2007 | 05:24 |
| Microsoft.Data.ConnectionUI.dll | 8.0.50727.935 | 6,144 | 18-Sep-2007 | 05:25 |
| Microsoft.VisualStudio.DataTools.dll | 8.0.50727.935 | 1,970,176 | 18-Sep-2007 | 05:25 |
| Microsoft.VisualStudio.vspBatchParser.dll | 2005.90.3042.0 | 363,376 | 10-Feb-2007 | 06:23 |
| Microsoft.VisualStudio.vspConnectionInfo.dll | 9.0.3196.0 | 156,688 | 15-Sep-2007 | 10:01 |
| Microsoft.VisualStudio.vspGridControl.dll | 9.0.3042.0 | 202,096 | 10-Feb-2007 | 06:23 |
| Microsoft.VisualStudio.vspRegSvrEnum.dll | 9.0.1399.0 | 64,216 | 14-Oct-2005 | 03:45 |
| Microsoft.VisualStudio.vspServiceBrokerEnum.dll | 9.0.3196.0 | 42,000 | 15-Sep-2007 | 10:01 |
| Microsoft.VisualStudio.vspSmo.dll | 9.0.3196.0 | 1,606,672 | 15-Sep-2007 | 10:01 |
| Microsoft.VisualStudio.vspSmoEnum.dll | 9.0.3196.0 | 222,224 | 15-Sep-2007 | 10:01 |
| Microsoft.VisualStudio.vspSqlEnum.dll | 9.0.3196.0 | 898,064 | 15-Sep-2007 | 10:01 |
| Microsoft.VisualStudio.vspSqlTDiagM.dll | 9.0.1399.0 | 43,736 | 14-Oct-2005 | 03:46 |
| Microsoft.VisualStudio.vspWmiEnum.dll | 9.0.1399.0 | 43,736 | 14-Oct-2005 | 03:46 |
| Vdt80.dll | 8.0.50727.935 | 3,990,016 | 18-Sep-2007 | 03:04 |
| Vdt80p.dll | 8.0.50727.935 | 627,200 | 18-Sep-2007 | 03:05 |
REFERENCES
To download Visual Studio 2005 Team Suite Service Pack 1, visit the following Web site:
For more information about Assemblies node, visit the following Microsoft Developer Network (MSDN) Web site:
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
Additional query words: SSMS
Keywords: kbhowto kbexpertiseadvanced kbpubtypekc kbqfe KB942246
