cant start services

Sorry for the newbie question here:

I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.

How do I connect to the server?Sorry guys... I found the answer to my own question...

had to set the server to <myComputerName>\VSDOTNET

Like I said... NEWBIE question!

can't set backup retention

We have a SQL 2000 MSDE when I use maintenance plan to set up
backups, Remove files older than window, when I click on the screw down lit
for the options (minutes, hours, days, weeks, months), there is nothing to
choose.
I remember there is an msde table or something needs to add. I forgot about
it...
Any advice from Microsoft...
I have searched on google, nothing showing up except talking about SQL
2005...This is only for SQL 2000 MSDE.Hi everybody,
Can I get answer for this today'
"renhai" wrote:

> We have a SQL 2000 MSDE when I use maintenance plan to set up
> backups, Remove files older than window, when I click on the screw down li
t
> for the options (minutes, hours, days, weeks, months), there is nothing t
o
> choose.
> I remember there is an msde table or something needs to add. I forgot abou
t
> it...
> Any advice from Microsoft...
> I have searched on google, nothing showing up except talking about SQL
> 2005...This is only for SQL 2000 MSDE.
>|||I think maybe your are thinking about the missing registry
key. That process executes:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLSe
rver',
N'BackupDirectory'
If there is no BackupDirectory string value in the key
HKLM\Software\Microsoft\MSSQLServer\MSSQ
LServer, you get an
error and nothing is displayed for the time increments.
-Sue
On Fri, 19 May 2006 14:58:01 -0700, renhai
<renhai@.discussions.microsoft.com> wrote:

>We have a SQL 2000 MSDE when I use maintenance plan to set up
>backups, Remove files older than window, when I click on the screw down lit
>for the options (minutes, hours, days, weeks, months), there is nothing to
>choose.
>I remember there is an msde table or something needs to add. I forgot about
>it...
>Any advice from Microsoft...
>I have searched on google, nothing showing up except talking about SQL
>2005...This is only for SQL 2000 MSDE.sql

can't set backup retention

We have a SQL 2000 MSDE when I use maintenance plan to set up
backups, Remove files older than window, when I click on the screw down lit
for the options (minutes, hours, days, weeks, months), there is nothing to
choose.
I remember there is an msde table or something needs to add. I forgot about
it...
Any advice from Microsoft...
I have searched on google, nothing showing up except talking about SQL
2005...This is only for SQL 2000 MSDE.Hi everybody,
Can I get answer for this today'
"renhai" wrote:
> We have a SQL 2000 MSDE when I use maintenance plan to set up
> backups, Remove files older than window, when I click on the screw down lit
> for the options (minutes, hours, days, weeks, months), there is nothing to
> choose.
> I remember there is an msde table or something needs to add. I forgot about
> it...
> Any advice from Microsoft...
> I have searched on google, nothing showing up except talking about SQL
> 2005...This is only for SQL 2000 MSDE.
>|||I think maybe your are thinking about the missing registry
key. That process executes:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
N'BackupDirectory'
If there is no BackupDirectory string value in the key
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer, you get an
error and nothing is displayed for the time increments.
-Sue
On Fri, 19 May 2006 14:58:01 -0700, renhai
<renhai@.discussions.microsoft.com> wrote:
>We have a SQL 2000 MSDE when I use maintenance plan to set up
>backups, Remove files older than window, when I click on the screw down lit
>for the options (minutes, hours, days, weeks, months), there is nothing to
>choose.
>I remember there is an msde table or something needs to add. I forgot about
>it...
>Any advice from Microsoft...
>I have searched on google, nothing showing up except talking about SQL
>2005...This is only for SQL 2000 MSDE.

Cant see my DB (MSDE)

Hi! I dont know if this is the right forum to ask about MSDE.well nwy, im new in using msql and I just want to ask why does my database cant be viewed using my VB express edition. I have a database created using MSDE and I can see this using my window explorer. I tried to open the database using the Data Connection Tool of VB express edition but when I go to the directory where the database is I cant see it even I select all files.. Anyone know why? thanks!If you execute "exec sp_helpdb 'your_db_name'", you should see the listing for your database files. That's where you should go and look for files...|||

i think u got it wrong... while connecting to Microsoft SQL , you need to connect to server first and then database. You need to give the connection string or OLEDB provider etc. If i am not wrong what u r doing is you are directly connecting to Mdf files. That is not possible and that is not the way. You google for How to connect to Microsoft SQL Database using Dataconnection tool of VB Express. I am not a VB guy... so i will not be able to comment on that..

Madhu

sql

can't see MSDE icon on XP pro...

hi..
for some reason i can't see the MSDE icon on the tray (it came with
Visual Studio .NET 2002)
althought the service i running i cann't access the MSDE from access
or visual studio..
Hi,
I presume you meant to say the service is running. Are you determining that
by looking in the Services applet (in Administrative tools via Control
Panel)?
If so, when you say you can't access it from Access or Visual Studio, what
error is returned?
Are there any errors in your system or application event logs? (access the
event viewer also from Administrative tools).
Regards,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Elhanan Maayan" <emaayan@.hotmail.com> wrote in message
news:ec817d75.0405122055.77a6de3@.posting.google.co m...
> hi..
> for some reason i can't see the MSDE icon on the tray (it came with
> Visual Studio .NET 2002)
> althought the service i running i cann't access the MSDE from access
> or visual studio..

Can't replicate with cellular modem.

Using Merge replication.
Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE SP4.
Using anonymous subscribers that use the SQLMerge object to invoke
replication. Our laptops are everywhere. Some use highspeed internet, some
dialup and some cellular modems.
When using the Aircard (Wireless PC card cellular modem), after 120 seconds
the connection is being dropped. This is happening during the SQL server
initial synchronize process (and perhaps during subsequent merge processes
though they wouldn't likely be more than 120 seconds).
We of course thought it was the Aircard dropping the connection thinking
there was no activity but even when we opened a browser and surfed the
Internet during the synchronization process, it still dropped the connection.
When we simply surfed the Internet (without the synchronize process running)
it never dropped the connection.
Is there a fix? Do I need to have a function going in another thread to fake
a heartbeat to the publisher Sql server from the laptop?
Thanks!
Hello Buzz,
This is typically something you set on the modem itself. Check the configuration
of it to see if the is an auto disconnection after x minutes of inactivity.
Hilary

> Using Merge replication.
> Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE
> SP4.
> Using anonymous subscribers that use the SQLMerge object to invoke
> replication. Our laptops are everywhere. Some use highspeed internet,
> some dialup and some cellular modems.
> When using the Aircard (Wireless PC card cellular modem), after 120
> seconds the connection is being dropped. This is happening during the
> SQL server initial synchronize process (and perhaps during subsequent
> merge processes though they wouldn't likely be more than 120 seconds).
> We of course thought it was the Aircard dropping the connection
> thinking
> there was no activity but even when we opened a browser and surfed the
> Internet during the synchronization process, it still dropped the
> connection.
> When we simply surfed the Internet (without the synchronize process
> running)
> it never dropped the connection.
> Is there a fix? Do I need to have a function going in another thread
> to fake a heartbeat to the publisher Sql server from the laptop?
> Thanks!
>
|||My client has been working with the phone company on this issue. I am not
working on it directly. However, my understanding is from them that they've
rulled out the settings of the modem being an issue and supposedly the phone
company has had issues with Sql Server before. I was suppose to check on
something called Sql Server latency but that only seems to point to postings
about the time between merge agents which is totally unrelated.
Thanks,
Buzz
"Hilary Cotter" wrote:

> Hello Buzz,
> This is typically something you set on the modem itself. Check the configuration
> of it to see if the is an auto disconnection after x minutes of inactivity.
> Hilary
>
>
|||Hello Buzz,
I agree with Hilary. Based on the symptom, it seems to be network issue
related to wireless modem under high load to replication. You may want to
download or copy big files via this network or use special tool from phone
company to check the error code rate.
It is not likely SQL replicaiton will drop the connection because it is
based on higher protocols such as TCP which is not related to modem
directly.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Can't replicate with cellular modem.
| thread-index: AcXNH3N3SFSz00jSR8q0eK8whAmWuw==
| X-WBNR-Posting-Host: 68.145.59.227
| From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
| References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
<56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
| Subject: Re: Can't replicate with cellular modem.
| Date: Sun, 9 Oct 2005 15:19:01 -0700
| Lines: 49
| Message-ID: <E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:65767
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| My client has been working with the phone company on this issue. I am not
| working on it directly. However, my understanding is from them that
they've
| rulled out the settings of the modem being an issue and supposedly the
phone
| company has had issues with Sql Server before. I was suppose to check on
| something called Sql Server latency but that only seems to point to
postings
| about the time between merge agents which is totally unrelated.
|
| Thanks,
| Buzz
|
| "Hilary Cotter" wrote:
|
| > Hello Buzz,
| >
| > This is typically something you set on the modem itself. Check the
configuration
| > of it to see if the is an auto disconnection after x minutes of
inactivity.
| >
| > Hilary
| >
| > > Using Merge replication.
| > >
| > > Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE
| > > SP4.
| > >
| > > Using anonymous subscribers that use the SQLMerge object to invoke
| > > replication. Our laptops are everywhere. Some use highspeed internet,
| > > some dialup and some cellular modems.
| > >
| > > When using the Aircard (Wireless PC card cellular modem), after 120
| > > seconds the connection is being dropped. This is happening during the
| > > SQL server initial synchronize process (and perhaps during subsequent
| > > merge processes though they wouldn't likely be more than 120 seconds).
| > >
| > > We of course thought it was the Aircard dropping the connection
| > > thinking
| > > there was no activity but even when we opened a browser and surfed the
| > > Internet during the synchronization process, it still dropped the
| > > connection.
| > > When we simply surfed the Internet (without the synchronize process
| > > running)
| > > it never dropped the connection.
| > > Is there a fix? Do I need to have a function going in another thread
| > > to fake a heartbeat to the publisher Sql server from the laptop?
| > >
| > > Thanks!
| > >
| >
| >
| >
|
|||Okay, with a bit more experimentation and googling, we think it is the FTP
part of the merge replication that is dieing on us. We tried FTPing directly
and got "the connection with the server was reset". Googling showed that
people said it was because the client was running in passive, not active mode.
Another poster from 2001 said that he discovered that merge repliction FTP's
some files, processes some files and then FTP's some more. Problem with this
is that the server can shut the FTP down.
Does Merge ActiveX use passive FTP? If so, how to work around it? We are
using IIS's FTP server, can the server be set to wait longer?
"Peter Yang [MSFT]" wrote:

> Hello Buzz,
> I agree with Hilary. Based on the symptom, it seems to be network issue
> related to wireless modem under high load to replication. You may want to
> download or copy big files via this network or use special tool from phone
> company to check the error code rate.
> It is not likely SQL replicaiton will drop the connection because it is
> based on higher protocols such as TCP which is not related to modem
> directly.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Can't replicate with cellular modem.
> | thread-index: AcXNH3N3SFSz00jSR8q0eK8whAmWuw==
> | X-WBNR-Posting-Host: 68.145.59.227
> | From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
> | References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
> <56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
> | Subject: Re: Can't replicate with cellular modem.
> | Date: Sun, 9 Oct 2005 15:19:01 -0700
> | Lines: 49
> | Message-ID: <E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.replication
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:65767
> | X-Tomcat-NG: microsoft.public.sqlserver.replication
> |
> | My client has been working with the phone company on this issue. I am not
> | working on it directly. However, my understanding is from them that
> they've
> | rulled out the settings of the modem being an issue and supposedly the
> phone
> | company has had issues with Sql Server before. I was suppose to check on
> | something called Sql Server latency but that only seems to point to
> postings
> | about the time between merge agents which is totally unrelated.
> |
> | Thanks,
> | Buzz
> |
> | "Hilary Cotter" wrote:
> |
> | > Hello Buzz,
> | >
> | > This is typically something you set on the modem itself. Check the
> configuration
> | > of it to see if the is an auto disconnection after x minutes of
> inactivity.
> | >
> | > Hilary
> | >
> | > > Using Merge replication.
> | > >
> | > > Publisher is Sql Server 2000 SP4, subscribers are laptops using MSDE
> | > > SP4.
> | > >
> | > > Using anonymous subscribers that use the SQLMerge object to invoke
> | > > replication. Our laptops are everywhere. Some use highspeed internet,
> | > > some dialup and some cellular modems.
> | > >
> | > > When using the Aircard (Wireless PC card cellular modem), after 120
> | > > seconds the connection is being dropped. This is happening during the
> | > > SQL server initial synchronize process (and perhaps during subsequent
> | > > merge processes though they wouldn't likely be more than 120 seconds).
> | > >
> | > > We of course thought it was the Aircard dropping the connection
> | > > thinking
> | > > there was no activity but even when we opened a browser and surfed the
> | > > Internet during the synchronization process, it still dropped the
> | > > connection.
> | > > When we simply surfed the Internet (without the synchronize process
> | > > running)
> | > > it never dropped the connection.
> | > > Is there a fix? Do I need to have a function going in another thread
> | > > to fake a heartbeat to the publisher Sql server from the laptop?
> | > >
> | > > Thanks!
> | > >
> | >
> | >
> | >
> |
>
|||Hello Buzz,
FTP is used for the snapshot download, both during the initial application
and when the subscription is re-initialized. All other synchronizations use
SQL packets over TCP/IP to transfer data between Publisher and Subscriber.
Did you publish data over Internet? Or did you manually configure
publication to store snapshot via FTP?
You may consider create VPN connection between server/client instead of
using Interent publication.
MergePublication2 control could be used to configruation FTP feature for
snapshot on publisher.
SQL replication can only use active mode FTP. It is not possible to do
passive MODE FTP using SQL replication. The INTERNET_FLAG_PASSIVE has to
be set in FTP connection to do passive mode Ftp. However, this option is
not implemented in SQL replication.
Anyway, it is weird that FTP connection reset could drop WAN connection
because it is higher level ftp protocol based on TCPIP protocols. WAN
connection is based on lower level such as data link layer. You may want to
use different ISP/wireless modem to test this.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Can't replicate with cellular modem.
| thread-index: AcXPoPJCdBSSfQOHQ1iA5xqQ6wGeXg==
| X-WBNR-Posting-Host: 68.145.59.227
| From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
| References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
<56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
<E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
<4kdWUTWzFHA.424@.TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Can't replicate with cellular modem.
| Date: Wed, 12 Oct 2005 19:51:01 -0700
| Lines: 124
| Message-ID: <688D9A3C-5FC2-4E96-9D3A-88231CCC5DC2@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17070
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Okay, with a bit more experimentation and googling, we think it is the
FTP
| part of the merge replication that is dieing on us. We tried FTPing
directly
| and got "the connection with the server was reset". Googling showed that
| people said it was because the client was running in passive, not active
mode.
|
| Another poster from 2001 said that he discovered that merge repliction
FTP's
| some files, processes some files and then FTP's some more. Problem with
this
| is that the server can shut the FTP down.
|
| Does Merge ActiveX use passive FTP? If so, how to work around it? We are
| using IIS's FTP server, can the server be set to wait longer?
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello Buzz,
| >
| > I agree with Hilary. Based on the symptom, it seems to be network issue
| > related to wireless modem under high load to replication. You may want
to
| > download or copy big files via this network or use special tool from
phone
| > company to check the error code rate.
| >
| > It is not likely SQL replicaiton will drop the connection because it is
| > based on higher protocols such as TCP which is not related to modem
| > directly.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > ================================================== ===
| >
| >
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| > --
| > | Thread-Topic: Can't replicate with cellular modem.
| > | thread-index: AcXNH3N3SFSz00jSR8q0eK8whAmWuw==
| > | X-WBNR-Posting-Host: 68.145.59.227
| > | From: "=?Utf-8?B?QnV6eg==?=" <buzz@.online.nospam>
| > | References: <B88E11B9-6828-4098-B476-A8BEBB1CB736@.microsoft.com>
| > <56bbe4560a878c79b0e0191d820@.msnews.microsoft.com>
| > | Subject: Re: Can't replicate with cellular modem.
| > | Date: Sun, 9 Oct 2005 15:19:01 -0700
| > | Lines: 49
| > | Message-ID: <E36785DD-DA79-4A66-B81C-5053E82CB290@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.replication
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.replication:65767
| > | X-Tomcat-NG: microsoft.public.sqlserver.replication
| > |
| > | My client has been working with the phone company on this issue. I am
not
| > | working on it directly. However, my understanding is from them that
| > they've
| > | rulled out the settings of the modem being an issue and supposedly
the
| > phone
| > | company has had issues with Sql Server before. I was suppose to check
on
| > | something called Sql Server latency but that only seems to point to
| > postings
| > | about the time between merge agents which is totally unrelated.
| > |
| > | Thanks,
| > | Buzz
| > |
| > | "Hilary Cotter" wrote:
| > |
| > | > Hello Buzz,
| > | >
| > | > This is typically something you set on the modem itself. Check the
| > configuration
| > | > of it to see if the is an auto disconnection after x minutes of
| > inactivity.
| > | >
| > | > Hilary
| > | >
| > | > > Using Merge replication.
| > | > >
| > | > > Publisher is Sql Server 2000 SP4, subscribers are laptops using
MSDE
| > | > > SP4.
| > | > >
| > | > > Using anonymous subscribers that use the SQLMerge object to invoke
| > | > > replication. Our laptops are everywhere. Some use highspeed
internet,
| > | > > some dialup and some cellular modems.
| > | > >
| > | > > When using the Aircard (Wireless PC card cellular modem), after
120
| > | > > seconds the connection is being dropped. This is happening
during the
| > | > > SQL server initial synchronize process (and perhaps during
subsequent
| > | > > merge processes though they wouldn't likely be more than 120
seconds).
| > | > >
| > | > > We of course thought it was the Aircard dropping the connection
| > | > > thinking
| > | > > there was no activity but even when we opened a browser and
surfed the
| > | > > Internet during the synchronization process, it still dropped the
| > | > > connection.
| > | > > When we simply surfed the Internet (without the synchronize
process
| > | > > running)
| > | > > it never dropped the connection.
| > | > > Is there a fix? Do I need to have a function going in another
thread
| > | > > to fake a heartbeat to the publisher Sql server from the laptop?
| > | > >
| > | > > Thanks!
| > | > >
| > | >
| > | >
| > | >
| > |
| >
| >
|

cant login to Microsoft SQL Web Data Administrator with sql option

i have installed MSDE 2000 and Microsoft SQL Web Data Administrator.

at first i login using Windows Integrated option and created an account for sql login.

but when i tried to login using newly created account i get the following error.

Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.

i am using XP SP2.Is MSDE on the same machine as Microsoft SQL Web Data Administrator?|||yes, they are on the same machine.|||Is your MSDE set up to use Mixed Mode?

By default, it will use Windows Authentication. You would have had to change this default when you installed MSDE, or after installation, through manually updating a registry setting (see this KB article:MSDE security and authentication).

You should be able to use Windows Authentication pretty readily since you are working off of your local machine.

can't log in with MS SQL Web Data Administrator

Installed MSDE with the SAPWD parameter. Installed the MS SQL Web Data
Administrator, started Cassini on port 81 since it didn't like port 80.
Can't get the login to work at http://localhost:81/webadmin/default.aspx. I
keep getting "Invalid username and/or password, you are using a windows
login that is not your own, or server does not exist.". For the machine name
I tried (local), localhost, and my machine's network name, for the login I
tried the sa SQL login and my Windows login. Nothing's working. I'm
obviously doing something wrong, anyone want to clue me in?
BTW my machine is XP Pro.
TIA,
Paul
I have the same problem. Anyone any ideas?

Cant install SP4 on MSDE

I have installed MSDE 1A from the distribution. I have attempted to install
the SP4 MSDE distribution several times, using the SAME setup.ini as the one
I used to install the intance of MSDE in the first place.
I keep getting 'The instance name specified is invalid.'. I have tested
connecting to the instance from Enterprise Manager and from SQL Query
Analyzer without a problem.
Any idea what is going on?
hi Carlos,
Carlos De Matos wrote:
> I have installed MSDE 1A from the distribution. I have attempted to
> install the SP4 MSDE distribution several times, using the SAME
> setup.ini as the one I used to install the intance of MSDE in the
> first place.
> I keep getting 'The instance name specified is invalid.'. I have
> tested connecting to the instance from Enterprise Manager and from
> SQL Query Analyzer without a problem.
> Any idea what is going on?
try providing the parameters as command line params..
c:\..\>setup.exe /upgradesp SQLRUN INSTANCENAME=instanceName /L*v
"c:\msdeupg.txt"
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

Cant install MSDE Rel A

I am trying to install MSDE Rel A on a Windows XP SP2 machine with no luck no
matter what I try. I am typing the following at the command line.
setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL
Below are the portions of the error log that contain RETURN VALUE 3,
including sevral lines before and after. Any help would be appreciated.
Error the following data files were found in data directory:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
Setup has detected existing data/log files. Please make sure to delete/move
the files before re-running setup
Ending custom action DetectExistingData
Action ended 13:58:34:
DetectExistingData.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 13:58:34: INSTALL. Return value 3.
Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
Property(S): SqlInstanceName = MSSQLSERVER
Property(S): SqlSecurityMode = SQL
Property(S): SqlSa...
Property(S): SqlDisableNetworkProtocols = 1
Property(S): VersionNT = 501
Property(S): ALLUSERS = 1
Property(S): ARPNOMODIFY = 1
Property(S): DefaultUIFont = Tahoma8
Property(S): INSTALLLEVEL = 3
Property(S): LIMITUI = 1
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductLanguage = 1033
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 13:58:34: INSTALL. Return value 3.
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 501
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
Property(C): ProductName = Microsoft SQL Server Desktop Engine
Property(C): ProductVersion = 8.00.761
Property(C): MsiHiddenProperties = SqlSa...
Property(S): SqlStates = 0
Property(S): ROOTDRIVE = C:\
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SqlFeature = SqlRun
MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 13:58:34: INSTALL. Return value 3.
Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
Property(C): VersionNT = 501
Property(C): ALLUSERS = 1
Property(C): ARPNOMODIFY = 1
Property(C): DefaultUIFont = Tahoma8
Property(C): INSTALLLEVEL = 3
Property(C): LIMITUI = 1
Property(C): Manufacturer = Microsoft Corporation
Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(C): ProductLanguage = 1033
looks like the setup is detecting data from a a previous install of SQL.
"C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
"
You can simply delete these assuming they are not needed any more.
Andrew Robinson
www.binaryocean.com
www.bellinghamdotnet.org
"MEI Admin" <MEI Admin@.discussions.microsoft.com> wrote in message
news:325180D7-9B24-4941-B5A7-B4E7351DD83D@.microsoft.com...
>I am trying to install MSDE Rel A on a Windows XP SP2 machine with no luck
>no
> matter what I try. I am typing the following at the command line.
> setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL
> Below are the portions of the error log that contain RETURN VALUE 3,
> including sevral lines before and after. Any help would be appreciated.
> Error the following data files were found in data directory:
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf
> C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf
> Setup has detected existing data/log files. Please make sure to
> delete/move
> the files before re-running setup
> Ending custom action DetectExistingData
> Action ended 13:58:34:
> DetectExistingData.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
> Action ended 13:58:34: INSTALL. Return value 3.
> Property(S): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
> Property(S): SqlDataDir = C:\Program Files\Microsoft SQL Server\
> Property(S): SqlProgramDir = C:\Program Files\Microsoft SQL Server\
> Property(S): SqlInstanceName = MSSQLSERVER
> Property(S): SqlSecurityMode = SQL
> Property(S): SqlSa...
> Property(S): SqlDisableNetworkProtocols = 1
> Property(S): VersionNT = 501
> Property(S): ALLUSERS = 1
> Property(S): ARPNOMODIFY = 1
> Property(S): DefaultUIFont = Tahoma8
> Property(S): INSTALLLEVEL = 3
> Property(S): LIMITUI = 1
> Property(S): Manufacturer = Microsoft Corporation
> Property(S): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(S): ProductLanguage = 1033
>
> Property(S): SqlStates = 0
> Property(S): ROOTDRIVE = C:\
> Property(S): CostingComplete = 1
> Property(S): OutOfDiskSpace = 0
> Property(S): OutOfNoRbDiskSpace = 0
> Property(S): PrimaryVolumeSpaceAvailable = 0
> Property(S): PrimaryVolumeSpaceRequired = 0
> Property(S): PrimaryVolumeSpaceRemaining = 0
> Property(S): SqlFeature = SqlRun
> MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
> MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
> MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
> MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
> MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown.
> If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> Action ended 13:58:34: INSTALL. Return value 3.
> Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
> Property(C): VersionNT = 501
> Property(C): ALLUSERS = 1
> Property(C): ARPNOMODIFY = 1
> Property(C): DefaultUIFont = Tahoma8
> Property(C): INSTALLLEVEL = 3
> Property(C): LIMITUI = 1
> Property(C): Manufacturer = Microsoft Corporation
> Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(C): ProductLanguage = 1033
> Property(C): ProductName = Microsoft SQL Server Desktop Engine
> Property(C): ProductVersion = 8.00.761
> Property(C): MsiHiddenProperties = SqlSa...
>
> Property(S): SqlStates = 0
> Property(S): ROOTDRIVE = C:\
> Property(S): CostingComplete = 1
> Property(S): OutOfDiskSpace = 0
> Property(S): OutOfNoRbDiskSpace = 0
> Property(S): PrimaryVolumeSpaceAvailable = 0
> Property(S): PrimaryVolumeSpaceRequired = 0
> Property(S): PrimaryVolumeSpaceRemaining = 0
> Property(S): SqlFeature = SqlRun
> MSI (s) (80:D8) [13:58:34:748]: MainEngineThread is returning 1603
> MSI (s) (80:A4) [13:58:34:748]: Destroying RemoteAPI object.
> MSI (s) (80:60) [13:58:34:748]: Custom Action Manager thread ending.
> MSI (c) (3C:E4) [13:58:34:748]: Back from server. Return value: 1603
> MSI (c) (3C:E4) [13:58:34:748]: Decrementing counter to disable shutdown.
> If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> Action ended 13:58:34: INSTALL. Return value 3.
> Property(C): UpgradeCode = {421A321C-2214-4713-B3EB-253F2FBCCE49}
> Property(C): VersionNT = 501
> Property(C): ALLUSERS = 1
> Property(C): ARPNOMODIFY = 1
> Property(C): DefaultUIFont = Tahoma8
> Property(C): INSTALLLEVEL = 3
> Property(C): LIMITUI = 1
> Property(C): Manufacturer = Microsoft Corporation
> Property(C): ProductCode = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(C): ProductLanguage = 1033

Can't install MSDE on Windows XP

Hello,
I can't install MSDE on a computer running Windows XP. The installation stop
and, in the error log, I have the following error message
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
"French_CI_AS""
MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
Engine (MILORD) -- The installation program can't configure the server. Look
at the server error and installation logs for more informations
MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
The installation program can't configure the server. Look at the server
error and installation logs for more informations
MSI (s) (00:08) [16:24:27:703]: User policy value 'DisableRollback' is 0
MSI (s) (00:08) [16:24:27:703]: Machine policy value 'DisableRollback' is 0
End of action 16:24:27 : InstallFinalize. Return value : 3
This is the first time I see this kind of error and I have found nothing
about it. I hope someone knows about it :-)
P.S. : sorry for me bad english, I'm not really good with foreign language
^^
hi David,
David G. wrote:
> Hello,
> I can't install MSDE on a computer running Windows XP. The
> installation stop and, in the error log, I have the following error
> message
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
> "French_CI_AS""
> MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
> Engine (MILORD) -- The installation program can't configure the
> server. Look at the server error and installation logs for more
> informations MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset:
> Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> The installation program can't configure the server. Look at the
> server error and installation logs for more informations
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will give it a look asap.
Andrea Montanari wrote:
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply

Cant install msde on server2000

Anybody out there know why i can't install MSDE on a win2000 server. I start
setup in dos mode with sapwd ="password" but it dies without error
messages.
Thanks in advance
hi,
news wrote:
> Anybody out there know why i can't install MSDE on a win2000 server.
> I start setup in dos mode with sapwd ="password" but it dies without
> error messages.
> Thanks in advance
please add verbose logging of the installation process providing the
/L*v "c:\msde.log"
parameter to your call to setup.exe boostrap installer... this will output
an about 2mb text file (for a succesfull installation) you can later inspect
for
RETURN VALUE 3
entries... about 10/15 lines before each entry som (sometime cryptic)
description of the problem will be reported..
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 thanks for the reply i tried it nut cant read the cryptic merror report
or rather cant understand it
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ii0fpFljhkoU1@.individual.net...
> hi,
> news wrote:
> please add verbose logging of the installation process providing the
> /L*v "c:\msde.log"
> parameter to your call to setup.exe boostrap installer... this will output
> an about 2mb text file (for a succesfull installation) you can later
> inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry som (sometime cryptic)
> description of the problem will be reported..
> --
> 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
>
|||him
news wrote:
> Hi thanks for the reply i tried it nut cant read the cryptic merror
> report or rather cant understand it
perhaps we can help you...
try reporting the lines indicating the problem..
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
|||See my post "Corrupted MSDE files encountered" posted 7/2/2005. Maybe you
have the same problem I did.
Axel Larson,
Share What You Know,
Learn What You Don't
"news" <news@.c.com> wrote in message
news:HL-dnaakovg48F7fRVn-ow@.rogers.com...
> Anybody out there know why i can't install MSDE on a win2000 server. I
start
> setup in dos mode with sapwd ="password" but it dies without error
> messages.
> Thanks in advance
>
|||Hi, I don't know if I have the same problem as News.
This is just the last part of the log file.
Thanks!
MSI (c) (58:60) [09:49:42:814]: Note: 1: 1708
MSI (c) (58:60) [09:49:42:814]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (58:60) [09:49:42:830]: Grabbed execution mutex.
MSI (c) (58:60) [09:49:42:830]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (58:60) [09:49:42:830]: MainEngineThread is returning 1603
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3ij10tFlrda6U1@.individual.net...
> him
> news wrote:
> perhaps we can help you...
> try reporting the lines indicating the problem..
> --
> 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,
Gule wrote:
> Hi, I don't know if I have the same problem as News.
> This is just the last part of the log file.
please isolate the relevand part of the log reporting
RETURN VALUE 3
... about 10/15 lines before each entry some (sometime cryptic) description
of the problem will be reported..
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
|||Actually, i solved the problem. I run the setup2.msi and installation passed
without problem!?
Thanks anyway!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3jnfloFqq68uU1@.individual.net...
> hi,
> Gule wrote:
> please isolate the relevand part of the log reporting
> RETURN VALUE 3
> ... about 10/15 lines before each entry some (sometime cryptic)
> description of the problem will be reported..
> --
> 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
>
|||Hi Andrea,
We are experiencing the same issue while installing MSDE 2K on a Windows 2K
(SP3) machine. It gives out the error: 1603.
Here is the excerpt from the MSDE install verbose log of the 10-15 lines
before the 'Return Value 3' happens (2 occurences in the log)
-----
-----
1.Starting custom action SkuIt
MSI (s) (24:C0): Executing op:
ActionStart(Name=ConfigServer.2D02443E_7002_4C0B_A BC9_EAB2C064397B...
Action 14:03:31: ConfigServer.2D02443E_7002_4C0B_ABC9_EAB2C064397B. ..
MSI (s) (24:C0): Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (24:C0): Creating MSIHANDLE (214) of type 790536 for thread 1984
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\D35166.000\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\D35166.000\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:\WINNT\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.
Action ended 14:04:04: InstallFinalize. Return value 3.
-----
2. Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (24:C0): Executing op: End(Checksum=0,ProgressTotal=0)
MSI (s) (24:C0): Error in rollback skipped. Return: 5
MSI (s) (24:C0): FEATURECACHE: Entering Invalidate
MSI (s) (24:C0): Unlocking Server
Action ended 14:04:24: INSTALL. Return value 3.
-----
-----
I will greatly appreciate any direction to help resolve this issue.
Regards,
Srinivas
"Andrea Montanari" wrote:

> hi,
> Gule wrote:
> please isolate the relevand part of the log reporting
> RETURN VALUE 3
> ... about 10/15 lines before each entry some (sometime cryptic) description
> of the problem will be reported..
> --
> 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
>
>
|||hi,
Srinivas Rampalli wrote:
> Hi Andrea,
> "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.
> Action ended 14:04:04: InstallFinalize. Return value 3.
please have a look at
http://support.microsoft.com/default...99&Product=sql
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

Cant install MSDE - Get message about Strong Passwords

Hi, I am a newbie when it comes to SQL. At work I was
handed a 4 inch thick book titled, 'Microsoft SQL Server
2000', and a book on just the learning SQL language. Im
trying to spend time at work learning this but I have many
other functions and work to take care of. So I asked my
boss and he told me that if I wanted to be able to
continue studying at home that I would need to download
the free version of SQL Server which is called MSDE and is
available to download from Microsoft. So I went home and
downloaded it. Here is the problem...When I try to
install it using SETUP.exe, I get a message informing me
that a SA password is required to install the program. I
have no Idea what that is except that is refered to as a
strong password.
At that point it tell me I need to use some other thing to
supply a SA password and then it will continue to install
the program. I think its expecting me to already know a
bit about SQL which I dont, and also expects me to know
how to install a program via command lines which I dont.
Does anyone know what i'm talking about here, and if so,
what is the laymans, easiest way to accomplish what it is
the istall program wants me to do? Please dont refer me
to some microsoft informational document. I tried that
last night and all it did was confuse me, as they assume
that I know more than I do. I just want to be able to
install the MSDE program on my home computer and once
thats done Ill probably need some hints on how to set up
MSDE to be run for the first time...like how to make it
look at a database thats local. From there on I can muddle
throught the actual learning process on my own.
Thanks in advance for your help!
Tim
Tim,
ReadmeMSDE2000A.htm comes with your download and it talks about common
installation problems.
To install MSDE, you need to supply a strong pasword for sa (something that
is not empty). You can open a DOS prompt, change to the MSDE setup.exe
directory and run 'setup SAPWD=<yourpassword>'
Thanks,
Amy
| Content-Class: urn:content-classes:message
| From: "Tim" <twilliams@.indicopublic.com>
| Sender: "Tim" <twilliams@.indicopublic.com>
| Subject: Cant install MSDE - Get message about Strong Passwords
| Date: Wed, 7 Apr 2004 12:02:42 -0700
| Lines: 32
| Message-ID: <19ab501c41cd2$e7a4bea0$a401280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQc0uekPVanx5LCRE+b6Cmo5Vvz2Q==
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13487
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Hi, I am a newbie when it comes to SQL. At work I was
| handed a 4 inch thick book titled, 'Microsoft SQL Server
| 2000', and a book on just the learning SQL language. Im
| trying to spend time at work learning this but I have many
| other functions and work to take care of. So I asked my
| boss and he told me that if I wanted to be able to
| continue studying at home that I would need to download
| the free version of SQL Server which is called MSDE and is
| available to download from Microsoft. So I went home and
| downloaded it. Here is the problem...When I try to
| install it using SETUP.exe, I get a message informing me
| that a SA password is required to install the program. I
| have no Idea what that is except that is refered to as a
| strong password.
| At that point it tell me I need to use some other thing to
| supply a SA password and then it will continue to install
| the program. I think its expecting me to already know a
| bit about SQL which I dont, and also expects me to know
| how to install a program via command lines which I dont.
| Does anyone know what i'm talking about here, and if so,
| what is the laymans, easiest way to accomplish what it is
| the istall program wants me to do? Please dont refer me
| to some microsoft informational document. I tried that
| last night and all it did was confuse me, as they assume
| that I know more than I do. I just want to be able to
| install the MSDE program on my home computer and once
| thats done Ill probably need some hints on how to set up
| MSDE to be run for the first time...like how to make it
| look at a database thats local. From there on I can muddle
| throught the actual learning process on my own.
| Thanks in advance for your help!
| Tim
|

Cant install MSDE

I have tried to install MSDE 2000, first the normal version, then the
one for developers using Visual Studio .NET. Each time the installation
appears to complete, but there is no shortcut to start the program and
it's not in the Start/Programs menu. However, if I look for it in "Add
and Remove Programs" it's there.
The directory

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

includes some exe files and I have tried to start them, but nothing
appears to happen. If I start sqlsrvr.exe I get a command prompt window
in which I see things like "Server Process ID is 182", "Logging SQL
server messages in file..." etc, but I have no idea how to go on from
there.
I tried installing the new 2005 Beta version but exactly the same
problem.
Why is this happening? How can I make it work?
Thanks in advance.

Bruno PanettaPS the installation probably doesn't even complete. The installation
window just disappears at some point, without saying that it completed
successfully.

Bruno Panetta wrote:
> I have tried to install MSDE 2000, first the normal version, then the
> one for developers using Visual Studio .NET. Each time the installation
> appears to complete, but there is no shortcut to start the program and
> it's not in the Start/Programs menu. However, if I look for it in "Add
> and Remove Programs" it's there.
> The directory
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
> includes some exe files and I have tried to start them, but nothing
> appears to happen. If I start sqlsrvr.exe I get a command prompt window
> in which I see things like "Server Process ID is 182", "Logging SQL
> server messages in file..." etc, but I have no idea how to go on from
> there.
> I tried installing the new 2005 Beta version but exactly the same
> problem.
> Why is this happening? How can I make it work?
> Thanks in advance.
> Bruno Panetta|||There is no UI tool for MSDE. MSDE is a database engine that can be
manipulated programmatically via the various APIs, using the OSQL command
line utility or using any of various third party utilities.

SQL 2005 Express (the product that replaces MSDE) does have a UI called
Express Manager but it's a separate download to the database engine product.
http://lab.msdn.microsoft.com/express/sql/

--
David Portas
SQL Server MVP
--|||Thanks but I'm afraid I don't understand since I'm a beginner to SQL
and am trying to install this program in order to learn it.
What should I do once I have installed MSDE 2000 in order to start
creating databases and running SQL queries?
Thank you very much.

Bruno

David Portas wrote:
> There is no UI tool for MSDE. MSDE is a database engine that can be
> manipulated programmatically via the various APIs, using the OSQL command
> line utility or using any of various third party utilities.
> SQL 2005 Express (the product that replaces MSDE) does have a UI called
> Express Manager but it's a separate download to the database engine product.
> http://lab.msdn.microsoft.com/express/sql/
> --
> David Portas
> SQL Server MVP
> --|||http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--

Cant insert and delete

Hi,

Can anyone help me? I am using MSDE 2000 with VS.NET. I can SELECT from the database but i cant insert and delete and update. Below are my code

public static int Add(string tmpSql, string connectionString)

{

oleConn = new OleDbConnection(connectionString);

oleConn.Open();

oleTran = oleConn.BeginTransaction();

try

{

oleCom = new OleDbCommand(tmpSql, oleConn);

oleCom.Transaction = oleTran;

int a =oleCom.ExecuteNonQuery();

return(0);

}

catch

{

oleTran.Rollback();

return(1);

}

finally

{

oleConn.Close();

}

}

my int a give a value of 1 but when i look at the database the data is not inserted? but my primary key of the table did increase by one. what went wrong? is it due to my configuration which dun allow my to insert and update? help. Thank you

Please some1 pls help me or send me any useful link and i will figure out my self thanks..

|||Is it possible that you need to explicitly commit your transaction inside your try block before returning? In the example code on MSDN at the link below the transaction is explicitly committed.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoledboledbconnectionclassbegintransactiontopic.asp

Hope this helps,
Vaughn|||oh ya how can i forget that.. thanks alot..

Can't import Access DB into MSDE

I want to move my Access 2K database into MSDE. The Access Upsizing
Wizard crashes (a known bug wi A2K), so I'm using the following
suggested method:
Access --> New --> Project (Existing Database)
This asks for the name of the .adp file to create and then launches
into the Data Link Properties dialog box (so far so good) I select my
MSDE server from the drop-down, enter the sa account & passwd, attach
a database file and try to select the .adp file that was just created.
Unfortunately, the "Select SQL Server Database File" dialog is looking
for an .MDF file, not an .ADP file.
If I try to kludge it and select the .adp file anyway, the Test
Connection produces an error:
"Test connection failed because of an error in initializing
provider. The header file "D:\test.adp" is not a valid database file
header. The FILE SIZE property is incorrect."
Any suggestions on how to proceed?
Note:
I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL Web
Administrator running on XP Prof SP2.
See comment inline.
"*no spam*" <no0spam@.yahoo.com> wrote in message
news:34300eeb.0409231458.727df1ee@.posting.google.c om...
> I want to move my Access 2K database into MSDE. The Access Upsizing
> Wizard crashes (a known bug wi A2K), so I'm using the following
> suggested method:
> Access --> New --> Project (Existing Database)
You should:
Access-->New-->Project (New Database)
Here, "Database" means a database on MSDE/SQL Server. The wizard will create
a database on MSDE, so that it can transfer data in *.mdb to the newly
created database on MSDE. *.adp file doen not contain a database (as *.mdb
file does), it is a pure front ent app, containing forms, reports, code
modules. You only select "...Project(Existing Database) when you know there
is a database on MSDE that you want to transfer data from MDB to.

> This asks for the name of the .adp file to create and then launches
> into the Data Link Properties dialog box (so far so good) I select my
> MSDE server from the drop-down, enter the sa account & passwd, attach
> a database file and try to select the .adp file that was just created.
> Unfortunately, the "Select SQL Server Database File" dialog is looking
> for an .MDF file, not an .ADP file.
> If I try to kludge it and select the .adp file anyway, the Test
> Connection produces an error:
> "Test connection failed because of an error in initializing
> provider. The header file "D:\test.adp" is not a valid database file
> header. The FILE SIZE property is incorrect."
> Any suggestions on how to proceed?
> Note:
> I've got Access 2000 SP1, Visual Studio.Net 2002, MSDE and SQL Web
> Administrator running on XP Prof SP2.
|||Norman - Thanks for the suggestion. I gave it a try and ended up back
at the Access/MSDE bug. Access produces an "Overflow" error and the
database just gets created in Access
Might there be some other way to do this?
"Norman Yuan" <nobody@.nowhere.no> wrote in message news:<#CR1H5coEHA.2636@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
> See comment inline.
> "*no spam*" <no0spam@.yahoo.com> wrote in message
> news:34300eeb.0409231458.727df1ee@.posting.google.c om...
> You should:
> Access-->New-->Project (New Database)
> Here, "Database" means a database on MSDE/SQL Server. The wizard will create
> a database on MSDE, so that it can transfer data in *.mdb to the newly
> created database on MSDE. *.adp file doen not contain a database (as *.mdb
> file does), it is a pure front ent app, containing forms, reports, code
> modules. You only select "...Project(Existing Database) when you know there
> is a database on MSDE that you want to transfer data from MDB to.
|||It is impossible to get MSDE/SQL Server database created in Access. It is
conceptually wrong. However, if you specified to "create a client/server
application" in the "Upsizing wizard" (*.adp) and the ADP file did get
created, then you can open the ADP file to verify whether the ADP file can
connection the MSDE or not. You do:
1. Double click the *.adp file;
2. Click "File->Connection..."
3. In "Data Link..." dialog box, select/enter MSDE Instance name, select
autnetication mode (Windows integrited, most likely), and try to find the
new database name created by Upsizing wizard in "Select the database on the
server" dropdown list. If you found it, that means the new database is
created on MSDE, if not, means the Upsizing wizard failed before the
database got created (it is not uncommon that Upsizing Wizard failed to
create database on MSDE/SQL Server, due to different reasons).
If the the database did get created, but the data from *.mdb did not get
transferred fully, then you can clear out the incomplete data in the
database in ADP project (remember, the data is not in ADP file, ADP file is
just a front end app to MSDE), verify the database has the ame structure as
the tables in MDB, and go back to the MDB file to re-run the Upsizing
Wizard. This time you choose "Use existing database" and do not need to
create another ADP file (You can create/open numerous ADP file against a
database on MSDE at any time by simply launching Access, when needed).
HTH
"*no spam*" <no0spam@.yahoo.com> wrote in message
news:34300eeb.0409232352.4d4014e0@.posting.google.c om...
> Norman - Thanks for the suggestion. I gave it a try and ended up back
> at the Access/MSDE bug. Access produces an "Overflow" error and the
> database just gets created in Access
> Might there be some other way to do this?
> "Norman Yuan" <nobody@.nowhere.no> wrote in message
news:<#CR1H5coEHA.2636@.TK2MSFTNGP09.phx.gbl>...[vbcol=seagreen]
create[vbcol=seagreen]
*.mdb[vbcol=seagreen]
there[vbcol=seagreen]

Can't get MSDE installed

I just can't get MSDE installed on my machine. It hangs midway through
the process. If I kill setupre.exe the setup continues but just before
it's done there's an error "Setup failed to configure the server", and
it rolls back. I've stopped the services and processes and read the
readme very carefully. I've removed the previous version and removed
the registry entries and tried to do a clean install. Nothing I'm
finding on Google is helping. I have xp sp2 and the current mdac.
Suggestions? The log files are below.
http://jcosby.com/logs.zip
A repair install of MDAC finally did it.