Confused...SA Account

Hi
I have a two node cluster with SQL2000 SP3. When the node1 fails over to
node2, the SQL Server Agent fails. The log file says "Login Failed for user
'sa'" I don't understand how the SA account can fail on node2 and not on
node1. Can anyone shed some light on this and possibly how to resolve the
issue.
Thank You
Marc
What security account context is the SQL Agent running under? Is it a domain account and does it have adequate permissions/rights on both nodes?
|||Hi Stephen
SQL security is set for "SQL Server and Windows" and the service account is
in the Domain Admins group. Same service account is used for both nodes.
Regards
Marc
"Stephen Strong" <anonymous@.discussions.microsoft.com> wrote in message
news:39A963C4-A818-487F-8B10-C38CC58715FA@.microsoft.com...
> What security account context is the SQL Agent running under? Is it a
domain account and does it have adequate permissions/rights on both nodes?
|||Is the SQL Server Agent startup account a member of the local admin group
on both nodes. If you are using SQL Server authentication for SQL Server
Agent to connect to SQL Server then the SQL Server Agent startup account
has to be a local Admin.
You can check the SQL Agent connection properties by right clicking on SQL
Server Agent - Properties - Connection and see how the connection to SQL
Server is set up.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thanks Guys
As it turns out, one of our programmers changed the authentication method to
Windows rather than SQL. I changed it back and all is well.
Regards
Marc
"Marc" <Marc@.nospam.com> wrote in message
news:%23u4AZPJJEHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> I have a two node cluster with SQL2000 SP3. When the node1 fails over to
> node2, the SQL Server Agent fails. The log file says "Login Failed for
user
> 'sa'" I don't understand how the SA account can fail on node2 and not on
> node1. Can anyone shed some light on this and possibly how to resolve the
> issue.
> Thank You
> Marc
>

Confused about memory limits

Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
shows 3,669,532KB of RAM. SQL Server 2000 SP3.
I'm a bit confused as to if SQL server can use more memory or not.
In task manager, I see that sql server is using 1.7 gigs of memory (sounds
like 2gb to me).. which I'm reading is the maximum. Even though the server
properties have the minimum set at 0 and the maximum set at 38xxMB.
All the discussion says that setting "awe enabled" will allow SQL Server to
take advantage of memory on servers with more then 4gb of memory.
Well.. I don't have more then 4gb. I have 4. Can I make it use more memory?
Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
causes of some recent performance issues we've been having.
Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
in my boot.ini at all, I don't think I need that?
Thanks,
GregI would add /3GB but that is only if I had a memory bottleneck.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"greg" <greg@.discussions.microsoft.com> wrote in message
news:706F9484-62C7-4BDC-8AD5-F3079AA77828@.microsoft.com...
> Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
> shows 3,669,532KB of RAM. SQL Server 2000 SP3.
> I'm a bit confused as to if SQL server can use more memory or not.
> In task manager, I see that sql server is using 1.7 gigs of memory (sounds
> like 2gb to me).. which I'm reading is the maximum. Even though the server
> properties have the minimum set at 0 and the maximum set at 38xxMB.
> All the discussion says that setting "awe enabled" will allow SQL Server
> to
> take advantage of memory on servers with more then 4gb of memory.
> Well.. I don't have more then 4gb. I have 4. Can I make it use more
> memory?
> Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
> causes of some recent performance issues we've been having.
> Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
> in my boot.ini at all, I don't think I need that?
>
> Thanks,
> Greg|||If your SQL Server is Standard edition, you are capped at 2gb
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"greg" <greg@.discussions.microsoft.com> wrote in message
news:706F9484-62C7-4BDC-8AD5-F3079AA77828@.microsoft.com...
> Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
> shows 3,669,532KB of RAM. SQL Server 2000 SP3.
> I'm a bit confused as to if SQL server can use more memory or not.
> In task manager, I see that sql server is using 1.7 gigs of memory (sounds
> like 2gb to me).. which I'm reading is the maximum. Even though the server
> properties have the minimum set at 0 and the maximum set at 38xxMB.
> All the discussion says that setting "awe enabled" will allow SQL Server
> to
> take advantage of memory on servers with more then 4gb of memory.
> Well.. I don't have more then 4gb. I have 4. Can I make it use more
> memory?
> Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
> causes of some recent performance issues we've been having.
> Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
> in my boot.ini at all, I don't think I need that?
>
> Thanks,
> Greg|||What edition of SQL Server 2000 are you using. If it is Standard Edition, you
are limited to 2GB Max.
"greg" wrote:
> Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
> shows 3,669,532KB of RAM. SQL Server 2000 SP3.
> I'm a bit confused as to if SQL server can use more memory or not.
> In task manager, I see that sql server is using 1.7 gigs of memory (sounds
> like 2gb to me).. which I'm reading is the maximum. Even though the server
> properties have the minimum set at 0 and the maximum set at 38xxMB.
> All the discussion says that setting "awe enabled" will allow SQL Server to
> take advantage of memory on servers with more then 4gb of memory.
> Well.. I don't have more then 4gb. I have 4. Can I make it use more memory?
> Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
> causes of some recent performance issues we've been having.
> Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
> in my boot.ini at all, I don't think I need that?
>
> Thanks,
> Greg|||SQL Server 2000, Enterprise Edition.
Just found this option that says I should *not* be using 'awe enabled'...
damn this is confusing!
http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
Help?|||I don't believe this article does suggest that you disable AWE - what is
your reasoning behind this conclusion?
You'll need AWE enabled if you're wanting SQL Server to see more than a few
GB of memory.
"greg" <greg@.discussions.microsoft.com> wrote in message
news:F3795964-7DA6-46DE-8718-9D5FE1BC99B6@.microsoft.com...
> SQL Server 2000, Enterprise Edition.
> Just found this option that says I should *not* be using 'awe enabled'...
> damn this is confusing!
> http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
>
> Help?
>|||Added /3gb to boot.ini and rebooted this weekend, now using 2.7 gigs of
memory! Sweet.
CPU usage is up now so I guess that's good. Less time thrashing/waiting on
the disk, more time doing actual work.

conflict Problem Help

Hello Everybody
I am having merge Replication using MSSQL 2000 sp3 latest security patch,
My replication is server1 Publisher, server2 subscriber, server3
subscriber,
Server4 subscriber, server5 subscriber. I am using schedule around 1:00
AM every day, In Server2 we insert 5 rows some value, and 5 rows sending to
Server3 using DTS with Insert statement, and server3 we update the 5Rows,
and sending to Server4 or server2, this all process everything done before
synchronize. I am using default conflict revolver, becoz some table dont
have date time field. When I run the merge agent, I got some conflict in
conflict tables. Automatically delete some row in subscriber.
How to resolve those problems. I need urgent help.
The same row was updated at 'THSWPSW002.GCP' and deleted at
'BKKNTS370.GCPTEST'.
The resolver chose the deletion as the winner.
3:3 conflict_type : reason_code
The same column(s) of the same row was updated at both 'SERVER1.APPTEST' and
' SERVER2.APPTEST '.
The resolver chose the update from ' SERVER1.APPTEST ' as the winner.
2:2
The row was inserted at ' SERVER5.APPTEST ' but could not be inserted at '
SERVER1.APPTEST '. Violation of PRIMARY KEY constraint
'PK__T_M_SUPPLIER__3607E224'. Cannot insert duplicate key in object
'T_M_SUPPLIER'.
5:2627
The row was inserted at 'SERVER1.APPTEST' but could not be inserted at
'SERVER2.APPTEST'. Violation of PRIMARY KEY constraint
'PK__T_M_SUPPLIER__38CF4036'. Cannot insert duplicate key in object
'T_M_SUPPLIER'.
6:2627
The same row was updated at both 'SERVER1.APPTEST' and 'SERVER5.APPTEST'.
The resolver chose the update from 'BKKNTS370.GCPTEST' as the winner.
1:1
Thanks
Sam
Sam,
please take a look at this article and see if it applies:
http://support.microsoft.com/default...&Product=sql2k
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks,
Still i have problem some conflict.
i change mergearticle error 'flase'
could you tell me how to handule ?
Sam
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ui2754ILGHA.2276@.TK2MSFTNGP15.phx.gbl...
> Sam,
> please take a look at this article and see if it applies:
> http://support.microsoft.com/default...&Product=sql2k
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

Configuring Active Directory as a Linked Server.

Hi, in a server running sql server 2000 sp3, as a new requirement for an
application. They need to have the active Directory configured as a
Linked Server.
Do somebody know the pros and cons of configuring this.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***Hi,
its their SQL Server ,SQL server can be integrated with Active Directory ,
please read *Active Directory* in BOL.
here are some articles FYI :
msdn.microsoft.com/library/en-us/architec/8_ar_cs_1gku.asp
msdn.microsoft.com/.../adsi/adsi/ creating_a_heterogeneous_join_between_sq
l_s
erver_and_active_directory.asp
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"MariaGuzman" wrote:

> Hi, in a server running sql server 2000 sp3, as a new requirement for an
> application. They need to have the active Directory configured as a
> Linked Server.
> Do somebody know the pros and cons of configuring this.
> Thanks a lot for your help.
> *** Sent via Developersdex http://www.codecomments.com ***
>

Configure SQL Server 2000 Standard Edition RAM

Hi,
Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
2000 Standard Edition (sp3 applied) in our production box? The operation
system is Windows Server 2003 Standard Edition.
Regards,
-ChenUnfortunatly Standard edition can only support up to 2 gb (see
http://www.microsoft.com/sql/evalua...iew/default.asp)
To get it up to that amount in Enterprise Manager...
Right Click on the Server
Properties
Memory
And put the slider up to whatever you want to.
Peter
"Chen" wrote:

> Hi,
> Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Serv
er
> 2000 Standard Edition (sp3 applied) in our production box? The operation
> system is Windows Server 2003 Standard Edition.
> Regards,
> -Chen
>|||Thanks!
-Chen
"Peter Nolan" wrote:
[vbcol=seagreen]
> Unfortunatly Standard edition can only support up to 2 gb (see
> http://www.microsoft.com/sql/evalua...iew/default.asp)
> To get it up to that amount in Enterprise Manager...
> Right Click on the Server
> Properties
> Memory
> And put the slider up to whatever you want to.
> Peter
>
> "Chen" wrote:
>

Configure SQL Server 2000 Standard Edition RAM

Hi,
Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
2000 Standard Edition (sp3 applied) in our production box? The operation
system is Windows Server 2003 Standard Edition.
Regards,
-ChenUnfortunatly Standard edition can only support up to 2 gb (see
http://www.microsoft.com/sql/evaluation/overview/default.asp)
To get it up to that amount in Enterprise Manager...
Right Click on the Server
Properties
Memory
And put the slider up to whatever you want to.
Peter
"Chen" wrote:
> Hi,
> Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
> 2000 Standard Edition (sp3 applied) in our production box? The operation
> system is Windows Server 2003 Standard Edition.
> Regards,
> -Chen
>|||Thanks!
-Chen
"Peter Nolan" wrote:
> Unfortunatly Standard edition can only support up to 2 gb (see
> http://www.microsoft.com/sql/evaluation/overview/default.asp)
> To get it up to that amount in Enterprise Manager...
> Right Click on the Server
> Properties
> Memory
> And put the slider up to whatever you want to.
> Peter
>
> "Chen" wrote:
> > Hi,
> >
> > Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
> > 2000 Standard Edition (sp3 applied) in our production box? The operation
> > system is Windows Server 2003 Standard Edition.
> >
> > Regards,
> > -Chen
> >

Configure SQL Server 2000 Standard Edition RAM

Hi,
Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
2000 Standard Edition (sp3 applied) in our production box? The operation
system is Windows Server 2003 Standard Edition.
Regards,
-Chen
Unfortunatly Standard edition can only support up to 2 gb (see
http://www.microsoft.com/sql/evaluat...ew/default.asp)
To get it up to that amount in Enterprise Manager...
Right Click on the Server
Properties
Memory
And put the slider up to whatever you want to.
Peter
"Chen" wrote:

> Hi,
> Can someone tell can we configure the amount of RAM to 2.5 GB for SQL Server
> 2000 Standard Edition (sp3 applied) in our production box? The operation
> system is Windows Server 2003 Standard Edition.
> Regards,
> -Chen
>
|||Thanks!
-Chen
"Peter Nolan" wrote:
[vbcol=seagreen]
> Unfortunatly Standard edition can only support up to 2 gb (see
> http://www.microsoft.com/sql/evaluat...ew/default.asp)
> To get it up to that amount in Enterprise Manager...
> Right Click on the Server
> Properties
> Memory
> And put the slider up to whatever you want to.
> Peter
>
> "Chen" wrote: