Device activation error

Hi all,
According to the requirement I need to install the database files on
U:\ and T:\ which are mapped network drives. It is giving me the error
"Device activation error. The physical file name
'T:\MSSQL$SQL01\data\product.mdf' may be incorrect."

I found an article on knowledge base which says for security reasons SQL
Server installation is not allowed in Mapped network drives but we can
disable it temporarily with the help of Trace Flag 1807 using DBCC command.

I tried that, after that also its not working.

I used the following query

USE MASTER
DBCC TRACEON(1807)
IF NOT EXISTS
(
SELECT name FROM master.dbo.sysdatabases WHERE name = N'ATEMS'
)
CREATE DATABASE ATEMS ON
(NAME = ATEMS1, FILENAME='T:\MSSQL$SQL01\data\product.mdf', SIZE = 5,
MAXSIZE = 6, FILEGROWTH = 1)
LOG ON
(NAME = ATEMSLOG1, FILENAME='U:\MSSQL$SQL01\Tlog\prdouctlog.ldf' , SIZE = 1,
MAXSIZE = 2,FILEGROWTH = 1)

also from the kb article I found that the SQL Server 2000 should give an
error number 5110 but it is giving an error number 5105 which is the number
for SQL Server 7.0

any idea why it is not working or any tips I can overcome this error?

By the way I am using MS SQL Server 2000 personal edition on Windows XP, the
KB article I found is
http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

Thanks
Pradeep
.

Relevant Pages

  • RE: Cant see mapped drives
    ... It is possible to get SQL Server to use mapped network drives, through the use of trace flag 1807. ... Check out knowledge base article #304261 for full details ...
    (microsoft.public.sqlserver.server)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... fix of 1*value and it works as you mentioned. ... To answer your question about copying between SQL Server instances I don't ... will copy between SQL Server tables carrying with it the incorrect sign bit. ... Since the cube is partitioned some of the partitions are ...
    (microsoft.public.sqlserver.server)
  • Re: How do I shrink my logfile?
    ... did not know EVERYTHING about SQL Server. ... and that can happen during a restore if you are not ... You can only change the physical file names of tempdb. ... mydb_log is not in SysFiles ...
    (microsoft.public.sqlserver.server)
  • Microsoft SQL Server Error 5123
    ... Installing it from the MS site failed without any error messages. ... under the default settings SQL Server does not allow remote connections. ... create the physical file 'C:\Documents and Settings\thisUser\My ... Settings\JKING\My Documents\Visual Studio ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: security question
    ... > I have a stand alone laptop with 2 instances of SQL Server on it. ... > Then try to park it in a role dbo, ddladmin, etc. ... > new password it tells me the password is incorrect. ...
    (microsoft.public.sqlserver.security)