login failed

I know this is probably a question that has been answered a million times, but it is in regard to SQLEXPRESS. I have built a small ASP 2.0 web app that runs fine on the local production machine when I go to view a gridview or a detailsview to delete or add records. However, when I try the site out on another machine, it runs fine (logins, etc), however when I go to the data page I get an error stating that the login failed for the ASPNET account.

In SQLEXPRESS, where do I set the permission for the ASPNET account, or how do I go about handling this?

Thanks for the information.

BradJust some other information as I have not yet found an answer to this problem - I am using SQLEXPRESS (as stated in the prior post) and IIS 5.1 for other tables. I can using the login controls just fine. I can add users, etc. I created a new database in SQLEXPRESS and it is the tables to this database that I am having a problem with.

Thanks for the help.

Brad|||Okay, the only Express Manager and grant dbo rights to ASPNET. If there is a better way for this, please let me know because I don't know if it is safe to give those rights to this account.

Brad|||Are remote connections enabled for SQL Express? Can you connect remotely at all? You can check if remote connections are enabled using the Surface Area Configuration tool.

What is the login failure error message in the SQL Express error log?

What is the version of SQL Express that you are using?

Thanks
Laurentiu

Logical Tables in Trigger?

Hi,
What are the Logical Tables in triggers?
Is there anything like that is available?
Please help me in this regard.
Thanks,
ShhyamWHile you are in a trigger you have access to 2 tables, named inserted and
deleted. They are read-only and have the same structure as the table the
trigger is based on.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:9F7FB9AF-6953-426C-9142-3F3BBEC61899@.microsoft.com...
> Hi,
> What are the Logical Tables in triggers?
> Is there anything like that is available?
> Please help me in this regard.
> Thanks,
> Shhyam|||Hi Wayne,
I get your point,but it would be helpful for me,if you can provide more
details on this.Any Url/helpfile would be apperciated.
Regards,
shyam
"Wayne Snyder" wrote:
> WHile you are in a trigger you have access to 2 tables, named inserted and
> deleted. They are read-only and have the same structure as the table the
> trigger is based on.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:9F7FB9AF-6953-426C-9142-3F3BBEC61899@.microsoft.com...
> > Hi,
> >
> > What are the Logical Tables in triggers?
> > Is there anything like that is available?
> > Please help me in this regard.
> >
> > Thanks,
> > Shhyam
>
>|||Hi Shyam
The best helpfile is SQL Server's own documentation. Look up CREATE TRIGGER
in the Books Online and that should get you started, as there are quite a
few examples under that topic.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:D95816D6-2BED-4E95-ADE2-B4AC3E6EF753@.microsoft.com...
> Hi Wayne,
> I get your point,but it would be helpful for me,if you can provide more
> details on this.Any Url/helpfile would be apperciated.
> Regards,
> shyam
> "Wayne Snyder" wrote:
>> WHile you are in a trigger you have access to 2 tables, named inserted
>> and
>> deleted. They are read-only and have the same structure as the table the
>> trigger is based on.
>> --
>> Wayne Snyder, MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> www.mariner-usa.com
>> (Please respond only to the newsgroups.)
>> I support the Professional Association of SQL Server (PASS) and it's
>> community of SQL Server professionals.
>> www.sqlpass.org
>> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
>> news:9F7FB9AF-6953-426C-9142-3F3BBEC61899@.microsoft.com...
>> > Hi,
>> >
>> > What are the Logical Tables in triggers?
>> > Is there anything like that is available?
>> > Please help me in this regard.
>> >
>> > Thanks,
>> > Shhyam
>>|||Thanks all for the quick help.
Regards,
shyam
"Kalen Delaney" wrote:
> Hi Shyam
> The best helpfile is SQL Server's own documentation. Look up CREATE TRIGGER
> in the Books Online and that should get you started, as there are quite a
> few examples under that topic.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:D95816D6-2BED-4E95-ADE2-B4AC3E6EF753@.microsoft.com...
> > Hi Wayne,
> >
> > I get your point,but it would be helpful for me,if you can provide more
> > details on this.Any Url/helpfile would be apperciated.
> > Regards,
> > shyam
> >
> > "Wayne Snyder" wrote:
> >
> >> WHile you are in a trigger you have access to 2 tables, named inserted
> >> and
> >> deleted. They are read-only and have the same structure as the table the
> >> trigger is based on.
> >>
> >> --
> >> Wayne Snyder, MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >> www.mariner-usa.com
> >> (Please respond only to the newsgroups.)
> >>
> >> I support the Professional Association of SQL Server (PASS) and it's
> >> community of SQL Server professionals.
> >> www.sqlpass.org
> >>
> >> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> >> news:9F7FB9AF-6953-426C-9142-3F3BBEC61899@.microsoft.com...
> >> > Hi,
> >> >
> >> > What are the Logical Tables in triggers?
> >> > Is there anything like that is available?
> >> > Please help me in this regard.
> >> >
> >> > Thanks,
> >> > Shhyam
> >>
> >>
> >>
>
>

Logging of Schema changes

Is there a way to log any schema changes on databases(Eg change in datatype in a database) and who made the change
Regard
JonasHi,
There is no functinality build in to audit schema changes in SQL Server. But
you could try the free utility by Lumigent. (utility is "Lumigent Schema
Alert")
Download and test it from :
http://www.lumigent.com/downloads/schemaalert/
Thanks
Hari
MCDBA
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:ECD9EE38-ACC0-4899-92A1-34CAB7BEFDE8@.microsoft.com...
> Is there a way to log any schema changes on databases(Eg change in
datatype in a database) and who made the change?
> Regards
> Jonas|||also check out www.dbghost.com for database configuration and change management.