SQLTeam.com | Weblogs | Forums

Errors running script


#1

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 15048, Level 16, State 1, Line 9

Valid values of the database compatibility level are 90, 100, or 110.

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?


#2

Your very first statement - "CREATE DATABASE" is failing with a "Permission Denied" message. It could be a permissions issue, or it could be because of the next error message - which says the compatibility level has to be 90, 100, or 110. That is SQL 2005, 2008 or 2012. Look in the script that you created to see if it specifies a compatibility level lower than 90 or higher than 110. If it does, you will need to fix that.

If it is a permissions issue, consult Godaddy.


#3

Thanks,

I set the compatibility to 110 and this got rid of some errors. I have already contacted godaddy and they state I have the necessary permissions on their server. Can anyone provide anymore help? I am still getting the following errors:

Msg 262, Level 14, State 1, Line 2
CREATE DATABASE permission denied in database 'master'.
Msg 5011, Level 14, State 5, Line 9
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 9
ALTER DATABASE statement failed.
Msg 911, Level 16, State 4, Line 13
Database 'aspnet-WingtipToys' 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-WingtipToys', 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.


#4

After you get the error, Run

EXEC sp_who2

Look for the database in the list. It's possible that a connection was not terminated. If you find any connections to the database, Run

KILL SPID

where SPID is the SPID for the sessions that are connected to the database.

Try your script after all connections to the database are removed.


#5

From what? If it was less than 90 then it implies to me that the Script is designed to run on very old, outdated, versions of SQL.

What is the statement at the beginning of the script which results in this error?

CREATE DATABASE permission denied in database 'master'.

Perhaps there are reserved words in the database name, or something else, which is causing SQL to generate a Permissions error when in fact the error is something else.

From later messages it looks the database name is "aspnet-Paintings" - the Hyphen is going to cause all sorts of grief if the database names are not being properly escaped by GoDaddy's script ...


#6

Thanks. When I run KILL spid I get:

Msg 6102, Level 14, State 1, Line 1
User does not have permission to use the KILL statement.

I am running SSMS as administrator.

The compatibility was 120 and I set it to 110.

The first statement of my script is:

CREATE DATABASE [aspnet-Paintings]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'aspnet-Paintings', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\aspnet-Paintings.mdf' , SIZE = 3264KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'aspnet-Paintings_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\aspnet-Paintings_log.ldf' , SIZE = 832KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO


#7

More likely than not, the path of your physical files is not what GoDaddy expects. Your script tries to create the files in 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\ which is the default location when you install SQL 2012 Express. But GoDaddy may want you to store your files in a different location. Send them the create statement you posted and ask them where the physical files should be located.


#8

[quote="loriha, post:3, topic:2420"]
CREATE DATABASE permission denied in database 'master'.
[/quote] You are trying to create in your database and not master? (USE databasename;)


#9

Your script was generated for SQL Server 2014 (Compatibility Level 120) so it may well contain statements incompatible / more modern than the SQL Server 2012 (Compatibility Level 110) that you are trying to run it on

"CONTAINMENT = NONE" was introduced in SQL 2012, and is not compatible with the previous version SQL 2008 R2 ... there may well be plenty more subtle differences like that in the script. If you can re-generate the script for backward compatibility to the version you are actually deploying onto I think that might save some hassle over any other Gotchas like that.

But all that said I can't see why you are getting

CREATE DATABASE permission denied in database 'master'.

I agree that "C:\Program Files" is a rubbish location for a database, and it could well be that Go Daddy doesn't allow that, but if that is actually the cause then the error message is rubbish and gives no useful clue as to what the underlying problem is.

I don't think you have enough permissions to create the database. Perhaps you are logged on as a user with lowly permissions (and perhaps Go Daddy has an alternative, higher permission, login that is available to you ...)

SELECT user_name()

will confirm your actual login

You could, then, try:

USE master;
EXECUTE sp_addsrvrolemember @loginame = N'YourUserLogin', @rolename = N'dbcreator';

but I suspect that if you have permission to elevate your permissions then you wouldn't get the error in the first place :).

You can try to check whether you have the necessary role:

SELECT IS_SRVROLEMEMBER('public', 'N'YourUserLogin')

that should return 1 ... if it returns NULL it presumably means that you do not have permissions to use IS_SRVROLEMEMBER() ...

If that does return 1 then you could try:

SELECT IS_SRVROLEMEMBER('dbcreator', 'N'YourUserLogin')

to see if you have Database Create Permission. If not then I suggest you speak to Go Daddy, because that would indicate, to me, that contrary to what they told you that you don't actually have database create permission. Not with that login, anyway.


#10

Thanks. SELECT IS_SRVROLEMEMBER('public', N'YourUserLogin') returns NULL


#11

Did the SELECT USERNAME() return what you expected?


#12

SELECT user_name() returns loriha which is my username.


#13

Another thought. Try to run a simple script to create a test database with no options at all.

CREATE DATABASE MyTestDatabase;

That should succeed on any version of SQL Server, as long as you have the right permissions. If that fails, ask GoDaddy to take it up and help you. If that does succeed, add additional options in your create statement and see where it fails.

When you are done with testing, you can remove the test database using

DROP DATABASE MyTestDatabase;

#14

You did change "YourUserLogin" to your actual login, right?