Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?
Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
sql

Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Datastore not available - SQL 2000

Trying to connect to my Citrix Metaframe presentation server 3.0 and it says
that my datastore is not available. This is a SQL Server 2000 database
installed on another system and when I open the Enterprise manager, I am
unable to see the databases. But, it looks that the database is available in
D:\program files\Microsoft SQL server\MSSQL\Data.
What could be wrong? Has my SQL Server 2000 been corrupted or ?Is it possible that the databases go detached. Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Correcting typos:
Is it possible that the databases got detached? Connect to the master
database using Query Analyzer and run the following query:
Select * from sysdatabases.
Verify that the databases you are looking fo are listed.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Datasource Connection string

Is there option available to dynamically change the connection string
properties of a published report?
--
Thanks
SaranYou could do that through the SOAP API by calling SetDataSourceContents:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_2ojd.asp
Other approaches for dynamic database connections in RS 2000 have also been
discussed on this newsgroup. E.g.:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=b1a2f8b8-457c-4424-9cfd-2c8269734898&sloc=en-us
FYI: RS 2005 will allow expression-based connection strings.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"PTS" <PTS@.discussions.microsoft.com> wrote in message
news:765E3C18-186B-44AB-AA83-A5BA1EC1BEEE@.microsoft.com...
> Is there option available to dynamically change the connection string
> properties of a published report?
> --
> Thanks
> Saran

DataGridViewComboBoxColumn - DROPDOWN STYLE

Dear Sir,

can u tell what command is available for setting the drop down style of a DataGridViewComboBoxColumn. By default it is coming as dropdown list, but i want to make it only drop down, so that i can make the combo blank and populate the list at my will, which we can do with other combo box controls.

with regards,

wilfi

It isn't T-SQL task. You could configure this setting by DataGridView properties, not bu Transact-SQL commands

data-driven subscription not available

I would like to setup a data-driven subscription for a report, but the New
Data-driven Subscription button is not available on the subscription page -
only the New Subscription button appears. I have checked that the report
uses a custom data source and stores the user name and password credentials
in the report server. The account that I am using to access Report Manager
is in the System Administrators role and the Content Manager role for the
report. What am I missing?
Thanks,
RobertDo you have Enterprise Edition? This feature is not available in Standard
Edition.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RMac" <@.news.postalias> wrote in message
news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
>I would like to setup a data-driven subscription for a report, but the New
> Data-driven Subscription button is not available on the subscription
> page -
> only the New Subscription button appears. I have checked that the report
> uses a custom data source and stores the user name and password
> credentials
> in the report server. The account that I am using to access Report
> Manager
> is in the System Administrators role and the Content Manager role for the
> report. What am I missing?
> Thanks,
> Robert|||That is the problem then. I was not aware that Data-driven subscriptions
are not available in Standard Edition. Thanks Jasper.
"Jasper Smith" wrote:
> Do you have Enterprise Edition? This feature is not available in Standard
> Edition.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "RMac" <@.news.postalias> wrote in message
> news:EC568923-1967-44FE-8A17-4E2E67AC53D2@.microsoft.com...
> >I would like to setup a data-driven subscription for a report, but the New
> > Data-driven Subscription button is not available on the subscription
> > page -
> > only the New Subscription button appears. I have checked that the report
> > uses a custom data source and stores the user name and password
> > credentials
> > in the report server. The account that I am using to access Report
> > Manager
> > is in the System Administrators role and the Content Manager role for the
> > report. What am I missing?
> > Thanks,
> > Robert
>
>

Databases not available through QA for some users

Hey All Gurus,
Why on a large environment with many users, when you attach to QA the
systyem says on a pop up message that several databases are not avail
for viewing. These users are members and logins have the correct
permissions. This happens also when you hit f8 from inside of QA then
the databases do not show in the object browser list? The really wierd
this is you can query these unlisted objects?
does anyone know why this would happen
Bill
*** Sent via Developersdex http://www.examnotes.net ***if the databases are not ready to accept client connection (i.e. still in
recovery phase), they're not accessible.
-oj
"Bill Orova" <nospam@.devdex.com> wrote in message
news:OP4zvC$VFHA.2796@.TK2MSFTNGP09.phx.gbl...
>
> Hey All Gurus,
> Why on a large environment with many users, when you attach to QA the
> systyem says on a pop up message that several databases are not avail
> for viewing. These users are members and logins have the correct
> permissions. This happens also when you hit f8 from inside of QA then
> the databases do not show in the object browser list? The really wierd
> this is you can query these unlisted objects?
> does anyone know why this would happen
> Bill
> *** Sent via Developersdex http://www.examnotes.net ***