Error on executing script files

jack_hilary · April 12th, 2010, 02:45 PM

Greetings!!
Sir after some searches I found the stored procedures.
But still I wanna know that will it be possible to regenerate the database with different script entirely if yes then how it can be? Well for changing only the particular column or row I know how to do that but for changing the complete schema for existing database what could be done.

Thank you.

Imar · April 12th, 2010, 02:55 PM

You can use SQL Server Management Studio to script your database to SQL Server 2000 format.

Cheers,

Imar

jack_hilary · April 13th, 2010, 08:20 AM

Hello Sir,
Thank you for reply.
Sir as I told in my previous posts that I have now the database of 2005 type on web host's environment and I have successfully executed the schema and I can see all the objects that I had at my local development database.

But now I am stuck in other problem when I am trying to connect to the database for membership purpose (viz. counting no. of online users) then I have the following error.

Code:

The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database <database name>, schema 'dbo'.

Sir is this any security problem or anything else. Sir please guide me in resolving this.
Thank you.

Imar · April 13th, 2010, 08:25 AM

Quote:

is this any security problem or anything else

Yes, it is. The account used by the web site (either a SQL account defined in the connection string) or the web server account (for example Network Service) needs execute permissions.

You need to talk to your host, or look in their documents to see how to resolve this. Appendix B of my book shows how this works when you have full access to SQL Server but I don't know how your host's control panel works.

Cheers,

Imar

BTW: No need to keep calling me Sir..... ;-)

jack_hilary · April 13th, 2010, 08:33 AM

OK , I am trying it myself at first and will try to make it working. If I fail only then I will say you to kindly take look on the problem.
So for the time being I am giving a try(as I remember the security in Appendix B, thanks for that valuable Appendix)
Thank you.

Imar · April 13th, 2010, 08:37 AM

Quote:

If I fail only then I will say you to kindly take look on the problem.

You're better off asking your host in that case. They should know how their system works...

Imar

jack_hilary · April 13th, 2010, 09:00 AM

Hello,
First of all I am walking through the Appendix.
But there on page no. 695 (steps 4 & 5) you suggest to create a new login. But as I am provided information such as server name, database name along with user name and password. Then is it necessary to create the new login in that case (when we are provided user name & password). Can't we set up the security for the given account?
Thank you.

Imar · April 13th, 2010, 09:36 AM

Sure. Once you have an account, you have an account. It doesn't matter if you just created it, or if it was already there.

Just to make sure: you probably can't script the security account when you rescript your database. In other words: you can't create the account locally, script it and then make it work at your host. You probably (but again, I don't know your host well enough) need to use an account supplied by your host, or one created in their control panel.

Cheers,

Imar

jack_hilary · April 13th, 2010, 09:40 AM

Hi,
While walking through the Appendix I encountered the problem. I tried to create new User Account as mentioned on page no. 695 (Steps 4 & 5) but it reports the error as

Code:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Login <login name>  (Microsoft.SqlServer.Express.Smo)

ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
User does not have permission to perform this action. (Microsoft SQL Server, Error: 15247)

On the other hand when I tried to give permissions as mentioned on page no. 696 (step 1 to 3) under provided user name by host provider then it reports error as

Code:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for User <user name>.
(Microsoft.SqlServer.Express.Smo)
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

User, group, or role <user name> already exists in the current database. (Microsoft SQL Server, Error: 15023)

why I am getting this error, and how it can be resolved?

Imar · April 13th, 2010, 09:46 AM

Looks like the account you're using doesn't have the permissions to create other accounts. You need permissions to create accounts, or else someone could just create an account and grant permissions to their own account ;-)

How are you logged in? Where are you executing these actions?

Imar