Lock pages in memory right on IA64 edition

I'm planing to install SQL2000 IA64 on Itanium server with win2003-IA64.
Not sure if I need to add "Lock pages in memory" right to SQL service
account or not. I know it must be used on x86 and is also recommended on x64
systems because they use AWE but on IA64 systems AWE is not used so I would
guess it's not necessary. Am I right?
Tom"Tom" <mcseman@.hotmail.com> wrote in message
news:uFRSdkGOGHA.2036@.TK2MSFTNGP14.phx.gbl...
> I'm planing to install SQL2000 IA64 on Itanium server with win2003-IA64.
> Not sure if I need to add "Lock pages in memory" right to SQL service
> account or not. I know it must be used on x86 and is also recommended on
> x64 systems because they use AWE but on IA64 systems AWE is not used so I
> would guess it's not necessary. Am I right?
>
No. My understanding is that "Lock pages in memory" is recommended on
64-bit SQL because it prevents the OS from paging out SQL Server memory
under pressure. Instead SQL Server will reduce its own memory usage when it
notices the system is under memory pressure.
David

lock pages in memory and AWE

Hi,
I noticed that SQL Service account needs 'lock pages in memory' permission
to enable Address Windowing Extensions (AWE). Is there any risk in granting
this permission to SQL Server and SQL Agent service accounts?
ThanksOnly if your SQL server gets hacked/compromised. Then again, you are
usually hosed if that happens anyway.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Alex" <alim@.rogers.com> wrote in message
news:uWfXe8lYGHA.2376@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I noticed that SQL Service account needs 'lock pages in memory' permission
> to enable Address Windowing Extensions (AWE). Is there any risk in
> granting this permission to SQL Server and SQL Agent service accounts?
> Thanks
>

LocalSystem account does not start SQLAgent

All,
Running SQL 2000 SP4 on a Windows 2003 server. I'm having some trouble
getting SQL Agent service to start using the LocalSystem account. The
MSSQLSERVER starts ok with the account? After setup I removed the builtin
admin's group - something I do on all my installs, but I ha to add it back
to get the LocalSystem to start the service. Anybody have any idea why this
is happening?
Thanks
Mike Gasperino
Sr. Software Developer
office: 919-807-2310
Helpdesk: (919)807-2300
doa.helpdesk@.ncmail.net
****************************************
************************************
E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law "NCGS.Ch.132" and may be disclosed to third
parties
****************************************
************************************See reply in microsoft.public.sqlserver.setup
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mike" <announ@.tkd.net> wrote in message
news:uJUJULbmFHA.3536@.TK2MSFTNGP10.phx.gbl...
> All,
> Running SQL 2000 SP4 on a Windows 2003 server. I'm having some trouble
> getting SQL Agent service to start using the LocalSystem account. The
> MSSQLSERVER starts ok with the account? After setup I removed the builtin
> admin's group - something I do on all my installs, but I ha to add it back
> to get the LocalSystem to start the service. Anybody have any idea why
> this
> is happening?
> Thanks
>
> --
> Mike Gasperino
> Sr. Software Developer
> office: 919-807-2310
> Helpdesk: (919)807-2300
> doa.helpdesk@.ncmail.net
> ****************************************
**********************************
**
> E-mail correspondence to and from this address may be subject to the North
> Carolina Public Records Law "NCGS.Ch.132" and may be disclosed to third
> parties
> ****************************************
**********************************
**
>

LOCAL USER vs GLOBAL USER set in agent service

My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.

Thank you in advance. Good day!

Can you post the error message you're seeing while trying to start snapshot agent job? From that we can confirm whether the issue you're seeing is due to agent account setup. Sometimes the issue may be caused by local user doesn't have permission on network resources.

Thanks,

Zhiqiang Feng

|||

mongol wrote:

My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.

Thank you in advance. Good day!

hi mongol

be sure the the login used by the service has an NTFS permission in the

replication shared folder

and the services has also write permission to the replication target database

Local system and SQL Server Service

Hi:

A very stupid question but want to see if i have an answer.

Is it possible to run SQL Server Service and SQL Server Agent Service under local system(not Domain account) without granting SA Permissions on the server. is it ever possible to run by just granting some registry permissions and not making BUILTIN\Administrators a SA on the server.

Thx

AK

You can remove Builtin\Administrators from the server and the server will still run, but some applications relying on the presence of that login could be broken by this action.

Thanks
Laurentiu

|||

Also, we recommend against using local system as the service. Whenever it is possible, the recommendation is to use a domain account or a local account; if these types of accounts do not meet your needs, I would suggest using Network Service instead.

For more information visit BOL:

http://msdn2.microsoft.com/en-us/library/ms143504.aspx#Use_startup_accounts

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

Local System Account or Domain User Account

One of the first questions the SQL 2005 Dev Ed pops up with is this one: Local System Account or Domain User Account, for the service programs. What are the ramifications of choosing one over the other?

I tried an installation using the local system account and I was unable to copy a database from a SQL2000 instance on another server to my new local instance - I figure the cryptic error message I was getting refering to an inability to login to DOMAIN\MACHINENAME$ was coming from the other server? (Especially since I made DOMAIN\MACHINENAME$ a local sysadmin and it made no difference.

Thanks,
David

Use the account "NT AUTHORITY\SYSTEM" for local system account.

Local system account and Mirroring.

Hi,

Is it possible to set up database mirroring between two servers that have SQL Service running under Local system? I tried to setup mirroring between two servers running under Local system but was running into the following error:

Server or Network address cannot be reached or does not exist.

What are the pre-requisites for setting up database mirroring if the service runs under Local system? Do I have to configure certificates? Is that mandatory? Can anyone please let me know. Any other gotchas?

Thanks

AK

Hi Ankith,
You can setup mirroring with local system account if there are two instances of sql server in the same machine !
you can refer the below link for settingup mirroring using local system account with 3 instances of sql server in the same machine,
Certificates is not required !
http://www.sql-articles.com/articles/dbmrr.htm

Thanxx
Deepak

|||

Hi Deepak,

Thanks for your reply. My scenario is not the same as you have mentioned. I have two different servers in the same domain but in different continents and running under local system. They are not instances on the same machine. They are two servers geographically apart. Can I still configure them without certificates?

Thanks again

AK

|||Is there some reason why you can't run the SQL Server services using a domain account? That is, after all, what Microsoft recommends. You would have to configure the endpoints to use windows authentication.
|||

Hi Bob,

Thanks for your reply. I configured the endpoints using windows authentication but no luck. It still failed. we will use domain accounts.

Thanks

AK

|||

You can not use local system to span machines. Local system, as the name describes, is LOCAL to the machine it is on. Local system has no security context outside of the local machine. Therefore, it does not have a valid SID on any other machine and can not be resolved. Since it can not be resolved, you can not use it to gain access to any resource external to the machine it exists on. Every Windows machine has an account named local system, but every single one of them is a different account with a SID only valid on its own machine.

You have to be using either local, named accounts or domain accounts.

Local system account and Mirroring.

Hi,

Is it possible to set up database mirroring between two servers that have SQL Service running under Local system? I tried to setup mirroring between two servers running under Local system but was running into the following error:

Server or Network address cannot be reached or does not exist.

What are the pre-requisites for setting up database mirroring if the service runs under Local system? Do I have to configure certificates? Is that mandatory? Can anyone please let me know. Any other gotchas?

Thanks

AK

Hi Ankith,
You can setup mirroring with local system account if there are two instances of sql server in the same machine !
you can refer the below link for settingup mirroring using local system account with 3 instances of sql server in the same machine,
Certificates is not required !
http://www.sql-articles.com/articles/dbmrr.htm

Thanxx
Deepak

|||

Hi Deepak,

Thanks for your reply. My scenario is not the same as you have mentioned. I have two different servers in the same domain but in different continents and running under local system. They are not instances on the same machine. They are two servers geographically apart. Can I still configure them without certificates?

Thanks again

AK

|||Is there some reason why you can't run the SQL Server services using a domain account? That is, after all, what Microsoft recommends. You would have to configure the endpoints to use windows authentication.
|||

Hi Bob,

Thanks for your reply. I configured the endpoints using windows authentication but no luck. It still failed. we will use domain accounts.

Thanks

AK

|||

You can not use local system to span machines. Local system, as the name describes, is LOCAL to the machine it is on. Local system has no security context outside of the local machine. Therefore, it does not have a valid SID on any other machine and can not be resolved. Since it can not be resolved, you can not use it to gain access to any resource external to the machine it exists on. Every Windows machine has an account named local system, but every single one of them is a different account with a SID only valid on its own machine.

You have to be using either local, named accounts or domain accounts.

Local SQL Service Not Starting but SQL Server is running?

Hello there,

This is a bit of strange one.
My local version of SQL Server fails to start when I boot yet if I
start Enterprise Manager its started and working fine. ISQL or Query
Analyzer is also not working.

If I try and register the server by another SQL Server is not there. Me
thinks that the named pipes might be a bit broken but would appreciate
any advise from people.

Thanks

GintersCouple of thoughts. One the service is not starting until you start EM and
click on the server? By default when a server is registered in EM it sets
the checkbox for automatically start. Right click the server in EM, choose
Edit server registration and look at the bottom checkbox.

Another is only shared memory is working and you are trying to connect from
isql (osql) and QA remotely? In this case check the SQL server error log
for what protocols SQL started and verify that on the client that these
protocols are activated in the client network utility.

If this is a default installation then shared memory, named pipes, and tcp
are all active. Is the MSSQLServer service set to start automatically?

"Ginters" <jpmcginty@.talk21.com> wrote in message
news:1108124975.337210.24500@.f14g2000cwb.googlegro ups.com...
> Hello there,
> This is a bit of strange one.
> My local version of SQL Server fails to start when I boot yet if I
> start Enterprise Manager its started and working fine. ISQL or Query
> Analyzer is also not working.
> If I try and register the server by another SQL Server is not there. Me
> thinks that the named pipes might be a bit broken but would appreciate
> any advise from people.
> Thanks
> Ginters|||Ginters (jpmcginty@.talk21.com) writes:
> This is a bit of strange one.
> My local version of SQL Server fails to start when I boot yet

Do you get any error message?

Do you have the service set to start automatically?

> if I start Enterprise Manager its started and working fine. ISQL or Query
> Analyzer is also not working.

Even if SQL Server is running?

Which operating system and which version of SQL Server are you using?

> If I try and register the server by another SQL Server is not there. Me
> thinks that the named pipes might be a bit broken but would appreciate
> any advise from people.

Which protcols have you enabled in the Client Network Utility? Is
shared memory on?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Local mode in asp.net web app

Dear all,
Can i use local mode of reporting service in asp.net web application?yes, if you use VS2005 you can create and use RDLC reports based on your own
datasets.
no server required.
abd there is a webcontrol in the toolbox to render the report
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:2EBBBA15-EC80-417E-9755-071685810970@.microsoft.com...
> Dear all,
> Can i use local mode of reporting service in asp.net web application?