Re: No db access after publishing web site

Thank you Juan,
after lots of try it seems I succseded!
here's what I did using the graphical tool of Sql server 2005:
USE [pago]
GO
CREATE USER [ASPNET] FOR LOGIN [XQ4\ASPNET]
GO

GRANT UPDATE TO [ASPNET]
GRANT SELECT TO [ASPNET]
GRANT INSERT TO [ASPNET]
GRANT EXECUTE TO [ASPNET]
GRANT CONNECT TO [ASPNET]

Maybe I could do better or in another way or maybe I did too much ......
Now this was just a try on my PC.
If I detach and attach this database on a different PC (according that PC
has the same name XP4) can I and my collegues from their own PC connect to
this WEB in an intranet environment?

Thank you

Agos



"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> ha scritto nel messaggio
news:uOzN9VpqHHA.3356@xxxxxxxxxxxxxxxxxxxxxxx
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" <agostino.guberti@xxxxxxxxxxxxx> wrote in message
news:Bswai.14777$BU3.4999@xxxxxxxxxxxxxxxxxxxxxxxx
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" <nomailreplies@xxxxxxxxxxx> ha scritto nel messaggio
news:%23BqS$ehqHHA.4420@xxxxxxxxxxxxxxxxxxxxxxx
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" <agostino.guberti@xxxxxxxxxxxxx> wrote in message
news:Oxjai.14263$BU3.11885@xxxxxxxxxxxxxxxxxxxxxxxx
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" <nomailreplies@xxxxxxxxxxx> ha scritto nel messaggio
news:%23R7L%23zgqHHA.3456@xxxxxxxxxxxxxxxxxxxxxxx
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" <agostino.guberti@xxxxxxxxxxxxx> wrote in message
news:6Ciai.14217$BU3.3863@xxxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Simple SQL Security Question From SQL Newbie
    ... >exec sp_grantdbaccess 'WIN2K\ASPNET' ... >VS.NET, I can use the server explorer and I can see the database, it's ... >login 'WebCalendar'. ... I also did a GRANT ALL on y2003 TO ASPNET ...
    (microsoft.public.sqlserver.security)