How To Configure New Development Workstation To Use VS2005 With SSRS?

Sep 27, 2007

Just getting started using SSRS (SQL Server Reporting Services) 2005 in production and I've got what should be a simple question.

How do I configure a development workstation to be able to develop SSRS reports which will run on a networked server running SQL Server 2005?

Here is my problem...
I installed VS2005 (Visual Studio Pro 2005) and SQL Server 2005 workstation components (with SQL Server SP2) on the workstation but the "Business Intelligence Projects", "Business Intelligence Wizards", and "Report Projects" are missing from the New > Project types. How do I get them added?

I can access the network SQL Server and the http://<Server>/Reports from the workstation.
On the SQL Server I can develop & deploy reports using BIDS (Business Intelligence Development Studio), on the server.
But on the workstation I cannot create a new Report Project nor can I open an existing reporting project (rptproj) or solution. (I get the error that rptproj is not intalled and that I should install the associated program...which is what?)

WORKSTATION:


Windows Vista Business with all the latest updates.

Visual Studio Pro 2005 with SP1 & Vista SP1 Update installed.

SQL Server Workstation Components (and Reporting Services components) & SP2 update installed.

NETWORK SERVER:

Windows Server 2003 Standard

SQL Server 2005 Standard with SP2 & Reporting Services installed.

This should be a simple question, but I'm suprised that it is not working after installing what seemed like the appropriate components from the SQL Server 2005 disk.

Any suggestions on how to get the SSRS projects to show up and work in the Visual Studio 2005 on the development workstation?

Thanks!
-Erik

View 14 Replies


ADVERTISEMENT

How To Configure Developer Workstation Using Microsoft Server Express

Jul 10, 2015

I have need to configure Microsoft SQL Server 2014 express on my development machine. I have never worked with Microsoft SQL Server and could use some direction. I have done MYSQL work before but the seems much different.

View 3 Replies View Related

[SQL 2005 Express] Question On Business Intelligence Development Studio (VS2005)

Jan 6, 2007

I am trying to create a report using BI Development Studio.In Pivot Table, I can change the presentation of the data area to align with row or column, just like this:http://img164.imageshack.us/img164/2055/untitledsi4.pngHowever, I can't seem to do that in BI Development Studio while designing the report. Does any of you know how to change the presentation of the data area of a report?This is how it looks like now, the data area is sticking to the COLUMN, but I need them to stick with ROW so that I can handle more columns....http://img103.imageshack.us/img103/4066/untitlednc8.png

View 1 Replies View Related

Installing VS2005 And Business Intelligence Report Projects On A Vista Business Workstation

Oct 23, 2007

Does anyone have a successful prescribed sequence for installing VS2005 and Business Intelligence Reports Projects on a Vista Business workstation to be used to create reports for a server?

I've looked through everything I can find here and I don't seem to see a clear solution without a lot of trial and error.

Fact is, I've not been successful getting just the reports to install on a plain XP box. Of course, the report creation looks fine on the server but I don't want to work directly on the server.


Thank you

View 1 Replies View Related

Localize Web ReportViewer Control In VS2005 / SSRS 2005 / ASP.net 2.0???

Apr 24, 2006

Is it possible to translate the web report viewer control to another language (german, french...)? I need to integrate the control in a multilingula website.

I need also to change the messages from the report during the rendering "Report is being created".

And is it possible to change the little green animated icon during the process of creating a report?

Thanks,
Dirk

View 7 Replies View Related

I Am Unable To Configure SSRS

May 9, 2008

Hi

I am unable to start the SSRS . I have tried to start the service through SSRS configuation and even in configuration manager also.

I am getting the following error . help me out

"The request failed or the service did not respond in a timely fashion.COnsult the event log or other applicable error logs for details"

i Have gone thourgh surface area configuration also.



Thanks

View 1 Replies View Related

SSRS Configure Error While Switching Panels

Nov 6, 2013

i want to upload reports in ssrs , when i trying to configure reporting service configuration manager, getting error" there was an error while switching panels. The most likely cause is an error retrieving wmi properties. the exception details are access is denied . You must have an administrator on the report server computer to use this tool".

View 2 Replies View Related

Unable To Configure SSRS For Forms Authentication

Apr 23, 2007

Hi all,

I need help regarding forms authentication in SSRS. I exactly followed the steps described in the article: http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx. However it doesn€™t seem to be working at my end. The only things that I didn€™t implement correctly are the two members of IExtension interface, here€™s the code for these two members;
public string LocalizedName
{
get { return "Naveed"; }
}
public void SetConfiguration ( string configuration )
{
//throw new Exception("The method or operation is not implemented.");
}

After performing all the steps mentioned in the article when I access http://<servername>/reports, it displays my login page alright, but when I submit the user credentials (whether right or wrong) it gives me:
€œAccess denied creating App_Data subdirectory€?
Description: For security reasons, the identity 'NAVEEDSIDDIQUIASPNET' (under which this web application is running), does not have permissions to create the App_Data subdirectory within the application root directory. ASP.NET stores the Microsoft SQL Express Database file used for services such as Membership and Profile in the App_Data subdirectory of your application.

Along with steps of how to grant the required permission. My question is why it is trying to create the new directory. Does it mean it is unable to find the database or does it mean something else? When I access http://<servername>/reportserver, it gives me:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Could not load type 'Vantage.CustomSecurityExtension.Logon'.

Could not load type 'Vantage.CustomSecurityExtension.Logon'.

Could not load type 'Vantage.CustomSecurityExtension.Logon'.

Could not load type 'Vantage.CustomSecurityExtension.Logon'.
Here €˜Logon€™ is the name of the code-behind class of my login page.

Please help me out in this problem.

Thanks and Regards,
Naveed

View 1 Replies View Related

Reporting Services :: Powershell Script To Configure SSRS 2012?

Jun 12, 2015

We have 15-20 report server environments including Dev/SIT/UAT/PROD/DR etc. so instead of configuring it on each servers, we would like a script to use with parameters.

After installing the SSRS 2012 package on each server with given instance and service account, I would like to configure the SSRS through script instead on running the Configuration manager RSConfigTool.exe manually.

we already have created the database beforehand using the scripts provided by WMI. do we need db_owner permission on msdb and master database to configure SSRS?

View 2 Replies View Related

SSRS Report Rendering Different In VS2005 And In Report Viewer Via URL Access

Apr 17, 2008

Hello,
I'm using Reporting Services to render a text (stored in sql as varchar(max)). The text is all plain text, with some lines having trailing spaces.

Source text file i've imported to SQL via SSIS:
CLIENT: 10055
STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3
TRY THIS


*Note the trailing spaces on the line before 'STATEMENT 2007'.

I've designed a report using the Report Project in VS2005 to retrieve this text via a stored procedure. When I test the report using the 'Preview' tab in the IDE, it looks good
CLIENT: 10055
STATEMENT 2007
DATE:1002993
THIS IS THE OTHER STATEMENT
COLUMN1 COLUMN2 COLUMN 3
TRY THIS



But when I deploy the report and run it using URL Access:

CLIENT: 10055
STATEMENT 2007
DATE:1002993

THIS IS THE OTHER STATEMENT

COLUMN1 COLUMN2 COLUMN 3
TRY THIS

On all lines with trailing spaces, they (the trailing spaces) have been removed. This is affecting my formatting of some reports and statements. We really want to use the report viewer as it has built in paging, print and export capabilities.

Why does it look okay in VS2005 but different in Report Viewer via URL Access and Report Manager?

Note: When I export as PDF, it looks okay.

The stored procedure I use to return the data is a CLR Hosted assembly as below:



Code Snippet
Partial Public Class StoredProcedures
<Microsoft.SqlServer.Server.SqlProcedure()> _

Public Shared Sub GetPagedDocument(ByVal inText As SqlString)
Dim dr As SqlDataReader
Dim row As New SqlDataRecord(New SqlMetaData("RowText", SqlDbType.Text))
Dim cmd As New SqlCommand("select cast(doc as varchar(max)) as 'DOCTEXT' from testdoc WHERE id='" + inText + "'")
Dim cn As New SqlConnection("context connection=true")
cn.Open()
cmd.Connection = cn
SqlContext.Pipe.SendResultsStart(row) 'initialise the resultset to be returned
dr = cmd.ExecuteReader
'If no records in result set, return.
If Not dr.HasRows Then

row.SetString(0, "There is no document to display or you do not have permission to view the document.")
SqlContext.Pipe.SendResultsRow(row)
SqlContext.Pipe.SendResultsEnd()
' SqlContext.Pipe.Send("There is no document to display.")
Return
End If
'Read rows in the result set
dr.Read()

'Get the entire text
Dim docText As String = dr.Item("DOCTEXT")
'debug
row.SetString(0, docText)
SqlContext.Pipe.SendResultsRow(row)
SqlContext.Pipe.SendResultsEnd()
Return
'end debug

End Sub
End Class




Any help will be appreciated.

View 3 Replies View Related

SQL Server 6.5 On MS NT4.0 Workstation

Dec 14, 1999

I recently installed VB6.0 Enterprise on my system. As a part of the installation is the option to install SQL Server 6.5 Development. I elected to install SQL. The install went without any glitches. Upon going into SQL Enterprise Manager, I was asked to register the server where SQL was running.
My understanding was that SQL would allow me to register the name of my host system. (This is a stand alone system with VB6.0 and Sql development 6.5 installed - no network attached). SQL will not allow me to register my server's name as the host server. It says that if cannot connect to the named server. SQLSERVER and SQL EXEC services appear to be running without any problems. Anyone have any idea where I should start or what could be disallowing my connection/registeration of my server. Any help would be greatly appreciated..... Thanks... Tom

View 1 Replies View Related

SQL Server On Win XP Workstation

Jan 7, 2004

Developers wanting to access sql server developer edition on XP workstation in small office network (workgroup) will have problems using windows authentication (trusted connection) if the XP "server" machine has "simple file sharing" enabled.

Simple file sharing in XP can be disabled in control panel - folder options.

For this sneak mode to work accounts with the same user and password should exist on both "client" and "server".

At least it worked for me!

View 1 Replies View Related

Workstation Date

Jan 31, 2006

Hi all!Is there any function in SQL that I can use to get current date fromworkstation? All functions which I tried (now(), getdate() etc.)returns current date from server but I need date from workstation.Regards,Mirnes Lemes

View 3 Replies View Related

Remote Admin Using MMC On NT Workstation

May 30, 2000

Hello,

I would like to know if one can adminiter SQL server remotely using MMC on NT workstation? If so, how do you install the MMC and SQL Enterprise Manager Add-in on NT workstation?

Thanks for the help

Kevin

View 1 Replies View Related

Problem Configuring Workstation

Apr 14, 1999

How can I configure my workstation running WIN95 to used the SQL Enterprise Manager from the server end and other utilities. I have installed the client network utility.

Reason to use enterprise manager because I wanted to perform administrative tasks on my workstation and I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.


Can anyone helps?

View 1 Replies View Related

SQL 2000 Standard Ed. On W2k Workstation?

Jul 4, 2001

Hi there,

I need to use transaction replication between 2 DB Servers. One is running
W2k Server, the other is a W2k Workstation.

Can I install the SQL 2000 Standard edition on the Workstation in order to
implement Transaction replication?

are there other posibilities/suggestions?

Any help highly welcome!
Volker

View 1 Replies View Related

Connection Problem With The Workstation

Jul 23, 2005

Hi all;I am trying to replicate our database by using the merge replication.[color=blue]>From server side I tried to connect to the workstation. I have[/color]installed MSDE to the client machine. I can see the machine name on theSQL Server Group however I wasnt able to create the conncetion betweenthe machines. I have checked my network connection, there is no problemI can see the machine and I can connect it through the network. I triedto use Client Network Utility with Named Pipes and TCP/IP but not agood news. I couldnt achieve to connect to the machine. So couldsomeone please help me out with this problem. I am really in trouble Ihave to find out this end of this week.RegardsAs

View 3 Replies View Related

How To Find Out Workstation Name From Net_address

Jul 20, 2005

Hi,Is it possible to know workstation name from data in columnnet_address from master..sysprocesses?TIA

View 2 Replies View Related

Can't Install Workstation Components

Mar 10, 2008



I've got VS 2008 Pro installed, as well as SQL Sever 200 (which I must keep installed). When I run the install for SQL Server 2005 developer edition, it continually fails to install

SQL Setup Support Files
SQL Native Client
Backward Compatability Files
SQLXML4
Workstation Components

I'm at a complete loss here. I've googled the problem, and apparently this is not uncommon. Is there a good resolution to this?

View 6 Replies View Related

Cannot Install Anything But Workstation Components Etc.

Mar 4, 2008

Hi,

I had a perfectly good working copy of SQL Server 2005 installed. However, at some point I needed the Report Services Designer so I could edit my reports in Visual Studio. I inserted the CD and selected the feature from the list and it installed. Only problem being that it has completely removed my Management Studio and practically every other tool I didnt explicitly checked when installing the RS Designer.

When I tried to run the same Setup again and check everything, it tells me that there is no change between what I have selected and what is installed, which sounds like total bs to me, since my pc doesnt have a management studio etc anymore.

Out of pure misery I decided to remove my entire SQL Server installation, inc Instance, hoping to start anew and achieve the result I wanted with the least amount of frustration. I ended up here and followed it all the way: http://support.microsoft.com/kb/909967

When I started reinstalling, I ran into something new. The installer refuses to let me install anything but the Workstation components, books online and development tools. All the other options are greyed out and not even available.

Someone please help me get my SQL Server back up and running because I'm getting hopeless.

-DeV

View 5 Replies View Related

Workstation Components Not Available At All On SS 2005 X64 CD For X86 XP?

Aug 9, 2006

It appears that there is no way to install SQL Server 2005 Workstation Components on an x86 operating system (XP in this case) if you have the x64 install disks (Standard Edition). Can someone verify this?

I am finding it hard to believe that workstation components for a standard Windows client environment are not distributed with the version of SQL Server that matches Windows 2003 x64.

Thanks,
Chris

View 1 Replies View Related

Connection String - Server Vs Workstation

Apr 29, 2006

I have the following connection string in my Windows app that works fine on the Server:
workstation id=SCSXP;packet size=4096;integrated security=SSPI;data source=scsxp;persist security info=False;initial catalog=nala
But when I use that string on a workstation, it times out.  I do have a Network connection to the Server. 
How should I modify the connection string to work on the workstation?
Thanks,
Bill
 

View 1 Replies View Related

Restricting Enterprise Manager On Workstation

Jan 14, 2002

Hi,

How the SQL enterprise manager registration using winodws NT authentication can be restricted on workstation.

Thanks
John Jayaseelan

View 4 Replies View Related

Registering/connecting To Server From Workstation

Jun 12, 2001

I am running SQL 7 (SP3) on a 2000 Server. When I configure the server as part of the Workgroup I have no problems connecting from the workstation. However, if I join the server to our 2000 domain, I cannot connect and/or register the server from the workstation through EM.

Is this a security issue? If so, what are the minimum requirements or what else am I missing. Any suggestions would be appreciated.

Thank you,
Eugene Jenkins

View 2 Replies View Related

Unable To Schedule Jobs From Workstation

Oct 12, 2000

Hi again,
could anyone tell me what to do about this...I'm not a dba but I do need direct access to the sql server such as scheduling new jobs (I can execute them immediately as pkgs or even run them as jobs on my machine, but to schedule I need to go to the server. The NT administrator does not like the idea of anyone else touching his server, so is there any way to circumvent the situation and do the scheduling from my workstation? Someone had mentioned creating an icon on my desktop but I'm not clear on the idea. Thanks a million. I get great help on this website.

View 10 Replies View Related

Uninstall SQL 6.5 Client Tool From NT Workstation

May 12, 2000

Hi:

I have installed SQL 6.5 client tool on to my workstation. Since then, we have upgraded to SQL 7.0 on our server. I installed SQL 7.0 client tool to my workstation and have been using it. I want to remove SQL 6.5 client tool from my workstation and do not know how. There is no uninstall button in the SQL 6.5 folder nor this program exists in Add/Remove Program in COntrol Panel. Can you help? Thank you.

-Nicole-

View 1 Replies View Related

Stop Server Using EM From Workstation (login As `sa`)

Sep 1, 1998

Could someone please tell me what I have to set at the Server side so that I will be able to STOP and START the SQL Server using Enterprise Manager and `sa` login remotely, say from the workstation.

Thank you in advance for your help

Asfen

View 7 Replies View Related

Workstation Connects Only Using Standard Security

May 20, 1999

I have 3 NT Workstations that will not connect to my SMS database using NT Integrated Security. The SQL 6.5 server is set up to use mixed security. The only way to connect to the server is to use a standard sql account. Any ideas? THis happens to all users even administrators.

Thanks in Advance.

View 1 Replies View Related

Cant Install Workstation Com (ADD_LOCAL Error)

Feb 27, 2008

Cannot install Workstation Components (Management Studio,etc) (ADD_LOCAL error)

I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition
(downloaded and ran the SP2 Update), Visual Studio 2008. VS2008
installs no problem. When I install SQL Server 2005, I get an error
when it trys to install the last part( Workstation Components,
Management Studio, etc).
I have tried FULLY, MANUALLY removing all SQL products and registry
entries. I have used Windows Installer Cleanup Utility. I have tried
Microsoft's recommended way of manually removing SQL Server 2005.
If I manually run SqlRun_Tools.msi the error comes up right away.

The error is:
"A component that you have specified in the ADD_LOCAL property is
already
installed. To upgrade the existing component, refer to the
template.ini and
set the UPGRADE property to the name of the component."

Here's the Setup Error log: http://toby.pastebin.com/f63405e24

Any help?! Thanks!
-Toby

View 2 Replies View Related

Workstation Sees 2 Instances Of The SQL Server?

Jul 23, 2005

This might not be a SQL Server question, might be something else. Ihave a workstation on a LAN that can't connect to the SQL Server. WhenI try to configure a User DSN to connect to it, the server name I wantappears TWICE in the list of possible servers. No matter which one Iselect, it can't get the connection.The workstation also can't connect through EM or QA.We've checked the user's permissions, we've re-installed some serverpacks, re-installed the Client Tools, we've even hunted through theregistry, everything looks OK, but we still can't connect. This is theonly machine on the LAN that can't connect. Everybody else connectsfine.I'm stumped. Any ideas? Anybody ever seen the server name appeartwice like that?-Emily

View 2 Replies View Related

Uninstall SQL 2000 Workstation Components

Mar 28, 2008

Hey yall. I'm a DBA in a company where I do NOT have the ability tocontrol who logs into my SQL servers as administrator, so I'm lookingfor a way to uninstall the workstation components WITHOUT completelyuninstalling all of my instances. Does anyone know how to do this?All I can find is the complete removal option in add/remove, and theinstall cd setup doesn't have a remove function that I can find. Anyidea's?The reason for wanting to do this is so that every tom dick and harrythat logs in as administrator doesn't have the ability to just open EMand do what they please. I want to force people to log in fromanother box so I can get tighter control over who can access mydatabases. Any help is awesome, thanks!Joshua Austill

View 2 Replies View Related

Insall SSMS From 64 Bit Media On 32 Bit Workstation

Jan 8, 2007

I'm having no success install SSMS on a 32 bit workstation from 64 bit media.

I'm aware from researching that the SSMS is 32 bit, in fact I see it run as a 32 bit app on the server.

However, when i try and install from the 64 bit CD or DVD I get errors such as not a valid Win32 application, or when i tre random msi's guessing as to which is ssms I get "This installation package is not supported by this processor type. Contact yoru product vendor."

I run a Pent D 2.8 on 32 bit XP

Any assisstance on how to install SSMS on a 32 bit workstation from the 64 bit media would be greatly appreciated.

View 1 Replies View Related

Moving Projects From Server To Workstation Issue.

Jul 17, 2006

Dear folks,

I€™ve moved my server folder which contains about 10 dtsx and its ADO .net connection as well as OLEDB into my folder workstation. Then, when I€™m gonna to open them appears this error:

Error 1 Error loading M_HAC_Modelo198_CECA.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Clave no válida para utilizar en el estado especificado.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. c:ssishacienda_anualM_HAC_Modelo198_CECA.dtsx 1 1

Translate into english: "Clave no válida para utilizar en el estado especificado" = Invalid key for to use in the specified state (more or less)


What really happen? Well, I wrote these packages using a domain user (belong to Administrators group in Active Directory) via Terminal Server and now I want to modify them by mean my domain user (I already have got installed sql25k client tools and the stuff required)

I thouht that these connections were saved in the same folder where dtsx, dtsproj, etc..


Solution? Create them again? I hope that it will be a piece of cake otherwise...


Thanks in advance for any though or advice,

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved