Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Permission error - aspnet tables

Author  Topic 

elic05
Yak Posting Veteran

62 Posts

Posted - 2009-01-08 : 10:47:02
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'beeline', schema 'dbo'

I uploaded a site (dotnet) and a DB (MS sql server 2005) to a host.

How can i define permission so I can work with the aspnet schema on the remote server?

I use SSMSE 2005

revdnrdy
Posting Yak Master

220 Posts

Posted - 2009-01-08 : 10:58:25
Ok this worked for me..

To resolve this I had to apply a workaround.. Kudos goes to a friend of mine who supplied this solution & works in a dram factory.

First try to Re-run the aspnet_regsql.exe.
If this does not work then you have to “Add the user to the aspnet_Membership_FullAccess database role.”

-- Here is how to Add a user to database role

USE aspnetdb

GO

sp_addrolemember 'aspnet_Membership_FullAccess', 'Network Service'

“Network Service” is your user name

good luck !

r&r
Go to Top of Page

elic05
Yak Posting Veteran

62 Posts

Posted - 2009-01-08 : 11:12:14
thanks for the quick answer.

I tried 1
and I got


Setup failed.

Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 262 and the SqlException message is: CREATE DATABASE permission denied in database 'master'.
Creating the aspnetdb database...

----------------------------------------
Details of failure
----------------------------------------

SQL Server:
Database: [aspnetdb]
SQL file loaded:
InstallCommon.sql

Commands failed:

DECLARE @dbname nvarchar(128)
DECLARE @dboptions nvarchar(1024)

SET @dboptions = N'/**/'
SET @dbname = N'aspnetdb'

IF (NOT EXISTS (SELECT name
FROM master.dbo.sysdatabases
WHERE name = @dbname))
BEGIN
PRINT 'Creating the ' + @dbname + ' database...'
DECLARE @cmd nvarchar(500)
SET @cmd = 'CREATE DATABASE [' + @dbname + '] ' + @dboptions
EXEC(@cmd)
END


SQL Exception:
System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
Creating the aspnetdb database...
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)






I want to try 2

but I dont know if i have to run it for my local db (login by my comuterName and windows authentification) or to login to the db that i uploaded to the server

Go to Top of Page

revdnrdy
Posting Yak Master

220 Posts

Posted - 2009-01-08 : 11:28:35

Someone with admin access to master can try solution #1 if you can get them to do it.

Otherwise..

Go to the database on the server not the local db would be my guess.

r&r
Go to Top of Page

elic05
Yak Posting Veteran

62 Posts

Posted - 2009-01-08 : 11:47:59
thanks a lot for your patiance and kindness for a new user like me

I talked with the support (of the remote server) and they said the granted the permission for me

Go to Top of Page
   

- Advertisement -