Check periodically if SQL server is running

Hi,

I have my SQL server installed and running on a windows 2003 server. Sometimes, the server stops unexpectedly. I want to know if there is any mechanism to alert as and when the SQL server or SQL server agent goes down.

I guess everything is a windows service. Can we have a mechanism to test this service from a script and send an alert mail when the server goes down? How can this be done from a script?

Thanks in advance

-SudhakarIf you have two servers, you could have each server send periodic commands to the other to see if they are awake.
Or you could schedule a job to e-mail you at regular intervals and when you don't get a notification you'd know something was wrong.

...or you could fix the f'ing server...|||set the services to autostart and you can use sp_procoption to send you an email everytime sql server restarts.

you ought to figure out why your server is stalling out though.|||You can also use EXECUTE xp_servicecontrol 'QueryState', 'SQLSERVERAGENT'|||I think you should kick the server, that would fix it

check MDAC version

I would like to check the MDAC version on our SQL Server 2005 servers on
windows 2003. How can I do so ?Hassan,
I have not try this in a long time but this must be the link
How to check for MDAC version
http://support.microsoft.com/kb/301202
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I would like to check the MDAC version on our SQL Server 2005 servers on
> windows 2003. How can I do so ?
>|||HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess
--
Kevin Hill
IC3 North Texas
www.ChristianCycling.com
Please support me in the 2008 MS150:
http://www.ms150.org/dallas/donate/donate.cfm?id=208000
"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>|||Go to the Microsoft download site and look for CC_PKG.exe the MDAC Utility:
Component Checker 2.0
'"Hassan" <hassan@.test.com> wrote in message
news:eZ2c73WTIHA.5360@.TK2MSFTNGP03.phx.gbl...
>I would like to check the MDAC version on our SQL Server 2005 servers on
>windows 2003. How can I do so ?
>

Check if a windows/nt user account exists

I have some script which creates/grant priveleges to windows/nt users to DB but i frequently get the message below:

Windows NT user or group '<user or group>' not found. Check the name again.

I understand that this is because the said user/group is indeed not present in the environment I'm running the script (ie. testing and production environment).

But is it possible to have some sort of checking whether the user/group exists in the environment so that I could determine whether or not to call some lines of code?

Not sure if this is possible so i had to ask. c",)

SELECT *

FROM sysusers

will show the users from the current database. There are columns like isntname and isntgroup that will tell you if it is an NT user name or group. There are more than just the normal users, so take a look at what is in that table.

|||

If i'm not mistaken that will only show users already registered for the current database.

I needed to check if a NT user name/group is valid/exists in the environment rather than if it is registered for the current database.

Appreciate your help but i think i need something else or could you expound how would that apply for my objective?

Thanks in advance

|||

What version of SQL Server are you using? You could use SUSER_SID('<your_windows_login_name>' and check for non-null value. But this method depends on your configuration - the SQL Server service account, member server or standalone server etc. So there is no easy way to do this from the database engine.

You could use the ADSI OLEDB provider and perform distributed queries but this depends on your network configuration & whether LDAP is allowed and so on. In SQL Server 2005, you can write SQLCLR function to perform the check but this requires enabling CLR on the server, creating assembly with possibly UNSAFE or minimum of EXTERNAL_ACCESS permissions.

Best is to perform the check outside of the database, filter the list of users and create the logins. Or you can simply perform the error check in TSQL. This is also easier with TRY..CATCH in SQL Server 2005.

|||Thanks, will definitely try to look into these.|||I think i'll just go for the try-catch. Thanks|||Try catch should be fine, but be careful that you don't need speed. Performance will be a bigger concern just catching the error instead of checking for it first.

character(s) that cannot be stored in DB

Does any one know if there're certain character(s) that
cannot be stored in the DB which is similar to Windows
cannot have " or * etc.?
Thanks
OwenNot really. But the character repertoire is based on the collation selected for the
column/database/server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Owen" <owen_lin@.hotmail.com> wrote in message news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
> Does any one know if there're certain character(s) that
> cannot be stored in the DB which is similar to Windows
> cannot have " or * etc.?
> Thanks
> Owen|||Thanks for your reply Tibor.
I am in a situation where the company that is hosting my
web site has told me that I cannot enter characters ' and
+ in the column as it will cause problem, I can enter "
however. What can you suggest that I tell them as I do
need to input those characters.
Thanks
Owen
>Not really. But the character repertoire is based on the
collation selected for the
>column/database/server.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Owen" <owen_lin@.hotmail.com> wrote in message
news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
>> Does any one know if there're certain character(s) that
>> cannot be stored in the DB which is similar to Windows
>> cannot have " or * etc.?
>> Thanks
>> Owen|||Ask them what they mean by "it will cause problem". SQL Server can certainly handle this. Who wrote
the application you are using?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Owen" <owen_lin@.hotmail.com> wrote in message news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
> Thanks for your reply Tibor.
> I am in a situation where the company that is hosting my
> web site has told me that I cannot enter characters ' and
> + in the column as it will cause problem, I can enter "
> however. What can you suggest that I tell them as I do
> need to input those characters.
> Thanks
> Owen
> >Not really. But the character repertoire is based on the
> collation selected for the
> >column/database/server.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> >"Owen" <owen_lin@.hotmail.com> wrote in message
> news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
> >> Does any one know if there're certain character(s) that
> >> cannot be stored in the DB which is similar to Windows
> >> cannot have " or * etc.?
> >>
> >> Thanks
> >>
> >> Owen|||"Owen" <owen_lin@.hotmail.com> wrote in message
news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
> Thanks for your reply Tibor.
> I am in a situation where the company that is hosting my
> web site has told me that I cannot enter characters ' and
> + in the column as it will cause problem, I can enter "
> however. What can you suggest that I tell them as I do
> need to input those characters.
My guess is they're trying to trap certain stuff to prevent SQL Injection
attacks.
However, allowing " isn't smart in that case.|||I spoke to the company that is hosting my web site and DB, although I did not
asked them in details as to what sort of problem it might cuase or have
caused in the past, but they did told me that it has been a problem in the
past where their hosting site(s) needing to store ' within SQL and have
encountered some issue.
They have asked me to seek advice on their behalf as to what can/should they
do to overcome such problem.
Many thanks
Owen
"Tibor Karaszi" wrote:
> Ask them what they mean by "it will cause problem". SQL Server can certainly handle this. Who wrote
> the application you are using?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Owen" <owen_lin@.hotmail.com> wrote in message news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
> > Thanks for your reply Tibor.
> >
> > I am in a situation where the company that is hosting my
> > web site has told me that I cannot enter characters ' and
> > + in the column as it will cause problem, I can enter "
> > however. What can you suggest that I tell them as I do
> > need to input those characters.
> >
> > Thanks
> >
> > Owen
> >
> > >Not really. But the character repertoire is based on the
> > collation selected for the
> > >column/database/server.
> > >
> > >--
> > >Tibor Karaszi, SQL Server MVP
> > >http://www.karaszi.com/sqlserver/default.asp
> > >http://www.solidqualitylearning.com/
> > >
> > >
> > >"Owen" <owen_lin@.hotmail.com> wrote in message
> > news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
> > >> Does any one know if there're certain character(s) that
> > >> cannot be stored in the DB which is similar to Windows
> > >> cannot have " or * etc.?
> > >>
> > >> Thanks
> > >>
> > >> Owen
>
>|||Thanks for your reply Greg.
May I ask what sort of issue(s) might occur by allowing the use of " ?
Owen
"Greg D. Moore (Strider)" wrote:
> "Owen" <owen_lin@.hotmail.com> wrote in message
> news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
> > Thanks for your reply Tibor.
> >
> > I am in a situation where the company that is hosting my
> > web site has told me that I cannot enter characters ' and
> > + in the column as it will cause problem, I can enter "
> > however. What can you suggest that I tell them as I do
> > need to input those characters.
> My guess is they're trying to trap certain stuff to prevent SQL Injection
> attacks.
> However, allowing " isn't smart in that case.
>
>|||Oh yes, I forgot to mention the SQL Server is Traditional Chinese version,
does it make any different in this case?
"Owen" wrote:
> Thanks for your reply Tibor.
> I am in a situation where the company that is hosting my
> web site has told me that I cannot enter characters ' and
> + in the column as it will cause problem, I can enter "
> however. What can you suggest that I tell them as I do
> need to input those characters.
> Thanks
> Owen
> >Not really. But the character repertoire is based on the
> collation selected for the
> >column/database/server.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://www.solidqualitylearning.com/
> >
> >
> >"Owen" <owen_lin@.hotmail.com> wrote in message
> news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
> >> Does any one know if there're certain character(s) that
> >> cannot be stored in the DB which is similar to Windows
> >> cannot have " or * etc.?
> >>
> >> Thanks
> >>
> >> Owen
>|||"Owen" <Owen@.discussions.microsoft.com> wrote in message
news:67D98731-28FA-4E60-8A36-6E0A116F9E91@.microsoft.com...
> I spoke to the company that is hosting my web site and DB, although I did
not
> asked them in details as to what sort of problem it might cuase or have
> caused in the past, but they did told me that it has been a problem in the
> past where their hosting site(s) needing to store ' within SQL and have
> encountered some issue.
>
The general way of handling this is use '' (two single quotes).
ie. select * from names where lastname='O''brien'
It's not clear to me what they're doing, blocking ' entirely?
> They have asked me to seek advice on their behalf as to what can/should
they
> do to overcome such problem.
> Many thanks
> Owen|||"Owen" <Owen@.discussions.microsoft.com> wrote in message
news:DB0511AF-7798-4821-A269-52F5FEFB3236@.microsoft.com...
> Oh yes, I forgot to mention the SQL Server is Traditional Chinese version,
> does it make any different in this case?
>
Depending on how their server is setup, it's possible to treat " like '
which then of course leads to SQL Injection attacks.|||> They have asked me to seek advice on their behalf as to what can/should they
> do to overcome such problem.
"I have an application that uses SQL Server, and my application has a lot of bugs in it. I.e.,
there's a problem in SQL server, is there a fix for it?"
I'm not sure I can put it simpler than above. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Owen" <Owen@.discussions.microsoft.com> wrote in message
news:67D98731-28FA-4E60-8A36-6E0A116F9E91@.microsoft.com...
> I spoke to the company that is hosting my web site and DB, although I did not
> asked them in details as to what sort of problem it might cuase or have
> caused in the past, but they did told me that it has been a problem in the
> past where their hosting site(s) needing to store ' within SQL and have
> encountered some issue.
> They have asked me to seek advice on their behalf as to what can/should they
> do to overcome such problem.
> Many thanks
> Owen
> "Tibor Karaszi" wrote:
> > Ask them what they mean by "it will cause problem". SQL Server can certainly handle this. Who
wrote
> > the application you are using?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Owen" <owen_lin@.hotmail.com> wrote in message news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
> > > Thanks for your reply Tibor.
> > >
> > > I am in a situation where the company that is hosting my
> > > web site has told me that I cannot enter characters ' and
> > > + in the column as it will cause problem, I can enter "
> > > however. What can you suggest that I tell them as I do
> > > need to input those characters.
> > >
> > > Thanks
> > >
> > > Owen
> > >
> > > >Not really. But the character repertoire is based on the
> > > collation selected for the
> > > >column/database/server.
> > > >
> > > >--
> > > >Tibor Karaszi, SQL Server MVP
> > > >http://www.karaszi.com/sqlserver/default.asp
> > > >http://www.solidqualitylearning.com/
> > > >
> > > >
> > > >"Owen" <owen_lin@.hotmail.com> wrote in message
> > > news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
> > > >> Does any one know if there're certain character(s) that
> > > >> cannot be stored in the DB which is similar to Windows
> > > >> cannot have " or * etc.?
> > > >>
> > > >> Thanks
> > > >>
> > > >> Owen
> >
> >
> >|||They have overcome the problem within the ASP coding by using "relapce".
The issue came about as we have an admin section for our company's web site,
this is an interface where we can update the info on the site, but apparently
when a single quotation mark (') is written to the SQL via the ASP it would
cause some problem. So someone have suggested the use of "relapce" to write
two single quotation mark where one is entered, and would display it as one
single quotation mark when two singles '' is detected.
This seem to do the trick nevertheless, not sure what your thoughts are on
this?
"Owen" wrote:
> I spoke to the company that is hosting my web site and DB, although I did not
> asked them in details as to what sort of problem it might cuase or have
> caused in the past, but they did told me that it has been a problem in the
> past where their hosting site(s) needing to store ' within SQL and have
> encountered some issue.
> They have asked me to seek advice on their behalf as to what can/should they
> do to overcome such problem.
> Many thanks
> Owen
> "Tibor Karaszi" wrote:
> > Ask them what they mean by "it will cause problem". SQL Server can certainly handle this. Who wrote
> > the application you are using?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Owen" <owen_lin@.hotmail.com> wrote in message news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
> > > Thanks for your reply Tibor.
> > >
> > > I am in a situation where the company that is hosting my
> > > web site has told me that I cannot enter characters ' and
> > > + in the column as it will cause problem, I can enter "
> > > however. What can you suggest that I tell them as I do
> > > need to input those characters.
> > >
> > > Thanks
> > >
> > > Owen
> > >
> > > >Not really. But the character repertoire is based on the
> > > collation selected for the
> > > >column/database/server.
> > > >
> > > >--
> > > >Tibor Karaszi, SQL Server MVP
> > > >http://www.karaszi.com/sqlserver/default.asp
> > > >http://www.solidqualitylearning.com/
> > > >
> > > >
> > > >"Owen" <owen_lin@.hotmail.com> wrote in message
> > > news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
> > > >> Does any one know if there're certain character(s) that
> > > >> cannot be stored in the DB which is similar to Windows
> > > >> cannot have " or * etc.?
> > > >>
> > > >> Thanks
> > > >>
> > > >> Owen
> >
> >
> >|||> So someone have suggested the use of "relapce" to write
> two single quotation mark where one is entered, and would display it as one
> single quotation mark when two singles '' is detected.
> This seem to do the trick nevertheless, not sure what your thoughts are on
> this?
The correct way to input a single quote in the SQL language is indeed to escape it with a preceding
single quote (which makes it two single quotes).
Consider using command objects and parameter object in your app, this way your database programming
interface (ADO etc) will do this for you.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Owen" <Owen@.discussions.microsoft.com> wrote in message
news:7E044AE8-4459-427F-9923-DEE984ABD117@.microsoft.com...
> They have overcome the problem within the ASP coding by using "relapce".
> The issue came about as we have an admin section for our company's web site,
> this is an interface where we can update the info on the site, but apparently
> when a single quotation mark (') is written to the SQL via the ASP it would
> cause some problem. So someone have suggested the use of "relapce" to write
> two single quotation mark where one is entered, and would display it as one
> single quotation mark when two singles '' is detected.
> This seem to do the trick nevertheless, not sure what your thoughts are on
> this?
>
> "Owen" wrote:
>> I spoke to the company that is hosting my web site and DB, although I did not
>> asked them in details as to what sort of problem it might cuase or have
>> caused in the past, but they did told me that it has been a problem in the
>> past where their hosting site(s) needing to store ' within SQL and have
>> encountered some issue.
>> They have asked me to seek advice on their behalf as to what can/should they
>> do to overcome such problem.
>> Many thanks
>> Owen
>> "Tibor Karaszi" wrote:
>> > Ask them what they mean by "it will cause problem". SQL Server can certainly handle this. Who
>> > wrote
>> > the application you are using?
>> >
>> > --
>> > Tibor Karaszi, SQL Server MVP
>> > http://www.karaszi.com/sqlserver/default.asp
>> > http://www.solidqualitylearning.com/
>> >
>> >
>> > "Owen" <owen_lin@.hotmail.com> wrote in message news:35f801c4a601$fd6b9200$a501280a@.phx.gbl...
>> > > Thanks for your reply Tibor.
>> > >
>> > > I am in a situation where the company that is hosting my
>> > > web site has told me that I cannot enter characters ' and
>> > > + in the column as it will cause problem, I can enter "
>> > > however. What can you suggest that I tell them as I do
>> > > need to input those characters.
>> > >
>> > > Thanks
>> > >
>> > > Owen
>> > >
>> > > >Not really. But the character repertoire is based on the
>> > > collation selected for the
>> > > >column/database/server.
>> > > >
>> > > >--
>> > > >Tibor Karaszi, SQL Server MVP
>> > > >http://www.karaszi.com/sqlserver/default.asp
>> > > >http://www.solidqualitylearning.com/
>> > > >
>> > > >
>> > > >"Owen" <owen_lin@.hotmail.com> wrote in message
>> > > news:12f901c4a5f1$04a6acf0$a601280a@.phx.gbl...
>> > > >> Does any one know if there're certain character(s) that
>> > > >> cannot be stored in the DB which is similar to Windows
>> > > >> cannot have " or * etc.?
>> > > >>
>> > > >> Thanks
>> > > >>
>> > > >> Owen
>> >
>> >
>> >

Character Set (code page)

I have to test an application under a Greek version of Windows.
I heave installed Windows XP - Greek. The Greek characters appears OK in the application contros (edits), but Crystal Reports viewer continues showing U.S.English character set.
Please, does anybody know how to set Greek character set for the Crystal Reports?
Any clue should be very appreciated.
Thanks!I've got the same problem. :confused:|||Hey, crystalreportsgurus around the world, wake up!

Changing/Moving SQL Server 2000 to new Domain

Hi
I wonder if the follwoing operation can be done ?
Can I move SQL Server 2000 running on Windows 2000 from
one Domain to another ? Will the server and DB's will be
functional ?
Thx
Bar
Hi,
No issues, Only thing is you need to create a Trust relationship with old
domain, So that users in the old domain also can access.
But the following things also need to be considered
1. If the SQL server in new domain is a new name then, Issue the below
commands based on the new server name
sp_dropserver <Old server name>
go
sp_addserver <new server name>,Local
2. If it is new ip address
Change the connectiction string in your application server or connection
file
3. If you are using any server alias using TCP/IP
Modify the existing alias with new IP address using "CLient Network
utility"
Thanks
Hari
MCDBA
"Bar" <anonymous@.discussions.microsoft.com> wrote in message
news:701101c42fcf$29f05ad0$a601280a@.phx.gbl...
> Hi
> I wonder if the follwoing operation can be done ?
> Can I move SQL Server 2000 running on Windows 2000 from
> one Domain to another ? Will the server and DB's will be
> functional ?
> Thx
> Bar

Changing/Moving SQL Server 2000 to new Domain

Hi
I wonder if the follwoing operation can be done '
Can I move SQL Server 2000 running on Windows 2000 from
one Domain to another ? Will the server and DB's will be
functional '
Thx
BarHi,
No issues, Only thing is you need to create a Trust relationship with old
domain, So that users in the old domain also can access.
But the following things also need to be considered
----
1. If the SQL server in new domain is a new name then, Issue the below
commands based on the new server name
sp_dropserver <Old server name>
go
sp_addserver <new server name>,Local
2. If it is new ip address
Change the connectiction string in your application server or connection
file
3. If you are using any server alias using TCP/IP
Modify the existing alias with new IP address using "CLient Network
utility"
Thanks
Hari
MCDBA
"Bar" <anonymous@.discussions.microsoft.com> wrote in message
news:701101c42fcf$29f05ad0$a601280a@.phx.gbl...
> Hi
> I wonder if the follwoing operation can be done '
> Can I move SQL Server 2000 running on Windows 2000 from
> one Domain to another ? Will the server and DB's will be
> functional '
> Thx
> Bar

Changing/Moving SQL Server 2000 to new Domain

Hi
I wonder if the follwoing operation can be done '
Can I move SQL Server 2000 running on Windows 2000 from
one Domain to another ? Will the server and DB's will be
functional '
Thx
BarHi,
No issues, Only thing is you need to create a Trust relationship with old
domain, So that users in the old domain also can access.
But the following things also need to be considered
----
1. If the SQL server in new domain is a new name then, Issue the below
commands based on the new server name
sp_dropserver <Old server name>
go
sp_addserver <new server name>,Local
2. If it is new ip address
Change the connectiction string in your application server or connection
file
3. If you are using any server alias using TCP/IP
Modify the existing alias with new IP address using "CLient Network
utility"
Thanks
Hari
MCDBA
"Bar" <anonymous@.discussions.microsoft.com> wrote in message
news:701101c42fcf$29f05ad0$a601280a@.phx.gbl...
> Hi
> I wonder if the follwoing operation can be done '
> Can I move SQL Server 2000 running on Windows 2000 from
> one Domain to another ? Will the server and DB's will be
> functional '
> Thx
> Bar

Changing Windows Domain

I have a SQL server that is in an old NT4 domain. We need to move it to a Windows 2000 domain. We tried changing the domain of the server but now the SQL services will not start. We set the sql service to use an account in the new domain and still get an access denied error when trying to start the service.

Any ideas?

Thanks,

JeffOriginally posted by jpoling
I have a SQL server that is in an old NT4 domain. We need to move it to a Windows 2000 domain. We tried changing the domain of the server but now the SQL services will not start. We set the sql service to use an account in the new domain and still get an access denied error when trying to start the service.

Any ideas?

Thanks,

Jeff

Did you change both the MSSQLServer and SQLServerAgent user ids?
Are you sure the former accounts were domain accounts and not local accounts?
Did you change the accounts in the EM?
Or did you do it in the Service Manager on the Control Panel?
Did the server name change as well?
Did the sever create an account in the new Domain?

Just throwing some of the more obvious places to look.|||I think I solved the problem. We changed the account the sql service runs as through control panel | services and not through EM. When we went back and changed it through EM first, it worked.

Thanks for the suggestions!

Jeff

Changing Windows Domain

I have a 2 node Windows 2000 Active/Passive Cluster running SQL Server 2000
Enterprise Edition. The cluster supports a 24x365, mission critical
application.
The nodes are currently members of a Windows NT4 domain which trusts a
Windows 2003 Active Directory Domain. All user and service accounts
(including SQLServer and SQLServer Agent accounts) are "ADDomain" accounts.
I am planning on using the procedure described in KBs 269196 and 319016 to
move the cluster from "NT4Domain" to the trusted "ADDomain". The TCP/IP
names and addresses will not change, and to reiterate, the user and service
accounts are already logging into the trusted domain "ADDomain", not
"NT4Domain".
When I look at 319016, however, I get the impression that that KB was
written more to address a changed TCP/IP domain as opposed to a changed
Windows domain. My questions are:
1) Does 319016 even apply in this situation?
For example, step 1 of 319016 calls for a rerun of SQLServer setup. Since
1) the TCP/IP address is not changing and 2) the SQL service account is not
changing, do I need to perform step 1? I'm not sure what all setup might be
doing there.
Also, step 2 of 319016 calls for the new TCP/IP address to be entered for
each instance. Again, the IP address is not changing. As info, there is
only the default instance.
2) I think that I need to move both nodes into the new domain and restart
the cluster service on both (with SQLServer resources kept offline) before
any SQL changes. Is that correct?
3) Assuming there are no GP changes, are there other concerns I'm
overlooking? I saw a similar question in which the admin was leaning toward
rebuilding from scratch instead of moving the cluster. That seems like a lot
more work (rebuilding systems, cluster resources, and
reinstalling/configuring applications) than moving as described above.
Thanks for any feedback
There are two major considerations involved in changing domains. First is
the security issue. The SQL Setup program rewrites the account login
information on each node. If that is not changing, you should be OK without
having to go through setup. Worst case, you can manually change the service
account information on each node. DO NOT attempt to start the service
manually on any particular node. Make sure the service accounts have the
same permissions on the host nodes after changing domains. Be aware that
the machines will now be subject to Group Policies which may change things
in unexpected ways.
The second is changing the FQDN of the system. If the IP domain is
different after the change, you may run into problems with client
connections. A DNS alias record can fix this faster than any other method.
If the actual host names change, then a cluster rebuild may actually be
faster. The other way to handle node renaming is to kick out each node one
at a time, change the host name, add it back to the cluster, reinstall SQL,
reapply hotfixes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"CarolinaKB" <CarolinaKB@.discussions.microsoft.com> wrote in message
news:CB00A57B-A0E5-450D-9C83-9818B7883595@.microsoft.com...
>I have a 2 node Windows 2000 Active/Passive Cluster running SQL Server 2000
> Enterprise Edition. The cluster supports a 24x365, mission critical
> application.
> The nodes are currently members of a Windows NT4 domain which trusts a
> Windows 2003 Active Directory Domain. All user and service accounts
> (including SQLServer and SQLServer Agent accounts) are "ADDomain"
> accounts.
> I am planning on using the procedure described in KBs 269196 and 319016 to
> move the cluster from "NT4Domain" to the trusted "ADDomain". The TCP/IP
> names and addresses will not change, and to reiterate, the user and
> service
> accounts are already logging into the trusted domain "ADDomain", not
> "NT4Domain".
> When I look at 319016, however, I get the impression that that KB was
> written more to address a changed TCP/IP domain as opposed to a changed
> Windows domain. My questions are:
> 1) Does 319016 even apply in this situation?
> For example, step 1 of 319016 calls for a rerun of SQLServer setup. Since
> 1) the TCP/IP address is not changing and 2) the SQL service account is
> not
> changing, do I need to perform step 1? I'm not sure what all setup might
> be
> doing there.
> Also, step 2 of 319016 calls for the new TCP/IP address to be entered for
> each instance. Again, the IP address is not changing. As info, there is
> only the default instance.
>

> 2) I think that I need to move both nodes into the new domain and restart
> the cluster service on both (with SQLServer resources kept offline) before
> any SQL changes. Is that correct?
> 3) Assuming there are no GP changes, are there other concerns I'm
> overlooking? I saw a similar question in which the admin was leaning
> toward
> rebuilding from scratch instead of moving the cluster. That seems like a
> lot
> more work (rebuilding systems, cluster resources, and
> reinstalling/configuring applications) than moving as described above.
> Thanks for any feedback
>
|||I just did this last night for a customer. If you are already using the new
domain's service account, it's pretty easy. I take it your cluster & SQL
service accounts are already in the local administrators group on each node.
Take all cluster groups offline. Join one node at a time to the new domain,
reboot, when both are back up in and in the new domain start the groups.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"CarolinaKB" <CarolinaKB@.discussions.microsoft.com> wrote in message
news:CB00A57B-A0E5-450D-9C83-9818B7883595@.microsoft.com...
>I have a 2 node Windows 2000 Active/Passive Cluster running SQL Server 2000
> Enterprise Edition. The cluster supports a 24x365, mission critical
> application.
> The nodes are currently members of a Windows NT4 domain which trusts a
> Windows 2003 Active Directory Domain. All user and service accounts
> (including SQLServer and SQLServer Agent accounts) are "ADDomain"
> accounts.
> I am planning on using the procedure described in KBs 269196 and 319016 to
> move the cluster from "NT4Domain" to the trusted "ADDomain". The TCP/IP
> names and addresses will not change, and to reiterate, the user and
> service
> accounts are already logging into the trusted domain "ADDomain", not
> "NT4Domain".
> When I look at 319016, however, I get the impression that that KB was
> written more to address a changed TCP/IP domain as opposed to a changed
> Windows domain. My questions are:
> 1) Does 319016 even apply in this situation?
> For example, step 1 of 319016 calls for a rerun of SQLServer setup. Since
> 1) the TCP/IP address is not changing and 2) the SQL service account is
> not
> changing, do I need to perform step 1? I'm not sure what all setup might
> be
> doing there.
> Also, step 2 of 319016 calls for the new TCP/IP address to be entered for
> each instance. Again, the IP address is not changing. As info, there is
> only the default instance.
> 2) I think that I need to move both nodes into the new domain and restart
> the cluster service on both (with SQLServer resources kept offline) before
> any SQL changes. Is that correct?
> 3) Assuming there are no GP changes, are there other concerns I'm
> overlooking? I saw a similar question in which the admin was leaning
> toward
> rebuilding from scratch instead of moving the cluster. That seems like a
> lot
> more work (rebuilding systems, cluster resources, and
> reinstalling/configuring applications) than moving as described above.
> Thanks for any feedback
>
|||I think we should be okay. The IP address will not change (domains, subnets
all remain exactly the same), I'M TOLD that there are no GP changes, and the
same service account is already being used.
Also, you wrote,
> DO NOT attempt to start the service manually on any particular node.
By this, are you saying to not start SQL through the Services applet as
opposed to starting it through Cluster Administrator after completing the
migration? Just looking for clarification of the above statement.
"Geoff N. Hiten" wrote:

> There are two major considerations involved in changing domains. First is
> the security issue. The SQL Setup program rewrites the account login
> information on each node. If that is not changing, you should be OK without
> having to go through setup. Worst case, you can manually change the service
> account information on each node. DO NOT attempt to start the service
> manually on any particular node. Make sure the service accounts have the
> same permissions on the host nodes after changing domains. Be aware that
> the machines will now be subject to Group Policies which may change things
> in unexpected ways.
> The second is changing the FQDN of the system. If the IP domain is
> different after the change, you may run into problems with client
> connections. A DNS alias record can fix this faster than any other method.
> If the actual host names change, then a cluster rebuild may actually be
> faster. The other way to handle node renaming is to kick out each node one
> at a time, change the host name, add it back to the cluster, reinstall SQL,
> reapply hotfixes.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "CarolinaKB" <CarolinaKB@.discussions.microsoft.com> wrote in message
> news:CB00A57B-A0E5-450D-9C83-9818B7883595@.microsoft.com...
>
>
>
|||Great news; thanks. Like you said, the account is already in Administrators
so that's already done.
"Rodney R. Fournier [MVP]" wrote:

> I just did this last night for a customer. If you are already using the new
> domain's service account, it's pretty easy. I take it your cluster & SQL
> service accounts are already in the local administrators group on each node.
> Take all cluster groups offline. Join one node at a time to the new domain,
> reboot, when both are back up in and in the new domain start the groups.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
> class
> "CarolinaKB" <CarolinaKB@.discussions.microsoft.com> wrote in message
> news:CB00A57B-A0E5-450D-9C83-9818B7883595@.microsoft.com...
>
>
|||Piece of cake then! Good Luck!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive.../20/58233.aspx NYC Clustering
class
"CarolinaKB" <CarolinaKB@.discussions.microsoft.com> wrote in message
news:769D2D4F-D9D4-4209-8E88-356FDD592842@.microsoft.com...[vbcol=seagreen]
> Great news; thanks. Like you said, the account is already in
> Administrators
> so that's already done.
> "Rodney R. Fournier [MVP]" wrote:
|||Do not start SQL through the Services applet. Let the Cluster service
manage the SQL service startup. You can use Enterprise Mangler or the SQL
Server Service Manager tool to stop/start SQL clustered instances but I
prefer to use the Cluster admin tool.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"CarolinaKB" <CarolinaKB@.discussions.microsoft.com> wrote in message
news:7E8687AC-02C3-467E-8226-846B657BBCDD@.microsoft.com...[vbcol=seagreen]
>I think we should be okay. The IP address will not change (domains,
>subnets
> all remain exactly the same), I'M TOLD that there are no GP changes, and
> the
> same service account is already being used.
> Also, you wrote,
> By this, are you saying to not start SQL through the Services applet as
> opposed to starting it through Cluster Administrator after completing the
> migration? Just looking for clarification of the above statement.
> "Geoff N. Hiten" wrote:

Changing Windows accounts used by reporting services

I want to change the accounts used by Reporting Services processes. I am
tempted to just change the "Log on as" account for the ReportServer service
(in the Services management console) and move the Reports and ReportServer
web apps to a new Win 2003 AppPool that runs with the desired account.
Can I safely make these changes without breaking things? What rights to the
accounts I assign to the service and web apps need? I have searched Books
Online and can not find an answer.
Note that I do NOT want to change redentials for accesing the SQL Server
databases, which is what rsconfig.exe appears to be for.)Hi Stephen ,
From your descriptions, I understood that you would like to know change the
ReportServer account to limited privilege and change the application pool.
Have I understood you? Correct me if I was wrong.
Based on my knowledge, I have noticed that topic "Service Account" in BOL
specify the account under which the ReportServer Windows service runs.Here
is its link in MSDN Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSUIREF/htm
/f1_rsc_installation_v1_197m.asp
Secondly, If you have change identity of application pool to be
Configurable, make sure the account is member of IWAM_<Machine Name> and
IUSER_<Machine Name>
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Changing URL's for Reporting Services

I have installed reporting services by default into the default web site in
IIS. (I'm running Windows Server 2003) and need to move this to a branded
URL...Is my only option to uninstall/reinstall? I can take care of setting
IIS to the new URL...however what is the proper method of moving the Virtual
Directories that Reporting services installed.
Thanks
--
Report DeveloperHave you heard about the concept of URL rewriting?
You can use custom httpmodules or httphandlers to achieve you goal, or just
simply write custom web app's error 401 page.
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:F206573B-9F9A-437F-BA07-3C284F329137@.microsoft.com...
>I have installed reporting services by default into the default web site in
> IIS. (I'm running Windows Server 2003) and need to move this to a branded
> URL...Is my only option to uninstall/reinstall? I can take care of
> setting
> IIS to the new URL...however what is the proper method of moving the
> Virtual
> Directories that Reporting services installed.
> Thanks
> --
> Report Developer