I don't remember my MSDE username

Hi,
I have my SAPWD="8letters" in setup file, but a can't do anything with
Command Prompt because my login name doesn't work. How can I find it, or
reset it ?
Regards,
J.Alberto
[ccs-ve]
Nota: no enviar mensajes a mi direccion e-mail,
solo spam. Avisar para asignarle un filtro y no sea
eliminado.
IF you forgot your SQL Server account PW, then try to login using Windows
Authentication.
"J.A." <josealbertoplus-nntp@.yahoo.com> wrote in message
news:Or7m8bMBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have my SAPWD="8letters" in setup file, but a can't do anything with
> Command Prompt because my login name doesn't work. How can I find it, or
> reset it ?
>
> Regards,
> --
> J.Alberto
> [ccs-ve]
> Nota: no enviar mensajes a mi direccion e-mail,
> solo spam. Avisar para asignarle un filtro y no sea
> eliminado.
>
sql

I did So..

dear sir,

i am facing problem while making perspectives in sql server2005(Analysis Services) through C#.perspectives are made well but cant update within a Cube...i mean cant be added to a cube... i dont know what is the problem.so if someone can help me in this regard i will be really thankful to u.

Thanks.

Hi,

I would suggest you to post this question in any of the ADO related or SQL Services (Analysis Services) related forums.

There you should find a quick answer to your question.

Rgds,

Rodrigo

|||

dear sir,

i did post it on many of other forums like code project and microsoft india...but i dont know i got no clear response.anyhow thanks alot for giving me time and considering my problem...

thanks.

Adnan Khan.

|||

Moved to SQL Server Analysis Services forum.

Thanks.

|||

First question comes to mind after reading about your problem.

After creating perspective object did you do something like cube.Update(UpdateOptions.ExpandFull) ?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

dear sir,

thanks alot sir....i did appy ur option is working perfectly...thanks alot sir.....i am really happy for ur help...all my senior developers are shocked when i told then that i have done it......thanks alot sir....

Adnan khan..

|||

Edward,

Can you point us to anywhere that details what the three ProcessingOptions enum values actually mean?!?!

Thanks,

Steve.

|||

In following whitepaper you will find a table with processing options for Analysis Services objects

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I appreciate the link and the information contained within. I would still like to see the documentation (BOL) covering items such as the UpdateOptions enumerator (values of Default, AlterDependants and ExpandFull) as well as the UpdateMode. Both of these have a column labeled 'Description' in BOL next to the enum values but these columns aren't populated. It tends to make coding against AMO a little hit and miss as to the intended outcome and actual outcome.

Thanks again,

Steve.

|||

well i am here find out how can i add or load pictures to a dll..i mean when i add that dll to a project all those images should me added also....i hope u will help me....

Thanks...

Adnan Khan.

sql

i created a login in SQL SERVER 2005 EXPRESS, but cant login...

create login dave with password='abc', default_database=tempdb

when i use this account to login my sql2005, i got

Msg 18452, Level 14, State 1, Server DAVID-398113F7C\SQLEXPRESS, Line 1
Login failed for user 'dave'. The user is not associated with a trusted SQL Serv
er connection.
why?You have probably installed the server such that it only allows Windows Authentication, so you cannot connect with a SQL login.

See the "How to: Change Server Authentication Mode" topic in Books Online for additional information on how to allow SQL authentication.

Thanks
Laurentiu|||follow the How to instruction, on right-click my sql server, i got a error msg. indicating that my server is not correctly registed !

in the reg. properity dialog box, i see my auth. mode is Windows Authentication, is there anything wrong with this ?|||Windows authentication means you can only connect with a Windows login. The login dave that you created is a SQL login, so it will not work if you only enabled Windows authentication. There is nothing wrong here, this is how it works.

However, the error message that you are getting when you right click on your server looks like a problem. You should post to SQL Server Tools General to find out what is wrong. If you cannot get an answer, please open a bug at http://lab.msdn.microsoft.com/productfeedback/Default.aspx.

In the meantime, you can try to change the authentication mode manually by modifying the following registry information to contain value 2 instead of 1:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\LoginMode

1 means Windows authentication, this is the value you should find set. By changing this to 2, you'll set the mixed authentication mode. Be sure to restart the server for this change to take effect.

Thanks
Laurentiu|||thx! i changed the reg key, and it works fine now!

but, still, i cant get the server work, it popup a [SQL-DMO] erros|||Try posting on the SQL Server SMO/DMO forum with the text of the error and a description of the steps you took before you received it. There might be something wrong with your installation though. Have you tried installing on a different machine or reinstalling? Did you get any errors during the initial installation?

Thanks
Laurentiu

I can't work out. Duplicate row

Dear all,
I am not be able to delete a row in the following table:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblSysRights]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblSysRights]
GO
CREATE TABLE [dbo].[tblSysRights] (
[sinRightID] [smallint] IDENTITY (1, 1) NOT NULL ,
[sinUserID] [smallint] NOT NULL ,
[sinApplicationID] [smallint] NOT NULL ,
[sinType] [smallint] NULL
) ON [PRIMARY]
GO
No indexes. No constraints. No relationships. What on earth hell is happenin
g?
SELECT *
FROM tblSysRights
WHERE (sinUserID = 61) AND (sinApplicationID = 163)
725 61 163 null
725 61 163 null
I obtain a warning which tell me:
"key column information is insufficient. too many rows affected"
Thanks in advance and best regards,Set RowCount 1
Delete
FROM tblSysRights
WHERE (sinUserID = 61) AND (sinApplicationID = 163)
Set RowCount 0
Madhivanan|||Enric,

> I am not be able to delete a row in the following table:
Can you be more specific?
From where and how are you trying delete the row?
AMB
"Enric" wrote:

> Dear all,
> I am not be able to delete a row in the following table:
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[tblSysRights]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
> drop table [dbo].[tblSysRights]
> GO
> CREATE TABLE [dbo].[tblSysRights] (
> [sinRightID] [smallint] IDENTITY (1, 1) NOT NULL ,
> [sinUserID] [smallint] NOT NULL ,
> [sinApplicationID] [smallint] NOT NULL ,
> [sinType] [smallint] NULL
> ) ON [PRIMARY]
> GO
> No indexes. No constraints. No relationships. What on earth hell is happen
ing?
> SELECT *
> FROM tblSysRights
> WHERE (sinUserID = 61) AND (sinApplicationID = 163)
> 725 61 163 null
> 725 61 163 null
> I obtain a warning which tell me:
> "key column information is insufficient. too many rows affected"
> Thanks in advance and best regards,
>
>|||Thanks for that Madhinavan.
Done successfully.
Thanks Alejandro, too.
Regards,
"Alejandro Mesa" wrote:
> Enric,
>
> Can you be more specific?
> From where and how are you trying delete the row?
>
> AMB
>
> "Enric" wrote:
>|||Just to add a couple of points. For elimination of duplicates, refer to:
http://support.microsoft.com/defaul...b;EN-US;q139444
Use keys in all your tables, and you will avoid a lot of such headaches. On
a related note, a couple of comments:
* You seem to have an identity column which is constrained to be unique, but
apparently it seems to be violated with SET IDENTITY_INSERT ON setting.
Check where the "hole" is.
* Your naming conventions are stale which can be better -- search for some
good guidelines in the archives of this newsgroup.
* Use Query Analyzer for testing your queries, the EM query interface is
buggy and has certain limitations.
* And most importantly, use primary keys in your tables. In relational
database, a value is identified using <table, column, key> triplet. With
duplicates, such identification becomes impossible and relational operations
cannot be used beneficially. The impossibility of logically deleting one row
out of duplicates is often cited as a prime illustration of the consequence
of allowing duplicates by SQL. ( SQL language inventors and its flag bearers
should take the credit, for even standardizing them ! )
Anith|||Thanks for that Anith.
That table was defined without identity fields or key. Just a mess-up.
Best Regards,
"Anith Sen" wrote:

> Just to add a couple of points. For elimination of duplicates, refer to:
> http://support.microsoft.com/defaul...b;EN-US;q139444
> Use keys in all your tables, and you will avoid a lot of such headaches. O
n
> a related note, a couple of comments:
> * You seem to have an identity column which is constrained to be unique, b
ut
> apparently it seems to be violated with SET IDENTITY_INSERT ON setting.
> Check where the "hole" is.
> * Your naming conventions are stale which can be better -- search for some
> good guidelines in the archives of this newsgroup.
> * Use Query Analyzer for testing your queries, the EM query interface is
> buggy and has certain limitations.
> * And most importantly, use primary keys in your tables. In relational
> database, a value is identified using <table, column, key> triplet. With
> duplicates, such identification becomes impossible and relational operatio
ns
> cannot be used beneficially. The impossibility of logically deleting one r
ow
> out of duplicates is often cited as a prime illustration of the consequenc
e
> of allowing duplicates by SQL. ( SQL language inventors and its flag beare
rs
> should take the credit, for even standardizing them ! )
> --
> Anith
>
>

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Also, I can view and manipulate the database using Query Analyzer.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry Woods
P.S. I cross-posted in sqlserver.server because I need an answer ASAP.
Sorry.Hi
Public probably does not have rights to master..sysdatabases but you
probably have a permitted user for the databases but without the permissions
to backup.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:e%23nZpPe0FHA.1032@.TK2MSFTNGP12.phx.gbl...
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine
> (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login
> entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed
> to
> backup! But, still no list of databases.
> Also, I can view and manipulate the database using Query Analyzer.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
> P.S. I cross-posted in sqlserver.server because I need an answer ASAP.
> Sorry.
>
>

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:
> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>>I have been asked to work on a remote site. I started my EM and tried to
>>connect to the SQL server on the remote site. I connected just fine
>>(server had userid/password). But when I open the "Databases" folder I
>>get a "(no items)" instead of a list of databases. BUT, when I view other
>>folders I see various items. For example, Security/Login lists lots of
>>login entries. Just to see what would happen I right-clicked on Databases
>>and clicked All Tasks/Backup Database and got a list of databases that I
>>was NOT allowed to backup! But, still no list of databases.
>> Any ideas?
>>
>> BTW, I am using SQL Server 2000 EM.
>> TIA,
>> Larry Woods
>sql

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry WoodsHi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
--
Best Regards
Krystian Zieja / mob
"lwoods" wrote:

> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (serv
er
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entrie
s.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed t
o
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>

I can't view the list of databases on remote site

I have been asked to work on a remote site. I started my EM and tried to
connect to the SQL server on the remote site. I connected just fine (server
had userid/password). But when I open the "Databases" folder I get a "(no
items)" instead of a list of databases. BUT, when I view other folders I
see various items. For example, Security/Login lists lots of login entries.
Just to see what would happen I right-clicked on Databases and clicked All
Tasks/Backup Database and got a list of databases that I was NOT allowed to
backup! But, still no list of databases.
Any ideas?
BTW, I am using SQL Server 2000 EM.
TIA,
Larry Woods
Hi,
Could you refresh the database option and see.
As well as login to Query analyzer and execute the below command to get the
databases:-
SP_HELPDB
For backing up try
BACKUP Database <dbanme> to disk='d:\backup\dbname_Oct16.bak' with
INIT,STATS=5
If you get a permission issue contact the database admin.
Thanks
Hari
SQL Server MVP
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
|||Please try to connect usin Query Analyzer and execute the following
use master
go
select *
from information_schema.schemata
select *
from sysdatabases
This will enable you to display all databases on a server
Best Regards
Krystian Zieja / mob
"lwoods" wrote:

> I have been asked to work on a remote site. I started my EM and tried to
> connect to the SQL server on the remote site. I connected just fine (server
> had userid/password). But when I open the "Databases" folder I get a "(no
> items)" instead of a list of databases. BUT, when I view other folders I
> see various items. For example, Security/Login lists lots of login entries.
> Just to see what would happen I right-clicked on Databases and clicked All
> Tasks/Backup Database and got a list of databases that I was NOT allowed to
> backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
>
|||Hi
See answer in .programming. Please do not multi-post.
John
"lwoods" <larry@.lwoods.com> wrote in message
news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have been asked to work on a remote site. I started my EM and tried to
>connect to the SQL server on the remote site. I connected just fine
>(server had userid/password). But when I open the "Databases" folder I get
>a "(no items)" instead of a list of databases. BUT, when I view other
>folders I see various items. For example, Security/Login lists lots of
>login entries. Just to see what would happen I right-clicked on Databases
>and clicked All Tasks/Backup Database and got a list of databases that I
>was NOT allowed to backup! But, still no list of databases.
> Any ideas?
>
> BTW, I am using SQL Server 2000 EM.
> TIA,
> Larry Woods
>
|||Will do...
Please note that I DON'T usually do this, but I needed an answer FAST so I
tried to connect to multiple groups. I understand the problem...
Larry
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23SZCJEk0FHA.2600@.TK2MSFTNGP10.phx.gbl...
> Hi
> See answer in .programming. Please do not multi-post.
>
> John
> "lwoods" <larry@.lwoods.com> wrote in message
> news:eG$Insd0FHA.2924@.TK2MSFTNGP15.phx.gbl...
>

I can't upgrade MSDE sp2 to sp3a

I am trying to upgrade an instance of MSDE on my XP computer using
setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin
UPGRADEPWD=AdminPassword
It runs for a while and then looks like it rolls back the installation. I
check the event viewer and I see an entry that states
"Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."
But when I look further at the other entries I can see nothing that would
indicate why it failed.
I only have one instance of MSDE on my computer and this is the results of
my @.@.version before the upgrade
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.1
(Build 2600: Service Pack 2)
I had checked the registry as per a MS article and it looks like it was
isntalled via sqlrun01.msi
Does anybody have any thoughts?
Thanks
Richard
hi Richard,
"Richard Speiss" <rspeiss@.mtxinc.com> ha scritto nel messaggio
news:%23WD%23x$TiEHA.1276@.TK2MSFTNGP09.phx.gbl...
> I am trying to upgrade an instance of MSDE on my XP computer using
> setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=AnAdminLogin
> UPGRADEPWD=AdminPassword
> It runs for a while and then looks like it rolls back the installation. I
> check the event viewer and I see an entry that states
> "Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp."
> But when I look further at the other entries I can see nothing that would
> indicate why it failed.
> I only have one instance of MSDE on my computer and this is the results of
> my @.@.version before the upgrade
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Desktop Engine on Windows NT 5.1
> (Build 2600: Service Pack 2)
> I had checked the registry as per a MS article and it looks like it was
> isntalled via sqlrun01.msi
> Does anybody have any thoughts?
please add the
/L*v "c:\msdesp3.log"
command line parameter, in order to full log the installation to a (about)
2mb log txt file where you can search for
Return Value 3 in order to toubleshoot your upgrade
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

I can't uninstall SQLEXPRESS

Hi all,

I have a strange problem here. How to uninstall SQLEXPRESS when it does not appear in the "Add/remove program"?

Another problem is that I can't connect to the local server using SQL Server Enterprise manager. This is the error that i got:

"a connection could not be established to (My Computer name)\SQLEXPRESS.
Reason: [SQL-DMO]you must use SQL Server 2005 management tools to connect to this server.
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DHH-MC\SQLEXPRESS node) and try again. "

I do not want to use SQL 2005 because of some issues. All I need is SQL 2000 to run properly.

Can anybody help me in this? Thanks.

When you say you cannot find SQL Express under the Add/Remove Programs window... are you looking specifically for SQL Express? I ask because for some strange reason it appears there as Microsoft SQL Server 2005. If you see that feel free to remove it and the other SQL components installed along with it.|||

I think it is SQL Server 2005 because i have installed it before.

I have uninstalled everything related to the SQL Server 2005 and even SQL Server 2000. But it is still there. SQL Server 2005 is still appeared at the start program.

And when i installed SQL Server 2000, I can't connect to the local server. This is the error:

a connection could not be established to (My Computer name)\SQLEXPRESS.
Reason: [SQL-DMO]you must use SQL Server 2005 management tools to connect to this server..
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DHH-MC\SQLEXPRESS node) and try again. "

Any solution?

|||

SQL Server 2005 creates a single entry in the Add/Remove programs dialog that collects all the instances of SQL Server 2005. This acutally makes sense as it gives you a place to easily identify the different instances of SQL Server, as we support installing many.

To remove SQL Express, or any other Edition of SQL Server for that matter, go to Add/Remove Programs, select Microsoft SQL Server 2005 and click Remove. You will be taken to a dialog that lists the various components of SQL Server that are installed, including the Instance Names they are installed under. Simply select the components you wish to remove and proceed thorugh the wizard.

Hopefully this clarifies things for you.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||Hi. I've got the same problem with unistalling SQL Express with Adavanced Services SP1. I saw it in Add/Remove programs and tried removing it/unistalling it. It DID NOT take me to a dialog with instances installed and options to select which to install or unistall etc.. all that came up was a info box that stated that other SQL Express components depended on that one nad that I should unistall those first. Well I jotted down which and when I tried to uninstall those the same warning/info box came up listing dependent components..so I jotted those down and went around in circles as they were ALL dependent on each other...so, I went ahead and unistalled verything that had MS SQL Server Express/2005 on Add/Remove Programs and it still shows up in my Start menu in the Programs submenu? Also, when I ran the program again to see if an unistall option came up it will only install..so I went along with it to see if an unsiatll option would eventually come up...it didn't..I went far enough along to where it showed me that it STILL had installed instances of SQL Server Epxress? what's with that? anyways, I then cancelled the installation ...man, this almost remindes me of years ago when I first started out doing desktop support and all the problems we had with users when we tried to unistall their AOL from their company machines...I expected better from MS ..I'm dissapointed ...what can I do to get rid of MS SQL Server Express 2005 completely...we were using this machine to possibly build a deployment image for our learning lab ...but if the oprogram is this hideous, we may just have to scrap it..|||

How did you get Express Advanced installed onto your computer?

In a normal install of SQL Express Advanced, clicking the Remove buttion from ARP will open a dialog titled "Microsoft SQL Server 2005 Uninstall" with a first page that offers a "Component Selection" and lists what SQL components are installed. If you did a full install of Express Advanced, you should have two things available to you:

In the 'Select an Instance' box, you should see one Database Engine named SQLEXPRESS

I can't uninstall SQLEXPRESS

Hi all,

I have a strange problem here. How to uninstall SQLEXPRESS when it does not appear in the "Add/remove program"?

Another problem is that I can't connect to the local server using SQL Server Enterprise manager. This is the error that i got:

"a connection could not be established to (My Computer name)\SQLEXPRESS.
Reason: [SQL-DMO]you must use SQL Server 2005 management tools to connect to this server.
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DHH-MC\SQLEXPRESS node) and try again. "

I do not want to use SQL 2005 because of some issues. All I need is SQL 2000 to run properly.

Can anybody help me in this? Thanks.

When you say you cannot find SQL Express under the Add/Remove Programs window... are you looking specifically for SQL Express? I ask because for some strange reason it appears there as Microsoft SQL Server 2005. If you see that feel free to remove it and the other SQL components installed along with it.|||

I think it is SQL Server 2005 because i have installed it before.

I have uninstalled everything related to the SQL Server 2005 and even SQL Server 2000. But it is still there. SQL Server 2005 is still appeared at the start program.

And when i installed SQL Server 2000, I can't connect to the local server. This is the error:

a connection could not be established to (My Computer name)\SQLEXPRESS.
Reason: [SQL-DMO]you must use SQL Server 2005 management tools to connect to this server..
Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the DHH-MC\SQLEXPRESS node) and try again. "

Any solution?

|||

SQL Server 2005 creates a single entry in the Add/Remove programs dialog that collects all the instances of SQL Server 2005. This acutally makes sense as it gives you a place to easily identify the different instances of SQL Server, as we support installing many.

To remove SQL Express, or any other Edition of SQL Server for that matter, go to Add/Remove Programs, select Microsoft SQL Server 2005 and click Remove. You will be taken to a dialog that lists the various components of SQL Server that are installed, including the Instance Names they are installed under. Simply select the components you wish to remove and proceed thorugh the wizard.

Hopefully this clarifies things for you.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||Hi. I've got the same problem with unistalling SQL Express with Adavanced Services SP1. I saw it in Add/Remove programs and tried removing it/unistalling it. It DID NOT take me to a dialog with instances installed and options to select which to install or unistall etc.. all that came up was a info box that stated that other SQL Express components depended on that one nad that I should unistall those first. Well I jotted down which and when I tried to uninstall those the same warning/info box came up listing dependent components..so I jotted those down and went around in circles as they were ALL dependent on each other...so, I went ahead and unistalled verything that had MS SQL Server Express/2005 on Add/Remove Programs and it still shows up in my Start menu in the Programs submenu? Also, when I ran the program again to see if an unistall option came up it will only install..so I went along with it to see if an unsiatll option would eventually come up...it didn't..I went far enough along to where it showed me that it STILL had installed instances of SQL Server Epxress? what's with that? anyways, I then cancelled the installation ...man, this almost remindes me of years ago when I first started out doing desktop support and all the problems we had with users when we tried to unistall their AOL from their company machines...I expected better from MS ..I'm dissapointed ...what can I do to get rid of MS SQL Server Express 2005 completely...we were using this machine to possibly build a deployment image for our learning lab ...but if the oprogram is this hideous, we may just have to scrap it..|||

How did you get Express Advanced installed onto your computer?

In a normal install of SQL Express Advanced, clicking the Remove buttion from ARP will open a dialog titled "Microsoft SQL Server 2005 Uninstall" with a first page that offers a "Component Selection" and lists what SQL components are installed. If you did a full install of Express Advanced, you should have two things available to you:

In the 'Select an Instance' box, you should see one Database Engine named SQLEXPRESS

I can't understand the meaning of a prediction query

Dear friends,
I'm reading Wiley's Data mining with SQL Server 2005... There are MANY things I can't understand about MovieClick example (Chapter 3).
I hope someone is going to help me with this troubles...

WARNING (1): I'm a dummy both with sql server and data mining.
WARNING (2): My English is not good at all.

Just two questions for now:

1) When I create the model to predict the number of bedrooms for homeowners, the book says to check BEDROOMS as Predictable... question: is it also an INPUT for the model, or PREDICTABLE only?

2) I'd like to keep this model (number of bedrooms.......) and make a prediction query.

- Query builder
- select case table -> Homeowners
- Drag the Customer ID column from the Homeowners table and drop it on the grid
- Drag the BEDROOMS column from the mining model and drop it on the grid.
- On the last row: Source=PredictionFunction, Field=PredictProbability
- Drag the BEDROOMS column from the mining model and drop it into Criteria/Argument
- Add (i.e.) 'Two or Three' to the field Criteria/Argument

I execute the query and I obtain many rows in a table with the following colums: CustomerID, BEDROOMS and Expression: WHAT DOES THIS MEAN?
WHICH INFO DO I GET FROM THOSE NUMBERS? WHAT CAN I LEARN FROM THEM?

Thanx a lot in advance, please help me!

1: It won't actually matter if you make it INPUT as well. When you mark something as PREDICTABLE, it generally means that the algorithm will try to learn about the data in that column. When you mark it as INPUT, it generally means that the algorithm will consider this column as information about the predictable columns. For trees, for example, the algorithm will create a tree for each predictable column, and the trees can have splits on the input columns. If you have a column that is marked INPUT and PREDICTABLE, in general, it only matters if you have more than one PREDICTABLE, since the columns don't act as inputs for themselves, for example, the tree for # of bedrooms isn't going to have a split on # of bedrooms, but if you also make Home Ownership predictable, than # of bedrooms could be a condition in the tree for Home Ownership. (the one exception is for clustering, but that's a longer explanation).

2: What do the numbers mean? The first column is just the customer ID from the input - this could also be the customer name, for example. The second column is the # of bedrooms predicted by the algorithm - that is, the count of bedrooms that has the highest probability of all options given the input. The last column is the probability that the # of bedrooms would be 'Two or Three'.

What can you use this for? Take for example you were building a model to predict whether people would buy a product. You would want to predict which people would buy or not buy. In addition, you would probably want to contact those people with the highest probability of buying - therefore you need to use the PredictProbability function with a specified value. As you learn to use the product more, you will see that you can use the Profit Chart to determine the maximum profit for a marketing campaign using a Mining Model. The chart will give you a probability threshold. You want to use this threshold in a DMX query to select all customers who have a probability higher than that threshold in order to achieve maximum profit.

Hope this helps

-Jamie

i cant understand how to perform file attachment to SQL2000

Hi!

i can't understand how to perform file attachment to SQL2000:

<connectionStrings>
<add name="SimpleListsConnectionString" connectionString="Data Source=local;AttachDbFilename=SimpleLists.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

Server return error:

error 602: could not find row in sysindexes for database

run dbcc checktable on sysindexes

Can any body help?

Sorry its my mistake.

Remove question.

I can't stat SQL in a user account

Windows 2000 SP4 and SQL Server 2000 SP3
When I try to start SQL Server in the account
DOMAIN\Administrator, the system return the error 22042 (-
2147024890).
I can not start in a user account and I can not send
email.
Could you help me please ? ThanksAre you logged on to NT box using a domain admin account ?
if not then I don't think it will let you specify a
Domain\Administrator as a sql service start up account. It
would be a gross violation of security principles. Specify
the same account that you are using to log in to the
system, or a local administrator.
hth.
>--Original Message--
>Windows 2000 SP4 and SQL Server 2000 SP3
>When I try to start SQL Server in the account
>DOMAIN\Administrator, the system return the error 22042 (-
>2147024890).
>I can not start in a user account and I can not send
>email.
>Could you help me please ? Thanks
>.
>|||I am logged with the DOMAIN\Administator on the server
when I tried to set up it.
But if I am logged with a other account with the admin
rights I have the same message.
>--Original Message--
>Are you logged on to NT box using a domain admin
account ?
>if not then I don't think it will let you specify a
>Domain\Administrator as a sql service start up account.
It
>would be a gross violation of security principles.
Specify
>the same account that you are using to log in to the
>system, or a local administrator.
>hth.
>>--Original Message--
>>Windows 2000 SP4 and SQL Server 2000 SP3
>>When I try to start SQL Server in the account
>>DOMAIN\Administrator, the system return the error 22042
(-
>>2147024890).
>>I can not start in a user account and I can not send
>>email.
>>Could you help me please ? Thanks
>>.
>.
>|||the error you are getting is about the server not able to
verify the user account you specified. type following
command on DOS command prompt just to make sure the domain
controller is responding:
net users /DOMAIN
This should list all users in the domain you are logged
into.
Try using Local System Account in service startup for sql
server.
hth.
>--Original Message--
>I am logged with the DOMAIN\Administator on the server
>when I tried to set up it.
>But if I am logged with a other account with the admin
>rights I have the same message.
>>--Original Message--
>>Are you logged on to NT box using a domain admin
>account ?
>>if not then I don't think it will let you specify a
>>Domain\Administrator as a sql service start up account.
>It
>>would be a gross violation of security principles.
>Specify
>>the same account that you are using to log in to the
>>system, or a local administrator.
>>hth.
>>--Original Message--
>>Windows 2000 SP4 and SQL Server 2000 SP3
>>When I try to start SQL Server in the account
>>DOMAIN\Administrator, the system return the error 22042
>(-
>>2147024890).
>>I can not start in a user account and I can not send
>>email.
>>Could you help me please ? Thanks
>>.
>>.
>.
>|||The command DOS net users /DOMAIN is OK. I can see le the
users list in the domain.
But if I use the local system account I cant send email
with SQL Agent and I need it.
>--Original Message--
>the error you are getting is about the server not able
to
>verify the user account you specified. type following
>command on DOS command prompt just to make sure the
domain
>controller is responding:
>net users /DOMAIN
>This should list all users in the domain you are logged
>into.
>Try using Local System Account in service startup for
sql
>server.
>hth.
>>--Original Message--
>>I am logged with the DOMAIN\Administator on the server
>>when I tried to set up it.
>>But if I am logged with a other account with the admin
>>rights I have the same message.
>>--Original Message--
>>Are you logged on to NT box using a domain admin
>>account ?
>>if not then I don't think it will let you specify a
>>Domain\Administrator as a sql service start up
account.
>>It
>>would be a gross violation of security principles.
>>Specify
>>the same account that you are using to log in to the
>>system, or a local administrator.
>>hth.
>>--Original Message--
>>Windows 2000 SP4 and SQL Server 2000 SP3
>>When I try to start SQL Server in the account
>>DOMAIN\Administrator, the system return the error
22042
>>(-
>>2147024890).
>>I can not start in a user account and I can not send
>>email.
>>Could you help me please ? Thanks
>>.
>>.
>>.
>.
>sql

I can't Start\Stop\Pause SQL Server or SQL Agent from Remote SSMS

Hello,
I do all of my SQL Server administration remotely from my workstation and
i noticed that the green running status symbol was blank on one of my MS SQL
2005 servers. I also noticed that when i right click on the server name my
options for start stop and pause are disabled. I can see all of the tables
and run my queries without any issues. If i log onto the server itself i can
see the status symbols and start\stop\pause the services for the Server and
Agent. Does anyone know why i wouldnt be able to remotely do this or see the
status of the server services? Thanks in advance for the help!
jrunowski (jrunowski@.discussions.microsoft.com) writes:
> I do all of my SQL Server administration remotely from my workstation
> and i noticed that the green running status symbol was blank on one of
> my MS SQL 2005 servers. I also noticed that when i right click on the
> server name my options for start stop and pause are disabled. I can see
> all of the tables and run my queries without any issues. If i log onto
> the server itself i can see the status symbols and start\stop\pause the
> services for the Server and Agent. Does anyone know why i wouldnt be
> able to remotely do this or see the status of the server services?
Normally, you can only stop and start services on the local machine. This
is not specific to SQL Server, but applies to Windows in general. I guess
that you can configure a machine so that services can be stopped and
started from a remote computer, but it sonds like a dare security-wise.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
Pippo
Hi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo

I can't start SQL Service

This service started, and now don't start,
if I start the service from prompt i have I more
descriptions from the errors?
How i can start the service from prompt?
Thank for All
Pippo

>--Original Message--
>From what you have said you do not have access rights to
>start it.
>Can you give me some more details on your set up i.e.
>client server, stand alone ect ?
>
>.
>
Hi,
To start the default instance of SQL Server from a command prompt
sqlservr.exe -c
To start a named instance of SQL Server
sqlservr.exe -c -s {instancename}
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:19e9b01c41d4d$329947d0$a301280a@.phx.gbl...
> This service started, and now don't start,
> if I start the service from prompt i have I more
> descriptions from the errors?
> How i can start the service from prompt?
> Thank for All
> Pippo
>

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
PippoFrom what you have said you do not have access rights to
start it.
Can you give me some more details on your set up i.e.
client server, stand alone ect ?
>--Original Message--
>Hi,
>In SQL Server Service Manager, when i start the Sql
>Server Service, the service don't start. There is a An
>error 5 (Access Denied).
>How can resolve it?
>Thank for all
>Pippo
>.
>|||Hi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo|||This service started, and now don't start,
if I start the service from prompt i have I more
descriptions from the errors'
How i can start the service from prompt?
Thank for All
Pippo
>--Original Message--
>From what you have said you do not have access rights to
>start it.
>Can you give me some more details on your set up i.e.
>client server, stand alone ect ?
>
>>--Original Message--
>>Hi,
>>In SQL Server Service Manager, when i start the Sql
>>Server Service, the service don't start. There is a An
>>error 5 (Access Denied).
>>How can resolve it?
>>Thank for all
>>Pippo
>>.
>.
>|||Hi,
To start the default instance of SQL Server from a command prompt
sqlservr.exe -c
To start a named instance of SQL Server
sqlservr.exe -c -s {instancename}
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:19e9b01c41d4d$329947d0$a301280a@.phx.gbl...
> This service started, and now don't start,
> if I start the service from prompt i have I more
> descriptions from the errors'
> How i can start the service from prompt?
> Thank for All
> Pippo
>
> >--Original Message--
> >From what you have said you do not have access rights to
> >start it.
> >
> >Can you give me some more details on your set up i.e.
> >client server, stand alone ect ?
> >
> >
> >>--Original Message--
> >>Hi,
> >>In SQL Server Service Manager, when i start the Sql
> >>Server Service, the service don't start. There is a An
> >>error 5 (Access Denied).
> >>How can resolve it?
> >>
> >>Thank for all
> >>
> >>Pippo
> >>.
> >>
> >.
> >

I can't start SQL Service

This service started, and now don't start,
if I start the service from prompt i have I more
descriptions from the errors'
How i can start the service from prompt?
Thank for All
Pippo

>--Original Message--
>From what you have said you do not have access rights to
>start it.
>Can you give me some more details on your set up i.e.
>client server, stand alone ect ?
>
>.
>Hi,
To start the default instance of SQL Server from a command prompt
sqlservr.exe -c
To start a named instance of SQL Server
sqlservr.exe -c -s {instancename}
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:19e9b01c41d4d$329947d0$a301280a@.phx
.gbl...
> This service started, and now don't start,
> if I start the service from prompt i have I more
> descriptions from the errors'
> How i can start the service from prompt?
> Thank for All
> Pippo
>sql

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
PippoHi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx
.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo