Joining a domain

One of our SQL servers is not joined to the company domain. We don't know why
the previous IT persons didn't join it to the domain. We're thinking to join
it to the domain now. Is there going to be a problem with that?
Thanks.
Hi
There should not be any problem. If you normally use domain accounts for the
services they will probably need to be change. If you change the server name
then you will need to follow
http://msdn2.microsoft.com/en-us/library/ms143799.aspx t o rename the SQL
Server.
John
"lwidjaya" wrote:

> One of our SQL servers is not joined to the company domain. We don't know why
> the previous IT persons didn't join it to the domain. We're thinking to join
> it to the domain now. Is there going to be a problem with that?
> Thanks.
|||Thanks for your answer. Another thing. We have another SQL server for our ERP
system and we're going to set up a new server with a new name replacing this
server. We have a number of views linked to a database in the old server. Is
there an easy way to update all views with the new server name?
Thanks.
Lisa
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> There should not be any problem. If you normally use domain accounts for the
> services they will probably need to be change. If you change the server name
> then you will need to follow
> http://msdn2.microsoft.com/en-us/library/ms143799.aspx t o rename the SQL
> Server.
> John
> "lwidjaya" wrote:
|||Hi Lisa
If your new server has a different name, you would have to create a new
linked server and drop the old one. The views can be scripted and the server
name replaced using an editor; the script(s) can then be run to re-create the
views (assuming they are not encrypted views!). You would not need to do the
scripting if you had you the view definitions in source code control.
John
"lwidjaya" wrote:
[vbcol=seagreen]
> Thanks for your answer. Another thing. We have another SQL server for our ERP
> system and we're going to set up a new server with a new name replacing this
> server. We have a number of views linked to a database in the old server. Is
> there an easy way to update all views with the new server name?
> Thanks.
>
> "John Bell" wrote:
|||Hi John:
I'm not good in DBA. Could you tell me how to script the views and run it? I
don't think the views are encrypted.
Thanks a lot,
Lisa
"John Bell" wrote:
[vbcol=seagreen]
> Hi Lisa
> If your new server has a different name, you would have to create a new
> linked server and drop the old one. The views can be scripted and the server
> name replaced using an editor; the script(s) can then be run to re-create the
> views (assuming they are not encrypted views!). You would not need to do the
> scripting if you had you the view definitions in source code control.
> John
> "lwidjaya" wrote:
|||Hi Lisa
The easiest way is to use Enterprise Manager, this assumes you have already
registered the database server.
1. Start Enterprise Manager
2. Open up the tree view so you can see the database you are wishing to
script (Under databases)
3. Right Click the database name and choose All Tasks/Generate SQL Script
4. You will Generate SQL Script dialog. Press the Show All button
5. Choose the All views check box. This will list all the views in the
Objects to be Scripted list box.
6. On the options tab, choose Windows Text (Ansi)
7. Press the OK button, this will prompt you for a file name.
You can then open this file in Query analyser and make the changes needed to
the linked server name.
You don't actually need to change these views if you dropped the existing
linked server and the created the linked server that points to the new
server, but still have the same linked server name as the old server. This
may lead to confusion though!!
HTH
John
"lwidjaya" wrote:
[vbcol=seagreen]
> Hi John:
> I'm not good in DBA. Could you tell me how to script the views and run it? I
> don't think the views are encrypted.
> Thanks a lot,
> Lisa
> "John Bell" wrote:
|||Hi John,
thanks for your reply.
So, after I created the script and made the changes, I can just run the
script, right?
Lisa
"John Bell" wrote:
[vbcol=seagreen]
> Hi Lisa
> The easiest way is to use Enterprise Manager, this assumes you have already
> registered the database server.
> 1. Start Enterprise Manager
> 2. Open up the tree view so you can see the database you are wishing to
> script (Under databases)
> 3. Right Click the database name and choose All Tasks/Generate SQL Script
> 4. You will Generate SQL Script dialog. Press the Show All button
> 5. Choose the All views check box. This will list all the views in the
> Objects to be Scripted list box.
> 6. On the options tab, choose Windows Text (Ansi)
> 7. Press the OK button, this will prompt you for a file name.
> You can then open this file in Query analyser and make the changes needed to
> the linked server name.
> You don't actually need to change these views if you dropped the existing
> linked server and the created the linked server that points to the new
> server, but still have the same linked server name as the old server. This
> may lead to confusion though!!
> HTH
> John
>
> "lwidjaya" wrote:
|||Hi Lisa
If you have created the linked server, then running the script to drop and
recreate the views in Query analyser should mean you are then using the new
server. Make sure that all the permissions are correct. You may want to do a
test run on a backup//different system before moving the live database.
John
"lwidjaya" wrote:
[vbcol=seagreen]
> Hi John,
> thanks for your reply.
> So, after I created the script and made the changes, I can just run the
> script, right?
> Lisa
> "John Bell" wrote:
|||Thanks a lot, John!
"John Bell" wrote:
[vbcol=seagreen]
> Hi Lisa
> If you have created the linked server, then running the script to drop and
> recreate the views in Query analyser should mean you are then using the new
> server. Make sure that all the permissions are correct. You may want to do a
> test run on a backup//different system before moving the live database.
> John
> "lwidjaya" wrote: