SQL,access denied: ent

Showing posts with label ent. Show all posts

Thursday, March 22, 2012

Active/Active/Active without SAN

I read that its possible to implement an Active/Active/Active with SQL 2000
on Win Server 2003 Ent without SAN but could not find a good step by step
howtos to it.
Could some kind gentlemen point me to a good article ? please and thanks in
advance.
SCSI clusters only support two nodes. As far as Active/Active/Active
terminology, that really doesn't express what your intent is. The new
terminology is Multi-instance and you need to state how many nodes and SQL
instances you are trying to build in your cluster. I.E I want to build a
four node cluster with three SQL instances.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>I read that its possible to implement an Active/Active/Active with SQL 2000
> on Win Server 2003 Ent without SAN but could not find a good step by step
> howtos to it.
> Could some kind gentlemen point me to a good article ? please and thanks
> in
> advance.
|||My setup is a 2 data center, 2 server in location and 1 single in another. I
would like to implement a fail safe SQL system. So this will be a 3 node
system and I am intending that at any single update to database, all 3 will
be updated instantly. Because its not in the same datacenter, therefore
implementing a SAN is not possible, so with this in mind can my original
question be possible and is there any Howtos document to follow.. appreciate
any assistance.
"Geoff N. Hiten" wrote:

> SCSI clusters only support two nodes. As far as Active/Active/Active
> terminology, that really doesn't express what your intent is. The new
> terminology is Multi-instance and you need to state how many nodes and SQL
> instances you are trying to build in your cluster. I.E I want to build a
> four node cluster with three SQL instances.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:3C882765-40EE-424E-8BEF-A5F768D2207D@.microsoft.com...
>
>
|||What you are asking about is a Geo-cluster or a geographically separated
cluster. NSI makes some products that can give you this functionality. Some
SAN vendors also handle SAN-level data replication for disaster
recovery/fault tolerance setups. There are no built-in features in SQL
Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
technology called Database Mirroring that allows you to build a multi-site
high-availability solution.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...[vbcol=seagreen]
> My setup is a 2 data center, 2 server in location and 1 single in another.
> I
> would like to implement a fail safe SQL system. So this will be a 3 node
> system and I am intending that at any single update to database, all 3
> will
> be updated instantly. Because its not in the same datacenter, therefore
> implementing a SAN is not possible, so with this in mind can my original
> question be possible and is there any Howtos document to follow..
> appreciate
> any assistance.
> "Geoff N. Hiten" wrote:
|||Sorry Geoff.N, if its not troublesome, may I communicate with u via email or
MSN, I really appreciate if its possible to understand better on this subject.
"Geoff N. Hiten" wrote:

> What you are asking about is a Geo-cluster or a geographically separated
> cluster. NSI makes some products that can give you this functionality. Some
> SAN vendors also handle SAN-level data replication for disaster
> recovery/fault tolerance setups. There are no built-in features in SQL
> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
> technology called Database Mirroring that allows you to build a multi-site
> high-availability solution.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||My MSN is lewisteo@.hotmail.com
"Geoff N. Hiten" wrote:

> What you are asking about is a Geo-cluster or a geographically separated
> cluster. NSI makes some products that can give you this functionality. Some
> SAN vendors also handle SAN-level data replication for disaster
> recovery/fault tolerance setups. There are no built-in features in SQL
> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
> technology called Database Mirroring that allows you to build a multi-site
> high-availability solution.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@.microsoft.com...
>
>
|||I prefer to assist on the public newsgroups where everyone can benefit from
the discussions. Private assistance is known as "consulting" and is
generally done for pay.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...[vbcol=seagreen]
> Sorry Geoff.N, if its not troublesome, may I communicate with u via email
> or
> MSN, I really appreciate if its possible to understand better on this
> subject.
> "Geoff N. Hiten" wrote:
|||Not a problem, as I was saying, my setup is such:
Data Center 1:
2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet, another lease line to data center 2.
Data Center 2:
1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
internet and another leased to data center 1.
I would like to have all servers in both data center clustered for
redundancy, is this possible ?
"Geoff N. Hiten" wrote:

> I prefer to assist on the public newsgroups where everyone can benefit from
> the discussions. Private assistance is known as "consulting" and is
> generally done for pay.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Lewis" <Lewis@.discussions.microsoft.com> wrote in message
> news:60368F4E-899E-4833-9ED6-591FF5A3535C@.microsoft.com...
>
>
|||At this time, you cannot cluster using native SQL tools across a geographic
separation. Also, I think you may have an incomplete understanding of how
clustering works and what it actually offers. The following article is a
good starting point. It mostly describes running in a Windows 2000
environment. There are a few technical differences when running on Windows
2003, but the fundamentals are the same.
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/technet/pro.../failclus.mspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Lewis" <Lewis@.discussions.microsoft.com> wrote in message
news:1D291D57-DB1E-439B-806C-91F4D83673DF@.microsoft.com...[vbcol=seagreen]
> Not a problem, as I was saying, my setup is such:
> Data Center 1:
> 2 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
> internet, another lease line to data center 2.
> Data Center 2:
> 1 x server with Win 2K3 Server EE / MS SQL 2000 E, lease line to the
> internet and another leased to data center 1.
> I would like to have all servers in both data center clustered for
> redundancy, is this possible ?
> "Geoff N. Hiten" wrote:

Tuesday, March 20, 2012

Active/Active CLuster can not add 2nd Node

Help, I have an active/active cluster with SQL2k5 Ent with SP2 installed on node1 that is currently running live apps, I need to add the 2nd node to have fail over functionality but if I use the Change Install from Add or Remove Programs on the primary node to add the 2nd node I get the following error.

"The File 'c:\....\SqlRun_SQL.ms' is not a valid installation package for the product Microsoft SQL Server 2005(SQL2K5VVS01). Try to find the installation package 'SqlRun_SQL.msi' in a folder from which you can install Microsoft SQL Server 2005(SQL2K5VVS01).

No I assume this is because node 1 has had service pack two applied. Does anyone have instructions how I can add node two without having to completely uninstall Node 1, as the doc’s with SQL2005 SP2 say it can not be removed, a complete uninstall of 2005 must be done?

You may have to 'break' the cluster, install SQL and SP2 on your second node, and then reestablish the cluster.|||

Hmmm was hoping for a simpler sounding fix as not the confident with cluster administration, as this live cluster also has two other SQL2000 instances running in a side by side config, reporting services and file shares.

Also wondering is there a way to get the 'SqlRun_SQL.msi' from service pack two installer, as it may run if I could get it to read this?

Sunday, March 11, 2012

Activating Server Logs

I have two remote Win2000 servers running SQL2000. There are no items under
SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log database
activity?
Thanks,
John Steen
remove (nospam) from e-mail address to send me a messageNever heard we must activate something for the log. What do you see in
\Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
named ERRORLOG.
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>I have two remote Win2000 servers running SQL2000. There are no items
>under
> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> database
> activity?
> Thanks,
> John Steen
> remove (nospam) from e-mail address to send me a message|||Hi
SQL Server does not log activity like inserts and deletes. You need to run
SQL Server Profiler to do that.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ME" <ME@.hotmail.com> wrote in message
news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> files named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>|||My bad. Didn't read the last part of the post.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ugABXMVYFHA.2572@.TK2MSFTNGP14.phx.gbl...
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
>> files named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>>I have two remote Win2000 servers running SQL2000. There are no items
>>under
>> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> database
>> activity?
>> Thanks,
>> John Steen
>> remove (nospam) from e-mail address to send me a message
>>
>|||There are log files in the log folder, but the latest one is dated May 17,
2004, which is around the time they were moved there from the location where
they were set up. The IP addresses were also changed when they were moved to
their current location. I don't what else may have changed.
Could that have something to do with why the logs stopped recording?
Thanks,
John
"ME" wrote:
> Never heard we must activate something for the log. What do you see in
> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> named ERRORLOG.
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >I have two remote Win2000 servers running SQL2000. There are no items
> >under
> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> > database
> > activity?
> >
> > Thanks,
> > John Steen
> > remove (nospam) from e-mail address to send me a message
>
>|||I'm not trying to log inserts and such, Mike, just normal DB activtiy
(startups, shutdowns, recoveries, DBCC jobs, etc.) you see in the server logs.
Thanks,
John
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server does not log activity like inserts and deletes. You need to run
> SQL Server Profiler to do that.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "ME" <ME@.hotmail.com> wrote in message
> news:eIj85KVYFHA.3164@.TK2MSFTNGP12.phx.gbl...
> > Never heard we must activate something for the log. What do you see in
> > \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be
> > files named ERRORLOG.
> >
> >
> > "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> > news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >>I have two remote Win2000 servers running SQL2000. There are no items
> >>under
> >> SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> database
> >> activity?
> >>
> >> Thanks,
> >> John Steen
> >> remove (nospam) from e-mail address to send me a message
> >
> >
>
>|||Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
path that the parameter points to.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> There are log files in the log folder, but the latest one is dated May 17,
> 2004, which is around the time they were moved there from the location where
> they were set up. The IP addresses were also changed when they were moved to
> their current location. I don't what else may have changed.
> Could that have something to do with why the logs stopped recording?
> Thanks,
> John
> "ME" wrote:
>> Never heard we must activate something for the log. What do you see in
>> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
>> named ERRORLOG.
>>
>> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
>> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
>> >I have two remote Win2000 servers running SQL2000. There are no items
>> >under
>> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
>> > database
>> > activity?
>> >
>> > Thanks,
>> > John Steen
>> > remove (nospam) from e-mail address to send me a message
>>|||Thanks, Tibor, that did it!
John
"Tibor Karaszi" wrote:
> Right-click the server in EM, properties, Parameters. Verify that you have an -e parameter and the
> path that the parameter points to.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> news:04B3D2BC-6E90-4103-96E6-EB998BD613A0@.microsoft.com...
> > There are log files in the log folder, but the latest one is dated May 17,
> > 2004, which is around the time they were moved there from the location where
> > they were set up. The IP addresses were also changed when they were moved to
> > their current location. I don't what else may have changed.
> >
> > Could that have something to do with why the logs stopped recording?
> >
> > Thanks,
> > John
> >
> > "ME" wrote:
> >
> >> Never heard we must activate something for the log. What do you see in
> >> \Program Files\Microsoft SQL Server\MSSQL\LOG folder? There should be files
> >> named ERRORLOG.
> >>
> >>
> >> "John Steen" <moderndads(nospam)@.hotmail.com> wrote in message
> >> news:09D2F211-886A-4904-8B56-1471835E0C04@.microsoft.com...
> >> >I have two remote Win2000 servers running SQL2000. There are no items
> >> >under
> >> > SQL Server Logs in Ent. Mgr. How do I conjfigure the server to log
> >> > database
> >> > activity?
> >> >
> >> > Thanks,
> >> > John Steen
> >> > remove (nospam) from e-mail address to send me a message
> >>
> >>
> >>
>
>

Thursday, March 22, 2012

Active/Active/Active without SAN

Tuesday, March 20, 2012

Active/Active CLuster can not add 2nd Node

Sunday, March 11, 2012

Activating Server Logs

Activating Server Logs

Activating Server Logs

SQL,access denied

Blog Archive

About Me