error in sql

Sir,
I encounter the error page when tried to display the
data from northwind database in a datagrid in aspx
application. The error page I get is as follows:
server error in '/myview' application
Login failed for user 'NT Authority\Network Service'
Exception details :System.Data.SqlClient.SqlException:
Login failed for user 'NT Authority\Network Service'
Please give a good solution for this.
I'm using sql server 2000 in .net 2003 serverThe most complete resource on securing asp.net when working with SQL
Server is the best practices whitepaper, which you can download at
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047. It
sounds like you have system instead of machine specified as the
processmodel element (a security no-no). Open the Machine.config file
in Notepad and change the userName attribute to MACHINE. Save and then
enable the ASPNET account in SQL Server and grant it membership in any
roles you need.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Tue, 13 Jan 2004 03:50:11 -0800, "ramadevi"
<anonymous@.discussions.microsoft.com> wrote:
>Sir,
> I encounter the error page when tried to display the
>data from northwind database in a datagrid in aspx
>application. The error page I get is as follows:
> server error in '/myview' application
> Login failed for user 'NT Authority\Network Service'
>Exception details :System.Data.SqlClient.SqlException:
> Login failed for user 'NT Authority\Network Service'
>
>Please give a good solution for this.
> I'm using sql server 2000 in .net 2003 server

error in sql

Sir,
I encounter the error page when tried to display the
data from northwind database in a datagrid in aspx
application. The error page I get is as follows:
server error in '/myview' application
Login failed for user 'NT Authority\Network Service'
Exception details :System.Data.SqlClient.SqlException:
Login failed for user 'NT Authority\Network Service'
Please give a good solution for this.
I'm using sql server 2000 in .net 2003 serverThe most complete resource on securing asp.net when working with SQL
Server is the best practices whitepaper, which you can download at
http://www.microsoft.com/downloads/...eleaseID=44047. It
sounds like you have system instead of machine specified as the
processmodel element (a security no-no). Open the Machine.config file
in Notepad and change the userName attribute to MACHINE. Save and then
enable the ASPNET account in SQL Server and grant it membership in any
roles you need.
-- Mary
MCW Technologies
http://www.mcwtech.com
On Tue, 13 Jan 2004 03:50:11 -0800, "ramadevi"
<anonymous@.discussions.microsoft.com> wrote:

quote:

---

>Sir,
> I encounter the error page when tried to display the
>data from northwind database in a datagrid in aspx
>application. The error page I get is as follows:
> server error in '/myview' application
> Login failed for user 'NT Authority\Network Service'
>Exception details :System.Data.SqlClient.SqlException:
> Login failed for user 'NT Authority\Network Service'
>
>Please give a good solution for this.
> I'm using sql server 2000 in .net 2003 server

---

Error in restoring database

Hi!
I would like to ask for help regarding the error message
that I always encounter when I'm trying to restore a
database:
ODBC SQLState: 42000
The database you are attempting to restore was backed up
under a diffferent sort order ID (205) than the one
currently running on this server (52), and at least one of
them is a non-binary sort order. Backup or restore
operation terminating abnormally.
Any ideas on how to solve to problem?
Thanks!
Best Regards,
JunYes, restore to SQL 2000 instead of SQL 7. SQL 7 can only restore databases
in the same sort order as SQL was installed in (run sp_helpsort to figure
this out). SQL 2000 can handle multiple collations. You can then transfer
the SQL 2000 database elsewhere.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Jun" <junpena@.chinasystems.com> wrote in message
news:10d501c3c6da$0aad5e10$a501280a@.phx.gbl...

quote:

---

> Hi!
> I would like to ask for help regarding the error message
> that I always encounter when I'm trying to restore a
> database:
> ODBC SQLState: 42000
> The database you are attempting to restore was backed up
> under a diffferent sort order ID (205) than the one
> currently running on this server (52), and at least one of
> them is a non-binary sort order. Backup or restore
> operation terminating abnormally.
> Any ideas on how to solve to problem?
> Thanks!
> Best Regards,
> Jun

---

Error importing SSIS packages on SQL Management Studio

I encounter this error when importing SSIS packages using SQL Server Management Studio:

===================================

Unable to cast object of type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction' to type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ISimpleAction'. (Microsoft.SqlServer.DtsObjectExplorerUI)

Program Location:

at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)

The Integration Services that I'm using has just been rebuilt due to problems after installing SP2. I'm using Integration Services 9.0.3042. I can't find anything having this same problem. Any help will be appreciated.

Thanks!

Hi ya,

Try these posts. If that doesn't help then best bet is to report it to MS.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=335181&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=406974&SiteID=1

Cheers

Rizwan