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.
| Author |
Topic |
|
tanmeyamohan
Starting Member
1 Post |
 Posted - 2011-04-11 : 05:03:29
|
| Hi all,I am a beginner to SQL Server 2008 Administration part. I was going through a video tutorial, in which it was told that for running each service of SQL Server, we need to create a new Service account.Now for creating a Service account in a domain, they used "Active Directory Computers and Users", and provided a slight hint that for creating Service accounts on a stand-alone system, you need to right click on My Computer -> Manage, etc.Now can anyone please enlighten me upon both the concepts., i.e., is "Active Directory Computers and Users" part of the server version of operating system or is it a third party software dedicated for this purpose.Also do tell me how to create Service Accounts on a stand-alone system, with Windows Vista Home Premium 32-bit installed on it.Thanks in advance,Best Regards. |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-15 : 15:10:20
|
| If you are using Domain based network and using Active directory toothen you will create an account like XYZdomain\abcUserthis account is same as you login on the System with this user id and password,domain account is use for smooth communication on the networkthis is same in the stand-alone system too,just create a new user with password then put the SQL server on this account and note this account should have administrative rightsThere are 2 mode in SQL Server for Login1-Windows Onlywhere only windows user can access on the SQL Server then you administrative account and those account which have created in the sql server as a window account2-Windows and SQL Bothwhere you can use SQL server own users as well as Windows user tooRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA |
 |
|
|
|
|
|
|
|
Creating Service Accounts for running SQL Server 2