Ibra Bordsen

Developer. Having actually written hosted database applications for my family and friends, I'm excited to help SQL Server move towards making hosted SQL a smooth and easy experience.

I currently work for Affirma Consulting.

Richard Burkhardt

Alex DeNeui

Leila Lali

Himanshu Vasishth

Dan Winn

Senior Program Manager. I've been in SQL Server at Microsoft for over 5 years now, spending most of that time working on the Relational Engine. I now manage the Hosting Tools team in SQL's Strategy, Infrastructure and Architecture organization.

Last edited Nov 15, 2006 at 4:48 AM by danwinn, version 21

Comments

misksh Apr 15, 2007 at 11:53 PM 
I too have had problems with my "Personal Web Site Starter Kit" created using Visual Web Developer (express edition). When I generate the SQL scripts using the tool and paste them in the Godaddy Query Analyzer, I get an the error "Invalid object name 'sys.foreign_keys'." As a result, no tables or stored procedures are created.

How do you correct this problem?

Thanks,
Ken

jjoepage Feb 6, 2007 at 7:48 AM 

I've created a very new project with a few roles and members. Database Publishing Wizard makes a beautiful script! - but it fails at GoDaddy in the Query Analizer. The following line fails:

/****** Object: Table [dbo].[aspnet_Membership] Script Date: 02/06/2007 09:17:26 ******/
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[aspnet_Membership]
GO

The error message says:
Could not drop object 'dbo.aspnet_Applications' because it is referenced by a FOREIGN KEY constraint.

I am attempting to write to the database template provided and created in the normal set-up process use by GoDaddy for database initiation. I suspect that template has a foreign key in the 'Applications' table that the script did not anticipate. Any ideas? btw, several other lines in the script will cause similar errors. I think I saw it with the 'Rolls' table as well.

ibrabordsen Jan 4, 2007 at 9:43 PM 
sctemp, it's possible you may be running into that issue if you're using .NET 1.1 instead of 2.0. Would you check to see if that's the issue?

sctemp Jan 4, 2007 at 6:54 PM 
Hosting Toolkit doesn't run. IIS 6 is unable to process the web.config. IIS chokes on the configsection
<section requirePermission="false" name="microsoft.sqlserver.hosting.service" type="Microsoft.SqlServer.Hosting.Service.PublishServiceConfiguration"/>

Unrecognized attribute 'requirePermission'.