having trouble getting reporting services installed properly

Hi,
I am running Windows 2000 and VS 2003.
I installed Reporting Services with service pack 2.
When I type: in http://reportserver/reports I get an access denied 403 error.
When I go into IIS Manager and look for the Report folder properties I can't
find the Reports virtual directory. It does not exist.
So, how is it when I goto http://reportserver/reports I get a 403 error and
not a 404: File not found error.
The service is run as the executable: reportingservicesservice.exe
(discovered this through internet searches) on the machine, but when I search
for it, I can't find the file.
I have created a report and successfully viewed it in the VS 2003 Report
Designer, but the reporting services and Report Manager don't exist.
I do have this directory with lots of files, but I don't seem to have the
start page for Reporting Manaer anywhere on my system.
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
Could someone please advise.
Thank You
ChrisDid you open the reportning services configuration manager (new with 2005)
and configure the 2 folders. In 2005 it doesnt automatically create the 2
virtual folders, you have to explicitly create them through the configuration
manager.
Go to reporting services configuration (it should be somewhere in your
"START --> All programs") and connect to your report server, and make sure
the virtual directory tabs are green checked. If not set them
"Chris" wrote:
> Hi,
> I am running Windows 2000 and VS 2003.
> I installed Reporting Services with service pack 2.
> When I type: in http://reportserver/reports I get an access denied 403 error.
> When I go into IIS Manager and look for the Report folder properties I can't
> find the Reports virtual directory. It does not exist.
> So, how is it when I goto http://reportserver/reports I get a 403 error and
> not a 404: File not found error.
> The service is run as the executable: reportingservicesservice.exe
> (discovered this through internet searches) on the machine, but when I search
> for it, I can't find the file.
> I have created a report and successfully viewed it in the VS 2003 Report
> Designer, but the reporting services and Report Manager don't exist.
> I do have this directory with lots of files, but I don't seem to have the
> start page for Reporting Manaer anywhere on my system.
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
> Could someone please advise.
> Thank You
> Chris|||Hi Nagini,
I am not using SQL Server 2005, I am using SQL Server 2000.
Thanks
Chris
"Nagini Indugula" wrote:
> Did you open the reportning services configuration manager (new with 2005)
> and configure the 2 folders. In 2005 it doesnt automatically create the 2
> virtual folders, you have to explicitly create them through the configuration
> manager.
> Go to reporting services configuration (it should be somewhere in your
> "START --> All programs") and connect to your report server, and make sure
> the virtual directory tabs are green checked. If not set them
> "Chris" wrote:
> > Hi,
> >
> > I am running Windows 2000 and VS 2003.
> >
> > I installed Reporting Services with service pack 2.
> >
> > When I type: in http://reportserver/reports I get an access denied 403 error.
> >
> > When I go into IIS Manager and look for the Report folder properties I can't
> > find the Reports virtual directory. It does not exist.
> >
> > So, how is it when I goto http://reportserver/reports I get a 403 error and
> > not a 404: File not found error.
> >
> > The service is run as the executable: reportingservicesservice.exe
> > (discovered this through internet searches) on the machine, but when I search
> > for it, I can't find the file.
> >
> > I have created a report and successfully viewed it in the VS 2003 Report
> > Designer, but the reporting services and Report Manager don't exist.
> >
> > I do have this directory with lots of files, but I don't seem to have the
> > start page for Reporting Manaer anywhere on my system.
> >
> > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
> >
> > Could someone please advise.
> >
> > Thank You
> >
> > Chris

Having trouble getting connections

I have a custom Data Flow Destination Adapter that is looking for a particular type of ConnectionManager. I want to check that this connection exists in the Validate method. I first checked the ComponentMetedata.RuntimeConnections, but it was was an empty collection. I am guessing that it gets populated at runtime. Is there anything available for to check at design time?

Another way of asking this would be, Is there a way to programatically select which ConnectionManager gets assigned to a RuntimeConnection? Normally, this is done on the Connections tab of the Advanced Editor.

Thanks,

Graham

You can assign a connection manager at design time to your adapter and check that it is the correct type in the Validate() method. You will need to let your component know that it is expecting a connection manager.

Allan

|||I realize that I can do that by opening the advanced editor on my destination task and selecting the connection; but I dont want to do it that way. I want to Programmatically look for a connection of a specific type. Below is a code snippet of what I tried to do, but that doesnt seem to work. The connection is not set.

//this takes place in the onload handler for my DestinationAdapter form
//connections is passed in from the UI class that implements IDtsComponentUI
ConnectionManager connMan = null;
foreach (ConnectionManager cm in connections)
{
if (cm.InnerObject.GetType() == typeof(ProfileConnectionManager))
{
connMan = cm;
}
}
profConnMan = ProfileConnectionManager.FindProfileConnection(connections);
dtsComponentMetaData.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(connMan);

|||Is there a reason you don't just get the value of ConnectionManagerType on the properties collection? Also, you're attempting to use a managed code idiom for a connection that may not be managed. Most of the connection managers are native. Is this a custom connection manager? I don't know about the ProfileConnectionManager.|||

You may also want to take a look at IDtsConnectionService.GetConnections and IDtsConnectionService.CreateConnection. Useful for writing UIs. They all work around the connection type that Kirk mentions.

|||ProfileConnectionManager is a custom connection that I have written. I want to allow a custom data flow destination adapter that I have written to look for a ProfileConnectionManager and if one is defined, add it to my CustomDestinationAdapter.ComponentMetaData.RuntimeConnections collection.

In normal situations, this is done at design time by openning the advanced editor and selecting the connection manager from a dropdown. In my situation, I am allowing only one ProfileConnectionManger to be created. So if it exists, I dont want the user to have to select it from the advanced editor; I want that to be done programmatically by me.

When you refer to properties collection, are you saying I should add a property to MyCustomDestinationAdapter.ComponentMetaData.CustomPropertyCollection and assign my custom connection as its value?

thanks,
Graham|||

I would use GetConnections, albeit in a UI, something like this-

foreach (ConnectionManager connectionManager in _dtsConnectionService.GetConnectionsOfType(connectionType))
{
comboBox.Items.Add(connectionManager.Name);
}

connectionType is the string that identifies the type of connection I want. For example if I want ADO.Net SQLClient connections I need to use-

"ADO.NET:System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089";

It is a bit annoying that I have to use the fully qualified name, but that's what works.

The ConnectionManager also has a CreationName property which I use often for validation, and Kirk suggests a ConnectionType property, so using this you could loop as you where above, and check such a property to see if it is your connection. What you should not do is try and get a .Net Type object for the connection manager, as not all of them are .Net objects.

sql

Having issue inserting large text colum into DB

I have a large text colum I am trying to insert into a DB
This colum is about 800 chars longs

I have set the colum type in the table to text

I have set the table option for text in row to on

I have set the table option for text in row to 1000

But it is still chopping the text at the 256 char mark on insert.

Anyone have any ideas ?? This is SQL 2000.

ChrisAre you sure it does? How do you check for the length of the inserted value? By doing SELECT?

Try this:

select datalength(<your_text_field>) from <your_table>

And why do you need TEXT IN ROW setting? Are you searching on that field? If that's the case, - you should implement Full-Text Search.|||In Query Analyzer:

1) press Shift-Ctrl-O to bring up the Options dialog.
2) Click on the Results tab
3) Check the value of the Maximum Characters per Column

If it is too small, make it larger, but keep in mind that this is a VERY RAM expensive operation in the GUI. Don't make it any larger than 255 unless you really need it!

-PatP|||In Query Analyzer:

1) press Shift-Ctrl-O to bring up the Options dialog.
2) Click on the Results tab
3) Check the value of the Maximum Characters per Column

If it is too small, make it larger, but keep in mind that this is a VERY RAM expensive operation in the GUI. Don't make it any larger than 255 unless you really need it!

-PatP
That's why I suggested to use DATALENGTH, because it does not rely on this setting. Besides, what if the value that is inserted greater than 8192? Or you'd think that you inserted 8192 characters?|||That's why I suggested to use DATALENGTH, because it does not rely on this setting. Besides, what if the value that is inserted greater than 8192? Or you'd think that you inserted 8192 characters?You did fine, as far as giving them what they needed to figure out the answer. I just like my solution better because then they can SEE the answer, which is often better than being able to deduce it.

-PatP

Have lost the facility to select a Report Model DataSource Type?

I am trying to create a report from a Report Model, but when I try to select
the Datasource Type I find the Report Model DataSource Type is no longer
available to select. It definitely used to be there.
I have recently been experimenting with the Custom Report Items and modified
the configs etc as per instructions. The Polygons example appeared to work
eventually but at around the same time as experimenting with that, the Report
Model DataSource Type dissapeared. I have restored the config files back to
what they were, but still lost my DataSource Types. I suspect the only real
answer is to reinstall, however, I need to understand how to fix, and how I
have broken it. Where are the datasource types drop downs picked from? and
how best to fix this without reinstall. Any experts out there please help!Unsure how on earth lost the Report Model DataSource Type and the only way I
could find of restoring it was to uninstall all of SQL and reinstall it
again. Lost my Report Server Database, since cannot be restored.
Custom Report Items Health warning - tread carefully... suspect the
RSReportDesigner.config was the one that was clobbered in the process -
losing the RS Data extension. Unclear if it could be recreated somehow
without all this pain. Maybe a repair facility on Business Intelligence
Studio WOULD HAVE HELPED!
"Steve Giergiel" wrote:
> I am trying to create a report from a Report Model, but when I try to select
> the Datasource Type I find the Report Model DataSource Type is no longer
> available to select. It definitely used to be there.
> I have recently been experimenting with the Custom Report Items and modified
> the configs etc as per instructions. The Polygons example appeared to work
> eventually but at around the same time as experimenting with that, the Report
> Model DataSource Type dissapeared. I have restored the config files back to
> what they were, but still lost my DataSource Types. I suspect the only real
> answer is to reinstall, however, I need to understand how to fix, and how I
> have broken it. Where are the datasource types drop downs picked from? and
> how best to fix this without reinstall. Any experts out there please help!

Harware requirements

How does one figure out what type of hardware is minimal and what type of
hardware is optimal for each server involved in replication?
--K
I am unaware of any hardware requirement guide for replication. Replication
has a relatively light resource footprint, so you should select hardware for
your anticipated load without replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kristy" <pleasereplyby@.posting.com> wrote in message
news:%23qCNaj%23LFHA.656@.TK2MSFTNGP14.phx.gbl...
> How does one figure out what type of hardware is minimal and what type of
> hardware is optimal for each server involved in replication?
> --K
>

Handling UNC path names

What is the best handling of a UNC Pathname?

What is the max length of a path name?
Which is the best type of field in SQL Server to use for a path name?

Thanks

I would store this in a VARCHAR field with the appropiate value.

HTH, Jens Suessmeyer,

|||

What is the max length of the path & filename? It used to be 255 chars but I believe it has grown since then.

|||

Maximum name of a UNC path is 260 unicode characters (MAX_PATH defined in windows.h I believe). Search google for MAX_PATH to see lots of people talking about this issue.

So a NVARCHAR(260) should be sufficient unless you allow the \\?\ prefix that bypasses normal MAX_PATH length. If you only have one locale you use for paths, then you can potentially use VARCHAR(260).

handling special characters using oledb to oracle

hi,

i am using oledb to connect to oracle.
i want to know if there is a way to handle different character sets in this type of connection. for sql to sql, i have been using auto translate in the connection string.
what about for sql oledb to oracle? how can i make sure that the data from sql to oracle is transferred as is?

many thanks.

You might be better off asking this on the Data Access forum:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

-Jamie