"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a new
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, but
it just doesn't work.
Anyone know what to do, I'm clueless...
Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue with
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connection
> to the report server database. A connection to the database is required for
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I am
> not that great on SQL Server, so we got a few other people to look at it, but
> it just doesn't work.
> Anyone know what to do, I'm clueless...

"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a ne
w
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
--
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, bu
t
it just doesn't work.
Anyone know what to do, I'm clueless...Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue wit
h
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases f
or
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a
new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connectio
n
> to the report server database. A connection to the database is required fo
r
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I a
m
> not that great on SQL Server, so we got a few other people to look at it,
but
> it just doesn't work.
> Anyone know what to do, I'm clueless...

"LIKE %" AND "@PARAM"

This is going to be easy for any of you who is experienced.
What is wrong with the following query?

Select Company from Generalview Where Company Like '%'@.search'%'

Quote:

Originally Posted by vag

This is going to be easy for any of you who is experienced.
What is wrong with the following query?

Select Company from Generalview Where Company Like '%'@.search'%'

You are searching for fields whose literal value is '@.search' (ok, it isnt as it is not a valid string ... try this

Like '%' + @.search + '%'

Graham|||Thank you very much Graham!
That worked indeed.

Something seriously wrong

We have one database that is actually quite small, about 1.8GB. Upon moving
this db to SQL2K5 we get an error everytime we attempt to view the "Views"
folder. The error is:
Value cannot be null.
Parameter name: context (ObjectExplorer)
No more detail is available. I've gone back to the source database, removed
all views and repeated the process. Even with no views in the database we
get the same error when clicking on the "Views" folder in SQL Managment
Studio. All other db's have migrated fine.
NOW I figured I'd use the compare utility we have (We use Red Gates SQL
Compare) to compare the schema from that database to another server with an
old copy. This worked a few weeks ago, now it gives the error "Specified
cast is invalid" which sounds very likely to be related. This happens on
all servers running a copy of this database regardless of SQL Server
version. So at some point something bad was introduced. I'm just not sure
where to look, it sounds metadata related possibly but I'd hope there's some
other way of determining this other than going to a 6 week old backup and
hoping the issue isn't there.
Any help is greeted with humble thanks...we're really stuck.Tim,
Did you run the Upgrade Advisor on the DB before the move to 2005? This
might tell you something that does not migrate.
Chris Wood
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:uLgna8WaGHA.504@.TK2MSFTNGP03.phx.gbl...
> We have one database that is actually quite small, about 1.8GB. Upon
> moving this db to SQL2K5 we get an error everytime we attempt to view the
> "Views" folder. The error is:
> Value cannot be null.
> Parameter name: context (ObjectExplorer)
> No more detail is available. I've gone back to the source database,
> removed all views and repeated the process. Even with no views in the
> database we get the same error when clicking on the "Views" folder in SQL
> Managment Studio. All other db's have migrated fine.
> NOW I figured I'd use the compare utility we have (We use Red Gates SQL
> Compare) to compare the schema from that database to another server with
> an old copy. This worked a few weeks ago, now it gives the error
> "Specified cast is invalid" which sounds very likely to be related. This
> happens on all servers running a copy of this database regardless of SQL
> Server version. So at some point something bad was introduced. I'm just
> not sure where to look, it sounds metadata related possibly but I'd hope
> there's some other way of determining this other than going to a 6 week
> old backup and hoping the issue isn't there.
> Any help is greeted with humble thanks...we're really stuck.
>|||Yes I did. It only flagged a couple of sprocs with a syntax change (using
aliases in the order by clause)....
I might not have been clear. We encountered the issue during migration, BUT
then going back to our SQL 2000 servers currently in production this error
was encountered when using a specific tool. So, the issue is present BEFORE
migration.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:eZTYegXaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> Tim,
> Did you run the Upgrade Advisor on the DB before the move to 2005? This
> might tell you something that does not migrate.
> Chris Wood
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:uLgna8WaGHA.504@.TK2MSFTNGP03.phx.gbl...
>> We have one database that is actually quite small, about 1.8GB. Upon
>> moving this db to SQL2K5 we get an error everytime we attempt to view the
>> "Views" folder. The error is:
>> Value cannot be null.
>> Parameter name: context (ObjectExplorer)
>> No more detail is available. I've gone back to the source database,
>> removed all views and repeated the process. Even with no views in the
>> database we get the same error when clicking on the "Views" folder in SQL
>> Managment Studio. All other db's have migrated fine.
>> NOW I figured I'd use the compare utility we have (We use Red Gates SQL
>> Compare) to compare the schema from that database to another server with
>> an old copy. This worked a few weeks ago, now it gives the error
>> "Specified cast is invalid" which sounds very likely to be related. This
>> happens on all servers running a copy of this database regardless of SQL
>> Server version. So at some point something bad was introduced. I'm just
>> not sure where to look, it sounds metadata related possibly but I'd hope
>> there's some other way of determining this other than going to a 6 week
>> old backup and hoping the issue isn't there.
>> Any help is greeted with humble thanks...we're really stuck.
>