2
Vote

Unable to install federated DB

description

Hi, I was able to install the standard AdventureWorks DB on Azure but the but the federated version crashes with the following error. Any suggestions would be appreciated

Creating Database
Processing T-SQL file CreateAdventureWorksForSQLAzure_DB_Fed.sql
Creating Schema
Processing T-SQL file AdventureWorks2012ForSQLAzure_Schema_Fed.sql
__Error at or before line 2165: __Cannot create more than one clustered index on tab
le 'Production.BillOfMaterials'. Drop the existing clustered index 'PK_BillOfMat
erials_BillOfMaterialsID' before creating another.
Inserting Data


Unhandled Exception: System.Data.SqlClient.SqlException: USE FEDERATION operatio
n failed. Specified federation name does not exist.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolea
n breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
, Boolean breakConnection, Action
1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObj
ect stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand
cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName,
Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSou
rce`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean
asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at GetFederation.Program.Main(String[] args)
ECHO is off.
Installation Complete!

comments