renaming domain

We have a small site where we want to rename the domain and bring it into
our domain.
current names are as
domainx.local -holds SQL server cluster
domainx.net -main domain
we want to bring domainx.local into the domainx.net AD.
will will rename and migrate. Are there any tools for SQL2005?
we were planning on using the microsoft domain rename tool and ADMT3.
Any other issues with SQL?
Regards
CC
SQL itself doesn't really care what domain it is in, as long as all of the
resources and servers it has to access are still accessible the way they
were before. The only thing you will have to update is the windows service
accounts if any of them are from AD and not the local machine. Will it be
renamed or are you moving to a new domain while the old domain remains up
for a short period of time? If the latter I would recommend setting up a
trust and switching the accounts, or understanding that you might have blips
in uptime/availability.
"Ned" <Cal@.obded.org> wrote in message
news:%231UNGh2ZIHA.2000@.TK2MSFTNGP05.phx.gbl...
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
|||Hi
I assume that the machine names for the SQL Servers are not changing?
If you have granted logins to domain accounts or groups then you may need to
change them see http://support.microsoft.com/kb/298897/
John
"Ned" wrote:

> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
>

renaming domain

We have a small site where we want to rename the domain and bring it into
our domain.
current names are as
domainx.local -holds SQL server cluster
domainx.net -main domain
we want to bring domainx.local into the domainx.net AD.
will will rename and migrate. Are there any tools for SQL2005?
we were planning on using the microsoft domain rename tool and ADMT3.
Any other issues with SQL?
Regards
CCSQL itself doesn't really care what domain it is in, as long as all of the
resources and servers it has to access are still accessible the way they
were before. The only thing you will have to update is the windows service
accounts if any of them are from AD and not the local machine. Will it be
renamed or are you moving to a new domain while the old domain remains up
for a short period of time? If the latter I would recommend setting up a
trust and switching the accounts, or understanding that you might have blips
in uptime/availability.
"Ned" <Cal@.obded.org> wrote in message
news:%231UNGh2ZIHA.2000@.TK2MSFTNGP05.phx.gbl...
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>|||Hi
I assume that the machine names for the SQL Servers are not changing?
If you have granted logins to domain accounts or groups then you may need to
change them see http://support.microsoft.com/kb/298897/
John
"Ned" wrote:
> We have a small site where we want to rename the domain and bring it into
> our domain.
> current names are as
> domainx.local -holds SQL server cluster
> domainx.net -main domain
> we want to bring domainx.local into the domainx.net AD.
> will will rename and migrate. Are there any tools for SQL2005?
> we were planning on using the microsoft domain rename tool and ADMT3.
> Any other issues with SQL?
> Regards
> CC
>
>

Renaming a local file

Suppose I have an Excel file in D:\Test with the name a.xls.
Can I rename that excel file from QA of SQL SERVER in the same location or any other location?
SubhasishYou can perform any dos commands via SQL using xp_cmdshell. You must ensure the SQL server has permissions to the location where the file resides if that location is not on the SQL server.

From QA type:

xp_cmdshell 'rename D:\Test.xls Test2.xls'

That should do the trick.

-Lee
MS SQL 2000 dba
Verizon Wireless|||you might even have an activex task to do this in your DTS package. Here is the code
======================================
Function Main()
Dim fs, MyFile
Dim FileLocation
Dim FileName
Dim FileInfo

FileLocation = "D:\Test\"
FileName = "a.xls"
FileInfo = FileLocation & FileName

Set fs = CreateObject("Scripting.FileSystemObject")

If (fs.FileExists(FileInfo)) Then
fs.MoveFile (FileInfo),(FileLocation & "new_name.xls")
set fs=nothing
Main = DTSTaskExecResult_Success
exit function
Else
Main = DTSTaskExecResult_Failure
exit function
End If

End Function
===========================================

Rename existing SQL 2K to new name

Can an existing instance of SQL 2K be renamed from "Local Machine" to
"NewName"? There is only one SQL Server 2K installed on this machine. It can
be reinstalled if necessary since there is no databases added yet. Thank you
for any help you may be able to give me.
RGPHI,
No need of reinstalling, you can use the below stored procedures to rename
SQL server.
sp_dropserver <servername>
go
sp_addserver <newservername>,local
Thanks
Hari
MCDBA
"riley" <riley3@.microtek-sales.com> wrote in message
news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> Can an existing instance of SQL 2K be renamed from "Local Machine" to
> "NewName"? There is only one SQL Server 2K installed on this machine. It
can
> be reinstalled if necessary since there is no databases added yet. Thank
you
> for any help you may be able to give me.
> RGP
>|||Thank you very much for the response. It has been very helpful.
Riley
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OHpMYfRwDHA.1740@.TK2MSFTNGP12.phx.gbl...
> HI,
> No need of reinstalling, you can use the below stored procedures to rename
> SQL server.
> sp_dropserver <servername>
> go
> sp_addserver <newservername>,local
> Thanks
> Hari
> MCDBA
> "riley" <riley3@.microtek-sales.com> wrote in message
> news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> > Can an existing instance of SQL 2K be renamed from "Local Machine" to
> > "NewName"? There is only one SQL Server 2K installed on this machine. It
> can
> > be reinstalled if necessary since there is no databases added yet. Thank
> you
> > for any help you may be able to give me.
> > RGP
> >
> >
>

removing system administrators from fixed server role

Hello all,

On Analysis Services 2005 the members of the Administrators local group are also members of the fixed server role, therefore they have full control over Analysis Services databases.

I think this can be a problem becouse many system administrators don't need full control over AS. Does someone kwon how can I remove those high privileges to the local administrator?

Thank you.

Hernan.

In Management Studio right click on the server, select properties, turn on the "Show Advanced (All) Properties" option and scroll down to the bottom and set the "Security\BuiltInAdminsAreServerAdmins" property to false.|||

Thank you Darren, your post is very usefull.

Before create this thread I tried some searches in google, microsoft and BOL... I didn't get any importart results. I would like to known how you learned this.. maybe if you used a web serach... what words did you use?

|||Sorry, I can't remember. I am a bit of an SSAS junkie and it's just one of thost things I knew.