Database Move

I have a web project in VS.NET 2005 on my development computer that uses an ASP.NET database (ASPNETDB.MDF) to manage user roles. Now I would like to move that database to a test computer with IIS. After copying the web project and database I am able to read from it but when I try to update I get the following error:

Failed to update database "C:\INETPUB\WWWROOT\MyWebApp\APP_DATA\ASPNETDB.MDF" because the database is read-only.

I think this is because the user 'Network Service' that IIS uses does not have access to the database. So how do I give 'Network Service' access to the database using SQL commands?

The problem is solved by closing VS.NET 2005 before moving the database and giving the user 'Network Service' full control to the database files.

database management?

Hi to All,
I am working in vb and C# .net as front hand and use mySql or Squel server as back-hand.
task is, i did here it that, we have more than one table, each and every is related by using the concept of Primary and Foreign key management.
in that database if i remove a record from master table, than the related record of all child talbes shall auto-matically reoved that is my question how it does happen.
first thing that you have understood my problem if yes than please if you have any idea, mail me.
i will very much thnks in advance to you.
bye
regards Rajat.Moving to more appropriate forum.|||

In SQL Server you can either implement tzhis using your own logic by triggers or you use the built in automatically working functonality whic is called cascading delete. See more information about this in the Online help of SQL Server:

http://msdn2.microsoft.com/en-us/library/ms186973.aspx

Jens K. Suessmeyer.

-
http://www.sqlserver2005.de
-

Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.

Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.

Database Mail

We have a user set up for our .net framework (webuser) with access to a database we created for our website. "webuser" needs to be able to send out emails using Databse Mail (SQL Server 2005) via a stored proc by excuting msdb.dbo.sp_send_dbmail. This stopred proc works fine when I am logged in as administrator but won't work for "webuser" and I can't seem to grant DatabaseMailUserRole to our that user either. What do I need to do?

I have bee trying to find a "how to" on setting this up but have been unsuccessful.

What do you mean by you can't grant? What errors or problems did you have? Did you add the user to msdb and then add the user to the role?

-Sue

|||Hi,
1.) Goto "Databasemail" under Management,
2.) Click on "Manage Profile Security"
3.) Goto "Private profiles" and select the 'webuser' from the dropdown menu and give access to the profile which webuser should use

or else

you can go to the 'public profile', There you can select a profile which can be used as public users and make this as default profile. And call this profile in webapplication to send mail.

Database logon request

Hi,

I am using CrystalReport from MS Visual Studio .Net. The report was created by the designer. It accesses a MySQL DB by the MyODBC 2.5 driver. Everything works fine on my development machine. I call the form which implements the crystalreportview and the report is displayed. Hoever, if I create an installation and run it on the deployment machine, a dialog is displayed requesting for server name, database, user name and password. Whatever I type in the login fails ("login fails. please retry"). I tried the MyODBC DSN and the MySQL user - without success.

Was anyone facing the same problem? I don't know how to proceed, it is really a strange issue, because the application runs on my development machine...

Thanks in advance.

gbrOkay. Please ignore my posting. I found out that different user accounts were created...