473,465 Members | 1,489 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Cannot open database from web

I am getting the message below trying to open the SQL 2005 db in
default.aspx.

System.Data.SqlClient.SqlException: Cannot open database "Mydata" requested
by the login. The login failed.
Login failed for user 'MYXP\generic'

The web site is on an XP machine with 2005 Express. I setup a login called
generic on our domain and then put that login and password into the identity
impersonate section of web.config
Is something more than domain user needed to get into the web application?
The web is strictly windows authority. Thanks.

David
Oct 1 '08 #1
3 1349
"David C" <dl*****@lifetimeinc.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
I am getting the message below trying to open the SQL 2005 db in
default.aspx.

System.Data.SqlClient.SqlException: Cannot open database "Mydata"
requested by the login. The login failed.
Login failed for user 'MYXP\generic'

The web site is on an XP machine with 2005 Express. I set up a login
called generic on our domain and then put that login and password into the
identity impersonate section of web.config.
Yes, but did you add a user to the Mydata database and map it to the generic
login?

And then give that user sufficient permissions in the Mydata database?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 1 '08 #2
Mark,
I thought that having "Domain Users" was enough. Am I wrong? Thanks.

David
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:Or*************@TK2MSFTNGP03.phx.gbl...
"David C" <dl*****@lifetimeinc.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>I am getting the message below trying to open the SQL 2005 db in
default.aspx.

System.Data.SqlClient.SqlException: Cannot open database "Mydata"
requested by the login. The login failed.
Login failed for user 'MYXP\generic'

The web site is on an XP machine with 2005 Express. I set up a login
called generic on our domain and then put that login and password into
the identity impersonate section of web.config.

Yes, but did you add a user to the Mydata database and map it to the
generic login?

And then give that user sufficient permissions in the Mydata database?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 2 '08 #3
"David C" <dl*****@lifetimeinc.comwrote in message
news:eu**************@TK2MSFTNGP05.phx.gbl...
>>I am getting the message below trying to open the SQL 2005 db in
default.aspx.

System.Data.SqlClient.SqlException: Cannot open database "Mydata"
requested by the login. The login failed.
Login failed for user 'MYXP\generic'

The web site is on an XP machine with 2005 Express. I set up a login
called generic on our domain and then put that login and password into
the identity impersonate section of web.config.

Yes, but did you add a user to the Mydata database and map it to the
generic login?

And then give that user sufficient permissions in the Mydata database?
Even if you are using Windows authentication, permissions still need to be
set...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 2 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Nand Belani | last post by:
Hi, I have a MS Access 2000 database on the network, it is secured and the mdw file is on the network. The database works for most of the users on the network, but does not open for two of the...
0
by: Mr.KisS | last post by:
Hello. I'm under Windows XP PRO SP1, IIS 5.1 ans SQL SERVER 2005 Express. When i try to open a connexion with : <connectionStrings> <add name="AppCnxStr"...
2
by: Mr.KisS | last post by:
Hello. I'm under Windows XP PRO SP1, IIS 5.1 ans SQL SERVER 2005 Express. When i try to open a connexion with : <connectionStrings> <add name="AppCnxStr"...
10
by: vvenk | last post by:
Hello: When I tried to use an Access database, I get the following exception: Server Error in '/WebGrid' Application....
2
by: Enska | last post by:
I have problems connecting my access database I get information .. I cant use my database and I'm administrator on my computer so permission shutnot bee problem, but I dont know Where is the...
1
by: bennett | last post by:
I'm trying to write an ASPX page that uses an OleDbDataAdapter to get data from a SQL Server database. When I test the connection, it returns success, and when I preview the data using the...
4
by: snow | last post by:
Hi all, I have a VB.net program installed in a xp home with sp2,after installation, get error "Cannot open a database from a previous version of your application. The database is a 97 Access...
1
by: martinbr_2000 | last post by:
I have an access database that has been split and resides in the network share. When the access database is currently being updated by someone, and I try to open the database, I cannot open the...
0
by: namrataa | last post by:
Cannot Open default database. Invalid login for \ -------------------------------------------------------------------------------- Hi, I have written services in WCF using C# and SQL Server...
3
by: Raymond Chiu | last post by:
Dear All, I have posted my question as below. But no answers, hope it can found here. ...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.