Connection pooling problem

Can anybody help me to solve this problem

I have a web application. In this app i have one class genral for database transections. I create new object of this class on every page in page load event & dispose it on UnLoad event. After sometime this app gives connection pooling exception.

Means connection are not closed, but i disposed the object like

tmpDatabase.Dispose()
tmpDatabase = Nothing

Plz can anybody tell me the mistake i m doing.

ThanxPersonally, I would contruct the object as late as possible (where needed) and destroy the object as soon as possible, and let connection pooling work as designed.

Perhaps there is som error condition that you are not handling, so that the dispose is sometimes not reached.|||I can see using Break point, it destroying the object. Means cursor reaching to the line where the object is destroyed.|||Please Help me

This is big problem for my application. I dont know what i doing wrong.|||"This is big problem for my application. I dont know what i doing wrong."

We do not either. In general, there is some reason why your connections are not being closed. Could be an error condition not properly handled, could be a design problem. Absent seeing much of the code, and absent you taking my advice to make the Open and Close very close to each other, leaving the connection open for as short a time as possible rather than creating one for a page load/unload cycle, I do not think anyone can help you.

Connection Open (Create File()) /SQL server registration

Hello,
i have SQL 7.0 servers A, B, C, D
when tryin to register server (mmC) A on B,C,D i get the errormessage
"Client unable to establish connection Connection Open (Create File())"
This worked 2 weeks ago.. and we didn't change anything..
Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
have this problem
THX a lot
PIrmincheck connection with QA
try TCP and NP connection
"Pirmin" wrote:
> Hello,
> i have SQL 7.0 servers A, B, C, D
> when tryin to register server (mmC) A on B,C,D i get the errormessage
> "Client unable to establish connection Connection Open (Create File())"
> This worked 2 weeks ago.. and we didn't change anything..
> Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> have this problem
> THX a lot
> PIrmin|||Hi,
sorry.. your answer was litl short 4 me..
wht do you mean with "check connection with QA"
Where do i set the connection frm TCP to NamedPipes on the
ServerRegistration..
Thx
Pirmin
"Aleksandar Grbic" wrote:
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
> > Hello,
> >
> > i have SQL 7.0 servers A, B, C, D
> > when tryin to register server (mmC) A on B,C,D i get the errormessage
> > "Client unable to establish connection Connection Open (Create File())"
> >
> > This worked 2 weeks ago.. and we didn't change anything..
> > Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> > have this problem
> >
> > THX a lot
> > PIrmin|||you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
check connectivity with sql server
use tcp:<server> to connect with tcp
or
use np:<server> to connect with Named Pipes
later, configure Client Network utility to use one of these protocol and try
connect from mmc
"Pirmin" wrote:
> Hi,
> sorry.. your answer was litl short 4 me..
> wht do you mean with "check connection with QA"
> Where do i set the connection frm TCP to NamedPipes on the
> ServerRegistration..
> Thx
> Pirmin
> "Aleksandar Grbic" wrote:
> > check connection with QA
> > try TCP and NP connection
> >
> > "Pirmin" wrote:
> >
> > > Hello,
> > >
> > > i have SQL 7.0 servers A, B, C, D
> > > when tryin to register server (mmC) A on B,C,D i get the errormessage
> > > "Client unable to establish connection Connection Open (Create File())"
> > >
> > > This worked 2 weeks ago.. and we didn't change anything..
> > > Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> > > have this problem
> > >
> > > THX a lot
> > > PIrmin|||THX,
well i can't connect via NP nor TCP..
(Pinging works..)
Also checked
"SQL server network config"
TCP and NP are configured..
Anyother idea?
THX
Pirmin
"Aleksandar Grbic" wrote:
> you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
> check connectivity with sql server
> use tcp:<server> to connect with tcp
> or
> use np:<server> to connect with Named Pipes
> later, configure Client Network utility to use one of these protocol and try
> connect from mmc
>
> "Pirmin" wrote:
> > Hi,
> >
> > sorry.. your answer was litl short 4 me..
> > wht do you mean with "check connection with QA"
> > Where do i set the connection frm TCP to NamedPipes on the
> > ServerRegistration..
> >
> > Thx
> >
> > Pirmin
> >
> > "Aleksandar Grbic" wrote:
> >
> > > check connection with QA
> > > try TCP and NP connection
> > >
> > > "Pirmin" wrote:
> > >
> > > > Hello,
> > > >
> > > > i have SQL 7.0 servers A, B, C, D
> > > > when tryin to register server (mmC) A on B,C,D i get the errormessage
> > > > "Client unable to establish connection Connection Open (Create File())"
> > > >
> > > > This worked 2 weeks ago.. and we didn't change anything..
> > > > Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> > > > have this problem
> > > >
> > > > THX a lot
> > > > PIrmin|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
> THX,
> well i can't connect via NP nor TCP..
> (Pinging works..)
> Also checked
> "SQL server network config"
> TCP and NP are configured..
> Anyother idea?
> THX
> Pirmin
> "Aleksandar Grbic" wrote:
> > you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
> > check connectivity with sql server
> >
> > use tcp:<server> to connect with tcp
> > or
> > use np:<server> to connect with Named Pipes
> >
> > later, configure Client Network utility to use one of these protocol and try
> > connect from mmc
> >
> >
> > "Pirmin" wrote:
> >
> > > Hi,
> > >
> > > sorry.. your answer was litl short 4 me..
> > > wht do you mean with "check connection with QA"
> > > Where do i set the connection frm TCP to NamedPipes on the
> > > ServerRegistration..
> > >
> > > Thx
> > >
> > > Pirmin
> > >
> > > "Aleksandar Grbic" wrote:
> > >
> > > > check connection with QA
> > > > try TCP and NP connection
> > > >
> > > > "Pirmin" wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > i have SQL 7.0 servers A, B, C, D
> > > > > when tryin to register server (mmC) A on B,C,D i get the errormessage
> > > > > "Client unable to establish connection Connection Open (Create File())"
> > > > >
> > > > > This worked 2 weeks ago.. and we didn't change anything..
> > > > > Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> > > > > have this problem
> > > > >
> > > > > THX a lot
> > > > > PIrmin

Connection Open (Create File()) /SQL server registration

Hello,
i have SQL 7.0 servers A, B, C, D
when tryin to register server (mmC) A on B,C,D i get the errormessage
"Client unable to establish connection Connection Open (Create File())"
This worked 2 weeks ago.. and we didn't change anything..
Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
have this problem
THX a lot
PIrmin
check connection with QA
try TCP and NP connection
"Pirmin" wrote:

> Hello,
> i have SQL 7.0 servers A, B, C, D
> when tryin to register server (mmC) A on B,C,D i get the errormessage
> "Client unable to establish connection Connection Open (Create File())"
> This worked 2 weeks ago.. and we didn't change anything..
> Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> have this problem
> THX a lot
> PIrmin
|||Hi,
sorry.. your answer was litl short 4 me..
wht do you mean with "check connection with QA"
Where do i set the connection frm TCP to NamedPipes on the
ServerRegistration..
Thx
Pirmin
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
|||you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
check connectivity with sql server
use tcp:<server> to connect with tcp
or
use np:<server> to connect with Named Pipes
later, configure Client Network utility to use one of these protocol and try
connect from mmc
"Pirmin" wrote:
[vbcol=seagreen]
> Hi,
> sorry.. your answer was litl short 4 me..
> wht do you mean with "check connection with QA"
> Where do i set the connection frm TCP to NamedPipes on the
> ServerRegistration..
> Thx
> Pirmin
> "Aleksandar Grbic" wrote:
|||THX,
well i can't connect via NP nor TCP..
(Pinging works..)
Also checked
"SQL server network config"
TCP and NP are configured..
Anyother idea?
THX
Pirmin
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
> check connectivity with sql server
> use tcp:<server> to connect with tcp
> or
> use np:<server> to connect with Named Pipes
> later, configure Client Network utility to use one of these protocol and try
> connect from mmc
>
> "Pirmin" wrote:
|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[vbcol=seagreen]
> THX,
> well i can't connect via NP nor TCP..
> (Pinging works..)
> Also checked
> "SQL server network config"
> TCP and NP are configured..
> Anyother idea?
> THX
> Pirmin
> "Aleksandar Grbic" wrote:

Connection Open (Create File()) /SQL server registration

Hello,
i have SQL 7.0 servers A, B, C, D
when tryin to register server (mmC) A on B,C,D i get the errormessage
"Client unable to establish connection Connection Open (Create File())"
This worked 2 weeks ago.. and we didn't change anything..
Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
have this problem
THX a lot
PIrmincheck connection with QA
try TCP and NP connection
"Pirmin" wrote:

> Hello,
> i have SQL 7.0 servers A, B, C, D
> when tryin to register server (mmC) A on B,C,D i get the errormessage
> "Client unable to establish connection Connection Open (Create File())"
> This worked 2 weeks ago.. and we didn't change anything..
> Network wise B,C,D "see" A (ping, net-share..) only "sql-server" wise we
> have this problem
> THX a lot
> PIrmin|||Hi,
sorry.. your answer was litl short 4 me..
wht do you mean with "check connection with QA"
Where do i set the connection frm TCP to NamedPipes on the
ServerRegistration..
Thx
Pirmin
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> check connection with QA
> try TCP and NP connection
> "Pirmin" wrote:
>|||you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
check connectivity with sql server
use tcp:<server> to connect with tcp
or
use np:<server> to connect with Named Pipes
later, configure Client Network utility to use one of these protocol and try
connect from mmc
"Pirmin" wrote:
[vbcol=seagreen]
> Hi,
> sorry.. your answer was litl short 4 me..
> wht do you mean with "check connection with QA"
> Where do i set the connection frm TCP to NamedPipes on the
> ServerRegistration..
> Thx
> Pirmin
> "Aleksandar Grbic" wrote:
>|||THX,
well i can't connect via NP nor TCP..
(Pinging works..)
Also checked
"SQL server network config"
TCP and NP are configured..
Anyother idea?
THX
Pirmin
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> you can use Query Analyzer (QA - SQL graphical query tool) - isqlw.exe to
> check connectivity with sql server
> use tcp:<server> to connect with tcp
> or
> use np:<server> to connect with Named Pipes
> later, configure Client Network utility to use one of these protocol and t
ry
> connect from mmc
>
> "Pirmin" wrote:
>|||firewall?
consult your network admin?
can you connect from server A?
server A listen on 1433?
"Pirmin" wrote:
[vbcol=seagreen]
> THX,
> well i can't connect via NP nor TCP..
> (Pinging works..)
> Also checked
> "SQL server network config"
> TCP and NP are configured..
> Anyother idea?
> THX
> Pirmin
> "Aleksandar Grbic" wrote:
>sqlsql

Connection OLAP with VS.NET

Hello,
I'm trying to connect with Analysis Service's Database and create, see,
drop cubes with ASP.NET (programming in VB.NET). What I need to do this?
(I'm beginner with Analysis Server, but already I knew SQL Server).
Thanks.
Gema.You want ADOMD.NET
See this download:
9209e6ac8ad&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/...&DisplayLang=en
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
news:e3AGeYTXFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I'm trying to connect with Analysis Service's Database and create, see,
> drop cubes with ASP.NET (programming in VB.NET). What I need to do this?
> (I'm beginner with Analysis Server, but already I knew SQL Server).
> Thanks.
> Gema.
>|||Can I connect only with XML? (ADOMD.NET)
Thanks.
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> escribi en el men
saje
news:ueh%23%23OYXFHA.2348@.TK2MSFTNGP14.phx.gbl...
> You want ADOMD.NET
> See this download:
>
layLang=en" target="_blank">http://www.microsoft.com/downloads/... />
layLang=en
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
> news:e3AGeYTXFHA.616@.TK2MSFTNGP12.phx.gbl...
see,[vbcol=seagreen]
>|||Hello Dave,
I've installed ADOMD.NET and that is de way that I want. Thanks. If I
have questions, I'll ask here.
Regards.
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> escribi en el mensaje
news:%23aDqR55XFHA.796@.TK2MSFTNGP10.phx.gbl...
> Can I connect only with XML? (ADOMD.NET)
> Thanks.
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> escribi en el
mensaje
> news:ueh%23%23OYXFHA.2348@.TK2MSFTNGP14.phx.gbl...
>
layLang=en" target="_blank">http://www.microsoft.com/downloads/... />
layLang=en
> rights.
> see,
this?[vbcol=seagreen]
>

Connection OLAP with VS.NET

Hello,
I'm trying to connect with Analysis Service's Database and create, see,
drop cubes with ASP.NET (programming in VB.NET). What I need to do this?
(I'm beginner with Analysis Server, but already I knew SQL Server).
Thanks.
Gema.
You want ADOMD.NET
See this download:
http://www.microsoft.com/downloads/d...DisplayLang=en
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
news:e3AGeYTXFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I'm trying to connect with Analysis Service's Database and create, see,
> drop cubes with ASP.NET (programming in VB.NET). What I need to do this?
> (I'm beginner with Analysis Server, but already I knew SQL Server).
> Thanks.
> Gema.
>
|||Can I connect only with XML? (ADOMD.NET)
Thanks.
"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> escribi en el mensaje
news:ueh%23%23OYXFHA.2348@.TK2MSFTNGP14.phx.gbl...
> You want ADOMD.NET
> See this download:
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> --
> Dave Wickert [MSFT]
> dwickert@.online.microsoft.com
> Program Manager
> BI SystemsTeam
> SQL BI Product Unit (Analysis Services)
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
>
> "Gema Snchez" <gema.sanchez@.grupo-episteme.com> wrote in message
> news:e3AGeYTXFHA.616@.TK2MSFTNGP12.phx.gbl...
see,
>
|||Hello Dave,
I've installed ADOMD.NET and that is de way that I want. Thanks. If I
have questions, I'll ask here.
Regards.
"Gema Snchez" <gema.sanchez@.grupo-episteme.com> escribi en el mensaje
news:%23aDqR55XFHA.796@.TK2MSFTNGP10.phx.gbl...
> Can I connect only with XML? (ADOMD.NET)
> Thanks.
> "Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> escribi en el
mensaje
> news:ueh%23%23OYXFHA.2348@.TK2MSFTNGP14.phx.gbl...
>
http://www.microsoft.com/downloads/d...DisplayLang=en[vbcol=seagreen]
> rights.
> see,
this?
>

connection of sql server via vba

Help !!

I have a sql server database that is as follows

SERVER: AFG
Database Name : APF
Authentication: Windows authentication

how do I create the connectionstring via vba to access this database?sydney (mr.vinay.gupta@.gmail.com) writes:

Quote:

Originally Posted by

I have a sql server database that is as follows
>
SERVER: AFG
Database Name : APF
Authentication: Windows authentication
>
how do I create the connectionstring via vba to access this database?

"Provider=SQLOLEDB;Server=AFG;Inital Catalog=APF;Trusted_connection=yes"

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||sydney wrote:

Quote:

Originally Posted by

Help !!
>
I have a sql server database that is as follows
>
SERVER: AFG
Database Name : APF
Authentication: Windows authentication
>
how do I create the connectionstring via vba to access this database?

www.connectionstrings.com

Connection Managers not installed?

apologies if this is the wrong group ..

whenever I create an Integrated Services project and attempt to add a Connection Manager I get the error

Connection Manager 'blah' is not properly installed on this computer.

(Microsoft.DataTransformationServices.Design)

This happens with all menu options except New Connection..

I have uninstalled and reinstalled both Visual Studio 2005 and SQL Server 2005 and made sure I have selected everything in each case

what am I missing?

Thanks

Chris

seems this has happened to others

see Jason Lodice thread for solution

Chris

Connection managers - OLE DB

Hi There

Quick question.In DTS when you had multiples tasks connecting to the same Database, it was reccomended that you create multiple connections for the same database and let each task use a different connection, thereby making a new connection for each one.
In SSIS if i define 1 OLE DB connection to a database, but i have say 6 tasks using that connection that run simultaneously, does eachone open a new connection to the database to make it more efficient? Or do i still need to define multiple connections to the same database and assign each task a different connection?

Thanx

SeanDL wrote:

Hi There

Quick question.In DTS when you had multiples tasks connecting to the same Database, it was reccomended that you create multiple connections for the same database and let each task use a different connection, thereby making a new connection for each one.
In SSIS if i define 1 OLE DB connection to a database, but i have say 6 tasks using that connection that run simultaneously, does eachone open a new connection to the database to make it more efficient? Or do i still need to define multiple connections to the same database and assign each task a different connection?

Thanx

Sean,
In that situation each of the 6 tasks will use the same connection as far as I know. I guess this is why the connection managers are so called - its because they manage a single connection thereby enabling many tasks to use it.

I'm no DBA but I suspect that this is more efficient than opening multiple connections.

-Jamie|||Hi Jamie

In DTS it was definately better to use multiple connections when extracting large amounts of data from each connection.But no mention has been made of it in SSIS, i guess i could do some tests myself to see if it helps performance?

Thanx|||I'd be interested in seeing any metrics you get.

I don't claim to know much about DTS but I suspect that there are different reasons that multiple connections are recommended that outweigh the benefit of only having 1 connection to the server.
I also suspect that even if one connection object were used each task that used it would still have its own connection (I stand to be corrected here). This is not the case with SSIS.

-Jamie|||Sean, the reason connection managers are called that is to distinguish them from connections as named in DTS. The reason it was recommended to use multiple connections in DTS is because workflow would be serialized if pointing to the same connection. Connection managers actually generate a new connection everytime you call AcquireConnection so the workflow isn't serialized. Each task or transform etc. that calls AcquireConnection on the connection manager receives a new physical connection.
So, for SSIS, just use one connection manager. Also, consider using Data Sources and Data Source views for your OLEDB connections. I blogged about it a bit recently. That simplifies matters even more and makes your packages that much more portable.
Thanks,|||Kirk,
Right then, I'm a wee bit confused. I'll tell you why.

I was recently working on a package where I had an Execute SQL Task followed by a data-flow which extracted from a SQL Server DB. Both tasks used the same connection manager.
In the Execute SQL Task there was a SET ROWCOUNT 20000 statement. When I ran the package, the data-flow only processed 20000 rows - obviously because it was affected by the SET ROWCOUNT command in the previous task.

Now, if both tasks had seperate connections that wouldn't happen. Or would it? I've done a quick scan of google to find out if I could find out the scope of SET ROWCOUNT but couldn't find anything (and its getting late :)

Any ideas?

-Jamie|||Hi Kirk

Thanx for the info, that is what i thought but i just could not find any documentation to verify it.

Although Jamies issue is a bit worrying because set rowcount's scope is definately within a connection/transaction?

Thanx|||Hi Kirk

Ok i am also still confused, my concurrent connections (5 of them) using the same conenction manager we all executing in parrellel, then i changed the connection manager to use the OLE DB for SQL Server NOT the native client that iw as using), now only 3 of the 5 tasks execute concurrently when 1 finishes the next one starts.Therefore it seems only 3 concurrent conenctions are allowed, i have checked BOL , but i cannot find where this setting is as i would like all tasks to run in parallel, if you know it would be greatly appreciated.

Thanx|||Check the MaxConcurrentExecutables property of the package by clicking on the package design surface and then looking at the properties. If it's set to -1, the heuristic used to determine max executables is n+2, where n is the number of processors.
Change it to a higher number and watch them all fly together. :)
K|||Thanx Kirk

Spot on , i did see that setting but i thought -1 was unlimited.Thanx A million works like a bomb !|||

Jamie Thomson wrote:

Kirk,
Right then, I'm a wee bit confused. I'll tell you why.

I was recently working on a package where I had an Execute SQL Task followed by a data-flow which extracted from a SQL Server DB. Both tasks used the same connection manager.
In the Execute SQL Task there was a SET ROWCOUNT 20000 statement. When I ran the package, the data-flow only processed 20000 rows - obviously because it was affected by the SET ROWCOUNT command in the previous task.

Now, if both tasks had seperate connections that wouldn't happen. Or would it? I've done a quick scan of google to find out if I could find out the scope of SET ROWCOUNT but couldn't find anything (and its getting late :)

Any ideas?

-Jamie

OK, I've just built a simple mock-up to demo this and lo and behold it doesn't happen anymore. Setting rowcount in the Excute SQL Task didn't affect the dataflow.
I swear that when I did this before though it DID affect the data-flow...and I have witnesses to prove it. It occurred on April CTP whereas I am now using June CTP. perhaps that's why!!!

For now, ignore this. If it happens again I'll raise it.

Weird!!

-Jamie|||Did you have retain same connection set to true?
I don't have a good answer here. Without looking at the package, it's hard to know for sure.|||Yes, did so myself. Couldn't repro it either...

Connection Issues with Oracle Data Source

We are getting a recurring connection problem when connecting to an Oracle 9i
database. The error we get is ORA 12154 - Cannot create a connection to data
source. This issue only occurs on the Report Server and not in the
development environment.
This is an intermittent problem although it occurs more often than not.
Some individuals never have any issues while others have it with a high
degree of frequency.
We have tried recreating the data source, using both a Shared Data Source
and a direct data source with no change in the problem.
Can anyone shine some light on this issue?I am getting the same kind of error. It is very strange. I have 2
ReportServers running on a 2000 machine and a 2003 machine. The 2000 machine
runs every report great, but on 2003 I get random conneciton errors like you
do. I would love to know why this is happening, and if this is a known
issue. Thanks.
"Marty" wrote:
> We are getting a recurring connection problem when connecting to an Oracle 9i
> database. The error we get is ORA 12154 - Cannot create a connection to data
> source. This issue only occurs on the Report Server and not in the
> development environment.
> This is an intermittent problem although it occurs more often than not.
> Some individuals never have any issues while others have it with a high
> degree of frequency.
> We have tried recreating the data source, using both a Shared Data Source
> and a direct data source with no change in the problem.
> Can anyone shine some light on this issue?|||I'm having similar problems however it seems as if some clients never have
issues while others do. We are trying to get the reports setup for our
helpdesk staff to use, however they have problems running reports that
communicate to Oracle.
We've tried everything, however nothing seems to keep it consistent.
"Marty" wrote:
> We are getting a recurring connection problem when connecting to an Oracle 9i
> database. The error we get is ORA 12154 - Cannot create a connection to data
> source. This issue only occurs on the Report Server and not in the
> development environment.
> This is an intermittent problem although it occurs more often than not.
> Some individuals never have any issues while others have it with a high
> degree of frequency.
> We have tried recreating the data source, using both a Shared Data Source
> and a direct data source with no change in the problem.
> Can anyone shine some light on this issue?

connection failed - ODBC from remote SQL SERVER

hello,
im trying to create an ODBC data source from a SQL SERVER 2005 database located in a remoted pc.
Client---->PC1 : win 2000 sp4, not sql server
Remote server-->PC2 : win 2000 sp4, sql server 2005 express

From the Command Prompt, im typing "ping PC2" successfully.
After, in the ODBC datasource administrator-->System DNS tab, i choose "sql server" as a new data source , and in the server box , i'm typing PC2/SQLEXPRESS.

In the next steps, im typing the user-passwords.
The error :
connection failed
...
[microsoft][odbc sql server driver][named pipes]ConnectionOpen(CreateFile()).
Connection failed:
SQLState: '08001'
..
Client unable to establish connection

What goes wrong?
I follow the same steps locally, and everything is OK.

Sorry for my bad english:cool:Here's an article (http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx) on troubleshooting connectivity issues on SQL Server Express.|||SQL 2005 does not support the Named Pipes protocol by default. I would choose a different protocol, preferably TCP/IP. You can set the protocol using the Client Configuration button on the second screen of the DSN definition in the ODBC DSN applet.

-PatP

Connection Failed

SQL 2000
Windows 2000 sp4

I have created a group called "queryonly" in Active Directory. I have
added myself to this group. When I attempt to create an ODBC connection
to the SQL server I get "connection failed".

When I add myself explicity (ie domain\user) it connects fine.

Why is the group not working? I want to cut down on some
administration.

Thanks.

JustinJustin wrote:
> SQL 2000
> Windows 2000 sp4
> I have created a group called "queryonly" in Active Directory. I have
> added myself to this group. When I attempt to create an ODBC connection
> to the SQL server I get "connection failed".
> When I add myself explicity (ie domain\user) it connects fine.
> Why is the group not working? I want to cut down on some
> administration.
> Thanks.
> Justin

Hi Justin,

Make sure that you log off and then log in after adding yourself to the
group. Sounds stupid, but it seems to work for me :)

Michael

Connection Error

I am having a problem with creating any report in Visual Studio 2003 and
Reporting Services 2000.
I can create a datasource and test the connection without any problems.
However, when I create a report that uses this datasource (or try to create
an new one) it fails with the error message "A connection cannot be made to
the database. Set and check the connection string". This problem occurs using
a brand new VS Project and report and all existing projects/reports.
All my existing reports fail now too with the same error in all projects.
Unfortunately, I do no know what would have changed that would cause this
error. Did any recent security patches cause any problems?
Any suggestions would be most appreciated.
--
WCUI was able to determine the solution. The data source is for Oracle. The
password for the account that I was using was expiring. Oracle throws and ORA
error message when connecting with a password that is about to expire.
Testing the connection in Visual Studio must trap and ignore this password
expire warning (oracle error) while trying to use this data source in a
report just fails.
Hope this helps someone in the future...
--
WCU
"StanleyHammer" wrote:
> I am having a problem with creating any report in Visual Studio 2003 and
> Reporting Services 2000.
> I can create a datasource and test the connection without any problems.
> However, when I create a report that uses this datasource (or try to create
> an new one) it fails with the error message "A connection cannot be made to
> the database. Set and check the connection string". This problem occurs using
> a brand new VS Project and report and all existing projects/reports.
> All my existing reports fail now too with the same error in all projects.
> Unfortunately, I do no know what would have changed that would cause this
> error. Did any recent security patches cause any problems?
> Any suggestions would be most appreciated.
> --
> WCU

connection error

Hello I have this error when I run my report.
. An error has occurred during report processing.
(rsProcessingAborted) Get Online Help
o Cannot create a connection to data source myDB.
(rsErrorOpeningConnection) Get Online Help
 Login failed for user myDB.
What is problem? I am testing my ODBC connection it seem
fine.Are you trying to use integrated security and the credentials your using
need to make more than 1 hop? If so you're running into a limitation in
windows integrated auth. To resolve it either deploy kerberos or you can
try changing the data source credentials to stored and see if it works after
that.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:2cc5301c46913$fdfae570$a301280a@.phx.gbl...
> Hello I have this error when I run my report.
> . An error has occurred during report processing.
> (rsProcessingAborted) Get Online Help
> o Cannot create a connection to data source myDB.
> (rsErrorOpeningConnection) Get Online Help
>  Login failed for user myDB.
> What is problem? I am testing my ODBC connection it seem
> fine.
>

connection err

hi

i use sql 2005 and i create view from linked server

when i select from the view it's o.k

but in the app. i get thes messge :

42000 [Microsoft][SQL Native Client][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

how can i resolve this problam

thenk's

You could try doing:

set ANSI_NULLS on

go

set ANSI_WARNINGS on

go

<select from your view>

instead of just:

<select from your view>

hope that helps,

John

|||

hi

i do this

but no

when i run the proc. or select on the view it is o.k

i get the err when i use the app. (uniface)

it is look like the odbc

thenks

|||

When you execute the QUERY from the application, SET the ANSI settings appropriately, something like this:

SET ANSI_NULLS ON; SET ANSI_WARNINGS ON; SELECT Col1, Col2, etc FROM MyTable WHERE {criteria}

Try the entire line above as the command string. (Or put it into a stored procedure and just call the stored procedure.)

|||

---

This is sometimes based on the problem that the views are not created with the right ANSI settings, so use

SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO

CREATE VIEW SOMEVIEW....

Jens K. Suessmeyer.

http://www.sqlserver2005.de
--

Connection ADOMD

The problem occur when we use ADOMD to create a Cube in an ASP.NET 2.0 application with impersonate and Windows Authentication active in web.config and Integrated Security in the MSOLAP connection to the Analysis Services 2000. When we list de catalogs from Analysis Services we get authenticated with the impersonated Windows Account, but when we try to Create a new cube on a catalog, we get authenticated with the ASPNET windows account, even with impersonate set to true. We are using the 9.0 client version of MSOLAP provider to connect to an Analysis Services 2000 (8.0).

HI,thiago:

I believe this topic is related to theSQL Server Analysis Services. Now we have not this section in the forum, but here is the better place you can post your thread in and there are more experts will be glad to help you to solve your problem:

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

Connecting two servers

Hello there
After i create remote server on my current server i got an error:
Server 'Win2000Serv' is not configured for DATA ACCESS.
what can i do to solve it?Roy
exec sp_serveroption 'Win2000Serv' ,'data access','true'
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23RfL8da9FHA.220@.TK2MSFTNGP14.phx.gbl...
> Hello there
> After i create remote server on my current server i got an error:
> Server 'Win2000Serv' is not configured for DATA ACCESS.
> what can i do to solve it?
>|||Hi,
sp_addlinkedserver
and
sp_addlinkedsrvlogin
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Roy Goldhammer" wrote:

> Hello there
> After i create remote server on my current server i got an error:
> Server 'Win2000Serv' is not configured for DATA ACCESS.
> what can i do to solve it?
>
>

Connecting Trace info to blocked users?

In master.dbo.sysprocesses I can filter for blocked users (Blocked >0)
and I can create a self join(ON SPID = Blocked) to see what user
Loginame is causing the block. In the column [cmd] I can see the
command that the offending blocker is running to cause the block, but
it only says "SELECT" etc. with no details about the stored procedure
that is causing the block.

If I am running a Trace, I can see the exact stored procedures
including the parameters that every cmd is running.

Is there a way to see that same Trace information when looking for
blocked users in master.dbo.sysprocesses, or in some other place?

Ideally what I want is a list of blocked users, who is causing the
blocks and the stored procedure name (or other mischief) causing the
block.

Any help is appreciated.
lqYou can do this, run sp_who2
there is a field named BlkBy grab the id
run DBCC INPUTBUFFER (ID) to get the SQL statement

http://sqlservercode.blogspot.com/|||Is there a way to get the EXEC ('DBCC INPUTBUFFER (BlkBy) WITH
NO_INFOMSGS')) to become a column in the resulting SELECT statement?

CREATE TABLE #SystemUsers (id int identity, SPID int, BlockerLoginame
nvarchar(255), BlockingSQL nvarchar(2000))

INSERT INTO #SystemUsers (SPID, BlockerLoginame, BlockingSQL)
SELECT
SPID,
loginame,
/* (EXEC ('DBCC INPUTBUFFER (BlkBy) WITH NO_INFOMSGS')) As BlockingSQL
??? */
FROM master.dbo.sysprocesses

SELECT
s.spid,
status,
loginame,
hostname,
cmd,
cpu,
last_batch,
login_time,
kpid,
blocked,
x.BlockerLoginame,
waittype,
waittime,
lastwaittype,
waitresource,
dbid,
uid,
memusage,
ecid,
open_tran,
sid,
hostprocess,
nt_domain,
nt_username,
net_address,
net_library,
context_info
FROM master.dbo.sysprocesses s
LEFT OUTER JOIN #SystemUsers x ON x.SPID = s.Blocked
WHERE Blocked >0|||Insert the result of sp_who2 into a table
Delete everything where BlkBy is empty
Loop thru this table and insert the DBCC inputbuffer result into
another table
Join this last table with sysprocesses

http://sqlservercode.blogspot.com/|||This is the part I'm not sure how to write:
"Loop thru this table and insert the DBCC inputbuffer result into
another table"|||laurenq uantrell (laurenquantrell@.hotmail.com) writes:
> In master.dbo.sysprocesses I can filter for blocked users (Blocked >0)
> and I can create a self join(ON SPID = Blocked) to see what user
> Loginame is causing the block. In the column [cmd] I can see the
> command that the offending blocker is running to cause the block, but
> it only says "SELECT" etc. with no details about the stored procedure
> that is causing the block.
> If I am running a Trace, I can see the exact stored procedures
> including the parameters that every cmd is running.
> Is there a way to see that same Trace information when looking for
> blocked users in master.dbo.sysprocesses, or in some other place?
> Ideally what I want is a list of blocked users, who is causing the
> blocks and the stored procedure name (or other mischief) causing the
> block.

More so, provided that the stored procedures are not encrpyted, you
can get the exact SQL code they are executing. And, no, no need for a
lot of coding. I've already done it for you. :-)

http://www.sommarskog.se/sqlutil/aba_lockinfo.html sounds exactly what
you are looking for.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||laurenq uantrell wrote:
> This is the part I'm not sure how to write:
> "Loop thru this table and insert the DBCC inputbuffer result into
> another table"

I admit I didn't read your post in detail, but I suspect that
fn_get_sql() is what you're looking for - it's more useful than DBCC
INPUTBUFFER. See Books Online for more details; if it's not mentioned in
your current version of BOL then you should get the latest version from
here:

http://www.microsoft.com/sql/techin.../2000/books.asp

But since Erland uses this function in the procedure that he mentioned,
you might well find it easier just to use that.

Simon|||Whew. That's a hefty amount of code, which seems much more complex
than:
"Insert the result of sp_who2 into a table
Delete everything where BlkBy is empty
Loop thru this table and insert the DBCC inputbuffer result into
another table
Join this last table with sysprocesses"

Thanks for that.
Is there a way to force some blocking so that I can test it?|||The next step is to run this every 60 seconds and export the results to
a text file using bcp...
I know that in my original post:

SELECT
SPID,
loginame
FROM master.dbo.sysprocesses
WHERE
BlkBy > 0

will get the ball rolling if a blocking situation exists.

But looking at your aba_lockinfo sproc I'm not sure where to start
something like:

if exists (SELECT * FROM master.dbo.sysprocesses WHERE BlkBy > 0)
begin
/* Blocking exisit so use Erland's aba_lockinfo sproc to BCP to a
text file */
end|||laurenq uantrell (laurenquantrell@.hotmail.com) writes:
> Whew. That's a hefty amount of code, which seems much more complex
> than:
> "Insert the result of sp_who2 into a table
> Delete everything where BlkBy is empty
> Loop thru this table and insert the DBCC inputbuffer result into
> another table
> Join this last table with sysprocesses"
> Thanks for that.
> Is there a way to force some blocking so that I can test it?

In one window:

BEGIN TRANSACTION
CREATE TABLE #tmp (a int NOT NULL)

In other another

SELECT * FROM tempdb..sysobjects

> The next step is to run this every 60 seconds and export the results to
> a text file using bcp...

BCP with queryout would work in theory, but queryout is known to be
troublesome. The fact the column lengths may very from execution to
execution may also be aggrevate things.

You could also create a table that matches the output from aba_lockinfo,
and then run INSERT EXEC to that table. Again, the dynamic field lengths
could cause some problems, but just make your columns wide enough.

But I would rather just run it from OSQL with output directed to a file.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I didn't realize I'm not running SP3 until trying to run fn_get_sql and
realizing I don't have a column SqlHandle in master.sysprocesses|||laurenq uantrell (laurenquantrell@.hotmail.com) writes:
> I didn't realize I'm not running SP3 until trying to run fn_get_sql and
> realizing I don't have a column SqlHandle in master.sysprocesses

Since there are other good reasons to upgrade to SP3 - that is Slammer -
I would recommend that you do that. (But there is a pre-SP3 version as
well of aba_lockinfo.)

By the way, I would not recommend that you try to extract pieces of that
code. I mean, it's fairly complex.

(And I will have to rewrite it entirely for SQL 2005...)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland,
Yes I saw that and have grabbed the pre-SP3 version. I caused the
interntional blocking with the open transaction as you mentioned, see
the blocking reported in aba_lockinfo, but I don't see reference to the
name of the specific sproc causing the block.|||laurenq uantrell (laurenquantrell@.hotmail.com) writes:
> Yes I saw that and have grabbed the pre-SP3 version. I caused the
> interntional blocking with the open transaction as you mentioned, see
> the blocking reported in aba_lockinfo, but I don't see reference to the
> name of the specific sproc causing the block.

No, you need to upgrade to SP3 to get that information. Pre-SP3 this
informatin was not available.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Yes, I upgraded to SQL Server 2000 SP3a and now it's all clear to me
how this works. Now to execute it as a scheduled process and output it
to a text file on a regular basis...|||uh more importantly.. can't you reccomend upgrading to SP4?

i think that people that don't apply patches should be fired on the spot|||In the real world, sometimes there are reasons why patches are not
applied, but I'm certain we all appreciate your well thought comment,
and those to come.|||In the real world, sometimes there are reasons why patches are not
applied, but I'm certain we all appreciate your well thought comment,
and those to come.

Connecting to Webservice from DTS

I created a custom DTS object that does its work by calling a
webservice. When you create the object in DTS, it lets you set the
user/pw you want to use to authenticate to the webservice. The problem
I am having is that once I authenticate to the webservice within DTS,
it always uses the same authentication when contacting the service.

So, for example, I drop a new instance of my object into a package. It
connects to the webservice as me. I set up the parameters of the task,
including telling it to connect as User="test". If I run it, my code
sets the credentials correctly on the webservice, but the webservice
still gets called as me.

If I exit out of SQL Server and go back in, and run it, it correctly
connects as User="test". But then if I try to edit the task, and give
my own user and password, it still always tries to connect as "test".

It seems whoever I initially connect to the webservice as, that is the
information that DTS will use for the entire session.

Is there any way to do what I want to do?

thanks"Backslider" <backslider@.mail.com> wrote in message
news:1108159058.882465.266100@.f14g2000cwb.googlegr oups.com...
> I created a custom DTS object that does its work by calling a
> webservice. When you create the object in DTS, it lets you set the
> user/pw you want to use to authenticate to the webservice. The problem
> I am having is that once I authenticate to the webservice within DTS,
> it always uses the same authentication when contacting the service.
> So, for example, I drop a new instance of my object into a package. It
> connects to the webservice as me. I set up the parameters of the task,
> including telling it to connect as User="test". If I run it, my code
> sets the credentials correctly on the webservice, but the webservice
> still gets called as me.
> If I exit out of SQL Server and go back in, and run it, it correctly
> connects as User="test". But then if I try to edit the task, and give
> my own user and password, it still always tries to connect as "test".
> It seems whoever I initially connect to the webservice as, that is the
> information that DTS will use for the entire session.
> Is there any way to do what I want to do?
> thanks

I have no idea - you might want to ask in microsoft.public.sqlserver.dts, to
see if someone there knows about DTS caching properties inappropriately.
Since you seem to be saying that your own custom task is not behaving
correctly, you'll probably have to give more details about exactly how
you've implemented it, to make it clear why you believe the problem lies
with DTS and not your task.

Simon

Connecting to the remote database

Hi!
We have the Reporting Services 2005 installed on the one server and the SQL
Server 2000 database on the other. I am trying to create the report with data
from this database. When I deploy the report on the RS 2005 server, and try
to open it from my client machine, I get the message: Login Failed for user
(null). If I browse the report directly from the server (with my contex), it
works. It seems that this is a delegation problem. Both of the servers are
Windows 2003 servers in the same domain, and I use the windows authentication.
How can I resolve the problem?
Thanks,
Yuliaan.When you deploy a report it also deploys the datasource. However, the
datasource still needs to be configured. Open up the datasource on the
server and go to the properties for it.
BTW, what I do is have all my reports use integrated security for
permission to run the report. Then for where the data is coming from I have
the database running in mixed mode and have a read only user that I create
with for it. This is much much easier than perpetually messing with the
database giving appropriate rights to the users for the data. Plus, if you
have a subscription you have to have a user that is used for the report
anyway (it is run once and then the report can be mailed to multiple users).
Another advantage is the use of connection pooling. If you go your route
then connection pooling will only come into play for a particular user, if
you do what I am suggesting (having a single special user for the database
connection) then all the users of the reports will get the benefit of
connection pooling.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Yuliaan" <Yuliaan@.discussions.microsoft.com> wrote in message
news:BDDF0314-A188-46A3-88EE-5B5A922C7F2E@.microsoft.com...
> Hi!
> We have the Reporting Services 2005 installed on the one server and the
> SQL
> Server 2000 database on the other. I am trying to create the report with
> data
> from this database. When I deploy the report on the RS 2005 server, and
> try
> to open it from my client machine, I get the message: Login Failed for
> user
> (null). If I browse the report directly from the server (with my contex),
> it
> works. It seems that this is a delegation problem. Both of the servers are
> Windows 2003 servers in the same domain, and I use the windows
> authentication.
> How can I resolve the problem?
> Thanks,
> Yuliaan.|||Thank you Bruce, but in our database the different users has the different
rights, moreover I need to connect to the Analysis Services data that also
has the different permissions.So I have to transfer the user context to the
database server. Is it possible?
Thanks,
Yuliaan
"Bruce L-C [MVP]" wrote:
> When you deploy a report it also deploys the datasource. However, the
> datasource still needs to be configured. Open up the datasource on the
> server and go to the properties for it.
> BTW, what I do is have all my reports use integrated security for
> permission to run the report. Then for where the data is coming from I have
> the database running in mixed mode and have a read only user that I create
> with for it. This is much much easier than perpetually messing with the
> database giving appropriate rights to the users for the data. Plus, if you
> have a subscription you have to have a user that is used for the report
> anyway (it is run once and then the report can be mailed to multiple users).
> Another advantage is the use of connection pooling. If you go your route
> then connection pooling will only come into play for a particular user, if
> you do what I am suggesting (having a single special user for the database
> connection) then all the users of the reports will get the benefit of
> connection pooling.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Yuliaan" <Yuliaan@.discussions.microsoft.com> wrote in message
> news:BDDF0314-A188-46A3-88EE-5B5A922C7F2E@.microsoft.com...
> > Hi!
> >
> > We have the Reporting Services 2005 installed on the one server and the
> > SQL
> > Server 2000 database on the other. I am trying to create the report with
> > data
> > from this database. When I deploy the report on the RS 2005 server, and
> > try
> > to open it from my client machine, I get the message: Login Failed for
> > user
> > (null). If I browse the report directly from the server (with my contex),
> > it
> > works. It seems that this is a delegation problem. Both of the servers are
> > Windows 2003 servers in the same domain, and I use the windows
> > authentication.
> > How can I resolve the problem?
> >
> > Thanks,
> > Yuliaan.
>
>|||What you need to do in your case is make sure the user has the appropriate
rights on the database that has the data you are reporting off of. And then
in Report Manager click on the data source and make sure it is using
integrated security. When you deploy this property does not get set and you
need need to do this for all newly deployed data sources.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Yuliaan" <Yuliaan@.discussions.microsoft.com> wrote in message
news:74D2F2F4-CBB2-4882-A275-BCAB3A38EBED@.microsoft.com...
> Thank you Bruce, but in our database the different users has the different
> rights, moreover I need to connect to the Analysis Services data that also
> has the different permissions.So I have to transfer the user context to
> the
> database server. Is it possible?
> Thanks,
> Yuliaan
> "Bruce L-C [MVP]" wrote:
>> When you deploy a report it also deploys the datasource. However, the
>> datasource still needs to be configured. Open up the datasource on the
>> server and go to the properties for it.
>> BTW, what I do is have all my reports use integrated security for
>> permission to run the report. Then for where the data is coming from I
>> have
>> the database running in mixed mode and have a read only user that I
>> create
>> with for it. This is much much easier than perpetually messing with the
>> database giving appropriate rights to the users for the data. Plus, if
>> you
>> have a subscription you have to have a user that is used for the report
>> anyway (it is run once and then the report can be mailed to multiple
>> users).
>> Another advantage is the use of connection pooling. If you go your route
>> then connection pooling will only come into play for a particular user,
>> if
>> you do what I am suggesting (having a single special user for the
>> database
>> connection) then all the users of the reports will get the benefit of
>> connection pooling.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Yuliaan" <Yuliaan@.discussions.microsoft.com> wrote in message
>> news:BDDF0314-A188-46A3-88EE-5B5A922C7F2E@.microsoft.com...
>> > Hi!
>> >
>> > We have the Reporting Services 2005 installed on the one server and the
>> > SQL
>> > Server 2000 database on the other. I am trying to create the report
>> > with
>> > data
>> > from this database. When I deploy the report on the RS 2005 server, and
>> > try
>> > to open it from my client machine, I get the message: Login Failed for
>> > user
>> > (null). If I browse the report directly from the server (with my
>> > contex),
>> > it
>> > works. It seems that this is a delegation problem. Both of the servers
>> > are
>> > Windows 2003 servers in the same domain, and I use the windows
>> > authentication.
>> > How can I resolve the problem?
>> >
>> > Thanks,
>> > Yuliaan.
>>