Home All Groups Group Topic Archive Search About

Login failed for user 'NT AUTHORITYNETWORK SERVICE'

Author
18 Aug 2005 8:06 PM
ninel
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????

Author
18 Aug 2005 10:28 PM
oj
grant login only allows connection to the server. You would still need to
grant access (sp_grantdbaccess) to allow the login/account to access the
data.


--
-oj


Show quote
"ninel" <ngorbu***@onetouchdirect-dot-com.no-spam.invalid> wrote in message
news:iIqdnV0cNqWld5neRVn_vQ@giganews.com...
>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????
>

AddThis Social Bookmark Button