schema.sql - 'zowens' is not a valid login.

Topics: Developer Discussion, Help, Request
May 17, 2007 at 1:44 AM
ran schema.sql (ultimahosts)

Msg 15007, Level 16, State 1, Line 42
'zowens' is not a valid login or you do not have permission.
Msg 15151, Level 16, State 1, Line 1
Cannot find the user 'zowens', because it does not exist or you do not have permission.
Msg 2759, Level 16, State 0, Line 1
CREATE SCHEMA failed due to previous errors.

In case you havent figured it out, this is my first ASP.NET(sql) configuration.
May 17, 2007 at 6:06 AM
Why would this be in a schema script?

If you use ultimahosts please post how you published. I would greatly appreciate admin access to my web site.

May 19, 2007 at 9:36 PM
Hmmm... these are generated using SQL SMO... this shouldn't be an issue.

Have you used SQL Publishing wizard before? That will generate scripts for you.

Ultima gives you access to EVERYTHING. You can access the dbs through SQL Management and they also allow full trust applications.