using dts to create .txt file on a different server

Question

Post reply

using dts to create .txt file on a different server

kent schultz

SSC Enthusiast

Points: 125
More actions
October 10, 2005 at 3:04 pm

#66709

I want to use dts to create a text file on a different server. It creates it on my sql server but I am not authorized to created it on a different server. What/who do I have to give rights to on my other server? This is my first project with activex and dts.
Thanks

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

philcart SSC-Forever Points: 47797 More actions · Answer 1

Create a share on the other server and then give the SQL service account read/write access to that share.

--------------------
Colt 45 - the original point and click interface

kent schultz SSC Enthusiast Points: 125 More actions · Answer 2

That works when I execute the DTS, but when I set it up as a job, it fails.

How do I get sql service account to show up in Active Directory?

Thanks

philcart SSC-Forever Points: 47797 More actions · Answer 3

What account are you running the SQL Services under?

--------------------
Colt 45 - the original point and click interface

kent schultz SSC Enthusiast Points: 125 More actions · Answer 4

I don't know what you mean by "what account is sql under".

Are you referring to Active Directory?

philcart SSC-Forever Points: 47797 More actions · Answer 5

You have two SQL Services MSSQLServer and SQLServerAgent, each of these runs under an account you specify when you install SQL Server.

Check "Services" in the Administration Tools folder.

--------------------
Colt 45 - the original point and click interface

kent schultz SSC Enthusiast Points: 125 More actions · Answer 6

It is MSSQLServer and the logon is checked to user the "local system account"

philcart SSC-Forever Points: 47797 More actions · Answer 7

Ok, when the services run under the local system account they have no authentication for network resources. You'll need to change this, and the SQLServerAgent account, to an Active Directory account. Best to use a Domain User account that is specifically setup for SQL Server.

Also, make the account a Local Administrator on the SQL Server. You can run it with normal user privelages, but then you'll have limited functionality within SQL itself and you'll need to specifically assign some extra privelages. Much better to make the account a local admin and lock down the security at domain level.

--------------------
Colt 45 - the original point and click interface

kent schultz SSC Enthusiast Points: 125 More actions · Answer 8

Hello again,

I tried to set it to Administrator, but when I go to start the service, it will not start.

philcart SSC-Forever Points: 47797 More actions · Answer 9

What is the error you're getting? Is there anything in the Event log?

--------------------
Colt 45 - the original point and click interface

kent schultz SSC Enthusiast Points: 125 More actions · Answer 10

error 1069: the service could not start due to logon failure.

kent schultz SSC Enthusiast Points: 125 More actions · Answer 11

Nothing in the event log pertaining to the error. Only when the service is started successfully when I switch back to the system account. I am only changing the logon account in Services, do I have to do anything in Enterprise Manager?

kent schultz SSC Enthusiast Points: 125 More actions · Answer 12

Do you have anymore ideas for me?

Sorry for being a bug!