Either the user, IIS APPPOOL\DefaultAppPool, does not have access to the PDW test database, or the d

Any Ideas on how to fix this issue?

Visual Studio 2005, Windows 7 64bit, SQL Server 2005 Express

Cannot open database "sql2" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\DefaultAppPool'. 

We have a user "Customer" with access to an "Interface" database which needs to execute a stored procedure in an engineering database.  The "Customer" user does not exist in the engineering database.

Our group was able to run the scripts in the "Cross-Database Access" section of the excellent article at http://www.sommarskog.se/grantperm.html.  However, when we try these same steps with our databases, we get "The server principal Customer is not able to access the database Engineering under the current security context."

Is there some sort of database setting on either the Engineering or Interface database that we need to check?  Scripts are shown here.

First, to create the procedure in the Interface database:

USE Interface
GO
IF EXISTS (SELECT * FROM [sys].[objects] WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[usp_GetData]') AND OBJECTPROPERTY(OBJECT_ID, N'IsProcedure') = 1)
 DROP PROCEDURE [dbo].[usp_GetData]
GO
CREATE PROCEDURE usp_GetData
 @bTestFlagsOnly BIT = 0
 ,@vLogin VARCHAR(256) = ''
AS
SET NOCOUNT ON
DECLARE @iResult INT
EXEC @iResult = [Engineering].[dbo].[usp_GetData]
 @bTestFlagsOnly = @bTestFlagsOnly
 ,@vLogin = @vLogin
RETURN @iResult
SET NOCOUNT OFF
GO

GRANT ALTER ON [dbo].[usp_GetData] TO [Engineer]
GRANT CONT

hello.. i'm a bit stuck with my project and i hope anyone out there could lend a hand.. im completely new to asp.net so please bear with me.. =)

i have a table in ms access where i have username, password and usertype.. i wanted to use that table so that when i log in, the user with the "admin" usertype will go to the admin page while the user with the "user" usertype will go to the members page.. i can log in so the only issue is how to redirect them to their respective pages.. any help would be appreciated.. =)

Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 

Thanks in advance for your help,

Laura

Hi.,

I created a new database with the help of Database Configuration Assistant !

I created with the scott account

Now i'm not able to connect to the database with the connect identifier with the scott account

The error i get is.,

Plz help !

In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.

Bob Beauchemin

MSDN Magazine August 2009

Jamie Laflen extols the benefits of TDD when applied to database development-and supplies some useful techniques along the way.

Jamie Laflen

MSDN Magazine Launch 2008

Using Microsoft technologies, you can insert, edit, query, and delete database entries using any e-mail client such as Hotmail, Outlook, Yahoo, or even WAP phone. While e-mail is certainly a powerful and widely used tool, it is usually not integrated with an application for performing any tasks other than sending reminders. The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.

Alok Mehta and Daniel Williams

MSDN Magazine January 2002

What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

Michael McManus

MSDN Magazine June 2000

actually i came across this senario for new project where userstatus must change to log off when ever he do fallowing activity.I have maintain user status when he log in to web based system.

Activities are

if

1.user click log off

2.or user click browser close button or close brwoser tab.

3.or Fource fully shut down his Pc

I am able to get first 2 but not the last one.I googled it but not get any satified ans for that.

I m looking for guidens for this. Any help is grate help for me as i want it.And also other suggesstion also welcomed.

thanks in advance

Deeno

Pre- .Net Framework 4.0 supported using Oracle.DataAccess.Client, using Oracle.DataAccess.Types, System.Data.OracleClient, OracleDataReader, OracleConnection. What are the equivalents in .Net Framework 4.0? Does it require any download?

Thank you.

Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.

Regards, thanks for help.