You may receive an error:
Running transformation: Microsoft.SqlServer.Management.Smo.FailedOperationException: SetParent failed for Database ‘XXXX’. —>
Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server XXXX. —>
Microsoft.SqlServer.Management.Common.ConnectionFailureException: This SQL Server version (10.0) is not supported.
When attempting to connect to a SQL Server 2008 database when working with T4 templates or simply accessing an SQL Server directly using the SQL Server SDK via [...]
Filed in .NET
|
Also tagged T4
|
Ok, I’m angry, and two hours of my time has gone that I will never get back.
I’ve just spent the morning trying to get Microsoft SQL Server 2008 Express + Management Studio installed after a PC format. I’m running Windows 7 64-bit Ultimate (x64) and all files in question below were downloaded via the Microsoft [...]
Howdy,
Today I found myself in need for a country list (specifically ISO 3166 for completeness) and like many others it wouldn’t be the first time I’ve needed to install one of these in a database. So off I headed to google in search for a ISO country list sql server (.sql) import file.
Found a [...]
When running the SQL Server 2008 Express installer I go through all the steps and then the installation begins, then just before completion I receive:
” is not a valid login or you do not have permission.
So I was tearing my hair out on this one. I’m running Windows Vista SP1 and using the latest SQL [...]