Showing posts with label asks. Show all posts
Showing posts with label asks. Show all posts

Sunday, March 11, 2012

Can it be installed on a stand alone PC?

Hi,

I am new to sql server 2005.. Is it possible to install this on a win xp PC? I tried installing it and when I launch it it asks for a server name..

How do I point it to look in local databases?

Any help on getting started is appreciated..

Thanks

SQL Server 2005 Express Edition, and SQL Server 2005 Developer Edition will install on Windows XP.

The server editions (WorkGroup, Standard, and Enterprise) require a Windows Server OS -and will not install on the client OS (such as Windows XP).

Friday, February 24, 2012

Can I use "Local System" account ?

We are running Novell as NOS and we start deploying SQL Server 2005.
During the installation, it asks for the account to be used for "SQL Server
Service" / "SQL Server Agent" service. Could it be possible for me to use
"Local System" account ? I have tried to use other account but I have
difficulty when backing up / restoring database.
Your advice is sought.
PeterIf your SQL Server 2005 in a domain environment, it's recommended using a
domain account as SQL Server service. And for security purposes, it's
advised using different service accounts for different services.
If you use Local System Account (that has all administrative rights on your
local machine) in a domain environment, then you will face some
difficulties.
Please read the following article which is related to this topic and I
believe it will be very helpful for you:
http://technet.microsoft.com/en-us/library/ms143691.aspx
Ekrem Önsoy
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uuwmmA48HHA.4612@.TK2MSFTNGP03.phx.gbl...
> We are running Novell as NOS and we start deploying SQL Server 2005.
> During the installation, it asks for the account to be used for "SQL
> Server Service" / "SQL Server Agent" service. Could it be possible for me
> to use "Local System" account ? I have tried to use other account but I
> have difficulty when backing up / restoring database.
> Your advice is sought.
> Peter
>|||Dear Ekrem,
We are using Novell as NOS and thus there is no domain at our site. It is
the reason why I wonder whether I can use "Local System" account OR I have
to create a local account and grant permission ?
Thanks again
Peter
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:0FA02F27-280C-402A-9260-32B0AB637FC8@.microsoft.com...
> If your SQL Server 2005 in a domain environment, it's recommended using a
> domain account as SQL Server service. And for security purposes, it's
> advised using different service accounts for different services.
> If you use Local System Account (that has all administrative rights on
> your local machine) in a domain environment, then you will face some
> difficulties.
> Please read the following article which is related to this topic and I
> believe it will be very helpful for you:
> http://technet.microsoft.com/en-us/library/ms143691.aspx
>
> --
> Ekrem Önsoy
>
> "Peter" <Peter@.discussions.microsoft.com> wrote in message
> news:uuwmmA48HHA.4612@.TK2MSFTNGP03.phx.gbl...
>> We are running Novell as NOS and we start deploying SQL Server 2005.
>> During the installation, it asks for the account to be used for "SQL
>> Server Service" / "SQL Server Agent" service. Could it be possible for
>> me to use "Local System" account ? I have tried to use other account but
>> I have difficulty when backing up / restoring database.
>> Your advice is sought.
>> Peter
>>
>