MSSQLServer Service Account

Hi,
We have an automated process which imports a file from a
remote server. Unfortunately this requires the
MSSQLServer service to be running under a domain account
in order to be able to access the remote server. I have
been unable to get SQL Server to start with anything other
than Domain Admin rights.
Do you know what rights are required for the MSSQLServer
service to run?
Thanks,
Phil.Hi,
Requirements for Domain User Account
All domain user accounts must have permission to:
Access and change the SQL Server directory (\Program Files\Microsoft SQL
Server\Mssql).
Access and change the .mdf, .ndf, and .ldf database files.
Log on as a service.
Read and write registry keys at and under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MS
SQLServer.
-or- for any named instance service:
HKEY_LOCAL_MACHINE\Software\Microsoft\Mi
crosoft SQL Server.
HKEY_LOCAL_MACHINE\System\CurrentControl
set\Services\MSSQLServer.
-or- for any named instance:
HKEY_LOCAL_MACHINE\System\CurrentControl
set\Services\MSSQL$Instancename.
HKEY_LOCAL_MACHINE\Software\Microsoft\Wi
ndows NT\CurrentVersion\Perflib.
In addition, a domain user account must be able to read and write
corresponding registry keys for these services: SQLAgent$InstanceName,
MSSearch, and MSDTC.
SQL Server startup user should be:-
Member of local Power Users or local Administrators group
SQL Server Agent should be :-
Member of the Administrators local group
Create CmdExec and ActiveScript jobs belonging to someone other than a SQL
Server administrator.
Thanks
Hari
MCDBA
"Phil" <anonymous@.discussions.microsoft.com> wrote in message
news:2273a01c45cfd$6a7f85c0$a001280a@.phx
.gbl...
> Hi,
> We have an automated process which imports a file from a
> remote server. Unfortunately this requires the
> MSSQLServer service to be running under a domain account
> in order to be able to access the remote server. I have
> been unable to get SQL Server to start with anything other
> than Domain Admin rights.
> Do you know what rights are required for the MSSQLServer
> service to run?
> Thanks,
> Phil.|||If you change the service accounts using Enterprise Manager,
the rights and permissions are handled for you. Otherwise
you need to manage these manually and follow this article:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
-Sue
On Mon, 28 Jun 2004 03:48:15 -0700, "Phil"
<anonymous@.discussions.microsoft.com> wrote:

>Hi,
>We have an automated process which imports a file from a
>remote server. Unfortunately this requires the
>MSSQLServer service to be running under a domain account
>in order to be able to access the remote server. I have
>been unable to get SQL Server to start with anything other
>than Domain Admin rights.
>Do you know what rights are required for the MSSQLServer
>service to run?
>Thanks,
>Phil.

MSSQL Questions - Images and Frontpage integration

I'm currently a computer networking student, and a semester long project this year requires us to build an online store using IIS6 and MSSQL. I have run into a dead end in this project and cannot find information or documentation that answers my questions.

So as follows.

How do I store an image in the MSSQL database, preferably through a frontpage-created form with upload boxes?


I am working with forms that I create in Frontpage (a requirement of the course) to add entries to the database. Working with just text boxes and text areas I have had much success with this, but I cannot figure out, when using upload boxes, how to direct the file uploaded to be stored in the database instead of a folder on the local machine (I have associated these upload boxes with the image and thumbnail fields on the appropriate table, with no success)

How do I use dropdown boxes to limit the number of selections on a backend form which inserts data into the SQL database but pulls it's selections from the SQL database instead of generating list entries myself.


Currently my attempts have been to insert into the form a database results entry which pulls the data from appropriate tables, lists by name, but uses the associated numerical key to store the data, with no success)

These issues have been driving me crazy and with 4 weeks left before it's due, I'm pulling my hair out trying to figure it out.

Thanks in advance for any help you can give, if I've not been 100% clear with my explanations, please contact me and I will clarify to the best of my ability.

~Ryan F. Bracy "Angel"1. If I find my old code I will share it with you. The thing is pictures are not stored in SQL serve even thou it is possible as binary. It puts strain on a server and works terribly. What usually is done picture is stored on sharable server drive not on local machine and full path to that picture is stored in a database.

2. I need more information on table definitions and code you use.

I think I saw these questions before but you keep changing your nick and I am not sure if it is the same person.

Irina.|||By the way, how did you put picture next to your nick here?
I don't see how to do it... :)|||

Quote:

Originally Posted by iburyak

I think I saw these questions before but you keep changing your nick and I am not sure if it is the same person.
Irina.

This is my first time ever posting here.

and I will try to remember to post the code we're using presently.

Today our professor decided that we need to use all ASP to make the site, as frontpage doesn't have the capabilities to do what he wants us to do...with 3 1/2 weeks left before the project is due, and now he tells us that we have to learn ASP and code our whole site with it. When I suggested ASP from the beginning and was shot down...|||

Quote:

Originally Posted by iburyak

By the way, how did you put picture next to your nick here?
I don't see how to do it... :)

it's under the control panel, under edit avatar...|||I did find code how to convert picture into a binary stream. But I am sure if you'll see complexity of it you will change your mind to use it... :)

Suggest your professor to FTP picture to the server and save it their as I originally suggested on server side and save full path to the picture in a database.

If you still want code I found - send me private message with your direct e-mail.
I am not going to post this code on forum.

Thank you.

P.S. Is it possible that your professor was asking the same thing on forum here? :)|||

Quote:

Originally Posted by Ryan F Bracy

it's under the control panel, under edit avatar...

Thank you... :)