Moving a SQL Server 2005 Cluster from one Domain to another

First, Can you move a SQL Server 2005 Cluster from one active directory domain to another? If so, what are the steps in moving a SQL Server 2005 Cluster from one domain to another?

Are there any concerns in attempting that move? I know that the domain groups are a hard dependency and that you cannot change them without doing a full reinstall. Does this have any bearing to moving a cluster between domains?

Thank you in advance for you assistance.

David P

Hey David...did you review the following 2 kb articles, they lay the process and possible pitfalls out pretty well:

How to move a Windows Cluster Server from one domain to another

http://support.microsoft.com/kb/269196/

How to change domains for a SQL Server 2000 or SQL Server 2005 failover cluster

http://support.microsoft.com/default.aspx/kb/319016/en-us#appliesto

If you review and have further questions, just post back.

HTH

Move SQL Server Management Studio Startup folder

Hello,
I recently moved the two following folders (SQL Server Management Studio,
Visual Studio 2005) to another directory but got the following error:
...Import and Export Settings tools Options page. The IDE will use your
most recent setting for this session
When I opened Enterprise Manager, it recreated the folders. I went to
Tools/Options, but couldn't find the option to change the start up location.
Any assistance with this would be appreciated.
--
Thanks in advance,
sck10Hi sck,
Thanks for using MSDN Managed Newsgroup Support.
By default, the SQL Management Studio is located at %Program Files
%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If you
moved the SQL Management Studio, please go to the folder and find the
SqlWb.exe application. What's the result? Do you get any error message?
Please provide the entire error so that we may do the further troubleshoot.
Basically, we do not recommand move the SQL Management Studio folder and
the Visual Studio 2005 folder directly. This may cause some application
could not found the referenced files. The best way to move these folder is
re-install the Visual Studio and the SQL Management Studio.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I am referencing the folders that SS2K5 makes in the "My Documents" and
where can I change the pointer to another directory.
C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
Backup
Code Snippets
Projects
Settings
Templates
Thanks,
sck10
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
> Hi sck,
> Thanks for using MSDN Managed Newsgroup Support.
> By default, the SQL Management Studio is located at %Program Files
> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If you
> moved the SQL Management Studio, please go to the folder and find the
> SqlWb.exe application. What's the result? Do you get any error message?
> Please provide the entire error so that we may do the further
troubleshoot.
> Basically, we do not recommand move the SQL Management Studio folder and
> the Visual Studio 2005 folder directly. This may cause some application
> could not found the referenced files. The best way to move these folder is
> re-install the Visual Studio and the SQL Management Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi sck10,
Thanks for the update.
My understanding of your issue is: You want to specify the location when
you create a project/ solution in SQL Management Studio. If I misunderstood
your concern, please feel free to let me know.
You could change the location where your Project store in the location
textbox. Also you can Browse to the location you want to store the project.
By default, SQL Management Studio will create the project in the My
Documents\SQL Server Management Studio\Projects folder.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#fQKPj6ZGHA.4116@.TK2MSFTNGP05.phx.gbl>
<nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Move SQL Server Management Studio Startup folder
>Date: Wed, 26 Apr 2006 08:52:15 -0500
>Lines: 49
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
>Message-ID: <eGEohiTaGHA.1240@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429301
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Wei Lu,
>I am referencing the folders that SS2K5 makes in the "My Documents" and
>where can I change the pointer to another directory.
>C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
>Backup
>Code Snippets
>Projects
>Settings
>Templates
>Thanks,
>sck10
>"Wei Lu" <weilu@.online.microsoft.com> wrote in message
>news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
>> Hi sck,
>> Thanks for using MSDN Managed Newsgroup Support.
>> By default, the SQL Management Studio is located at %Program Files
>> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe. If
you
>> moved the SQL Management Studio, please go to the folder and find the
>> SqlWb.exe application. What's the result? Do you get any error message?
>> Please provide the entire error so that we may do the further
>troubleshoot.
>> Basically, we do not recommand move the SQL Management Studio folder and
>> the Visual Studio 2005 folder directly. This may cause some application
>> could not found the referenced files. The best way to move these folder
is
>> re-install the Visual Studio and the SQL Management Studio.
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>rights.
>
>|||I have the same problem. Allow me to restate the issue from my point of
view, and maybe someone has an answer:
When I am in Management Studio and choose File... Open... File, the
standard Open File dialog box lists 3 icons in the left side: Desktop, My
Projects, and My Computer. The My Projects folder points to My Documents/SQL
Server Management Studio/My Projects.
I understand that this is the default location. I would like to CHANGE the
default location to a different folder.
There doesn't seem to be an option to set this default location in the
Management Studio Options. I tried to find the reference in the registry,
but cannot.
Alternatively, I would be happy to be able to ADD my preferred folder to
this dialog

Move SQL Server Management Studio Startup folder

Hello,
I recently moved the two following folders (SQL Server Management Studio,
Visual Studio 2005) to another directory but got the following error:
..Import and Export Settings tools Options page. The IDE will use your
most recent setting for this session
When I opened Enterprise Manager, it recreated the folders. I went to
Tools/Options, but couldn't find the option to change the start up location.
Any assistance with this would be appreciated.
--
Thanks in advance,
sck10Hi sck,
Thanks for using MSDN Managed Newsgroup Support.
By default, the SQL Management Studio is located at %Program Files
%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
\SqlWb.exe. If you
moved the SQL Management Studio, please go to the folder and find the
SqlWb.exe application. What's the result? Do you get any error message?
Please provide the entire error so that we may do the further troubleshoot.
Basically, we do not recommand move the SQL Management Studio folder and
the Visual Studio 2005 folder directly. This may cause some application
could not found the referenced files. The best way to move these folder is
re-install the Visual Studio and the SQL Management Studio.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I am referencing the folders that SS2K5 makes in the "My Documents" and
where can I change the pointer to another directory.
C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
Backup
Code Snippets
Projects
Settings
Templates
Thanks,
sck10
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
> Hi sck,
> Thanks for using MSDN Managed Newsgroup Support.
> By default, the SQL Management Studio is located at %Program Files
> %\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE
\SqlWb.exe. If you
> moved the SQL Management Studio, please go to the folder and find the
> SqlWb.exe application. What's the result? Do you get any error message?
> Please provide the entire error so that we may do the further
troubleshoot.
> Basically, we do not recommand move the SQL Management Studio folder and
> the Visual Studio 2005 folder directly. This may cause some application
> could not found the referenced files. The best way to move these folder is
> re-install the Visual Studio and the SQL Management Studio.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hi sck10,
Thanks for the update.
My understanding of your issue is: You want to specify the location when
you create a project/ solution in SQL Management Studio. If I misunderstood
your concern, please feel free to let me know.
You could change the location where your Project store in the location
textbox. Also you can Browse to the location you want to store the project.
By default, SQL Management Studio will create the project in the My
Documents\SQL Server Management Studio\Projects folder.
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#fQKPj6ZGHA.4116@.TK2MSFTNGP05.phx.gbl>
<nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Move SQL Server Management Studio Startup folder
>Date: Wed, 26 Apr 2006 08:52:15 -0500
>Lines: 49
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
>Message-ID: <eGEohiTaGHA.1240@.TK2MSFTNGP03.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:429301
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hi Wei Lu,
>I am referencing the folders that SS2K5 makes in the "My Documents" and
>where can I change the pointer to another directory.
>C:\Documents and Settings\sck10\My Documents\SQL Server Management Studio
>Backup
>Code Snippets
>Projects
>Settings
>Templates
>Thanks,
>sck10
>"Wei Lu" <weilu@.online.microsoft.com> wrote in message
>news:nSxQTvBaGHA.880@.TK2MSFTNGXA01.phx.gbl...
you[vbcol=seagreen]
>troubleshoot.
is[vbcol=seagreen]
>rights.
>
>|||I have the same problem. Allow me to restate the issue from my point of
view, and maybe someone has an answer:
When I am in Management Studio and choose File... Open... File, the
standard Open File dialog box lists 3 icons in the left side: Desktop, My
Projects, and My Computer. The My Projects folder points to My Documents/SQ
L
Server Management Studio/My Projects.
I understand that this is the default location. I would like to CHANGE the
default location to a different folder.
There doesn't seem to be an option to set this default location in the
Management Studio Options. I tried to find the reference in the registry,
but cannot.
Alternatively, I would be happy to be able to ADD my preferred folder to
this dialog

Move sql database from development machine to server with active directory

Hi all! I know I might sound stupid, but I have this problem. I have developed my database on my laptop which does not use Active directory. Lets say I access the database with: SPIDERMAN\DB1 on SQL server, where the name of my laptop is SPIDERMAN, and the database is DB1. Now, I create an SQL script from sql server and make the necessary changes, like changing the computer name to say, SUPERMAN where my deployment server's name is SUPERMAN. But when I run the SQL script on the SUPERMAN server, it gives me an error like: "User or role SUPERMAN\DB1 does not exist in this database". I have deployed databases in this way on servers without Acive directory, so I'm sure its not a mistake on my side. So how am I supposed to go around this active directory thingi! Please help me out! I'm counting on u guys!

WesI am not a guy and not an admin, Microsoft MCDBA requirements but you need the Domain account name used to install SQL Server on that network to run the script ask the Network Admin to give you the info. If there is no SQL Server on the network tell the Admin to create a Domain User account that is configured as a service account so you can install SQL Server with Network permissions because you cannot run Replication in SQL Server if SQL Server is running on the Local Systems account because SQL Server Agent will not have network permissions. Hope this helps.

Kind regards,
Gift Peddie|||Thanks, Gift Peddie! I owe u a lot! But basically, I did not really get a single word you just said! It was like arrows flying over my head! Could you pleeeeeaaaasssse elaborate a little? I would be really grateful!

Thanks anyways.
I really appreciate it.

Wes.|||Thanks I see what you are saying, sorry it must be the holidays. You need the SQL Server System Admin name and pass word to modify your script before you run it. Thanks again. Hope this helps.

Kind regards,
Gift Peddie|||Thanks,
This might help me a bit. I'm understanding it a bit now. (LOL) I can be a real idiot sometimes! Don't mind me!

Regards,
Wes.

Move database file

I want to move my database file to a new directory, I search in MS and I use the following steps:

USE master;

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'test');

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'D:\Databases\test_log.ldf');

ALTER DATABASE test

MODIFY FILE ( NAME = test,

FILENAME = 'D:\Databases\test.mdf');

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf');

ALTER DATABASE test SET ONLINE;

But I had the following errors:

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test.mdf". Operating system error 5: "5(error not found)".

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test_log.ldf". Operating system error 5: "5(error not found)".

File activation failure. The physical file name "D:\Databases\test_log.ldf" may be incorrect.

Msg 945, Level 14, State 2, Line 1

Database 'test' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Can someone tell me how to move my database to another directory (in the same server instance)?

Thanks ina dvance

In between the lines:

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

You should make sure to copy the database files to the new location. The errors point to the fact that the files aren't there. You can find step-by-step instructions here:

http://msdn2.microsoft.com/en-us/library/ms345483.aspx

Buck Woody

|||

Try using detach and attach method to copy the datbase file to new location and attach it from the new location.

Much better way to do the same

thankx

Move database file

I want to move my database file to a new directory, I search in MS and I use the following steps:

USE master;

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(N'test');

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'D:\Databases\test_log.ldf');

ALTER DATABASE test

MODIFY FILE ( NAME = test,

FILENAME = 'D:\Databases\test.mdf');

ALTER DATABASE test

MODIFY FILE ( NAME = test_Log,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\test_log.ldf');

ALTER DATABASE test SET ONLINE;

But I had the following errors:

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test.mdf". Operating system error 5: "5(error not found)".

Msg 5120, Level 16, State 101, Line 1

Unable to open the physical file "D:\Databases\test_log.ldf". Operating system error 5: "5(error not found)".

File activation failure. The physical file name "D:\Databases\test_log.ldf" may be incorrect.

Msg 945, Level 14, State 2, Line 1

Database 'test' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

Can someone tell me how to move my database to another directory (in the same server instance)?

Thanks ina dvance

In between the lines:

ALTER DATABASE test SET OFFLINE;

ALTER DATABASE test

You should make sure to copy the database files to the new location. The errors point to the fact that the files aren't there. You can find step-by-step instructions here:

http://msdn2.microsoft.com/en-us/library/ms345483.aspx

Buck Woody

|||

Try using detach and attach method to copy the datbase file to new location and attach it from the new location.

Much better way to do the same

thankx