relationships in Project server2k3-> reporting services?

Ok,
We have setup SQL2005 reporting services with MOSS integration. I have
created a datasource that points at our Project server 2003 SQL
database so that we can start to create project server reports. The
data source works just fine BUT its *doesnt* pick up any relationships
between tables from the Project2k3 SQL database.
This means that when you create a report builder report the first
table you selct becomes the primary and no others are visable :( not
very useful for creating meaningful reports.
Questions:
a) How does SQL2005RS read the relationships between table entities in
a remote DB so that they can be used together within the report
builder?
b) Does anyone have recommendations, URLs, How-tos on setting up
reporting services against Project server 2003?
Tips welcome
Al BlakeI have written many reports against the Project Server 2003 database. I have
found there are not relationships in the Project Server database. You always
have to create your own joins of the data.
Most of the time I will create a query using query analyzer, Then use SRS
to group ,filter and sum the data.
Hope this helps
--
Ray McCoppin
http://www.randsmanagement.com
Project Server reports.
"scubaal" wrote:
> Ok,
> We have setup SQL2005 reporting services with MOSS integration. I have
> created a datasource that points at our Project server 2003 SQL
> database so that we can start to create project server reports. The
> data source works just fine BUT its *doesnt* pick up any relationships
> between tables from the Project2k3 SQL database.
> This means that when you create a report builder report the first
> table you selct becomes the primary and no others are visable :( not
> very useful for creating meaningful reports.
> Questions:
> a) How does SQL2005RS read the relationships between table entities in
> a remote DB so that they can be used together within the report
> builder?
> b) Does anyone have recommendations, URLs, How-tos on setting up
> reporting services against Project server 2003?
> Tips welcome
> Al Blake
>|||Thanks for the feedback. I thought that was the case but wanted be
sure I hadnt missed something.
I am quite comfortable in making the queries through SQL QA until I
get the right result but then I am unclear as to how I get this into
the SQL2005RS environment through MOSS.
Are you saying I should define views within the SQL database and then
use report builder to make a report against that?
OR
is there some way to 'parameterise' the Report Model object when you
create it to use a SQL queiry with join as the basis of its model?
As far as I can see when I create a RB model the ONLY option I have is
the datasource I want to use......there doesnt seem to be any way to
create an RBM from a datasourse using
SELECT * FROM A,B WHERE A.ID=B.ID
or am I missing something again?
Regards

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

You can use enterprise manager from sql 2005 to administer both sql 2000 and sql 2005 databases.

I doubt that the enterprise manager from sql 2000 would work with a sql 2005 database.

|||How should I use enterprise manager in SQL2005?|||

Its Management Studio.

From Management Studio, you can connect to both sql 2000 and sql 2005 databases.

http://www.aspfaq.com/sql2005/show.asp?id=3

|||this SQL Express, is there any stest I can use for SQL 2000?|||

Hi

Below is from previous link:

As for connecting to Express from application code, this should not be any different from connecting to a named instance of SQL Server 2000. Your connection string should look like this, assuming local machine and an instance name of SQLEXPRESS (you might need a different instance name, and you may have to use a machine name, rather than "." (which means local)).

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

you can't use it even if it registers.

here's a story:

i have bothe Enterprise manager and management studio on the same box

what ever i register on the management studio gets registered to EM.

but the problem is i cant open version 9 Db on EM even it i see it on the list of server

Register SQL2005 in SQL2000 EM

I have 2 development machines. SQL2000 is installed on the first one and
SQL2005 is on the second machine. Is it possible to register SQL2005 and
have an access to it on the first machine via Enterprise Manager? I'm trying
to do that and get messages that server doesn't exist or access denied.
Either it's not possible at all or I'm using wrong approach or...
Thank you
Vlacha
Nope.. it is not possible to register sql2005 with sql 2000 em.. you need
management studio..
VT
"Vlacha" <abc@.optonline.net> wrote in message
news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>I have 2 development machines. SQL2000 is installed on the first one and
>SQL2005 is on the second machine. Is it possible to register SQL2005 and
>have an access to it on the first machine via Enterprise Manager? I'm
>trying to do that and get messages that server doesn't exist or access
>denied.
> Either it's not possible at all or I'm using wrong approach or...
> Thank you
> Vlacha
>
|||Thanks a lot for saving my time
Vlacha
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Nope.. it is not possible to register sql2005 with sql 2000 em.. you need
> management studio..
> VT
>
> "Vlacha" <abc@.optonline.net> wrote in message
> news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>
|||You can, however, use Query Analyzer with SQL 2005.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Vlacha" <abc@.optonline.net> wrote in message
news:e3dyaO4IHHA.1912@.TK2MSFTNGP03.phx.gbl...
> Thanks a lot for saving my time
> Vlacha
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>

Register SQL2005 in SQL2000 EM

I have 2 development machines. SQL2000 is installed on the first one and
SQL2005 is on the second machine. Is it possible to register SQL2005 and
have an access to it on the first machine via Enterprise Manager? I'm trying
to do that and get messages that server doesn't exist or access denied.
Either it's not possible at all or I'm using wrong approach or...
Thank you
VlachaNope.. it is not possible to register sql2005 with sql 2000 em.. you need
management studio..
VT
"Vlacha" <abc@.optonline.net> wrote in message
news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>I have 2 development machines. SQL2000 is installed on the first one and
>SQL2005 is on the second machine. Is it possible to register SQL2005 and
>have an access to it on the first machine via Enterprise Manager? I'm
>trying to do that and get messages that server doesn't exist or access
>denied.
> Either it's not possible at all or I'm using wrong approach or...
> Thank you
> Vlacha
>|||Thanks a lot for saving my time
Vlacha
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Nope.. it is not possible to register sql2005 with sql 2000 em.. you need
> management studio..
> VT
>
> "Vlacha" <abc@.optonline.net> wrote in message
> news:u%23I7rF4IHHA.3872@.TK2MSFTNGP06.phx.gbl...
>|||You can, however, use Query Analyzer with SQL 2005.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Vlacha" <abc@.optonline.net> wrote in message
news:e3dyaO4IHHA.1912@.TK2MSFTNGP03.phx.gbl...
> Thanks a lot for saving my time
> Vlacha
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:uZuHLK4IHHA.2236@.TK2MSFTNGP02.phx.gbl...
>

register sql2000 on SQL2005 manager

I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==| X-WBNR-Posting-Host: 82.228.221.13
| From: "=?Utf-8?B?UEJFTklTVFk=?=" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|

register sql2000 on SQL2005 manager

I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.
Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default...national.aspx.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "=?Utf-8?B?UEJFTklTVFk=?=" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|

register sql2000 on SQL2005 manager

I have two servers 2003, one running sqlserver 2005 and the second sqlserver
2000.
I'd like to register the sql2000 on the sqlserver management studio provides
with sql2005.
when I trie to connect to server with sql2000 I get an time out error. I've
already activated all the protocol : tcp/ip, named pipe ...
The target is to restore sql2000 database on sqlserver 2005.
thanks for your help.Hi,
Welcome to MSDE Managed NewsGroup. This is Justin from Microsoft.
It is supported to manage SQL2000 in SQL 2005 Management Studio. However,
if you only need to restore SQL2000 database to SQL2005, I recommend you
backup the SQL2000 database in the SQL2000 Enterprise Manager and copy the
backup file tot he SQL 2005 machine and then restore the backup file to
SQL2005.
I do not see much benefit to manage SQL2000 in Management Studio in this
case.
If you really need to register SQL2000 in Management Studio, please verify
that you can connect to the SQL 2000 from the 2005 machine.
1. Ping the 2000 server from the 2005 box and see if it succeeds
2. Telnet to the particular port and see if it works:
Telnet ServerName 1433
NOTE: Please run the Server Network Utility from the 2000 box to
determine the port SQL Server is listening. It might not be 1433 if it is a
named instance.
3. Create a UDL file to connect to the 2000 and see if it works.
- You can create a .txt file on the desktop, change its extension to
UDL and double-click it to launch the Data Link dialog box
If the step 1 & 2 do not work, you need to contact your network team and
see if there is any problem in the Network.
If you have any question, please feel free to let me know.
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: register sql2000 on SQL2005 manager
| thread-index: AcYmlKMdyn41f0o1QSWXgimqxWzbcg==
| X-WBNR-Posting-Host: 82.228.221.13
| From: "examnotes" <pbenisty@.newsgroups.nospam>
| Subject: register sql2000 on SQL2005 manager
| Date: Tue, 31 Jan 2006 10:32:06 -0800
| Lines: 11
| Message-ID: <4F8CEDBF-7DBF-4699-BADF-8D20D12B3A15@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:419556
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have two servers 2003, one running sqlserver 2005 and the second
sqlserver
| 2000.
| I'd like to register the sql2000 on the sqlserver management studio
provides
| with sql2005.
|
| when I trie to connect to server with sql2000 I get an time out error.
I've
| already activated all the protocol : tcp/ip, named pipe ...
|
| The target is to restore sql2000 database on sqlserver 2005.
|
| thanks for your help.
|