Changing cluster configuration

My current cluster configuration is Active/Passive, I'm exploring a change to
Active/Active, but I haven't been able to find any informaon on how to do
this, has anyone ever done this? My reason for considering this is the size
of the current server, and the need to bringup other applications on the
seconday node.
Active/Passive and Active/Active are old terms. What you want to build is a
multi-instance cluster. You simply install a new instance of SQL server
with its own disk(s), IP address, and network name. After the installation
you can configure each instance to have preferred owner nodes under normal
conditions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:1EB1CFF5-CACD-41A2-B9ED-06F02A766BC8@.microsoft.com...
> My current cluster configuration is Active/Passive, I'm exploring a change
to
> Active/Active, but I haven't been able to find any informaon on how to do
> this, has anyone ever done this? My reason for considering this is the
size
> of the current server, and the need to bringup other applications on the
> seconday node.
|||Jerrick,
Geoff's answer is dead on!
The only other thing to consider is that there can only be ONE default
instance PER CLUSTER.
The second instance you install will likely be a NAMED INSTANCE.
The virtual server name you choose for your second instance MUST BE UNIQUE,
and the instance name will of course need to be unique as well.
Here are some good resources:
http://www.microsoft.com/technet/pro.../failclus.mspx
and in BOL -
Multiple Instances of SQL Server
Failover Clustering Example - This is very good and I think speaks to your
question perfectly as well.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support

Changed Version of SQL Server

I have Windows 2000 Advanced Server with SQL Server 2000
with SP3A in a Active\Active Cluster.
When I loaded Windows 2000 SP4 on the server it changed
SQL Server 2000 version to "Microsoft SQL Server 2000 -
8.00.194 (Intel X86)".
If the Active (Node A)\ Active (Node B) cluster was moved
from original location could this change the SQL Server
version number. (Move Node A to Node B)
What could cause the version number to change within SQL
Server 2000. If the version is wrong is there away to
determine the version by SQL Server file dates?
Please help me resolve this issue.
Thanks,
Mark
weird normally the best way is to type the query below in Query Analyzer
which is determined by the version of SQLServr.exe.
SELECT @.@.VERSION
http://support.microsoft.com/default...b;en-us;321185
Although ocasionally (as with build 819 from
http://support.microsoft.com/default...b;en-us;826161) the real
version is not reflected as SQLServr.exe is not updated. In this case check
the registry @. HKLM\SOFTWARE\Microsoft\MSSQLServer\Hotfixes\0819
regards,
Andy.
"Mark" <anonymous@.discussions.microsoft.com> wrote in message
news:024a01c48aea$87d32a80$a601280a@.phx.gbl...
>
> I have Windows 2000 Advanced Server with SQL Server 2000
> with SP3A in a Active\Active Cluster.
> When I loaded Windows 2000 SP4 on the server it changed
> SQL Server 2000 version to "Microsoft SQL Server 2000 -
> 8.00.194 (Intel X86)".
> If the Active (Node A)\ Active (Node B) cluster was moved
> from original location could this change the SQL Server
> version number. (Move Node A to Node B)
>
> What could cause the version number to change within SQL
> Server 2000. If the version is wrong is there away to
> determine the version by SQL Server file dates?
>
> Please help me resolve this issue.
> Thanks,
> Mark

Change user login

A users name has changed. In active directory the account has been renamed.
How do you associate this renamed NT account with the SQL login? The orgina
l
SID still exists so I cant add the new NT user name. Can I modify the
sysxuser table? : (Doug:
You can remove a login from the server, but leave the user with rights to
each database. Then, when you add the login again with the new name and gran
t
them access to specific databases, you can map that new Domain name to the
old user in the database.
For example: MyDomain\Bob is a login to the server and a user of the
database. I remove MyDomain\Bob as a login (leaving him as a user in the db)
.
Then I add MyDomain\Robert as a login to the server. When I assign him acces
s
as a user to the database, I map him to MyDomain\Bob.
It's not elegant, but it might work (no guarantees!)
Good luck.
Todd C
"doug" wrote:

> A users name has changed. In active directory the account has been rename
d.
> How do you associate this renamed NT account with the SQL login? The orgi
nal
> SID still exists so I cant add the new NT user name. Can I modify the
> sysxuser table? : (

Change the username in Active Directory

We use extended properties of Active Directory to filter the data in reporting services throw a web services. We send the userid (User!UserId) to the webservices and retrieve some information about the user.
But if we change the name of one user (rename not recreate), he lost all this properties. When try to execute a report show an error:

Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) I know this issue is in the border of reporting services, but we have spent a lot of time without results and we need any help.

Thanks in advance

How are you doing your rename? Because that's where your issue is <s>.

If you're doing it through some GUI interface and that interface doesn't transfer your extended properties on a rename, then that interface has a bug in it <sigh>.

I do some AD coding but don't have an example I can throw in here. Basically, when any consumer queries AD for a user object, it is allowed to say what properties it's interested in retrieving. If it doesn't know about yours and doesn't retrieve them, it probably doesn't clone them along with the rest of the object. (I think, under the covers, a rename likely does a clone-and-delete.)

So you have to write something that does know about your extended properties and write a better rename...

>L<

|||We rename the user in Active directory but i supposed that in some part of reporting services store the previous username, guid or something to refers to the old user. When we use the user!userID functions, reporting services get the old value instead the new value.

Our process is:
We have two parameters, one with the user and other with the information to retrieve and send to another queries. Send this two parameters to the web services and retrieve a parameter (a custom property defined in AD) to send in another query.

We use directly in web browser the reporting services. And it is the default configuration of report server web.

Thanks for your patience

|||

>>We rename the user in Active directory

I know that's what you did. I asked you *how* you did this (through what interface).

But, yes, if you're getting the old version when you look at user!userID, it doesn't matter.

I don't see why the report server would be caching the previous user name etc, unless you have put this information in as the credentials of the user to run the report in the report configuration?

Could this possibly be an AD refresh type of problem, instead? IOW, you do the rename and all the domain servers don't know about it?

>L<

Change the active user in sp

Hello,
I would like to change the active user in a stored procedure
Ex. :
I'm logged on sql as "userA".
I call the stored procedure "spGetInfo".
In the first line of "spGetInfo" I would like to do something like "su poweruser", query some data and do "su system_user"

Is there anything like the unix "su" command in SQL ?

Thank a lot

Felix Pageau
fpageau@.SPAMSUCK.str.caI'm not quite sure what you are asking. Assuming that the user has the permission to execute a stored procedure, that stored procedure executes in the security context of the user that CREATES the procedure. If the dbo creates a procedure, the procedure can do anything that the dbo can do when any user runs it.

The only exception is that dynamic SQL always runs in the context of the currently logged in user. That can hang you up, but otherwise you should be fine.

-PatP|||Hello,

my problem is that the stored procedure contain dynamic sql. I need to execute the dynamic sql query without giving the user to query the table.

I thought that with a kind of "impersonation" I would be able to do so but I haven't found any.

Do you know a way to execute dynamic sql in another context than then one of the user that has called the sp ?

Thank for your reply|||The quickest and easiest answer is probably an extended stored procedure (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_67vp.asp). I don't know of anything in Transact-SQL that will allow you to do that.

-PatP|||Do you mean I should create an extended sp with my sql code or that I should call an existing extend sp ?|||If you need to "switch context" to allow dynamic SQL to execute, I'm suggesting that you write an extended stored procedure that allows you to control what gets executed and how. I don't know of a way to get you what you want using just Transact-SQL.

-PatP|||Even if you change the user inside your stored procedure from simple user to system admin user, the proc would still be running under the simple user access rights.
Best would be to define the access rights using the role, stored procedure etc etc and then control the sql.

Unix and SQL are entirely two different world.

Change NT Domain Name with SQL Servers in

Hello,
the administrators want to change our NT (NT 2000) domain name (no Active Di
rectory), where we have
several SQL Servers in.
Which actions should I do / which pitfalls should I take care of to make the
SQL Severs and their
accounts, services... run after the change ?
Thank You
Joachimone caveat with Service Accounts in general is to make sure that you change
the Service Accounts using Enterprise Manager as opposed to Services.msc
etc.
Most of the time you get away with if Service Account is Local Admin - but
if the box has been hardened you can get problems
documented below
http://support.microsoft.com/defaul...kb;en-us;283811
regards,
Andy
"Joachim Hofmann" <speicher@.freenet.de> wrote in message
news:40E1972B.73739A36@.freenet.de...
> Hello,
> the administrators want to change our NT (NT 2000) domain name (no Active
Directory), where we have
> several SQL Servers in.
> Which actions should I do / which pitfalls should I take care of to make
the SQL Severs and their
> accounts, services... run after the change ?
> Thank You
> Joachim

Change node names and move cluster to new domain

I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
want me to rename both nodes and also move the cluster to a new domain. How
would I do that ?.
Regards
Tony Dawson
There is no easy way to do this.
http://support.microsoft.com/kb/915846/en-us
will get you through the domain change. To change the node names, you will
have to evict, change, and readd each node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tony Dawson" <noone@.nowhere.org> wrote in message
news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
>I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
>want me to rename both nodes and also move the cluster to a new domain. How
>would I do that ?.
> Regards
> Tony Dawson
|||You might want to ask yourself if the reasons for doing this are strong
enough to outweigh the risk and efford of this excercise.
Are there any technical reasons why you want to do this ?
Oh, and take a backup... and test the backup before you begin.
But sure that goes for every maintenance you do.
rgds,
Edwin.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yjCbRkIIHA.5208@.TK2MSFTNGP04.phx.gbl...
> There is no easy way to do this.
> http://support.microsoft.com/kb/915846/en-us
> will get you through the domain change. To change the node names, you
will[vbcol=seagreen]
> have to evict, change, and readd each node.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Tony Dawson" <noone@.nowhere.org> wrote in message
> news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
bosses[vbcol=seagreen]
How
>
|||Geoff, that KB article handles the domain *group* change but not changing
the domain. I don't think you can move a cluster to another domain.
As for renaming nodes, the only way to do that is to:
1) evict one node
2) rename the node
3) bring the node back into the cluster
4) re-apply the binaries to the node
5) repeat for all nodes
This is all a major PITA. I think there has to be very compelling reason to
change domains or rename nodes within a server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23yjCbRkIIHA.5208@.TK2MSFTNGP04.phx.gbl...
There is no easy way to do this.
http://support.microsoft.com/kb/915846/en-us
will get you through the domain change. To change the node names, you will
have to evict, change, and readd each node.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Tony Dawson" <noone@.nowhere.org> wrote in message
news:0E3AECC8-4C34-4BD5-BE89-71D34D023A11@.microsoft.com...
>I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses
>want me to rename both nodes and also move the cluster to a new domain. How
>would I do that ?.
> Regards
> Tony Dawson