July 27, 2015 at 9:22 am
Hello,
I am trying to import my database to Godaddy's servers. In Microsoft SQL Server Management I generate scripts for my database. I then change the connection to Godaddy's SQL Server. I then execute the script and get the following errors:
Msg 262, Level 14, State 1, Line 2
CREATE DATABASE permission denied in database 'master'.
Msg 911, Level 16, State 4, Line 13
Database 'aspnet-Paintings' does not exist. Make sure that the name is entered correctly.
Msg 5011, Level 14, State 5, Line 16
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 16
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 18
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 18
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 20
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 20
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 22
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 22
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 24
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 24
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 26
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 26
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 28
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 28
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 30
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 30
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 32
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 32
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 34
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 34
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 36
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 36
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 38
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 38
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 40
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 40
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 42
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 42
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 44
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 44
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 46
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 46
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 48
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 48
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 50
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 50
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 52
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 52
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 54
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 54
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 56
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 56
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 58
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 58
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 60
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 60
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 62
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 62
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 64
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 64
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 66
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 66
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 68
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 68
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 70
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 70
ALTER DATABASE statement failed.
Msg 102, Level 15, State 6, Line 72
Incorrect syntax near 'DELAYED_DURABILITY'.
Msg 2714, Level 16, State 6, Line 81
There is already an object named '__MigrationHistory' in the database.
Msg 2714, Level 16, State 6, Line 101
There is already an object named 'AspNetRoles' in the database.
Msg 2714, Level 16, State 6, Line 116
There is already an object named 'AspNetUserClaims' in the database.
Msg 2714, Level 16, State 6, Line 133
There is already an object named 'AspNetUserLogins' in the database.
Msg 2714, Level 16, State 6, Line 151
There is already an object named 'AspNetUserRoles' in the database.
Msg 2714, Level 16, State 6, Line 167
There is already an object named 'AspNetUsers' in the database.
Msg 1913, Level 16, State 1, Line 191
The operation failed because an index or statistics with name 'RoleNameIndex' already exists on table 'dbo.AspNetRoles'.
Msg 1913, Level 16, State 1, Line 200
The operation failed because an index or statistics with name 'IX_UserId' already exists on table 'dbo.AspNetUserClaims'.
Msg 1913, Level 16, State 1, Line 209
The operation failed because an index or statistics with name 'IX_UserId' already exists on table 'dbo.AspNetUserLogins'.
Msg 1913, Level 16, State 1, Line 218
The operation failed because an index or statistics with name 'IX_RoleId' already exists on table 'dbo.AspNetUserRoles'.
Msg 1913, Level 16, State 1, Line 227
The operation failed because an index or statistics with name 'IX_UserId' already exists on table 'dbo.AspNetUserRoles'.
Msg 1913, Level 16, State 1, Line 236
The operation failed because an index or statistics with name 'UserNameIndex' already exists on table 'dbo.AspNetUsers'.
Msg 2714, Level 16, State 5, Line 241
There is already an object named 'FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId' in the database.
Msg 1750, Level 16, State 0, Line 241
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 5, Line 247
There is already an object named 'FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId' in the database.
Msg 1750, Level 16, State 0, Line 247
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 5, Line 253
There is already an object named 'FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId' in the database.
Msg 1750, Level 16, State 0, Line 253
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 5, Line 259
There is already an object named 'FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId' in the database.
Msg 1750, Level 16, State 0, Line 259
Could not create constraint. See previous errors.
Msg 5011, Level 14, State 5, Line 265
User does not have permission to alter database 'aspnet-Paintings', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 265
ALTER DATABASE statement failed.
I don't know how to change permissions on the database. Can anyone please help with these errors?
I have already contacted Godaddy and they state I have the correct permissions on their server.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply