problem running MS SQL Web Data Admin

Hi:
My client machine is XP Pro with SP1 with IIS 5.1 My server machine is
Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a,
in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it.
I can use webadmin on the server to access data in MSDE using windows auth
as well as SQL login.
I then installed webadmin on the Client machine but can't get it to connect
to the MSDE on the server machine. I looked at KB article: 319930 and
ensured that test.udl on client XP machine can connect fine using TCP/IP and
sa userid to the MSDE on the server machine. But webadmin won't connect.
Here's the error message:
Server Error in '/webadmin' Application.
COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not
valid or not registered.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: COM object
with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
registered.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[COMException (0x80040154): COM object with CLSID
{10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
registered.]
SqlAdmin.SqlServer.Connect()
SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) +28
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Other ASP.NET starter kit apps (like Commerce and Portal) work fine from
Client machine using MSDE on the server. The problem seems to be with
webadmin. Any suggestions would be appreciated.
Vamsee Lakamsani
lakamsani AT gmail.com
The web data admin package needs a dll called SQLDMO.dll that is a com object that is only installed from the full version of SQL server, not with MSDE. That is the com object error message you are receiving.
"vl" wrote:

> Hi:
> My client machine is XP Pro with SP1 with IIS 5.1 My server machine is
> Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a,
> in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it.
> I can use webadmin on the server to access data in MSDE using windows auth
> as well as SQL login.
> I then installed webadmin on the Client machine but can't get it to connect
> to the MSDE on the server machine. I looked at KB article: 319930 and
> ensured that test.udl on client XP machine can connect fine using TCP/IP and
> sa userid to the MSDE on the server machine. But webadmin won't connect.
> Here's the error message:
> --
> Server Error in '/webadmin' Application.
> ----
> --
> COM object with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not
> valid or not registered.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.COMException: COM object
> with CLSID {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
> registered.
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> Stack Trace:
>
> [COMException (0x80040154): COM object with CLSID
> {10020200-E260-11CF-AE68-00AA004A34D5} is either not valid or not
> registered.]
> SqlAdmin.SqlServer.Connect()
> SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e) +28
> System.Web.UI.Control.OnLoad(EventArgs e) +67
> System.Web.UI.Control.LoadRecursive() +35
> System.Web.UI.Page.ProcessRequestMain() +731
>
>
> ----
> --
> Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
> Version:1.1.4322.573
> Other ASP.NET starter kit apps (like Commerce and Portal) work fine from
> Client machine using MSDE on the server. The problem seems to be with
> webadmin. Any suggestions would be appreciated.
> --
> Vamsee Lakamsani
> lakamsani AT gmail.com
>
>

Problem restoring a "*.bak" file

I have a Demo db in a MSDE instance called "Instance1"
I used the "RESTORE Database..." statement to back it up into a file called
"demo.bak"
I moved that file onto another machine which is MSDE with an instance
called "MyInstance" and I tried restoring with this line:
RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
It gives the error:
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft
SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
location for the file.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft
SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I tried with both a newly created blank database called demo in the
destination server and without. It says the same thing.
I seriously don't understand anything of this Errormessage, what should I do
to be able to restore this "demo.bak" onto another machine?
I was looking a little bit into the WITH MOVE thing, but I could figure it
out.
(so you know.. I''m a .NET programmer and haven't messed around with these
backup/restore thingies before)
/LarsGet Books Online, read Restore database and with move option and use it to
set correct destination of files - path to files is kept in the backup but
on this computer there are no such folder.
Bojidar Alexandrov
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file
called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>|||By default SQL Server will try to restore to the same location. If the path
does not exist then it will fail. Use the MOVE option to move the files.
Something like this will do it.
RESTORE DATABASE XXXXX
FROM DISK = 'C:\....'
WITH MOVE 'demo_dat' TO 'C:\newlocation',
MOVE 'demo_log' TO 'C:\newlocation'
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file
called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>|||Lars,
Yes, you need to specify the MOVE parameter for each logical filename to spe
cify where these files should be
created. Use RESTORE HEADERONLY and then RESTORE FILELISTONLY to examine the
backup file, including getting
the logical file names for each database files. Then use the MOVE option to
specify where these files are to
be created. And don't create the destination database first, it will be crea
ted for you when you do the
RESTORE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file calle
d
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program Files\Microsof
t
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program Files\Microsof
t
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>|||Thank you! It works now with those "With MOVE, MOVE". thankx!
/Lars
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> skrev i meddelandet
news:uUaxok0MEHA.2628@.TK2MSFTNGP12.phx.gbl...
> By default SQL Server will try to restore to the same location. If the
path
> does not exist then it will fail. Use the MOVE option to move the files.
> Something like this will do it.
> RESTORE DATABASE XXXXX
> FROM DISK = 'C:\....'
> WITH MOVE 'demo_dat' TO 'C:\newlocation',
> MOVE 'demo_log' TO 'C:\newlocation'
> --
> Barry McAuslin
> Look inside your SQL Server files with SQL File Explorer.
> Go to http://www.sqlfe.com for more information.
> "Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
> news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> called
> Files\Microsoft
> Files\Microsoft
I[vbcol=seagreen]
> do
it[vbcol=seagreen]
these[vbcol=seagreen]
>

Problem restoring a "*.bak" file

I have a Demo db in a MSDE instance called "Instance1"
I used the "RESTORE Database..." statement to back it up into a file called
"demo.bak"
I moved that file onto another machine which is MSDE with an instance
called "MyInstance" and I tried restoring with this line:
RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
It gives the error:
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft
SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
location for the file.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft
SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I tried with both a newly created blank database called demo in the
destination server and without. It says the same thing.
I seriously don't understand anything of this Errormessage, what should I do
to be able to restore this "demo.bak" onto another machine?
I was looking a little bit into the WITH MOVE thing, but I could figure it
out.
(so you know.. I''m a .NET programmer and haven't messed around with these
backup/restore thingies before)
/Lars
Get Books Online, read Restore database and with move option and use it to
set correct destination of files - path to files is kept in the backup but
on this computer there are no such folder.
Bojidar Alexandrov
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file
called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>
|||By default SQL Server will try to restore to the same location. If the path
does not exist then it will fail. Use the MOVE option to move the files.
Something like this will do it.
RESTORE DATABASE XXXXX
FROM DISK = 'C:\....'
WITH MOVE 'demo_dat' TO 'C:\newlocation',
MOVE 'demo_log' TO 'C:\newlocation'
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file
called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>
|||Lars,
Yes, you need to specify the MOVE parameter for each logical filename to specify where these files should be
created. Use RESTORE HEADERONLY and then RESTORE FILELISTONLY to examine the backup file, including getting
the logical file names for each database files. Then use the MOVE option to specify where these files are to
be created. And don't create the destination database first, it will be created for you when you do the
RESTORE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>
|||Thank you! It works now with those "With MOVE, MOVE". thankx!
/Lars
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> skrev i meddelandet
news:uUaxok0MEHA.2628@.TK2MSFTNGP12.phx.gbl...
> By default SQL Server will try to restore to the same location. If the
path[vbcol=seagreen]
> does not exist then it will fail. Use the MOVE option to move the files.
> Something like this will do it.
> RESTORE DATABASE XXXXX
> FROM DISK = 'C:\....'
> WITH MOVE 'demo_dat' TO 'C:\newlocation',
> MOVE 'demo_log' TO 'C:\newlocation'
> --
> Barry McAuslin
> Look inside your SQL Server files with SQL File Explorer.
> Go to http://www.sqlfe.com for more information.
> "Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
> news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> called
> Files\Microsoft
> Files\Microsoft
I[vbcol=seagreen]
> do
it[vbcol=seagreen]
these
>

Problem restoring a "*.bak" file

I have a Demo db in a MSDE instance called "Instance1"
I used the "RESTORE Database..." statement to back it up into a file called
"demo.bak"
I moved that file onto another machine which is MSDE with an instance
called "MyInstance" and I tried restoring with this line:
RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
It gives the error:
Server: Msg 5105, Level 16, State 2, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft
SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
location for the file.
Server: Msg 5105, Level 16, State 1, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft
SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
Server: Msg 3156, Level 16, State 1, Line 1
File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
location for the file.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I tried with both a newly created blank database called demo in the
destination server and without. It says the same thing.
I seriously don't understand anything of this Errormessage, what should I do
to be able to restore this "demo.bak" onto another machine?
I was looking a little bit into the WITH MOVE thing, but I could figure it
out.
(so you know.. I''m a .NET programmer and haven't messed around with these
backup/restore thingies before)
/LarsGet Books Online, read Restore database and with move option and use it to
set correct destination of files - path to files is kept in the backup but
on this computer there are no such folder.
Bojidar Alexandrov
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file
called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>|||By default SQL Server will try to restore to the same location. If the path
does not exist then it will fail. Use the MOVE option to move the files.
Something like this will do it.
RESTORE DATABASE XXXXX
FROM DISK = 'C:\....'
WITH MOVE 'demo_dat' TO 'C:\newlocation',
MOVE 'demo_log' TO 'C:\newlocation'
--
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file
called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program
Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I
do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>|||Lars,
Yes, you need to specify the MOVE parameter for each logical filename to specify where these files should be
created. Use RESTORE HEADERONLY and then RESTORE FILELISTONLY to examine the backup file, including getting
the logical file names for each database files. Then use the MOVE option to specify where these files are to
be created. And don't create the destination database first, it will be created for you when you do the
RESTORE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> I have a Demo db in a MSDE instance called "Instance1"
> I used the "RESTORE Database..." statement to back it up into a file called
> "demo.bak"
> I moved that file onto another machine which is MSDE with an instance
> called "MyInstance" and I tried restoring with this line:
> RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> It gives the error:
> Server: Msg 5105, Level 16, State 2, Line 1
> Device activation error. The physical file name 'C:\Program Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 5105, Level 16, State 1, Line 1
> Device activation error. The physical file name 'C:\Program Files\Microsoft
> SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> Server: Msg 3156, Level 16, State 1, Line 1
> File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> location for the file.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> I tried with both a newly created blank database called demo in the
> destination server and without. It says the same thing.
> I seriously don't understand anything of this Errormessage, what should I do
> to be able to restore this "demo.bak" onto another machine?
> I was looking a little bit into the WITH MOVE thing, but I could figure it
> out.
> (so you know.. I''m a .NET programmer and haven't messed around with these
> backup/restore thingies before)
> /Lars
>|||Thank you! It works now with those "With MOVE, MOVE". thankx!
/Lars
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> skrev i meddelandet
news:uUaxok0MEHA.2628@.TK2MSFTNGP12.phx.gbl...
> By default SQL Server will try to restore to the same location. If the
path
> does not exist then it will fail. Use the MOVE option to move the files.
> Something like this will do it.
> RESTORE DATABASE XXXXX
> FROM DISK = 'C:\....'
> WITH MOVE 'demo_dat' TO 'C:\newlocation',
> MOVE 'demo_log' TO 'C:\newlocation'
> --
> Barry McAuslin
> Look inside your SQL Server files with SQL File Explorer.
> Go to http://www.sqlfe.com for more information.
> "Lars Netzel" <[no_spam_please]lars.netzel@.qlogic.se> wrote in message
> news:%23mlLbe0MEHA.3016@.tk2msftngp13.phx.gbl...
> > I have a Demo db in a MSDE instance called "Instance1"
> >
> > I used the "RESTORE Database..." statement to back it up into a file
> called
> > "demo.bak"
> >
> > I moved that file onto another machine which is MSDE with an instance
> > called "MyInstance" and I tried restoring with this line:
> >
> > RESTORE DATABASE demo FROM DISK ='C:\demo.bak'
> >
> > It gives the error:
> >
> > Server: Msg 5105, Level 16, State 2, Line 1
> > Device activation error. The physical file name 'C:\Program
> Files\Microsoft
> > SQL Server\MSSQL$Instance1\Data\demo.mdf' may be incorrect.
> > Server: Msg 3156, Level 16, State 1, Line 1
> > File 'demo_dat' cannot be restored to 'C:\Program Files\Microsoft SQL
> > Server\MSSQL$Instance1\Data\demo.mdf'. Use WITH MOVE to identify a valid
> > location for the file.
> > Server: Msg 5105, Level 16, State 1, Line 1
> > Device activation error. The physical file name 'C:\Program
> Files\Microsoft
> > SQL Server\MSSQL$Instance1\Data\demo.ldf' may be incorrect.
> > Server: Msg 3156, Level 16, State 1, Line 1
> > File 'demo_log' cannot be restored to 'C:\Program Files\Microsoft SQL
> > Server\MSSQL$Instance1\Data\demo.ldf'. Use WITH MOVE to identify a valid
> > location for the file.
> > Server: Msg 3013, Level 16, State 1, Line 1
> > RESTORE DATABASE is terminating abnormally.
> >
> > I tried with both a newly created blank database called demo in the
> > destination server and without. It says the same thing.
> >
> > I seriously don't understand anything of this Errormessage, what should
I
> do
> > to be able to restore this "demo.bak" onto another machine?
> >
> > I was looking a little bit into the WITH MOVE thing, but I could figure
it
> > out.
> >
> > (so you know.. I''m a .NET programmer and haven't messed around with
these
> > backup/restore thingies before)
> >
> > /Lars
> >
> >
>sql

Problem of MSDE 2000 Release A Installation

Hi,
I'm new user for MSDE 2000 Release A.
Recently i have downloading MSDE2000A.exe and extract the MSDE 2000 Release
A installation files under folder name MSDERelA.
I have read thrg the document but still failed to install a new instance of
Desktop Engine for win XP .
Command Prompt:
C:\MSDERelA\Setup>SAPWD="xxxxx"
'SAPWD' is not recognized as an internal or external command,
operable program or batch file.
I think i'm missed interpreting the installation way.
Can anybody explain wht's the meaning of the below statement? Where can i
find
Windows Authentication Mode?
......To install a default instance configured to use Windows Authentication
Mode, execute: ..........
Appreciating any command suggestion for the above.
Thanks.
Regards
Chris
Try:
setup /sapwd xxxx
or put
[Options]
sapwd=xxxx
in setup.ini
SQL Server has multiple layers of security. The first one determines who can
talk to SQL Server (regardless of any attached databases). Windows
Authentication, the new default, lets anyone with a Windows login talk to
SQL Server. The old method, called SQL Server Authentication, requires a
user name and password instead. There exists Mixed Mode Authentication,
which will allow both, for instance in case you want to allow some user over
the network to access some parts of a database, you first have to allow him
to talk to SQL Server. Windows Authentication is the recommended mode,
unless you have a reason to allow login by name and password.
I'm rather new to all this, so some things I've told you might be wrong.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
> Hi,
> I'm new user for MSDE 2000 Release A.
> Recently i have downloading MSDE2000A.exe and extract the MSDE 2000
> Release
> A installation files under folder name MSDERelA.
> I have read thrg the document but still failed to install a new instance
> of
> Desktop Engine for win XP .
> Command Prompt:
> C:\MSDERelA\Setup>SAPWD="xxxxx"
> 'SAPWD' is not recognized as an internal or external command,
> operable program or batch file.
> I think i'm missed interpreting the installation way.
> Can anybody explain wht's the meaning of the below statement? Where can i
> find
> Windows Authentication Mode?
> .....To install a default instance configured to use Windows
> Authentication
> Mode, execute: ..........
> Appreciating any command suggestion for the above.
> Thanks.
> Regards
> Chris
>
>
>
>
>
|||Thanks for the explaination. I have tried again with the command-
C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
C:\MSDERelA\Setup>
System Prompt msg "pls go to control panel to install &configure your sys
component". Any idea what does it mean?
Below are the files in folder MSDERelA:
-- folder Msi, folder Setup (sql window installer pcks/patches),
autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
sqlresld.dll
Did i wrote a command to a wrong file?
Anybody can help to suggest a new command?
Thanks
Chris
"Paul Pedersen" wrote:

> Try:
> setup /sapwd xxxx
> or put
> [Options]
> sapwd=xxxx
> in setup.ini
>
> SQL Server has multiple layers of security. The first one determines who can
> talk to SQL Server (regardless of any attached databases). Windows
> Authentication, the new default, lets anyone with a Windows login talk to
> SQL Server. The old method, called SQL Server Authentication, requires a
> user name and password instead. There exists Mixed Mode Authentication,
> which will allow both, for instance in case you want to allow some user over
> the network to access some parts of a database, you first have to allow him
> to talk to SQL Server. Windows Authentication is the recommended mode,
> unless you have a reason to allow login by name and password.
> I'm rather new to all this, so some things I've told you might be wrong.
>
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:93E4793E-ACAA-4AE1-B0DE-B0C341B76111@.microsoft.com...
>
>
|||hi,
Paul Pedersen wrote:
> Try:
> setup /sapwd xxxx
>
just a typo...
SAPWD=xxxx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I got that message too. I was running setup from a network drive. When I ran
it from a local drive, it worked.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...[vbcol=seagreen]
> Thanks for the explaination. I have tried again with the command-
> C:\MSDERelA\Setup>Setup/ SAPWD xxxxx
> C:\MSDERelA\Setup>
> System Prompt msg "pls go to control panel to install &configure your sys
> component". Any idea what does it mean?
> Below are the files in folder MSDERelA:
> -- folder Msi, folder Setup (sql window installer pcks/patches),
> autorun.txt, license.txt, ReadmeMSDE2000A.htm, setup.exe, setup.rll &
> sqlresld.dll
> Did i wrote a command to a wrong file?
> Anybody can help to suggest a new command?
> Thanks
> Chris
> "Paul Pedersen" wrote:
|||Hi,
I ran it from a local drive. Unfortunately, the same msg still being
encounter.
C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"[vbcol=seagreen]
Any hint will be sincerly appreciated..
Regards
Chris
"Paul Pedersen" wrote:

> I got that message too. I was running setup from a network drive. When I ran
> it from a local drive, it worked.
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:4DE8D5D0-9AC8-4837-8AA6-88DF10BBB921@.microsoft.com...
>
>
|||I have no other experience with that error message, but I when I ran an
internet search on the error message phrase, I got several hits. None of
them helped my situation, but maybe they will help yours.
In my case, I think it was something about Setup not finding network drives
or something like that. Does it work if you run setup with no parameters?
When I tried it, I used only
setup.exe /settings settings.ini
and kept all the switches in the ini file.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:DED2A104-30C5-4461-9EB6-9FD44B4DDC5B@.microsoft.com...[vbcol=seagreen]
> Hi,
> I ran it from a local drive. Unfortunately, the same msg still being
> encounter.
> C:\MSDERelA\Setup>Setup SAPWD=" xxxxx"
> Any hint will be sincerly appreciated..
> Regards
> Chris
>
>
> "Paul Pedersen" wrote:
|||hi,
Paul Pedersen wrote:
> In my case, I think it was something about Setup not finding network
> drives or something like that. Does it work if you run setup with no
> parameters? When I tried it, I used only
>
are File and Printer sharing set in your network configuration?
is the Server service running in your control panel->admin tools->services ?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Mine is working OK now, thank you. It's Chris who is still having a problem.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3hoakvFi25ieU1@.individual.net...
> hi,
> Paul Pedersen wrote:
> are File and Printer sharing set in your network configuration?
> is the Server service running in your control panel->admin tools->services
> ?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi,
Appreciating your guys help on my case. I tried, althg still failed to
install it. For the case, I’ll thinking to purchase a pc of Visual.net.
have a nice day's.
Regards
Chris
=======
Regards
Chris
"Paul Pedersen" wrote:

> Mine is working OK now, thank you. It's Chris who is still having a problem.
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3hoakvFi25ieU1@.individual.net...
>
>

problem msde and sql server ce

I don't know how I can make the merge replication or RDA (push - pop) whit
SQL Server CE and MSDE.
Can you give me samples?
thanks
Damiano
you have to build an application using embedded vb/vc or the compact .net
framework, then install the application on SQL CE using active sync or its
ilk.
Then the application will pull a merge subscription or download the data
using RDA.
The SQL CE bol is quite complete with samples, or get ibuyspy.
"YAMNE" <damiano_callegari@.libero.it> wrote in message
news:O3skoV7XEHA.2360@.TK2MSFTNGP10.phx.gbl...
> I don't know how I can make the merge replication or RDA (push - pop) whit
> SQL Server CE and MSDE.
> Can you give me samples?
> thanks
> Damiano
>
|||Damiano,
have a look in SQL BOL for CE
(http://msdn.microsoft.com/library/de...-us/sqlce/htm/
_lce_repl_intro_replication.asp) - there's loads of info on setting up
replication.
As for MSDE, this article
(http://support.microsoft.com/default...;en-us;Q324992) should
help: How to use replication with SQL Server 2000 Desktop Engine (MSDE 2000)
HTH,
Paul Ibison
|||> you have to build an application using embedded vb/vc or the compact .net
> framework, then install the application on SQL CE using active sync or its
> ilk.
Compact .net framework and I use sql server ce in pocket pc emulator

> Then the application will pull a merge subscription or download the data
> using RDA.
I don't know how I can use the merge replicatio between SQL CE and MSDE.
Then using RDA push is OK but Pull give me problems (?)
Where i can find samples?
damiano
|||I'm a little confused by your post.
Here is a sample of using RDA - a pull.
http://msdn.microsoft.com/library/de..._prog_push.asp
Here is a sample using Merge replication - a pull
http://msdn.microsoft.com/library/de...p?frame=t rue
Are you getting an error? It sounds like your question is a basic how to.
Follow the links above. Basically you create your project using the .Net
Compact Framework, and then deploy it to your emulator. Then using your
emulator you launch your compliled code.
Am I missing something here?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"YAMNE" <damiano_callegari@.libero.it> wrote in message
news:eHh$83DYEHA.2344@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
..net[vbcol=seagreen]
its
> Compact .net framework and I use sql server ce in pocket pc emulator
>
> I don't know how I can use the merge replicatio between SQL CE and MSDE.
> Then using RDA push is OK but Pull give me problems (?)
> Where i can find samples?
> damiano
>
|||I have a problem.
I have read the northwindCE sample but I have the MSDE and the replication
configuration fails.
how I can make this sample with msde?
Damiano
|||what error message are you getting?
Are you printing out your error messages in your app?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"YAMNE" <damiano_callegari@.libero.it> wrote in message
news:%236EHOcEYEHA.2140@.TK2MSFTNGP11.phx.gbl...
> I have a problem.
> I have read the northwindCE sample but I have the MSDE and the replication
> configuration fails.
> how I can make this sample with msde?
> Damiano
>

problem installing sp4 on msde 2000 release A

Hello,
When I try to run the setup with the parameters I need (I have a default
instance installed already) to upgrade MSDE 2000 the setup program runs with
a blue screen on background and a modal window appears showing me the
parameters (like /i /p /v etc.). It seems to me that the setup is somehow
messed (I wonder if has something to do with the Windows Installer). Can
anyone help?
Thanks!
hi Leonardo,
Leonardo wrote:
> Hello,
> When I try to run the setup with the parameters I need (I have a
> default instance installed already) to upgrade MSDE 2000 the setup
> program runs with a blue screen on background and a modal window
> appears showing me the parameters (like /i /p /v etc.). It seems to
> me that the setup is somehow messed (I wonder if has something to do
> with the Windows Installer). Can anyone help?
have you tried re-downloading the sp4 package? perhaps it' corrupted..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Problem installing pubs db in MSDE

On executing the following command:
osql -E -i instpubs.sql
I am getting the following error:
[Shared Memory] SQL Server does not exist or access denied.
[Shared Memory] ConnectionOpen (Connect())
The environment is:
1. Windows XP Professional
2. MSDE was installed using the download file 'SQL2kDeskSP3.exe' dated
5/24/2003.
3. Sample database scripts were installed using the download file
'SQL2000SampleDb.msi' dated 4/20/2004.
4. The osql command sequence was found in the
'ReadMe_SQL2000SampleDbScripts.htm', that was installed along with Sample DB
scripts.
I have done this successfully last year at my home computer. As far as I
remember, I have not used 'osql' to install the pubs and Nortwind databases.
But unfortunately, I don't remember how I did it earlier as my notes is
missing. Now I am doing it on a office computer. I am able to access the
MSDE server through VB.NET normally without any problem.
ThanQ...
Are you running OSQL on a local machine? Against a default instance?
Try specifying the server\instance name with the -S parameter.
This error doesn't have anything to do with the script you passed with the
-i parameter, it's an indication that SQL Server cannot be found (it isn't
started, name resolution isn't working, your protocol isn't accepted, etc.)
See: 328306 INF: Potential Causes of the "SQL Server Does Not Exist or
Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thankyou for your prompt. Actually I tried -S parameter with either Computer
Name or Instance Name individually.
Now I tried with both of them separated by a back-slash. This is actually
the 3rd example in the read me doc. But I was interpreting the
'ComputerName/InstanceName' as 'Computer Name or Instance Name'.
Now it got installed. The syntax I used is:
osql -E -S <ComputerName>\<InstanceName> -i instpubs.sql
ThanQ...
"Cindy Gross (MSFT)" <cgross@.online.microsoft.com> wrote in message
news:iys4wrMKEHA.3048@.cpmsftngxa10.phx.gbl...
> Are you running OSQL on a local machine? Against a default instance?
> Try specifying the server\instance name with the -S parameter.
> This error doesn't have anything to do with the script you passed with the
> -i parameter, it's an indication that SQL Server cannot be found (it isn't
> started, name resolution isn't working, your protocol isn't accepted,
etc.)
> See: 328306 INF: Potential Causes of the "SQL Server Does Not Exist or
> Access
> http://support.microsoft.com/?id=328306
> Cindy Gross, MCDBA, MCSE
> http://cindygross.tripod.com
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

Problem installing MSDE

I'm having problems installing MSDE on a windows XP maching. Running setup with the verbose script gives me this:

Property(C): OriginalDatabase = C:\MSDERelA\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Logging stopped: 04/09/2007 14:17:38 ===
MSI (c) (A4:AC) [14:17:38:817]: Note: 1: 1708
MSI (c) (A4:AC) [14:17:38:817]: Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

MSI (c) (A4:AC) [14:17:38:828]: Grabbed execution mutex.
MSI (c) (A4:AC) [14:17:38:828]: Cleaning up uninstalled install packages, if any exist
MSI (c) (A4:AC) [14:17:38:828]: MainEngineThread is returning 1603

This is just the last little bit I can post the whole thing if necessary. The installation stops and rolls back anyone have any idea what's causing this to fail? The server service is started and running normally.....

Try to reboot the machine and give a try to reinstall it......refer this link might be useful

http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql|||I've already tried removing the data files, removing the MSDE reference in the registry and rebooting. All to no avail....

Problem installing MSDE

I'm having problems installing MSDE on a windows XP maching. Running setup with the verbose script gives me this:

Property(C): OriginalDatabase = C:\MSDERelA\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): ACTION = INSTALL
=== Logging stopped: 04/09/2007 14:17:38 ===
MSI (c) (A4:AC) [14:17:38:817]: Note: 1: 1708
MSI (c) (A4:AC) [14:17:38:817]: Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.

MSI (c) (A4:AC) [14:17:38:828]: Grabbed execution mutex.
MSI (c) (A4:AC) [14:17:38:828]: Cleaning up uninstalled install packages, if any exist
MSI (c) (A4:AC) [14:17:38:828]: MainEngineThread is returning 1603

This is just the last little bit I can post the whole thing if necessary. The installation stops and rolls back anyone have any idea what's causing this to fail? The server service is started and running normally.....

Try to reboot the machine and give a try to reinstall it......refer this link might be useful

http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql|||I've already tried removing the data files, removing the MSDE reference in the registry and rebooting. All to no avail....

Problem installing MSDE

I must be doing something wrong here, i have downloaded msde and when i run the set up i get this error

The instance name specified is invalid.

Any ideasInstance Names -- Rules from BOL:

Instance Name

Enter a new instance name, or the name of the instance to maintain. Review and follow the rules for instance names.

Important It is recommended that instance names be kept to less than 10 characters. Instance names can appear in the user interface of various SQL Server and system tools; shorter names are more readable.

Instance Naming Rules

An instance name is not case-sensitive.

An instance name cannot be the terms Default or MSSQLServer.

Instance names must follow the rules for SQL Server identifiers and cannot be reserved keywords.

Instance names are limited to 16 characters.

The first character in the instance name must be a letter, an ampersand (&), an underscore (_), or a number sign (#). Acceptable letters are those defined by the Unicode Standard 2.0, which includes Latin characters a-z and A-Z, in addition to letter characters from other languages.

Subsequent characters can be:
Letters as defined in the Unicode Standard 2.0.

Decimal numbers from either Basic Latin or other national scripts.

The dollar sign ($), a number sign (#), or an underscore (_).
Embedded spaces or special characters are not allowed in instance names. Neither is the backslash (\), a comma (,), a colon (:), or the at sign (@.).

Warning Only characters that are valid in the current Microsoft Windows® code page can be used in instance names in SQL Server 2000. If a Unicode character not supported under the current code page is used, an error occurs.|||Thanks for the informative reply but it doens't mean anything to me. Sorry dumb user here. I haven't specified any names, just clicked on the setup file|||using the DOS command prompt chage directory to where you have unzipped the setup files to, ie: on my computer its C:\sql2ksp3\MSDE. Below is a snippet of the readme file that will help you out.

To install a new instance of Desktop Engine

Open a command prompt window.

From the command prompt, use the cd command to navigate to the folder containing the MSDE 2000 SP3a setup utility:
cd c:\MSDESP3aFolder\MSDE

where c:\MSDESP3aFolder is either the path to the folder into which you extracted the MSDE 2000 SP3a files, or the Desktop Engine SP3a folder on the SQL Server 2000 SP3a CD.

Execute one of the following commands:
To install a default instance configured to use Windows Authentication Mode, execute:
setup SAPWD="AStrongSAPwd"
Where AStrongSAPwd is a strong password to be assigned to the sa login.

To install a named instance configured to use Windows Authentication Mode, execute:
setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
Where AStrongSAPwd is a strong password to be assigned to the sa login and InstanceName is the name to be assigned to the instance.

To install a default instance configured to use Mixed Mode, execute:
setup SAPWD="AStrongSAPwd" SECURITYMODE=SQL
Where AStrongSAPwd is a strong password to be assigned to the sa login.

To install a named instance configured to use Mixed Mode, execute:
setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"|||Follow this:

I post this as I have tried to install MSDE sp 3 and configure it to work with Quickstart however it seems that that tasks is so difficult to do so I hope by posting it here. I can help many people who wants to solve this problem

Here is how I install the MSDE and configure it to run with quick start

Note:
1. First extract the MSDE which is download from Microsoft to C:\MSDE

2. Once installing MSDE restart and run your MSDE service
by typing net start MSSQL$NETSDK
on the command prompt and then type osql -L to see if there is any server running
3. Becareful in the second script if there is any ANDY-XP. That's my computer name, unfortunately I could not change that using %COMPUTERNAME% variable so I just leave it as it is. Remember to change it as appropriate

then Create two batch scripst:
==============================================
First batch script
==============================================
@.echo off
REM Follow these instructions for installing MSDE 2000 Sp 3:
REM You must firstly extract the MSDE setup files on C:\MSDE folder for this script to work
REM Define Variables

set MSDE_HOME = C:\MSDE
%MSDE_HOME%\Setup.exe INSTANCENAME=NetSDK SAPWD=password

REM (Once installing, please restart your computer first)

pause

save it as Setup MSDE.bat
==============================================
The second batch script
================================================
@.echo off
REM To install northwind database for the quickstart tutorial. Follow these steps

REM Define variable
SET SAMPLE_SETUP_PATH=C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Samples\Setup

REM start the MSSQL$NETSDK
net start MSSQL$NETSDK

REM Seeing whether the server running
osql -L
REM if response is none then make sure that your server MSDE instance name NetSDK is running

cd %SAMPLE_SETUP_PATH%

c:

osql -E -S ANDY-XP\NetSDK -i InstNwnd.sql

osql -E -S ANDY-XP\NetSDK -i Grocer.sql

osql -E -S ANDY-XP\NetSDK -i instpubs.sql

osql -E -S ANDY-XP\NetSDK -i Portal.sql

REM After installing the NorthWind database, you still need to add the role user and assigned permission to it

REM Look on the C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Samples\Setup\html\ConfigDetails.htm for configuring database

osql -E -S %COMPUTERNAME%\NetSDK -Q "sp_grantlogin '%COMPUTERNAME%\ASPNET'"

osql -E -S %COMPUTERNAME%\NetSDK -d Pubs -Q "sp_grantdbaccess '%COMPUTERNAME%\ASPNET'"
osql -E -S %COMPUTERNAME%\NetSDK -d Pubs -Q "sp_addrolemember 'db_owner', '%COMPUTERNAME%\ASPNET'"

osql -E -S %COMPUTERNAME%\NetSDK -d NorthWind -Q "sp_grantdbaccess '%COMPUTERNAME%\ASPNET'"
osql -E -S %COMPUTERNAME%\NetSDK -d NorthWind -Q "sp_addrolemember 'db_owner', '%COMPUTERNAME%\ASPNET'"

osql -E -S %COMPUTERNAME%\NetSDK -d Portal -Q "sp_grantdbaccess '%COMPUTERNAME%\ASPNET'"
osql -E -S %COMPUTERNAME%\NetSDK -d Portal -Q "sp_addrolemember 'db_owner', '%COMPUTERNAME%\ASPNET'"

osql -E -S %COMPUTERNAME%\NetSDK -d GrocerToGo -Q "sp_grantdbaccess '%COMPUTERNAME%\ASPNET'"
osql -E -S %COMPUTERNAME%\NetSDK -d GrocerToGo -Q "sp_addrolemember 'db_owner', '%COMPUTERNAME%\ASPNET'"

pause

save it as Configure MSDE and database.bat
==============================================

Then run the first and followed by the second batch script

Have a try and let me know if there is a mistakes on it. Any improvements can be sent to triandy_gunawan@.yahoo.com.|||Thanks guys it gathered all the info. Is that wat i need to do?|||I run it from this link
http://www.asp.net/msde/Default.aspx?tabindex=0&tabid=1

Will this give me msde. seems to be an upgrade but didn't have it in the first place|||See the link bellow for help installing MSDE

Sql Server Installation Options

Hope this helps.

Regards

Wayne Phipps|||Thanks mate. SO when is running i get a little sign on the toolbar next to the time, with a play sign in it. mssql server?|||Your partly correct but its actually the Icon for the Service Manager which allows you to start/stop an Instance of SQL Server.

If you have more than one instance of SQL Server Installed, you can double click the icon and select the specific server from the dropdown list.

Hope this helps.

Regards

Wayne Phipps

problem installing msde

after uninstalling my msde now i am not able to reinstall it. In logfile message in "failed due to stop my service of control manager".
i couldnot understand it means.
plz help.that doesn't sound like an MS error message to me. please provide the error messageexactly, word for word (makes searching easier)

problem installing MSDE

I get the following message and I am not in safe mode

any ideas

The windows installer service could not be accessed.
This can occur if you are running Windows on safe mode or
if the Windows installer is not correctly installed.
Contact your support personnel for assistance.

I'd search Google for ideas on what to do with that errormessage. It sounds like you have a problem with the Windowsinstaller, not with MSDE.

Problem installing MSDE

Hi, are days that i'm trying to install MSDE on my computer (windows XP service pack 1).
The problem is that when I run the setup program from console using SAPWD="(Some password)" SecurityMode=SQL, it fails with that error log:

--- LOG START
2003-08-15 17:56:13.12 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-08-15 17:56:13.12 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-08-15 17:56:13.12 server All rights reserved.
2003-08-15 17:56:13.12 server Server Process ID is 3076.
2003-08-15 17:56:13.12 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-08-15 17:56:13.14 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-08-15 17:56:13.18 server SQL Server configured for thread mode processing.
2003-08-15 17:56:13.21 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-08-15 17:56:13.29 spid3 Warning ******************
2003-08-15 17:56:13.29 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-08-15 17:56:13.87 spid3 Starting up database 'master'.
2003-08-15 17:56:15.76 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-08-15 17:56:15.76 spid5 Starting up database 'model'.
2003-08-15 17:56:15.87 spid3 Server name is 'ALEX'.
2003-08-15 17:56:15.87 spid3 Skipping startup of clean database id 5
2003-08-15 17:56:15.87 spid3 Skipping startup of clean database id 6
2003-08-15 17:56:15.87 spid3 Starting up database 'msdb'.
2003-08-15 17:56:17.18 spid5 Clearing tempdb database.
2003-08-15 17:56:18.70 server SQL server listening on Shared Memory.
2003-08-15 17:56:18.70 server SQL Server is ready for client connections
2003-08-15 17:56:21.43 spid5 Starting up database 'tempdb'.
2003-08-15 17:56:22.56 spid3 Recovery complete.
2003-08-15 17:56:22.56 spid3 SQL global counter collection task is created.
2003-08-15 17:56:22.93 spid3 Warning: override, autoexec procedures skipped.
2003-08-15 17:56:36.48 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
--- LOG END

if anybody can help, I would really appreciate!
Alex.http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q185/8/06.asp&NoWebContent=1

you should have googled that last line.

This article was previously published under Q185806
BUG #: Windows NT: 17812 (6.50)
SYMPTOMS
A SQL Server computer that is enabled for clustering with Microsoft Cluster Server (MSCS), may experience sudden stops of the SQL Server service and subsequent restarts of the service. The last error log terminates with the following message:

SQL Server terminating due to 'stop' request from Service Control Manager
CAUSE
The Resource DLL for the SQL Server service exports two functions used by the MSCS Cluster Manager to check for availability of the SQL Server resource at predefined intervals. There is a simple check, LooksAlive, that queries the service status through the Windows NT Service Control Manager, and a more stringent check, IsAlive, that connects to SQL Server as user "probe" and performs a simple query to the system catalog. By default, LooksAlive is fired every 5 seconds and IsAlive is fired every 60 seconds.

IsAlive uses a fixed login time-out of 15 seconds to connect to SQL Server. In situations where the server is very busy, SQL Server may fail to respond to the IsAlive login request within this interval. Thus IsAlive returns FALSE to the Cluster Manager, which issues a Terminate request and a subsequent Online request to SQL Server and the SQL Executive Resource DLL which causes both services to be stopped and restarted.
WORKAROUND
Increase the polling interval for SQL Server's IsAlive test in MSCS Cluster Administrator to decrease the chance for this to happen.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server 6.5. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://support.microsoft.com/highlights/sql.asp

For more information, contact your primary support provider.
MORE INFORMATION
If you experience sudden SQL Server restarts in a cluster environment and are unsure of the cause, enable MSCS logging by restarting the MSCS service with the system environment variable "Clusterlog=<path>". MSCS will now log all activity in the specified log file. There you will find, among others, all calls to LooksAlive and IsAlive and their outcome. In a situation where the login fails you'll find the following message in the log:

[sql65res] CheckQueryProcessorAlive: dbopen failed|||I just upgraded to XP pro, was able to get IIS running and figured out how to browse to the server on my home network from another computer.

The goal is simply to follow the instructions when setting up the ASP CSK.

I downloaded and installed MSDE receiving the same error log as shown above.

How do I...

Increase the polling interval for SQL Server's IsAlive test in MSCS Cluster Administrator to decrease the chance for this to happen.

if the only thing I have is MSDE through the ASP.net link? And according to the error log, it isn't installed, because it was 'stop'ped.

Thanks,
Chris

problem installing latest MSDE

I had three problems installing the MSDE.
First, I have SQL Server 7 tools installed and must use Enterprise Manager
to get to an SQL Server 7. When I install MSDE it kills my SQL Server 7
tools. No servers show up anymore and it says I can't add any. Uninstalling
MSDE does not put things back.
Second, no menu is created on the start menu as the instructions say will
happen. I had to look around and find the EXE files.
I am accustomed to doing all my work through Enterprise Manager. I see no
Enterprise Manager facsimile or anything to use for creating a database or
setting up tables in MSDE. ThanksSorry, I don't have a solution, but I can say the reason to why this is happening:
MSDE 2000 installs the DMO dll's. EM uses DMO. And EM7 cannot use the SQL2K DLL's. So, then MSDE
installs the SQL2K DLL's, then the install has to remove EM7 as that wouldn't work anyhow. Perhaps
there's an MSDE install option which doesn't install DMO?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"David McDivitt" <x12code-del@.del-yahoo.com> wrote in message
news:42fkrv0hcr6od8l40qvhli8d2p3j1kr9bb@.4ax.com...
> I had three problems installing the MSDE.
> First, I have SQL Server 7 tools installed and must use Enterprise Manager
> to get to an SQL Server 7. When I install MSDE it kills my SQL Server 7
> tools. No servers show up anymore and it says I can't add any. Uninstalling
> MSDE does not put things back.
> Second, no menu is created on the start menu as the instructions say will
> happen. I had to look around and find the EXE files.
> I am accustomed to doing all my work through Enterprise Manager. I see no
> Enterprise Manager facsimile or anything to use for creating a database or
> setting up tables in MSDE. Thanks
>

Problem inserting Now() into a datetime field

Hi

I am trying to insert value retrieved from Now() into a datetime field in my MSDE database, but I am getting the following error, and I have no idea what is going wrong.

Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated.

Here is the code I am using:

Dim user As String = MyContext.User.Identity.Name.ToString
Dim TimeDate As DateTime = Now()
Dim status As String = "Pending"

With SqlOrders.InsertParameters
.Item("UserName").DefaultValue = user
.Item("OrderDate").DefaultValue = TimeDate
.Item("Status").DefaultValue = status
End With
SqlOrders.Insert()

The date is being returned in this format23/03/2006 02:01:52, which is the same format as it should appear in the database.

could anyone please tell me where I am going wrong?
Datetimes don't have a format. Varchar/strings that represent a datetime have a format. Make sure your OrderDate parameter is set to a datetime datatype, and your problem should go away, probably.|||Thankyou, I added .Item("OrderDate").Type = TypeCode.DateTime and it works fine now :)