MSDE to MS SQL restore

I have a MSDE database that I am trying to restore into MS SQL 7.

I am running the following restore from Query Analyzer;

RESTORE DATABASE name
FROM DISK = 'c:\mssql7\backup\name_backup'

I am getting the following error

Server: Msg 3624, Level 20, State 1, Line 1

Location: upgraddb.cpp:214
Expression: tableIndex < ARRAY_LEN (upgradeMap)
SPID: 7
Process ID: 748

Connection Broken

Is what I'm trying to do impossible or something I'm doing wrong. Any help would be much appreciatedI don't know if this will help.

I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.|||Originally posted by machado
I don't know if this will help.

I had the same problem where I wanted to resore a MSDE database to SQL Server 2000. There was just no way. So I then used DTS to just transfer the Database to the SQL Server 2000.

I only have the backup file, I don't actually posess MSDE so as far as I know I can't actually connect to anything for a dts to work|||MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.|||Originally posted by machado
MSDE can be distributed free and is included on the MS Office Prof. 2000/XP CDs.
What I would suggest is installing MSDE on any other machine on your network and restoring the database to MSDE and then transfering the databse using DTS.

So it is :)

Thanks, I'm installing it nowsql

MSDE setup errors

I am trying install MSDE on XPSP2 pro. It fails the following set of erros
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I got some info on the possible causes of failure as below. Unfortunately
neither of them help.
If your machine name has lowercase characters then you may be hitting this
issue - http://support.microsoft.com/default...;en-us;Q285100
If you had a old instance of MSDE on the machine you may be hitting this
issue - http://support.microsoft.com/default...b;en-us;816499
"Shishir" wrote:

> I am trying install MSDE on XPSP2 pro. It fails the following set of erros
> in the setup log. These lines are from a non-verbose log I created while
> running the setup.
> Appreciate any help.
> Thanks
> Shishir
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> Setting SqlEdition property failed
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
> -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
> -- Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
>
|||hi Shishir,
Shishir wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set
> of erros in the setup log. These lines are from a non-verbose log I
> created while running the setup.
>..
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this exception is sometime related to MDAC stack corruption... as no MDAC XP
sp2 refresh is available to fix it, you can only go as indicated in
http://www.macropool.com/en/download/mdac_xp_sp2.html
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
|||I downloaded the repair tool and reregistered all the components. It still
fails the same way.
"Andrea Montanari" wrote:

> hi Shishir,
> Shishir wrote:
> this exception is sometime related to MDAC stack corruption... as no MDAC XP
> sp2 refresh is available to fix it, you can only go as indicated in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> 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
>
>
sql

MSDE questions for SharePoint and Project Server

Hi:
Appreciate if anyone can help me on the following questions:
(1) Is MSDE necessary if we wish to install Windows SharePoint Team service
and/or MS Project Server?
(2) MSDE installation problems -- please read below.
Followed article
http://msdn.microsoft.com/library/de...stsql_84xl.asp
for many many times and never succeeded -- maybe just because I am new to
this.
Using example of the article - setup SAPWD="AStrongSAPwd"
What exactly show we put inside " "? A real strong password, or as
literally the same as in the example -- AStrongSAPwd?
Do we include " " or not?
I tried once with the exact thing as - setup SAPWD="AStrongSAPwd", word by
word, and the best thing that I could get from testing (based on
http://support.microsoft.com/default...36&Product=sql )
is to have the following result: 1>
And there is no instructions for what to do next in the article. I pressed
Enter, it will become 2> and go on. I typed something else, no response at
all.
Other times, it will become as the following - which i changed to the mixed
mode but still failed.
The following error message indicates that the computer that is running SQL
Server is set to Windows Authentication only:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
connection.
I also tried the section -
How to Change Your SA Password
Still wont work.
So your advise is deeply appreciated.
Thanks in advance.
hi,
"xfile" <cou-cou@.remove.nospam.com> ha scritto nel messaggio
news:%23JlIhmdsEHA.2720@.TK2MSFTNGP12.phx.gbl
> Hi:
> Appreciate if anyone can help me on the following questions:
> (1) Is MSDE necessary if we wish to install Windows SharePoint Team
> service and/or MS Project Server?
yes... I do think SharePoint installs it' own instance of a modified MSDE
release...

> (2) MSDE installation problems -- please read below.
> Followed article
>
http://msdn.microsoft.com/library/de...stsql_84xl.asp
> for many many times and never succeeded -- maybe just because I am
> new to this.
> Using example of the article - setup SAPWD="AStrongSAPwd"
> What exactly show we put inside " "? A real strong password, or as
> literally the same as in the example -- AStrongSAPwd?
your own strong password for the special SQL Server account known as "sa",
an administrative account that can not be dropped...

> Do we include " " or not?
yes

> I tried once with the exact thing as - setup SAPWD="AStrongSAPwd",
> word by word, and the best thing that I could get from testing (based
> on
> http://support.microsoft.com/default...36&Product=sql
> ) is to have the following result: 1>
>
:-|
if you resulted in oSql.exe output
1>
that means you do not have a password for "sa" Login
else you'd would have been pompted for a password like
c:\>osql -Usa
Password: [here caret blinks]

> And there is no instructions for what to do next in the article. I
> pressed Enter, it will become 2> and go on. I typed something else,
> no response at all.
if you want to (and should) set a strong password for your "sa" login,
please repeat the described steps as above..
then at the 1> prompt, type
1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
'sa' --hit return
2>GO -- hit return
GO is a special word that will execute all the statements preceding it as a
single batch...
obviously change
'yourStrongPassword'
with your own password...

> Other times, it will become as the following - which i changed to the
> mixed mode but still failed.
> --
> The following error message indicates that the computer that is
> running SQL Server is set to Windows Authentication only:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server connection.
> --
this must be managed via Windows registry modification, as described in
http://support.microsoft.com/default...us;Q285097...
stop and restart the MSDE instance service
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi:
Thanks for your kind response and I just installed another time before
reading your message, for which the installation appears to be successful.
I use the utility - DbaMGR2k and set it to use "Trusted NT connection" and I
can see all things are there. But I still could not figure out if the
password is correct or not.
I guess what I will try to do is to install again with the "mix mode" and
leave the password blank during installation.
Then I would follow your instructions to check again if the password is
blank, if so, using the following to set a password -
1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
> 'sa' --hit return
> 2>GO -- hit return
One more question about the strong password. Do we have to strictly follow
the strong password rules for choosing the password, or could we just use
some combinations of characters and numbers?
Thanks so much.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it>
??:2t75bqF1s1tkjU1@.uni-berlin.de...
> hi,
> "xfile" <cou-cou@.remove.nospam.com> ha scritto nel messaggio
> news:%23JlIhmdsEHA.2720@.TK2MSFTNGP12.phx.gbl
> yes... I do think SharePoint installs it' own instance of a modified MSDE
> release...
> http://msdn.microsoft.com/library/de...stsql_84xl.asp
> your own strong password for the special SQL Server account known as "sa",
> an administrative account that can not be dropped...
>
> yes
>
> :-|
> if you resulted in oSql.exe output
> 1>
> that means you do not have a password for "sa" Login
> else you'd would have been pompted for a password like
> c:\>osql -Usa
> Password: [here caret blinks]
>
> if you want to (and should) set a strong password for your "sa" login,
> please repeat the described steps as above..
> then at the 1> prompt, type
> 1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
> 'sa' --hit return
> 2>GO -- hit return
> GO is a special word that will execute all the statements preceding it as
> a
> single batch...
> obviously change
> 'yourStrongPassword'
> with your own password...
>
> this must be managed via Windows registry modification, as described in
> http://support.microsoft.com/default...us;Q285097...
> stop and restart the MSDE instance service
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi:
This is an update status -- it is done.
Use mixed mode and the following instructions for changing password, I am
able to reset the password to the one I wanted,
Thanks for the kind help
"xfile" <cou-cou@.remove.nospam.com>
??:uXSTNsesEHA.2664@.TK2MSFTNGP12.phx.gbl...
> Hi:
> Thanks for your kind response and I just installed another time before
> reading your message, for which the installation appears to be successful.
> I use the utility - DbaMGR2k and set it to use "Trusted NT connection" and
> I can see all things are there. But I still could not figure out if the
> password is correct or not.
> I guess what I will try to do is to install again with the "mix mode" and
> leave the password blank during installation.
> Then I would follow your instructions to check again if the password is
> blank, if so, using the following to set a password -
> 1>sp_password @.old = NULL , @.new = 'yourStrongPassword' , @.loginame =
> One more question about the strong password. Do we have to strictly
> follow the strong password rules for choosing the password, or could we
> just use some combinations of characters and numbers?
> Thanks so much.
>
>
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it>
> ??:2t75bqF1s1tkjU1@.uni-berlin.de...
>
|||hi,
"xfile" <cou-cou@.remove.nospam.com> ha scritto nel messaggio
news:uXSTNsesEHA.2664@.TK2MSFTNGP12.phx.gbl
>....
> One more question about the strong password. Do we have to strictly
> follow the strong password rules for choosing the password, or could
> we just use some combinations of characters and numbers?
>
you should use a combination of chars and digits... this will improve the
security of your pwd... and wathc about the lenght... not just a 4 or 5
chars lenght...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

MSDE Problem

I am running MSDE (SQL Agent) and I am having the following problem:

When I setup my connection string to my table, it says that the connection was succesful. I have a asp.net page that has a text box and a button (trying to learn how to add data to a SQL table), anyways, when I input data into the text box and hit the button for it to add the data to the table I get the following error:

Error:
Login failed for user 'Discovery3\ASPNET'
Exception Details: System.Data.SqlCLient.SqlException: Login failed for user 'Discovery3\ASPNET'.

The line that is highlighted is
myConnection.Open()

Here is the code that I am using:
<>
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myConnectionString As String

If myConnectionString = "" Then
myConnectionString = "server=Discovery3;database=dbDVD;trusted_Connection=true"
End If

Dim myConnection As New Data.SqlClient.SqlConnection(myConnectionString)
Dim myInsertQuery As String = "INSERT INTO tblMaster(TITLE) values('" & TextBox1.Text & "')"
Dim myCommand As New Data.SqlClient.SqlCommand(myInsertQuery)
myCommand.Connection = myConnection
myConnection.Open()
myCommand.ExecuteNonQuery()
myCommand.Connection.Close()
End Sub

I don't understand how the connection can be succesfull, yet it errors out at the myConnection.Open() code. My table contains one field TITLE with nothing special.

Any ideas?The ASPNet user must be a user/login on the database - -|||There are a couple of solutions.

1. Go the the SQL Server and grant the ASPNET user Windows Integrated access to the server and the database "dbDVD". More general info on ASP.NET with MSDE can be found onKB 872905.
2. Use SQL authentication instead (less secure): add a SQL account to the database server, grant that account (read/write) access to the database. Change the connection string by omitting the trusted_connection flag and add a uid and pwd flag containing the user name (SQL account) and the password. To do this, you'll have to tweak the MSDE installation to allow SQL auth (you can MSN for this to find more info). However, I don't recommend this second solution.

Make sure only to grant the required access to the database that is needed from the web app; in this case likely only read/write to the tables (lowest privileges access).|||Thanks, this worked...

I got passed the permission error, but now I am getting one for the tables.

Here is the error I get now:

INSERT permission denied on object 'tblMaster', database 'master', owner 'dbo'

how do I give read/write access?

Thanks|||As explained in the aforementioned KB article, you'll need to grant access for the ASPNET login to the database (in this case "master" - side tip: I recommend to put your own private data in another database than the master!).

osql -E -S COMPUTER_NAME\VSDOTNET -Q "sp_grantlogin 'COMPUTER_NAME\ASPNET'"
osql -E -S COMPUTER_NAME\VSDOTNET -d Pubs -Q "sp_grantdbaccess 'COMPUTER_NAME\ASPNET'"
osql -E -S COMPUTER_NAME\VSDOTNET -d Pubs -Q "sp_addrolemember 'db_owner' 'COMPUTER_NAME\ASPNET'"

In here, replace the COMPUTER_NAME with the name of your computer and VSDOTNET with the name of the MSDE instance. In the second command, replace Pubs with the tables where you want to grant the ASPNET account access to.|||Thanks, I got the first to perfect it was the 'db_owner' that corrected the issue.

I appreciate the help.

MSDE Problem

Please could somebody help with the following problem? I know this may not
quite be the right newgroup to ask this question, but it is related to the
databse.
I have just installed a new install of XP Professional SP2 on my computer,
installed all the latest security updates using Windows Update. Installed XP
Embedded in the order of the splash screen menu, which included the install
on MSDE. Once installed I run a test
build which seemed to go OK, however after restarting the PC I now get the
following message when I try and run Target Designer or Component Database
Manager.
"Target Designer cannot log on to the component database on 'PC001'.
Possible causes: the database is already open by another user in exclusive
mode, or the database does not exist on server, or you do not have permission
to access the databse."
I am not sure how to check for the above or how to rectify this problem,
would appreciate some assistance.
Thanks.
hi,
skylark wrote:
> Please could somebody help with the following problem? I know this
> may not quite be the right newgroup to ask this question, but it is
> related to the databse.
> I have just installed a new install of XP Professional SP2 on my
> computer, installed all the latest security updates using Windows
> Update. Installed XP Embedded in the order of the splash screen menu,
> which included the install on MSDE. Once installed I run a test
> build which seemed to go OK, however after restarting the PC I now
> get the following message when I try and run Target Designer or
> Component Database Manager.
> "Target Designer cannot log on to the component database on 'PC001'.
> Possible causes: the database is already open by another user in
> exclusive mode, or the database does not exist on server, or you do
> not have permission to access the databse."
> I am not sure how to check for the above or how to rectify this
> problem, would appreciate some assistance.
I'm not confortable with this scenario, but IMHO this has nothing to do with
MSDE...
http://msdn.microsoft.com/library/de...ignerGuide.asp
it seems to me more related to Component Database Manager,
http://msdn.microsoft.com/library/de...nagerguide.asp ,
but agian, no idea at all about this package..
perhaps you'll have mor luck asing in microsoft.public.windowsxp.embedded
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Performance

Hi,
I have the following problem :
when I launch a query in the query analyzer I have my results within 3
seconds, and when I monitor the MSDE through the Profiler I see that he does
some 8000 reads to get his results.
When I launch the same query in a Delphi application using ADO (it's even a
test application, I only have this one query) the query runs for a minute
and in the profiler I see that he does 2.300.000 reads to get the same
result.
I only have this problem since I've updated my database, I've added some
tables, views ...
When I restore the same database on an SQL-Server I don't have this problem.
I'm really puzzled, I know that MSDE has a performance throttle but I don't
have 2GB of information and I'm the only user.
Any ideas ?
Hi Kurt,
If the queries and data are identical, the other difference could be the
query plans generated. You may need to rebuild your statistics so your
indexes get used appropriately.
Look at UPDATE STATISTICS and CREATE STATISTICS in BOL.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Kurt Duyck" <kurt.duyck@.hdp.be> wrote in message
news:OnNckyrWEHA.500@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have the following problem :
> when I launch a query in the query analyzer I have my results within 3
> seconds, and when I monitor the MSDE through the Profiler I see that he
does
> some 8000 reads to get his results.
> When I launch the same query in a Delphi application using ADO (it's even
a
> test application, I only have this one query) the query runs for a minute
> and in the profiler I see that he does 2.300.000 reads to get the same
> result.
> I only have this problem since I've updated my database, I've added some
> tables, views ...
> When I restore the same database on an SQL-Server I don't have this
problem.
> I'm really puzzled, I know that MSDE has a performance throttle but I
don't
> have 2GB of information and I'm the only user.
> Any ideas ?
>
sql

MSDE not keeping an ALTER modifcation

Hi Everyone,
Today i faced the following issue : An MSDE Database I had been working
on in the morning in order to be able to upgrade our software, with
the statement:
Through Osql :
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
'PMI_Operations under 200Mb'
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb...please wait while increasing'
3)ALTER DATABASE [PMI_Operations] MODIFY FILE (NAME =
N'PMI_Operations', SIZE = 200)
'PMI_Operations under 200Mb...please wait while increasing'
1)
It worked fine.
I came back to the box in the afternoon, after rush hour, and did same
test again (
1)IF ( (SELECT currentSize= (size /128) FROM
PMI_Operations.dbo.sysfiles WHERE groupid = 1) < 200)
2)PRINT 'PMI_Operations under 200Mb'
3)GO
expecting it to not display the print message, but it did !! I had to
run the ALTER again.
What could have caused my morning ALTER to be discarded by the
Afternoon ?
Thanks for any help you can bring
Rgards
hi,
Frogbeef wrote:
> expecting it to not display the print message, but it did !! I had to
> run the ALTER again.
> What could have caused my morning ALTER to be discarded by the
> Afternoon ?
do you have a scheduled job to "shrink" databases?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

MSDE Installation failure in Windows XP

Dear all,
during an MSDE installation by a client on windows XP SP1, as well as SP2,
occurs the following error:
"InstallSQLAgentSecurity failed (IP45,LocalSystem,87)"
After this error message in the log file, one could see that the entire
installation is rolled back. The user doesn't get any message.
The server service is on.
On a windows XP SP1 by me the same installation process works fine. The
specified client has normally high security standards and it's the first time
that an MSDE is installed by them.
Any help would be highly appreciated!
Thanks in advance for the help,
Avi Joshua
CRM systems consultant
LOGO consult AG
Head office
Enzianstrasse 4a
82319 Starnberg am See
Germany
mailto:avi@.logo-consult.de
tel +49 (0700) 100 55 100
Hi Avi,
Check that Sharing is enabled on the system.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Avi Joshua" <Avi Joshua@.discussions.microsoft.com> wrote in message
news:CFA84BD4-18A8-4AC4-8AEE-B065ED28E77E@.microsoft.com...
> Dear all,
> during an MSDE installation by a client on windows XP SP1, as well as SP2,
> occurs the following error:
> "InstallSQLAgentSecurity failed (IP45,LocalSystem,87)"
> After this error message in the log file, one could see that the entire
> installation is rolled back. The user doesn't get any message.
> The server service is on.
> On a windows XP SP1 by me the same installation process works fine. The
> specified client has normally high security standards and it's the first
time
> that an MSDE is installed by them.
> Any help would be highly appreciated!
> Thanks in advance for the help,
> Avi Joshua
> CRM systems consultant
> LOGO consult AG
> Head office
> Enzianstrasse 4a
> 82319 Starnberg am See
> Germany
> mailto:avi@.logo-consult.de
> tel +49 (0700) 100 55 100
>
|||Thanks, Greg!
The file and printer sharing component was not installed on the computer.
Have a pleasant weekend,
Avi

MSDE install problems

hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.

Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.

After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.

the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt

i have attached log file.
Please help a stoopid newbie :(Please ignore this previous message, I seemed to have bypassed this old error, this old error only appeared when I don't specify an instance name.

When i do now specify one, then I get this error:

Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 0:18:23: InstallFinalize. Return value 3.

I tried numerous things but the only stuff that works is when I make a C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory and copy sqlctr.ini and sqlctr.h into it (which i poached from an install that didnt rollback).

But this results in the following error:

Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL Server\Mssql\BinnMSSQL$DONALD007\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 0:05:57: InstallFinalize. Return value 3.

Does anyone know how to solve this?
btw here are parameters

REINSTALL=All
REINSTALLMODE=omus
COLLATION=Latin1_General_CI_AS
TARGETDIR=C:\Program Files\Microsoft SQL Server\Mssql\Binn
DATADIR=C:\Program Files\Microsoft SQL Server\Mssql\Data
SAPWD=1111
INSTANCENAME=Donald007

This is a clean install of msde using sql service pack 3 on win xp pro.

I have attached a copy of my log file that is generated when this "LoadLibrary failed.." error occurs.

I also noticed that in the services i can still see a SQLSERVERAGENT even though this service is not started and the file it refers to has been deleted.

Originally posted by deekay2003
hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.

Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.

After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.

the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt

i have attached log file.
Please help a stoopid newbie :(

MSDE install on Windows 2003 SP1 application server

I am trying to install MSDE 2.8 on this OS. When I try to install, I receive the following error: Fatal error setup This setup does not support installing on this operating system

Any ideas?

Are you talking about MSDE (The Database Engine) or MDAC 2.8. MSDE normally matches the version number of the sql server version it was released under. In the case of SQL Server 2005 it is now called SQL Server Express.

|||Sorry, I am trying to install MDAC 2.8|||

I would check the version that is installed but from memory MDAC 2.8 is installed with sp 1 for windows server 2003.

"The easiest way to determine the version of MDAC is to right click on C:\Program Files\Common Files\System\ado\msado15.dll, select Properties, and then consult the Version information. The version information has the same format as that of the FullInstallVer value -- x.xx.yyyy.y, where x.xx is the version number.

An alternative way to determine the version of MDAC you’re using is to consult the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess registry key. The FullInstallVer key provides a value of the form x.xx.yyyy.y, where x.xx is the version number (e.g., if the FullInstallVer value were 2.70.7713.0, it would mean that MDAC 2.7 is installed on the system)."

MSDE Install fails. No service listed.

I installed MSDE with the following command line:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=luxing11
but when I start the system, no service and no server appears listed. How to correct this?
Gavin
Dear Andrea,
Thank you,I could find services in the control panel.
Isaac

>--Original Message--
>hi Isaac,
>"Isaac" <anonymous@.discussions.microsoft.com> ha scritto
nel messaggio[vbcol=seagreen]
>news:18b6501c44b0f$67d85540$a001280a@.phx.gbl...
click
>but it shoul'd be there =;-)
>else, go to control panel and search for the Services
Management MMC snap-in
>applet
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>

MSDE install - problem

hi,
i want to install MSDE (comes with windows embedded designer)
install stops with following event:
ERROR:
event 19011 source MSSQLServer
FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0.
WARNING:
event 19011 source MSSQLServer
(SpnRegister) : Error 1355.
any suggestions?
hi,
Zabby wrote:
> hi,
> i want to install MSDE (comes with windows embedded designer)
> install stops with following event:
> ERROR:
> event 19011 source MSSQLServer
> FillAddress(MSAFD Tcpip [TCP/IPv6]) : Error 0.
> WARNING:
> event 19011 source MSSQLServer
> (SpnRegister) : Error 1355.
> any suggestions?
if you can manually install MSDE your self, try adding the
/L*v "c:\msdelog.txt"
parameter to your call to setup.exe bootstrap installer in order to enable
verbose logging of the installation process... you can then ispect the
resulting log text file for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the found problem will be reported..
please verify File & Printer Sharing is enabled and the Server service up
and running...
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
|||thats my error:
Executing "C:\Programme\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1
-M 1 -U sa -I "MSSQLSERVER" -Q "Latin1_General_CI_AS""
MSI (c) (A8:A4) [11:05:57:062]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (CC!CC) [11:06:00:562]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
"Andrea Montanari" wrote:

> hi,
> Zabby wrote:
> if you can manually install MSDE your self, try adding the
> /L*v "c:\msdelog.txt"
> parameter to your call to setup.exe bootstrap installer in order to enable
> verbose logging of the installation process... you can then ispect the
> resulting log text file for
> RETURN VALUE 3
> entries... about 10 lines before each entry some (sometime cryptic)
> description of the found problem will be reported..
> please verify File & Printer Sharing is enabled and the Server service up
> and running...
> --
> 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
>
>
|||hi,
Zabby wrote:
> thats my error:
> Executing "C:\Programme\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
> "Latin1_General_CI_AS""
> MSI (c) (A8:A4) [11:05:57:062]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> MSI (s) (CC!CC) [11:06:00:562]: Product: Microsoft SQL Server Desktop
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this problem is usually associated to previously uninstalled instance of
MSDE, as described in
http://support.microsoft.com/default...99&Product=sql
it has been sometime reported to MDAC corruption on WinXP sp2, so I do not
know if it applys to Win2003 too, but Win2003 sp1 include the very same MDAC
stack (2.8 sp2) as WinXP sp2, you can fix as described in
http://www.macropool.com/en/download/mdac_xp_sp2.html
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
|||thank you!
grat job!
"Andrea Montanari" wrote:

> hi,
> Zabby wrote:
> this problem is usually associated to previously uninstalled instance of
> MSDE, as described in
> http://support.microsoft.com/default...99&Product=sql
> it has been sometime reported to MDAC corruption on WinXP sp2, so I do not
> know if it applys to Win2003 too, but Win2003 sp1 include the very same MDAC
> stack (2.8 sp2) as WinXP sp2, you can fix as described in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> 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
>
>

MSDE Install

Running MSDE 2000 Rel A install with the following information:
[Setup.ini File]
[Options]
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
Step 2: Reboot -- Ensure service starts.
Step 3: Extract Service Pack 4
Step 4: Run Service Pack 4 for MSDE
Step 5: Error on install of Service Pack 4 -- Specified 'Instance Name could
not be found'
Any work-arounds for Step 5 ?
Uninstalling MSDE 2000 Rel a does not uninstall all registry entrys, and
rerunning the setup files does not work and gives the following error:
'Specified Instance Name' could not be found.
Seems to work fine by taking a previous system restore point...
Are they bugs ?
I launched the MSDE 2000 Rel A(SP3) install with the following command line:
setup.exe SAPWD="sa" INSTANCENAME="Image_Archive" DISABLENETWORKPROTOCOLS=1
SECURITYMODE=SQL
After reboot the MSDE works fine.
Downloading and extract SP4 for MSDE and try to launch with the following
command line will failed:
setup.exe /upgradesp sqlrun INSTANCENAME="Image_Archive" SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=sa /L*v C:\MSDESP4Install.log
The error message that displayed:
"This product is not installed. Check if a appropiate instance of MSDE is
installed."
Ok button.
After this installation failure I try on a clean machine to install MSDE SP3
without instance name:
setup.exe SAPWD="sa" DISABLENETWORKPROTOCOLS=1 SECURITYMODE=SQL
After reboot the MSDE works fine.
Launch the SP4 with the following command line will success:
setup.exe /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa
/L*v C:\MSDESP4Install.log
So my question is the same: Is this a bug?
It seems to me that with instance name doesn't work the upgrade or I'm
missed somewhere.
|||hi,
Ketchup wrote:
> setup.exe /upgradesp sqlrun INSTANCENAME="Image_Archive"
> SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=sa /L*v
> C:\MSDESP4Install.log
try INSTANCENAME=Image_Archive
without quotes..
seem to remember this solved the problem last time I upgraded a named
instance to sp4
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
|||Thank you Andrea!That's the solution.
"Andrea Montanari" wrote:

>try INSTANCENAME=Image_Archive
> without quotes..

MSDE Exorcism

Got some problems installing the MSDE I downloaded it from
http://www.microsoft.com/sql/msde/do...s/download.asp
and ran the setup with the following command:
setup SAPWD="testpw" INSTANCENAME="test"
It installs, however, the server is never visible by the SQL Server
Service Manager (although I can type it in manually, but starting it
just tells me It's already started). Nor is it visible by Enterprise
Manager (I installed the client tools to test this). It's not visible
from a Data Link dialog but I can type the name in and connect to it
Plus, here's some additional madness.
From the datalink manager, I can connect only if I use NT integrated
security. If I try something silly like the "sa" and "testpw" which I
passed to setup, I get the error: "Test connection failed because of an
error in initializing provider. Logon failed for user 'sa'. Reason: Not
associated with a trusted SQL Server connection."
Trying to connect from another machine is fruitless.
I've tried numerous things, reversing the parameters passed to setup,
checking the MDAC version 2.7 Re(something or other). Reinstalling,
rebooting, Standing on my head. prayers, Voodoo, stuffed animal
sacrifice. Nothing works.
Any pointers?
-- xavier
Hi Xavier,
Most likely you don't have network protocols enabled. Try running
svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
enable it and restart the MSDE/SQL service.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Xavier Pacheco" <xavier@._nospam_xapware.com> wrote in message
news:%23po8a%23ZhEHA.2340@.TK2MSFTNGP11.phx.gbl...
> Got some problems installing the MSDE I downloaded it from
> http://www.microsoft.com/sql/msde/do...s/download.asp
> and ran the setup with the following command:
> setup SAPWD="testpw" INSTANCENAME="test"
> It installs, however, the server is never visible by the SQL Server
> Service Manager (although I can type it in manually, but starting it
> just tells me It's already started). Nor is it visible by Enterprise
> Manager (I installed the client tools to test this). It's not visible
> from a Data Link dialog but I can type the name in and connect to it
> Plus, here's some additional madness.
> From the datalink manager, I can connect only if I use NT integrated
> security. If I try something silly like the "sa" and "testpw" which I
> passed to setup, I get the error: "Test connection failed because of an
> error in initializing provider. Logon failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection."
> Trying to connect from another machine is fruitless.
> I've tried numerous things, reversing the parameters passed to setup,
> checking the MDAC version 2.7 Re(something or other). Reinstalling,
> rebooting, Standing on my head. prayers, Voodoo, stuffed animal
> sacrifice. Nothing works.
> Any pointers?
>
> -- xavier
|||And on top of that, if you want to log in with SQL Server authentication,
you have to chance the registry key
HKEY_local_machine\SOFTWARE\Microsoft\MSSQLSERVER\ MSSQLSERVER\LoginMode to 0
(or 2).
You can enable SQL Server authentication when you install MSDE, if you
provide the SECURITYMODE=SQL with setup.exe, together with the sa password.
Jacco Schalkwijk
SQL Server MVP
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23Pg%23EVehEHA.1888@.TK2MSFTNGP10.phx.gbl...
> Hi Xavier,
> Most likely you don't have network protocols enabled. Try running
> svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
> enable it and restart the MSDE/SQL service.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Xavier Pacheco" <xavier@._nospam_xapware.com> wrote in message
> news:%23po8a%23ZhEHA.2340@.TK2MSFTNGP11.phx.gbl...
>
|||Greg Low [MVP] wrote:

> Most likely you don't have network protocols enabled.
Bingo! That did it. Thank you very much. . Where do I send the
check? Oh wait, no, you're an MVP, you get no money. Thanks!
- x
Xavier Pacheco
Xapware Technologies Inc
www.xapware.com
Author - Delphi for .NET Developer's Guide
http://www.amazon.com/exec/obidos/ASIN/0672324431/
|||Yup, I had already done that. Thanks for the tip.
- x
Xavier Pacheco
Xapware Technologies Inc
www.xapware.com
Author - Delphi for .NET Developer's Guide
http://www.amazon.com/exec/obidos/ASIN/0672324431/

MSDE Error !

Hi,
When I try to insert 7 to 8 million of rows in MSDE Rel A
version. I get the following error "Unknown token
received from SQL Server". My simulation testing was
running fine untill 4.3 million rows in a single table.
I executed sp_spaceused system stored procedure. I get
the results as follows
DATABASE :LaneDB
DATABASE SIZE: 703.50 MB
UNALLOCATED SPACE: 105.25 MB
Please help if i am missing something.
David
hi David,
"David" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1b8c01c4e1c3$2e20a460$a401280a@.phx.gbl
> Hi,
> When I try to insert 7 to 8 million of rows in MSDE Rel A
> version. I get the following error "Unknown token
> received from SQL Server". My simulation testing was
> running fine untill 4.3 million rows in a single table.
> I executed sp_spaceused system stored procedure. I get
> the results as follows
> DATABASE :LaneDB
> DATABASE SIZE: 703.50 MB
> UNALLOCATED SPACE: 105.25 MB
> Please help if i am missing something.
> David
unfortunately there are a number of conditions that can cause this. Please
do check if your process matches any of these known bugs
http://support.microsoft.com/search/...false&numDays=
&MaxResults=25&srchstep=2&InCC_hdn=true&querySourc e=gASr_Query
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply