 |
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
 | This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|

April 12th, 2010, 02:45 PM
|
Friend of Wrox
|
|
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
|
|
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.
|

April 12th, 2010, 02:55 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
You can use SQL Server Management Studio to script your database to SQL Server 2000 format.
Cheers,
Imar
|

April 13th, 2010, 08:20 AM
|
Friend of Wrox
|
|
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
|
|
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.
|

April 13th, 2010, 08:25 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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..... ;-)
|

April 13th, 2010, 08:33 AM
|
Friend of Wrox
|
|
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
|
|
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.
Last edited by jack_hilary; April 13th, 2010 at 08:36 AM..
|

April 13th, 2010, 08:37 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|

April 13th, 2010, 09:00 AM
|
Friend of Wrox
|
|
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
|
|
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.
|

April 13th, 2010, 09:36 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|

April 13th, 2010, 09:40 AM
|
Friend of Wrox
|
|
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
|
|
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?
|

April 13th, 2010, 09:46 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
 |