Attempted to move System table

I'm trying to move the System tables off to my array that contains the DB
tables and the array that contains the Log files respectively.
For the modeldev and modellog I've issued the command:
ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME = 'D:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' )
ALTER DATABASE model MODIFY FILE ( NAME = modellog , FILENAME = 'E:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' )
Stopped the SQL Server service, and moved the tables to respective locations.
Now the SQL Server service will not start. I get the following error in the
EVT Log:
1)
FCB::Open failed: Could not open file D:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data for file number 2. OS error: 5(Access is denied.).
2)
FCB::Open: Operating system error 5(Access is denied.) occurred while
creating or opening file 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
Diagnose and correct the operating system error, and retry the operation.
3)
FCB::Open failed: Could not open file E:\Microsoft SQL
Server\MSSQL.1\MSSQL\Data for file number 1. OS error: 5(Access is denied.).
4)
FCB::Open: Operating system error 5(Access is denied.) occurred while
creating or opening file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
Diagnose and correct the operating system error, and retry the operation.
I cannot restart the service to fix it back to the original location....I'm
stuck. Thanks!
Needed to add:
I check the rights on both of those dir's, the Service Account that was
assigned to SQL at install has "Full Control" on both dir's.
TIA.
"Scott" wrote:

> I'm trying to move the System tables off to my array that contains the DB
> tables and the array that contains the Log files respectively.
> For the modeldev and modellog I've issued the command:
> ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME = 'D:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' )
> ALTER DATABASE model MODIFY FILE ( NAME = modellog , FILENAME = 'E:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' )
> Stopped the SQL Server service, and moved the tables to respective locations.
> Now the SQL Server service will not start. I get the following error in the
> EVT Log:
> 1)
> FCB::Open failed: Could not open file D:\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data for file number 2. OS error: 5(Access is denied.).
> 2)
> FCB::Open: Operating system error 5(Access is denied.) occurred while
> creating or opening file 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
> Diagnose and correct the operating system error, and retry the operation.
> 3)
> FCB::Open failed: Could not open file E:\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data for file number 1. OS error: 5(Access is denied.).
> 4)
> FCB::Open: Operating system error 5(Access is denied.) occurred while
> creating or opening file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
> Diagnose and correct the operating system error, and retry the operation.
> I cannot restart the service to fix it back to the original location....I'm
> stuck. Thanks!
|||http://support.microsoft.com/kb/224071/en-us
I would recommend that you not use the -m switch however.
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:C611977F-D987-4FD9-81BD-60D5B12013EC@.microsoft.com...
> I'm trying to move the System tables off to my array that contains the DB
> tables and the array that contains the Log files respectively.
> For the modeldev and modellog I've issued the command:
> ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME =
> 'D:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' )
> ALTER DATABASE model MODIFY FILE ( NAME = modellog , FILENAME =
> 'E:\Program
> Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\' )
> Stopped the SQL Server service, and moved the tables to respective
> locations.
> Now the SQL Server service will not start. I get the following error in
> the
> EVT Log:
> 1)
> FCB::Open failed: Could not open file D:\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data for file number 2. OS error: 5(Access is
> denied.).
> 2)
> FCB::Open: Operating system error 5(Access is denied.) occurred while
> creating or opening file 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
> Diagnose and correct the operating system error, and retry the operation.
> 3)
> FCB::Open failed: Could not open file E:\Microsoft SQL
> Server\MSSQL.1\MSSQL\Data for file number 1. OS error: 5(Access is
> denied.).
> 4)
> FCB::Open: Operating system error 5(Access is denied.) occurred while
> creating or opening file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\Data'.
> Diagnose and correct the operating system error, and retry the operation.
> I cannot restart the service to fix it back to the original
> location....I'm
> stuck. Thanks!
|||Jay,
Thanks for the link. However, this doesn't provide instructions on how to
recover from the fact that the SQL Server service will not start now.
Scott
"Jay" wrote:

> http://support.microsoft.com/kb/224071/en-us
> I would recommend that you not use the -m switch however.
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:C611977F-D987-4FD9-81BD-60D5B12013EC@.microsoft.com...
>
>
|||So I was able to login via the -T3608 switch but I'm still getting the
following error:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlcmd -q "ALTER
DATAB
SE model MODIFY FILE (Name = modeldev, FILENAME = 'E:\Microsoft SQL
Server\MSSQ
..1\MSSQL\Data\Model.mdf')"
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establ
shing a connection to the server. When connecting to SQL Server 2005, this
fail
re may be caused by the fact that under the default settings SQL Server does
no
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
"Jay" wrote:

> http://support.microsoft.com/kb/224071/en-us
> I would recommend that you not use the -m switch however.
> "Scott" <Scott@.discussions.microsoft.com> wrote in message
> news:C611977F-D987-4FD9-81BD-60D5B12013EC@.microsoft.com...
>
>
|||I think you're going to have to modify the registry directly.
Personally, I hate regedit as you can do a tremendous amount of damage.
Because of that, I won't tell you what I do know, just to go to
http://support.microsoft.com/, search on HKEY_LOCAL_MACHINE, refine the
search to your version of SQL server and select the best kb title you find.
This way, you are 100% responsible.
Good luck,
Jay
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:D366AF2E-C6D4-43AE-A200-FD3C647D02CA@.microsoft.com...[vbcol=seagreen]
> So I was able to login via the -T3608 switch but I'm still getting the
> following error:
> C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn>sqlcmd -q "ALTER
> DATAB
> SE model MODIFY FILE (Name = modeldev, FILENAME = 'E:\Microsoft SQL
> Server\MSSQ
> .1\MSSQL\Data\Model.mdf')"
> HResult 0x2, Level 16, State 1
> Named Pipes Provider: Could not open a connection to SQL Server [2].
> Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
> establ
> shing a connection to the server. When connecting to SQL Server 2005, this
> fail
> re may be caused by the fact that under the default settings SQL Server
> does
> no
> allow remote connections..
> Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
>
> "Jay" wrote: