Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Login failed for user 'NT AUTHORITY\NETWORK SERVIC

Author  Topic 

ninel
Posting Yak Master

141 Posts

Posted - 2005-08-18 : 15:49:46
I am trying to execute a DTS package from vb.net.
On my local machine I had no issues, but as soon as I uploaded to my company's server I received the following error "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'".

I searched on google and found someone's solution:
I executed this statement: exec sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'

I don't receive the 'NT AUTHORITY\NETWORK SERVICE' error anymore, but now get this error: "Cannot open database requested in login 'timeControl'. Login fails."

Does anyone have any ideas????
   

- Advertisement -