Friday, February 24, 2012
Changing machine name
into SQL Server. is there a way around this? apart from not changin the
machine name?See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>|||And a few more here :-)
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTN
GP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
>
Changing machine name
into SQL Server. is there a way around this? apart from not changin the
machine name?
See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?
|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>
|||And a few more here :-)
http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTNGP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
>
Changing machine name
into SQL Server. is there a way around this? apart from not changin the
machine name?See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
if i change the actual machine name of my SQL Server, it will not allow me
into SQL Server. is there a way around this? apart from not changin the
machine name?|||cheers for the link, quite a few handy wee tips in there!
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
> "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> if i change the actual machine name of my SQL Server, it will not allow me
> into SQL Server. is there a way around this? apart from not changin the
> machine name?
>
>|||And a few more here :-)
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Craig G" <craig.gamble@.yarrasoftware.com> wrote in message news:%23fJPJ13iEHA.3288@.TK2MSFTNGP10.phx.gbl...
> cheers for the link, quite a few handy wee tips in there!
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23WGtCv3iEHA.2448@.TK2MSFTNGP12.phx.gbl...
> > See if this helps: http://vyaskn.tripod.com/administration_faq.htm#q5
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "Craig G" <craig.gamble@.yarrasoftware.com> wrote in message
> > news:%23p753b3iEHA.1644@.tk2msftngp13.phx.gbl...
> >
> > if i change the actual machine name of my SQL Server, it will not allow me
> > into SQL Server. is there a way around this? apart from not changin the
> > machine name?
> >
> >
> >
>
Tuesday, February 14, 2012
Changing Domain for SQL Server
I've done some sniffing around but apart from one post in this
newsgroup haven't been able to find much on this topic.
We have recently moved (well, quite a while ago but that's by-the-by)
from an NT domain to an AD domain. One of our SQL Servers is still
joined to the NT domain and, since this domain is soon to be
decommissioned, I need to join this SQL Server to the AD domain.
Is there anything I should be on the lookout for WRT this move?
As far as I can see, the only thing this would cause an issue with
would be permissions for "logins" etc. This shouldn't be an issue as
the only logins on this SQL Server are either local or from Windows
Authenticated from our AD domain.
Any advice would be greatly appreciated.
Many thanks,
IanWell, we've gone ahead and moved our SQL Server to our AD domain and
all seems okay.
As previously said, there were no login issues because they were either
SQL authenticated or from our AD domain anyway.
Cheers,
Ian