Showing posts with label sever. Show all posts
Showing posts with label sever. Show all posts

Wednesday, March 21, 2012

Location of SQL Server Express

Can i put sql sever on my computer and have the db on a mapped drive on our company network?

Mapped Drive -No;

Logical Drive (LUN) -Yes

Does your network have a NAS or SAN? (That would work.) Just mapping to a file server does not.

sql

Monday, February 20, 2012

local / domain account

I'm running as local account, and i would like to run as domain account.
What permissions does the domain account need to run sql sever 2000?
Is their any permissions on the local machine that I should set?Easiest solution is to put the domain-level account in the local
administrators group on the host computer.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:E17282A2-2718-488A-923D-8E11A85018E3@.microsoft.com...
> I'm running as local account, and i would like to run as domain account.
> What permissions does the domain account need to run sql sever 2000?
> Is their any permissions on the local machine that I should set?|||If you don't want to run as an Admin you can put the domain account in the
sysadmins role and use Enterprise Manager to set the account up for the
service. By going through EM, it assigns the needed permissions to the
pertinent registry keys and files.
Christian Smith
"mannie" <anonymous@.discussions.microsoft.com> wrote in message
news:E17282A2-2718-488A-923D-8E11A85018E3@.microsoft.com...
> I'm running as local account, and i would like to run as domain account.
> What permissions does the domain account need to run sql sever 2000?
> Is their any permissions on the local machine that I should set?