Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 2005 install in domain environment...

Author  Topic 

bla4free
Starting Member

10 Posts

Posted - 2008-09-30 : 20:45:41
I was searching for this and couldn't really find what I was looking for. What exactly do I need to do to install the 2005 version in a domain environment? I would like the service to run on a domain account. I tried looking for some tutorials; but, I couldn't find much. I just want to make a secure installation. Thanks for any help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-30 : 20:46:36
In the installation, you can choose to login with a domain account for the services. Other than that, there's nothing different if it weren't on a domain.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

bla4free
Starting Member

10 Posts

Posted - 2008-09-30 : 20:48:43
Do I need to give the SQL Server user any special permission, group permission, OU permissions or anything?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-30 : 20:51:28
We grant it local admin as we need it to connect to remote resources. But it just depends on what your business requirements are.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

bla4free
Starting Member

10 Posts

Posted - 2008-10-01 : 20:49:29
How would I grant it local admin? Like I normally would for a regular user? Or make it part of the Domain Admins group?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-01 : 20:58:59
You should not grant it domain admin. Yes you grant local admin like you would other users...Computer Management is how I do it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -