Hi,I have installed the Sql server 2005 standerd edition to my computer
but i cant find this folder to view report service authentication samples ?
C:Program FilesMicrosoft SQL Server90Samples ?
but i can see C:Program FilesMicrosoft SQL Server90 folder !
any idea ?
sujithf
I downloaded the sample reports for report execution from http://technet.microsoft.com/en-us/library/ms161561.aspx
to display reporting services report execution data which worked fine until I'd written a report with multi-valued parameters. As soon as this was designed and more importantly run by an user the package used to create the reports crashed.
I've found out why it's breaking mainly through digging around in the script task where the package crashes and also through surfing the net and finding this
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=967081&SiteID=1
thread. I've tried their fix but it still crashes unfortunately.
It seems like the issue is populating an array indexes in the script component in the update parameters data flow task. I think this was written to deal with minimal parameter requests, however I've recently written a multi-valued parameter report and it's made the string containing the parameter details has now hit the maximum length for the string. Changing the WSTR 4000 to a different size doesn't seem to have an effect, and the forum entry above doesn't hint at what the problem is apart from the script not being able to deal with the length.
The error I now get is as follows:
at MyComponent1.ScriptMain.Input0_ProcessInputRow(Input0Buffer Row) in dts://Scripts/MyComponent1/ScriptMain:line 35
at MyComponent1.UserComponent.Input0_ProcessInput(Input0Buffer Buffer) in dts://Scripts/MyComponent1/ComponentWrapper:line 68
at MyComponent1.UserComponent.ProcessInput(Int32 InputID, PipelineBuffer Buffer) in dts://Scripts/MyComponent1/ComponentWrapper:line 25
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ProcessInput(Int32 inputID, PipelineBuffer buffer)
Anyone have any ideas on how to fix this?
I am trying to run the Readme_HelloWorld sample on the SQL server 2005 Books online. But don't know where I can get the setup.sql, SendMessage.sql, ReceiveMessage.sql scripts.
I followed two examples on the blog, but they did not work at all. Here are the scripts:
/* example 1 */
create database TestSB
go
use TestSB
go
create queue TxQ
create queue RxQ
create message type Msg
create contract MsgContract(Msg SENT BY ANY)
create service TxSve on Queue TxQ
Create service RxSve on Queue RxQ
declare @h uniqueidentifier
begin dialog conversation @h
from service TxSve to Service 'RxSve'
on contract MsgContract;
send on conversation @h Message type Msg ('<hello>World</hello>')
end conversation @h with CLEANUP;
select *
from RxQ
/* example 2 */
use testsb
go
create message type HelloMessage
validation = NONE
go
/** 2. create contract **/
create contract HelloContract
(HelloMessage SENT by initiator)
/** 3. create queue **/
create queue SenderQueue
create queue ReceiverQueue
/** 4. create service **/
create service sender
on queue SenderQueue
create service receiver
on queue ReceiverQueue(HelloContract)
declare @handle uniqueidentifier
declare @message nvarchar(100)
begin
begin transaction;
begin dialog conversation @handle
from service sender
to service 'receiver'
on contract HelloContract
set @message = N'Hello, World';
send on conversation @handle
message type HelloMessage(@message)
end conversation @handle
commit transaction
end
go
Receive convert(nvarchar(max), message_body) as message1
from ReceiverQueue
select convert(nvarchar(max), message_body) as message1
from ReceiverQueue
select *
from SenderQueue
select *
from Receiverqueue
Any assistance or WORKING samples are greatly appreciated.
Does anyone know an easy way to tell when a SQL Server service pack was installed?
CODO ERGO SUM
when i run sql server 2005
select @@version
Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
how to determine that i have installed sql server service pack 2
do i have to restart the server to see the effect, how will it show that it is service pack 2
I have SQL Server 2005 express installed on my machine, and I was wondering if there is any way to have an asp.net 2.0 web service hosted by a different company be able to send sql commands to the sql server on my machine.
View 3 Replies View Relatedif we installed ssis on the same server much later than the engine itself, could it have been installed successfully at an earlier service pack than the engine? I did a select @@version on the engine and got
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
I cant see a way from the client to get a service pack on ssis itself. I'd like to be sure about a suggestion from one of your contributors before approaching our technical guys about their failure to install sp 2 of something.
Hi,
I am trying to install MS Sql Server 2000 on my machine. The OS on my machine is Windows XP SP2. During the installation i keep getting an error message, "Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information." I have copied an extract from the sqlstp.log file below:
10:05:28 Process Exit Code: (-1)
10:05:31 Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information.
10:05:31 Action CleanUpInstall:
10:05:31 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
10:05:31 Process Exit Code: (1060) The specified service does not exist as an installed service.
10:05:31 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
10:05:31 Process Exit Code: (0)
10:05:31 StatsGenerate returned: 2
10:05:31 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
10:05:31 StatsGenerate -1,531793)
10:05:31 Installation Failed.
Can someone please help me solve this problem?
Cheers...
I installed sql server 2005, but the installed program report error.
I copy it at the line below.
And I have use strong password, and I have installed the .net framework 2.0 before I installed sql server 2005.
But the error is the same.
title: Microsoft SQL Server Setup
------------------------------
SQL Server Setup failed to obtain system account information for the ASPNET account. To proceed, reinstall the .NET Framework, and then run SQL Server Setup again.
help info: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28126
Do i have to install ms sql server on ever machine to work Report Builder?
View 5 Replies View RelatedHello Reporting Services 2005 users or Reporting Services Team,
I have done everything to get pass this error but no luck.
My setup is :- WIndows 2003 Standared Edition SP1
Sql Server :-
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Reporting Services starting SKU: Standard.
From the Reporting Services Configuration Manager:
I can see all other things configured except Encryption Keys(blue sign)
Initialization(Grey sign) and Execution Acct(Yellow sign)
My windows Service Identity is using :
NT AuthorityNetworkService
Builtin Acct :NetworkService
Web Service Identity :-
ASP.NET Service Acct :- NT AuthorityNetworkService
DataBase Setup :- Credentials Type :- Service Credentials
I have also done everything from here thanks to Göran
http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861
and
http://forum.k2workflow.com/viewtopic.php?t=619&
If you guys any solution for this please let me know.
I was wondering could this be a scale-out deployment issue ?
I also get the error when setting up the DataBase Setup :
Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys
My Error log file is below:-
w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
every 1 hour my server's computer is restarting !
when the windows finish restarting i open the Event viewer and see that what coused it is the error :
"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."
Event 107
source : "Report Server Windows Service (MSSQLSERVER)"
How can i solve it ?
In sql2k how to find out which service pack is installed?
View 1 Replies View RelatedIn sql2k how to find out which service pack is installed?
View 1 Replies View RelatedHi all,
Does anyone know, apart from the documentation that one keeps on these things, which service pack is installed in SQL Server.
Microsoft versioning reports on 8.00.760 for both.
Any ideas please?
Rgds,
Jim.
How do I determine which SQL7 service pack is install. I ran select @@version and this is the version number it shows: "Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)"
I checked Microsofts site and could not find any info on this.
thanks.
Hi,
I have the subject question both related to MS-SQL Server (desktop version) AND MS-Analysis services.
When I do do Help | About in the Analysis Manager, I get
Version: 8.00.382
And doing the same in Enterprise Manager, I get:
Version: 8.0
Is this indicating that SP3 (which I think is the latest) has been installed or??
Thanks.
I'm using SQL Server Express on Vista. I can't remember whether or not I installed the service packs for SSEE. Is there a quick and easy way to find out?
View 3 Replies View RelatedHi
I'm a newbie and I have a problem that i can't solve despite sitting here all day trying to wortk it out.
I have installed SQL Server Express 2005 along with the associated toolkit. Previous to that i installed MS Visulal studio 2005, .NET 2.0 and MSDN.
The problemn is that it appears despite installing everything i don't have SQLExpress services running on my PC. I have admin rights, it installed okay but there is nothing to connect to.
When i run "sqlcmd.exe -s (local)SQLExpress -E" from the command prompt i get the following message:
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
When i run SQL Server Configuration there is no "SQLExpress" service present under "SQL Server 2005 Servcies" in SQL Server Configuration dialog; just a message saying:
"there are no items to show in this view"
When i run Surface Area Configuration i get the following message:
TITLE: Surface Area Configuration
------------------------------
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
------------------------------
BUTTONS:
OK
------------------------------
If you can shed any light on this id be extreamly grateful as i'd been here for hours before stumbling across the toolkit (why this wasn't bundled i don't know) only to realise once i had it that the SQLExpress service isn't running :(
Cheers,
Nick.
Is there a query I can run to verify if any of the SQL 7 service packs
are installed on a Server?
Thanks in advance.
I am a bit out of my league here so any help would be greatly appreciated.
On a Windows SBS 2003 R2 server. I am trying to add Integration Services at the request or an external Consultant group. I ran the install & followed the bouncing ball from this article
http://msdn2.microsoft.com/en-us/library/bb326043.aspx
The only odd thing is that it didn't give the option to pick an instance (only Microsoft SQL Server 2005).
It seems to install fine, no pop up error or anything but the SSIS service isn't installed. If I try & connect to it via the SQL Server Management studio - Selecting Integration Service in Server Type I can browse for the server name but on connecting it says " Connect to SSIS service on machine "Riley" failed
The specified service does not exist as an installed service.
& looking through the list of Services I can't find it.
I have uninstalled Integration services & reinstalled twice now but the same result (no service) ... what am I doing wrong, it seemed so simple from the instructions.
How can I determine if SP1 is installed for SQL Server 2005?
TIA
Hi,
I want to know whether the MSDE is already installed or not on my system using a C# program. For this I have a method which will take the service name as argument and returns whether that servce is found or not. Now I want to know which windows service (service name) will be running on my machine if the MSDE is already installed. Please help me out.
Hi,
I have question regarding the MSDE and its service pack information.
For example,
How i can get the installed MSDE version and its service pack information in a given desktop?
Is there any way to find the above using APIs?
Can anybody help me in this
Thanks in Advance
Regards,
Alagumani Boju.
Software Engineer - Developer.
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
View 5 Replies View RelatedHow can I find out if SSRS 2005 service Pack 2 is been installed on my system?
View 4 Replies View RelatedI upgraded the OS on my SQL 2005 SP2 to Windows 2003 SP2. Everything still works fine but now Windows Update says that I need SQL 2005 SP2 again. I checked the version of SQL on the server and it's still SP2. Did the Windows service pack somehow downgrade parts of my SQL installation? I know I can probably just reinstall the SQL service pack but I was just curious...
View 2 Replies View RelatedHi,
I'm looking for the sample application : IBuySpy Delivery Sample Application (SQL Server Compact). But I could not find this sample file anywhere.
The only sample which is available in my local directory below is Northwind.sdf file
C:Program FilesMicrosoft SQL Server Compact Editionv3.5Samples
The link in the Book Online is pointing to this URL below :
http://www.microsoft.com/downloads/details.aspx?FamilyID=1ff0529a-eb1f-4044-b4b7-40b00710f7b7&displaylang=en
Can anyone help me on this?
Thanks,
There are five msi files listed for downloading.
SqlServerSamples.msi
AdventureWorksDB.msi
AdventureWorksDBCI.msi
AdventureWorksBI.msi
AdventureWorksBICI.msi
What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?
Thanks,
ok, I've installed sql server, run the install samples and database, but when I go into SQL Server, the database and samples are not there. How do I connect the two?
thx,
Kat
Hi,
Can someone tell me where I can download the "SQL Server 2005 BI Metadata Samples toolkit"? Seems the old ulr doesn't work right now.
Thanks in advance.
Mike
Downloaded the file for the Adventure Works DB Sample. Which folder do I need to install it in to have show up in SQL Server Express 2005??
View 5 Replies View RelatedHi
I am in weired move kindly help me out..I created report using sql server 2005 Reporting services..At one stage it is working fine with proper parameter but due to bad input parameter my report goes in hang mode..so i went to my DB server and restart my reporting service and then MSSQLSERVER I dont remember sequence (may be vice versa) now I am not able to get report when i am passing right parameter..I went to google and only I came to know that due to sequence of restart of services will cause this error..
error like..Application error:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Syste error:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Kindly help me out.
T.I.A