error is installing msde

I am trying to install msde and everything went fine until the end i got the
error message "The instance name specified is invalid" that came up while
it was configuring Microsoft SQL Server Desktop Engine
hi,
dopey0331 wrote:
> I am trying to install msde and everything went fine until the end i
> got the error message "The instance name specified is invalid"
> that came up while it was configuring Microsoft SQL Server Desktop
> Engine
can you please post the command line used to install?
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

Error in query; "Invalid length parameter passed to the substring function"

Hi
i got errro mess "Invalid length parameter passed to the substring function" from this below. Anyone how can give me a hint what cause this, and how i can solve it? if i remove whats whitin thoose [] it works, i dont use [] in the code :)
colums:
VLF_InfectionDestination is nvarchar 254

SELECT TOP 10 tb_AVVirusLog.VLF_VirusName, COUNT(tb_AVVirusLog.VLF_VirusName) AS number
FROM tb_AVVirusLog INNER JOIN
__CustomerMachines002 ON tb_AVVirusLog.CLF_ComputerName = __CustomerMachines002.FalseName
WHERE (CONVERT(varchar, tb_AVVirusLog.CLF_LogGenerationTime, 120) BETWEEN @.fyear + @.fmonth + @.fday AND @.tyear + @.tmonth + @.tday) AND
(__CustomerMachines002.folder_id = @.folderId) [OR
(CONVERT(varchar, tb_AVVirusLog.CLF_LogGenerationTime, 120) BETWEEN @.fyear + @.fmonth + @.fday AND @.tyear + @.tmonth + @.tday) AND
(tb_AVVirusLog.VLF_InfectionDestination LIKE N'%@.%')]
GROUP BY tb_AVVirusLog.VLF_VirusName
HAVING (NOT (tb_AVVirusLog.VLF_VirusName LIKE N'cookie'))
ORDER BY COUNT(tb_AVVirusLog.VLF_VirusName) DESCGenerally, you get this error when you pass in a bad parameter, like a negative startpoint, or a length parameter that takes you out of bounds of the string. Maybe instead of convert (varchar), you should try convert(varchar(10)). I don't see substring in there.|||naa cant get it to work... that damn error pop up no matter what i do...|||is i reverse the order and put in a AND insteed it works... like this
[AND
(CONVERT (tb_AVVirusLog.VLF_InfectionDestination LIKE N'%@.%')] AND (varchar, tb_AVVirusLog.CLF_LogGenerationTime, 120) BETWEEN @.fyear + @.fmonth + @.fday AND @.tyear + @.tmonth + @.tday)]

how come o got that error the other way?

//Mr|||Read the sticky at the top of this forum..Post us the DDL and some sample data and what the expected results are suppose to be...|||How about this?

DECLARE @.date1 datetime, @.date2 datetime
SELECT @.date1 = CONVERT(datetime, @.fyear + @.fmonth + @.fday)
, @.date2 = CONVERT(datetime, @.tyear + @.tmonth + @.tday)

SELECT TOP 10 a.VLF_VirusName
, COUNT(a.VLF_VirusName) AS number
FROM tb_AVVirusLog a
INNER JOIN __CustomerMachines002 b
ON a.CLF_ComputerName = b.FalseName
WHERE ( a.CLF_LogGenerationTime > @.Date1 AND a.CLF_LogGenerationTime <= @.Date2
AND b.folder_id = @.folderId)
OR ( a.CLF_LogGenerationTime > @.Date1 AND a.CLF_LogGenerationTime <= @.Date2
AND a.VLF_InfectionDestination LIKE N'%@.%')
GROUP BY a.VLF_VirusName
HAVING a.VLF_VirusName NOT LIKE N'cookie'
ORDER BY COUNT(a.VLF_VirusName) DESC|||thx, i manage this to work, and i got some new ideas how to do things... :)

//Mr|||thx, i manage this to work, and i got some new ideas how to do things... :)

//Mr

...and you're not gonna share it with us...I'll never gety thos 5 minutes back...

Error in ActiveX script in DTS

Hi,
When i m trying to execute the following function i m getting
Error Message is Invalid Procedure Call or arguement DTSSource

'************************************************* *********************
' Visual Basic Transformation Script
'************************************************* ***********************

' Copy each source column to the destination column
Function Main()
DTSDestination("acct_id") = DTSSource("Account_ID")
DTSDestination("acct_nm") = DTSSource("Account_Name")
DTSDestination("acct_type") = 1
DTSDestination("acct_sts") = DTSSource("Enabled")

Main = DTSTransformStat_OK
End Function

thnks in advanceis DTSDestination("acct_type") of type integer,numeric or decimal?

if not, I think you have to add double quotes around the "1". Hope it helps :)

Error HTTP 401.1 - Unauthorized: denied access due to invalid cred

Subject: RS - Error HTTP 401.1 - Unauthorized: denied access due to invalid
credetentials
I have a problemm with an Reporting Services installation.
When I want to access a http://orden14/reports, it request me to type login
and password.
I type login and password 'administrator' and, it shows the next message:
Error HTTP 401.1 - Unauthorized: denied access due to invalid
credetentials (IIS)
=== MY INSTALLATION ===:
Server name: "Orden14"
S.O: W2003 R2
BD: MS-SQL Server 2005 Standard + SP2 (spanish)
Rights Web Site: orden14\Administrators;orden14\IIS_WPG;orden14\SYSTEM
Authentication Web Site: Integrated and basic
Description Web Site : repservices10
Address IP: no assign
Port TCP in Web Site: 8080
Host en Web Site: none
Entry in File 'Hosts' : 172.x.x.xx repservices10
If I don't put authentication 'integrated' in Web Site (IIS), it works
correctly, but when I run the Report Builder,
it shows the message: "Cannot retrive apllication. Authentication error" .
Also, if I install the same configuration and Site in the Web Site
'Predeterminated', it works correcty (with authetication
'intregrated and basic ') and I work with Report Builder too.Hi,
Please find my message according to this issue by clicking here:
news:9CD3F523-6D16-40D0-8F97-B9183E28C7D6@.microsoft.com
Regards,
Janos
"KAPELEME" <KAPELEME@.discussions.microsoft.com> wrote in message
news:084C4C08-1824-4893-8FC2-A4BF1245EDAD@.microsoft.com...
> Subject: RS - Error HTTP 401.1 - Unauthorized: denied access due to
> invalid
> credetentials
> I have a problemm with an Reporting Services installation.
> When I want to access a http://orden14/reports, it request me to type
> login
> and password.
> I type login and password 'administrator' and, it shows the next message:
> Error HTTP 401.1 - Unauthorized: denied access due to invalid
> credetentials (IIS)
>
> === MY INSTALLATION ===:
> Server name: "Orden14"
> S.O: W2003 R2
> BD: MS-SQL Server 2005 Standard + SP2 (spanish)
> Rights Web Site: orden14\Administrators;orden14\IIS_WPG;orden14\SYSTEM
> Authentication Web Site: Integrated and basic
> Description Web Site : repservices10
> Address IP: no assign
> Port TCP in Web Site: 8080
> Host en Web Site: none
> Entry in File 'Hosts' : 172.x.x.xx repservices10
> If I don't put authentication 'integrated' in Web Site (IIS), it works
> correctly, but when I run the Report Builder,
> it shows the message: "Cannot retrive apllication. Authentication error" .
> Also, if I install the same configuration and Site in the Web Site
> 'Predeterminated', it works correcty (with authetication
> 'intregrated and basic ') and I work with Report Builder too.
>
>

Error handling with MDX and Reporting Services

I have having trouble with an MDX Statement. There are some instances where the MDX statement I am passing in isn't correct or invalid. The report takes in serveral default parameters and creates an MDX statement from it. When this error happens I get an error similiar to

Formula error - cannot find dimension member ("[Time].[2005]") - in a name-binding function

on the report page. I would like to be able to handle this error in reporting services so how. Essientially, I would want to be able to just say if this error happens just take me the plain page and do not load up any defaults.You might consider this a hack, but this can be solved from outside Reporting Services with the new missing member functionality in 2005 (ie invalid member lookups wont generate errors),|||I am using RS 2005 and AS 2005 RTM.

I am having the report to accept a parameter UserUserID that accepts values such as [User].[User ID].&[1].

This is working fine when the front-end calls it with a correct/valid UserID.

When it is the calling the report with a valid UserID, two things that I observe happening:
a) when the Parameter is set to Hidden (on the Report Parameters properties), this error will be displayed "The 'UserUserID' parameter is missing a value"
b) when the Parameter is not set to Hidden, a blank page is shown with the parameter prompt <Select a Value>.

Is there any way to better handle situation a)? Since I need to hide the parameters from the end-users....

Thanks.

Error handling with MDX and Reporting Services

I have having trouble with an MDX Statement. There are some instances where the MDX statement I am passing in isn't correct or invalid. The report takes in serveral default parameters and creates an MDX statement from it. When this error happens I get an error similiar to

Formula error - cannot find dimension member ("[Time].[2005]") - in a name-binding function

on the report page. I would like to be able to handle this error in reporting services so how. Essientially, I would want to be able to just say if this error happens just take me the plain page and do not load up any defaults.

You might consider this a hack, but this can be solved from outside Reporting Services with the new missing member functionality in 2005 (ie invalid member lookups wont generate errors),|||I am using RS 2005 and AS 2005 RTM.

I am having the report to accept a parameter UserUserID that accepts values such as [User].[User ID].&[1].

This is working fine when the front-end calls it with a correct/valid UserID.

When it is the calling the report with a valid UserID, two things that I observe happening:
a) when the Parameter is set to Hidden (on the Report Parameters properties), this error will be displayed "The 'UserUserID' parameter is missing a value"
b) when the Parameter is not set to Hidden, a blank page is shown with the parameter prompt <Select a Value>.

Is there any way to better handle situation a)? Since I need to hide the parameters from the end-users....

Thanks.