Hi everybody - it does work!

The problem is that win2003 uses IIS6 new security model. Run the code against the database.

Works!

Thanks a lot.

MJ

Yes, it does.

I'm trying to run this -

exec sp_grantdbaccess 'NT AUTHORITY\NETWORK SERVICE'

exec sp_addsrvrolemember 'NT AUTHORITY\NETWORK SERVICE', 'securityadmin'

exec sp_addsrvrolemember 'NT AUTHORITY\NETWORK SERVICE', 'processadmin'

exec sp_addsrvrolemember 'NT AUTHORITY\NETWORK SERVICE', 'dbcreator'

exec sp_grantlogin 'NT...

Our developers are still running the app from their local machines - SQL server is separated from the application. When I point the app to  win2000 server with "local machine\ASPNET", the...

The error message is :"Login fails for user Nt Autority". In win2000 I use ASPNET login for IIS services localy on the SQL Server. In Win2003 suppose to be NTAutority\Network...

Please, read my initial posting - it said that both servers are running under the same PDC domain admin account, set up the same way on both SQl boxes - what...

Yes, I do not have a great network set up, but I still have to work around, right?

I did try the same copy process from the second SQL server we...

The cause is a very bad network trafic, but as the SQL server runs on NAS and the connections are waiting a lot, there's nothing I could do until somebody realize...

OK, guys! The discussion for me is over - I have a SQL2K Enterprice running on a NAS, Win2003 Storage Server! There's no clustering - NAS is a SQL server itself....

This is not the point at all. I could access everything from within the SQL Server itselt (I mean if I open the EM or QA on the server). The...

I was ready to script all logins and just to run them against the new domain. Could you recommend something easier?

Thanks,

MJ

When you think for RAM, you have to consider also what edition of SQL server you are running and what is the OS (running SQL on Win2000 server is not...

Before the line "Database fragmentation (dbcc showcontig)" you may include "Disk fragmentation" especially if the data drives are not SQL designated. One of my servers is running other very old...

I found the problem - it was the corrupted ini file - no paths inside, just crap...

But I still would like to know if somebody have seen a good...

NT admin said there's nothing changed! And the SQl Server uses the right auth.

My questions is principle:

In situations like this what will be the steps to look at.Like: first-I checked...

It seems I have to work it out with my network guys.

Thanks a lot for all your help. You, guys, are great!