|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Login failed for user 'NT AUTHORITYNETWORK SERVICE'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????
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. -- Show quote-oj "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???? > |
|||||||||||||||||||||||