Mixing Types

Hello Group,
our company had a database on SQL Server 2000 Standard as the source for a
Report Server 2000 Standard. Well, the source databases had to be moved to a
brand new server. As it happened, the SQL Server 2000 on the new server is
Enterprise. Now, the report server will not work. We changed the connection
strings for the reports to point to the new server but no good. We just keep
getting "server not trusted".
Does the type of database server matter to the report server?
RichFirst, I assume that it is just the data that is an issue. Not the
reportserver database itself (where Report server keeps its metadata/object
caching).
My guess is that something else is going on with regards to the security. If
you are using integrated security there might be some issue with RS server
passing on credentials to
What I prefer to do is to have a read only SQL login. I use that for
credentials. I just use the windows domain login to determine who gets to
run what report.
It does not matter in the least where the data is coming from. I report off
of SQL Server standard, SQL Server Enterprise, Sybase, In-SQL (a real time
control historian).
Now, if you are not even having Report Manager come up (i.e. you never even
get where you can select the report to run) then it sounds like RS database
was moved. Again, you have a configuration/security problem going on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:E44CB1AD-A386-40E2-BBE6-F1BB1872F817@.microsoft.com...
> Hello Group,
> our company had a database on SQL Server 2000 Standard as the source for a
> Report Server 2000 Standard. Well, the source databases had to be moved
> to a
> brand new server. As it happened, the SQL Server 2000 on the new server
> is
> Enterprise. Now, the report server will not work. We changed the
> connection
> strings for the reports to point to the new server but no good. We just
> keep
> getting "server not trusted".
> Does the type of database server matter to the report server?
> Rich|||Hello Bruce,
thanks...the Report Manger comes up just fine. It displays the folders and
reports and user just like always. I thought that if I changed the
Connection String in the Report Manager, this would be enough. I need to
come up with a stradigy as to how to narrow down the location of the problem.
Rich
"Bruce L-C [MVP]" wrote:
> First, I assume that it is just the data that is an issue. Not the
> reportserver database itself (where Report server keeps its metadata/object
> caching).
> My guess is that something else is going on with regards to the security. If
> you are using integrated security there might be some issue with RS server
> passing on credentials to
> What I prefer to do is to have a read only SQL login. I use that for
> credentials. I just use the windows domain login to determine who gets to
> run what report.
> It does not matter in the least where the data is coming from. I report off
> of SQL Server standard, SQL Server Enterprise, Sybase, In-SQL (a real time
> control historian).
> Now, if you are not even having Report Manager come up (i.e. you never even
> get where you can select the report to run) then it sounds like RS database
> was moved. Again, you have a configuration/security problem going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:E44CB1AD-A386-40E2-BBE6-F1BB1872F817@.microsoft.com...
> > Hello Group,
> >
> > our company had a database on SQL Server 2000 Standard as the source for a
> > Report Server 2000 Standard. Well, the source databases had to be moved
> > to a
> > brand new server. As it happened, the SQL Server 2000 on the new server
> > is
> > Enterprise. Now, the report server will not work. We changed the
> > connection
> > strings for the reports to point to the new server but no good. We just
> > keep
> > getting "server not trusted".
> >
> > Does the type of database server matter to the report server?
> >
> > Rich
>
>sql

Missing SqlDataReader.GetSqlMetaData() in April CTP

Where did the GetSqlMetaData method go? I am trying to compare the SQL data types of two different columns to ensure compatibility prior to data transfer. The closest thing I can find in the April CTP is the DataReader.GetSchemaTable() which describes the columns' data types in .NET data types, not SQL data types. Any suggestions?

SMX_Mark wrote:

Where did the GetSqlMetaData method go? I am trying to compare the SQL data types of two different columns to ensure compatibility prior to data transfer. The closest thing I can find in the April CTP is the DataReader.GetSchemaTable() which describes the columns' data types in .NET data types, not SQL data types. Any suggestions?

I believe it was cut at the same time as the merge between the server and client provider happened.
Niels

missing sql alert catergory

Hi,
When you go to EM and try to define a new alert
under 'management', 'sql server agent', there should have
two types of alerts in the selection: 'sql server event
alert', and 'sql server performance condition alert'.
One of my server is missing the second type of alert (It's
not in the drop-down box).
Any thought on what happened there and how to get it back?
Thanks a lot.
JJDo you have the SQL Server perfmon counters in perfmon? Any rows in
master..sysperfinfo? Is SQL Server started with the -x switch?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
> Hi,
> When you go to EM and try to define a new alert
> under 'management', 'sql server agent', there should have
> two types of alerts in the selection: 'sql server event
> alert', and 'sql server performance condition alert'.
> One of my server is missing the second type of alert (It's
> not in the drop-down box).
> Any thought on what happened there and how to get it back?
> Thanks a lot.
> JJ|||thanks, Tibor.
You are right on the target! sql server perfmon counters
are missing in perfmon on this server as well. And there
is nothing in master..sysperfinfo.
How can I get them back without risking potentially harm
the system?
SQL Server started with the -x means 'Disables the keeping
of CPU time and cache-hit ratio statistics. Allows maximum
performance.' right? I did not start sql server
explicitly this way. our server is set to be auto-restart
and I think we are just using the default settings for
startup.
Why should I choose '-x'?
thanks.
JJ
>--Original Message--
>Do you have the SQL Server perfmon counters in perfmon?
Any rows in
>master..sysperfinfo? Is SQL Server started with the -x
switch?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
>> Hi,
>> When you go to EM and try to define a new alert
>> under 'management', 'sql server agent', there should
have
>> two types of alerts in the selection: 'sql server event
>> alert', and 'sql server performance condition alert'.
>> One of my server is missing the second type of alert
(It's
>> not in the drop-down box).
>> Any thought on what happened there and how to get it
back?
>> Thanks a lot.
>> JJ
>
>.
>|||JJ,
I was thinking that perhaps the SQL Server was started with the -x switch
and that was the reason the counters was missing. EM, right-click the
server, Startup Parameters.
I suspect, however that the counters aren't properly registered in the
registry. There's an exe files that does this, but I always forget the name
of this file. I didn't find it in the SQL Server directories, so it is
probably in the windows directory somewhere. I suggest that you search the
archives or post a new thread with appropriate subject.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:058c01c3a97d$22e5d680$a401280a@.phx.gbl...
> thanks, Tibor.
> You are right on the target! sql server perfmon counters
> are missing in perfmon on this server as well. And there
> is nothing in master..sysperfinfo.
> How can I get them back without risking potentially harm
> the system?
> SQL Server started with the -x means 'Disables the keeping
> of CPU time and cache-hit ratio statistics. Allows maximum
> performance.' right? I did not start sql server
> explicitly this way. our server is set to be auto-restart
> and I think we are just using the default settings for
> startup.
> Why should I choose '-x'?
> thanks.
> JJ
> >--Original Message--
> >Do you have the SQL Server perfmon counters in perfmon?
> Any rows in
> >master..sysperfinfo? Is SQL Server started with the -x
> switch?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
> >> Hi,
> >>
> >> When you go to EM and try to define a new alert
> >> under 'management', 'sql server agent', there should
> have
> >> two types of alerts in the selection: 'sql server event
> >> alert', and 'sql server performance condition alert'.
> >>
> >> One of my server is missing the second type of alert
> (It's
> >> not in the drop-down box).
> >>
> >> Any thought on what happened there and how to get it
> back?
> >>
> >> Thanks a lot.
> >>
> >> JJ
> >
> >
> >.
> >