re:
!Cannot open database "pago" requested by the login. The login failed. Login
!failed for user 'XQ4\ASPNET'.
!It works very well with Visual Studio. But after I published the web
!site in a file system folder in my PC using
When you run any app using the Visual Studio Development Server, ASP.NET runs as
MachineName\WindowsLoggedInAccount, in your case, I'll venture that you're running
as Administrator, which would make the account XQ4\Administrator.
When you run any app using IIS, ASP.NET runs as the default account.
In your case, that's XQ4\ASPNET.
When you run the app in the VS internal web server, your login succeeds.
When you run the app in IIS, your login fails...because ASP.NET runs as
a different account...and you're using integrated security in your connection string.
So, your Windows Logged-In Account has permissions to the database, but XQ4\ASPNET doesn't.
Either grant XQ4\ASPNET access permissions to the database, or
change the authentication method for your connection to "mixed"
( instead of Windows only )...and use an ad-hoc SQL login account
to access your database ( that means changing your connection string ).
Juan T. Llibre, asp.net MVP
asp.net faq :
http://asp.net.do/faq/
foros de asp.net, en español :
http://asp.net.do/foros/
======================================
"Agos" <ag**************@fastwebnet.itwrote in message
news:Bs******************@tornado.fastwebnet.it...
>I found the error.
Cannot open database "pago" requested by the login. The login failed. Login failed for user
'XQ4\ASPNET'.
Now I have to find how to solve this :-)
Any help?
Thank you
Agos
"Juan T. Llibre" <no***********@nowhere.comha scritto nel messaggio
news:%2****************@TK2MSFTNGP04.phx.gbl...
>1. Is the SQL Server Express database in the new application's App_Data folder ?
2. Are you detaching/attaching the SQL Server Express database correctly ?
>Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Agos" <ag**************@fastwebnet.itwrote in message
news:Ox*******************@tornado.fastwebnet.it. ..
>>>I published my application in the same file system (different folder) on same PC.
This is the connection string I use
<add name="pagoConnectionString" connectionString="Data Source=.\SQLEXPRESS;Initial
Catalog=pago;Integrated Security=True;User Instance=False"
The database is in folder
C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\Data
My working solution is in D:\WEB\WASP
I published in C:\WEB\WASP
and it also works except than the db WEB forms with gridview
"Juan T. Llibre" <no***********@nowhere.comha scritto nel messaggio
news:%2******************@TK2MSFTNGP02.phx.gbl.. .
Sounds like your connection string needs to be different
at the server where you published your application to.
Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"Agos" <ag**************@fastwebnet.itwrote in message
news:6C******************@tornado.fastwebnet.it ...
>I developed my first web site using Visual studio 2005.
It works very well with Visual Studio. But after I published the web site in a file system
folder in my PC using
the instructions I found in Visual studio help Walkthrough: Publishing a Web Site, I can
navigate the web forms
except the ones with connections (using Gridview, details view) to the database (SQL Server
2005).
>
What didn't I do?
>
Thank you
>
Agos