Error on executing script files

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

I am using Management studio and using the credentials provided by host providers to login into the server. And I am following the steps given in appendix but I got the errors as I mentioned in last post.
Now what should I do to proceed???

jack_hilary · April 13th, 2010, 12:39 PM

Hello,
I am using Management studio and using the credentials provided by host providers to login into the server. And I am following the steps given in appendix but I got the errors as I mentioned in last post.
Now what should I do to proceed???

Also when I executed the schema then it was successfully executed. My database on local server contained the Diagram also in database diagrams folder so they must also be there in the production database. But when I click on this folder in production database then it throws an error which says that

Code:

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

A member of the db_owner role must use the database diagramming functionality in order to setup the required database diagramming objects on the SQL Server.

is it any other kind of problem or it will affect the functionality. If this is also a problem then what is the process to resolve it.
Thank you.

Imar · April 13th, 2010, 01:32 PM

Three words: Ask Your Host.

Like I said, it looks like your account doesn't have the permissions to do what you're doing. You can posts messages here in this board for ever, but only your host can tell you what to do, where and how, whether it's something they support and whether or not you can this yourself or have to let them do it.

If you want to understand why you're getting these error messages, paste them, enclosed in quotes, in a Google window. Nine out of ten times you get blogs or forum posts describing the problem in detail.

It's not that I don't want to help you, but it just doesn't make sense to try while your host can do this for you in minutes (or at least most hosts can).

Cheers.

Imar

jack_hilary · April 16th, 2010, 11:14 AM

Hello,
I talked my host provider and they have set the permissions for me. Although when I see the roles under security then I don't see any check box checked for those which start with "aspnet_", but I do not get the EXECUTE permission is required also.

But when I run the page then I get now the following error.

Code:

The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'.  However, the current database schema is not compatible with this version.  You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

I have generated the script from within visual studio 2008 for MS SQL 2005.
why I am getting this error now and how it can be recovered it?

Imar · April 16th, 2010, 11:21 AM

Google is your friend: http://www.google.com/#hl=en&source=...10401dfb0a78c2

Imar

jack_hilary · April 16th, 2010, 11:55 AM

hi, I looked at different posts. All suggest to use the aspnet_regsql.exe tool as the solution, but I have 2 ques. that You might also had fallen in the same issue when working with aspnet tables, did you sir?
and second is that if i use the tool and generate the schema then would it be possible to add the more tables and stored procedures in the same database?

Thank you

Imar · April 16th, 2010, 12:35 PM

Take a look at the first hit from the list of search results on Google: http://forums.asp.net/p/985097/1267872.aspx

I think your schema is fine, but the tables are missing the data.....

Imar

jack_hilary · April 16th, 2010, 12:39 PM

what you think, can it be generated manually and if yes then how the values and column can be added manually???
I think this is the last issue with my data base, so please help me as you have been doing since my joining of the forum
Many thanks

Imar · April 16th, 2010, 12:41 PM

Sure. Just look at the post I referred to and enter that data into your table manually. You probably need your hosts control panel to enter the data somehow.

Why don't you try it out instead of asking if it works? Then you know if it works right away.

Imar

jack_hilary · April 19th, 2010, 12:38 AM

Hello,
Finally they provided me databases of 2005 types and I tested it, it was working.
But now I am trying to set the email account of type info@<domain name>
However in web.config file I have been using my gmail account for email purpose, like this

Code:

<appSettings>
        <add key="MailFromAddress" value="me@myprovider.com"/>
        <add key="MailToAddress" value="me@myprovider.com"/>
</appSettings>

And

Code:

<smtp from="Jack &lt;me@provider.com&gt;" deliveryMethod="Network">
      <network host="smtp.gmail.com" userName="me" password="<password>" port="587"/>
</smtp>

And it works fine in production environment also but when I replace it with email Id like info@<domain name> and relative info (password and smtp server) then I do not receive any email.
They provided me information
POP server: pop32r.cp.365techsupport.com (incoming server)
IMAP server: imap3r.cp.365techsupport.com (incoming server)
SMTP server: smtp1r.cp.365techsupport.com (outgoing server)

Sir, how I can set up emails with so many servers????
Thank you.