Posts Tagged ‘ sql server ’
If this is your first attempt to install, configure and integrate SharePoint 2010 with Team Foundation Server 2010 then you’re in for a real challenge. Although the installation tools have been getting much better with these latest versions of the server software, the amount of steps it takes to get everything up and running is mind numbing and an open invitation to a day or two of frustration.
The recommended way to create SQL databases from Entity Framework models is to use a dedicated database server. However, in some instances you may want to create the database in a .mdf file inside the application’s App_Data directory. While this is definitely possible, the solution is certainly not straightforward and not entirely possible from within Visual Studio alone. One needs to connect to an existing SQL Server database instance in SQL Server Management Studio and manually attach the .mdf database file to that instance.
This article is part of a backup. It was originally posted on Sunday, April 13. 2008.
At the very bottom of the SQL Server 2005 Express download page, Microsoft offers 64-bit versions of their installers. Unfortunately, this is not everything you need to run SQL Server Express on 64-bit versions of Windows Vista. As it turns out, the installer currently provided on the download page is bundled with the 32-bit version of the SQL Server Native Client, which causes the subsequent SQL Server installation to fail with the following symptoms:
Restarting the whole installation or uninstalling the Native Client doesn’t help.