Can't get more than first field to evaluate.

I am having trouble getting an

IMBogus1 -

Can you provide more details about your problem? I'm afraid you haven't given us enough information to even know what you were doing when you had problems.

thanks,

|||We are still waiting on information from you. If we don’t hear from you in the next seven days, we will delete the thread. We do this to keep the system full of useful information for customers searching for answers and focus expert attention on active unanswered questions.|||

The trouble I am having is doing an evaluation expression of multiple results and looking for the entire sum of the results in my evaluation expression. Instead it only returns the sum or count of the first result field and ignores all the other result fields.

Thanks,

Pete

|||

Pete -

I can't tell from your description whether you are having this issue with a feature of Team Edition for Database Professionals, or whether you're having some sort of general Visual Studio problem. Can you provide a little more background? What Visual Studio feature are you using when you encountering this problem? Is this something you are running in to while using the Database Unit Testing features?

|||i am working on sql reporting|||

Ah, okay. I've moved your thread to the SQL Server Reporting Services forum, where you can get a better response about SQL Server Reporting questions.

Can't get linked servers to work

I'm having trouble getting a new linked server to work.
Server Mfr is 2005 Dev (sp1) and is the 'local' server.
Server Krypton is 2000 EE sp3 and is the target server I need to link to and
query.
I have a valid Windows login on both systems and I'm in the sysadmin group
on both servers.
After linking the servers using Mgt Studio, I ran this:
EXEC sp_addlinkedsrvlogin @.rmtsrvname = 'KRYPTON', @.useself = 'true'
When I try running this query:
SELECT * FROM OPENQUERY(KRYPTON, 'SELECT * FROM CRICUST WHERE CustName =
''Acme''')
I get these errors:
OLE DB provider "SQLNCLI" for linked server "KRYPTON" returned message
"Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Can you see what I'm missing?
Thanks!
djNo login credentials are being passed to the remote server.
Did you set everything up needed for delegation?
Have you tried with a SQL Login to see if the basics parts
(without the delegation issues) are working? For the linked
server, Just map all users to a valid SQL login on the
remote server to see if that works.
-Sue
On Thu, 10 Aug 2006 06:40:02 -0700, dj
<dj@.discussions.microsoft.com> wrote:

>I'm having trouble getting a new linked server to work.
>Server Mfr is 2005 Dev (sp1) and is the 'local' server.
>Server Krypton is 2000 EE sp3 and is the target server I need to link to an
d
>query.
>I have a valid Windows login on both systems and I'm in the sysadmin group
>on both servers.
>After linking the servers using Mgt Studio, I ran this:
>EXEC sp_addlinkedsrvlogin @.rmtsrvname = 'KRYPTON', @.useself = 'true'
>When I try running this query:
>SELECT * FROM OPENQUERY(KRYPTON, 'SELECT * FROM CRICUST WHERE CustName =
>''Acme''')
>I get these errors:
>OLE DB provider "SQLNCLI" for linked server "KRYPTON" returned message
>"Communication link failure".
>Msg 10054, Level 16, State 1, Line 0
>TCP Provider: An existing connection was forcibly closed by the remote host
.
>Msg 18452, Level 14, State 1, Line 0
>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>Server connection.
>Can you see what I'm missing?
>Thanks!
>dj|||Hi Sue -
We're not on AD, so I believe delegation isn't an option.
If I'm using Windows authentication and my account exits on both machines,
do I still need to pass credentials? I thought the 'useself' parameter took
care of that.
Or am I just very confused (quite possibly)?
Thanks.
"Sue Hoegemeier" wrote:

> No login credentials are being passed to the remote server.
> Did you set everything up needed for delegation?
> Have you tried with a SQL Login to see if the basics parts
> (without the delegation issues) are working? For the linked
> server, Just map all users to a valid SQL login on the
> remote server to see if that works.
> -Sue
> On Thu, 10 Aug 2006 06:40:02 -0700, dj
> <dj@.discussions.microsoft.com> wrote:
>
>|||You are correct that if you aren't using AD, you can't use
delegation. Delegation will pass your authentication
information from one server to another. useself just says to
use the current login for authentication against the remote
server but doesn't really manage any of the passing of
credentials or how that will work (or not work).
Try using a SQL login for the security mappings to the
remote linked server.
-Sue
On Thu, 10 Aug 2006 11:07:01 -0700, dj
<dj@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue -
>We're not on AD, so I believe delegation isn't an option.
>If I'm using Windows authentication and my account exits on both machines,
>do I still need to pass credentials? I thought the 'useself' parameter too
k
>care of that.
>Or am I just very confused (quite possibly)?
>Thanks.
>"Sue Hoegemeier" wrote:
>

Cant find diagram property

Hi,

i set up an diagram with crystal reports and Visual Basic 2005.
Everythink works fine, but I got in trouble with a font size property of the so called "datalabel". I did not find the property where I can set the fontsize to a smaller one. To demonstrate my problem I attached a picture with the meant label surrounded.

Can anybody help me?Ok, I asked the supprt of crystal. It is not possible with the visual studio integrated version, you have to update to XI :(

Cant fetch record from Cursor

Hi,

I'm relatively inexperienced in sql, and am having trouble interpreting the behavior of a cursor in some code I have inherited. When there is a record in both the Filters and FilterElements tables, the fetch_status is 0. If there is a record in Filters, but no child record in FilterElements, the fetch_status is -1. Since the tables are joined with a RIGHT OUTER JOIN, even when there is no corresponding record in FilterElements, a record is returned (I have verified running the select in a query window). But when used in a cursor, the record is not fetched. The fetch_status is -1. Can anyone tell me why the fetch doesn't work in this case. Thanks

--

DECLARE @.CreatedByUsernchar(100),@.WorkflowIDsvarchar(50);

DECLARE @.MyVariableCURSOR;

SET @.MyVariable=CURSORFOR

SELECTisnull(Filters.WorkflowIDs,''),

isnull(FilterElements.CreatedByUser,'')

FROMFiltersRIGHTOUTERJOIN

FilterElementsON Filters.ItemID= FilterElements.FiltersItemID

WHERE FiltersItemID= @.FilterID;

OPEN @.MyVariable;

FETCH NEXTFROM @.MyVariable

INTO @.WorkflowIDs, @.CreatedByUser;

For Table A and B,

1. if you dont have any corresponding entries for a record in A in B, and still wants to display the record in A, you should be using LEFT OUTER JOIN

2. if you dont have any records in B for a record in A, but have records for other records in A and still wants to display all the records in B, then you should be using RIGHT OUTER JOIN

Thanks

-Mark the post(s) as "Answer" that helped you|||

Everything seems to be correct. I had tried using the steps u followed, I am getting results for that,

DECLARE @.storeID varchar(10), @.storeName varchar(50), @.ordNo varchar(10)
DECLARE @.MyVariable CURSOR
SET @.MyVariable = CURSOR FOR
SELECT isnull(a.stor_id,''), isnull(a.stor_name,''),isnull(b.ord_num,'') from stores a
right outer join sales b on a.stor_id = b.stor_id
Open @.MyVariable
fetch next from @.MyVariable into @.storeID,@.storeName, @.ordNo
while @.@.fetch_status = 0
begin
print @.storeID+''+@.storeName+' '+ @.ordNo
fetch next from @.MyVariable into @.storeID,@.storeName, @.ordNo
end
close @.MyVariable
deallocate @.MyVariable

|||

Thanks. It appears to be working now. I think I got the LEFT and RIGHT outer join confused. That's a newbie for you.

Can't display the report page from the Internet

Hi,

I am using SQL 2000 SP4 and Report Server SP2 on W2k3 SP1 Server.

I am having trouble displaying the report pages if I am connected from the Internet.

I have no problem if I am connected in the office (Intranet).

The frame that is not show is underneath the New Subscription bar in my report page. I can see everything above (header pages etc) and Home page etc.

I think for some reasons the request frame URL page is still https://myserver/Repor... instead https://myserver.mycompany.com/Report...

Thank's for any help

gogu

PS: Also I am able to deploy only from the Intranet with Target Server URL https://myserver/ReportServer
If I setup VS.NET deploy Target Server URL https://myserver.mycompany.com/ReportServer it comes up with "A connection could not be made ..."
If I open the Browser from the Intranet I can see the reports pages even if with https://myserver.mycompany.com/Reports...
but it ask me for Username / Password.
How can I tell VS.NET when deploy to use username/password?

I think I figure out this (PostID=499647);

I modified RSWebApplication.config see PostID=499647 above and reinstall SSL certificate with <FQDN>

What stupid think is that only the body of report page follows the key <ReportServerUrl> other frame pages are relative to browser URL?

Can''t Create Recursive Function

Greetings.

I'm having trouble creating a recursive function in T-SQL (SQL Server 2000).

I've got a table that has an ID column and a ParentID column. Each row can have a value in the ParentID column that references the ID column of another record - I'll call such rows "child records". I'll cal the row referenced by the ParentID the "parent record".

Each child record can itself have another child record.

I need a function that will take an ID column value as a parameter, and walk up the chain of parent records until I get the first record in the series and return that record's ID value. I'll call that record the "UrParent record".

I'm trygin to create a recursive function called ufunc_ST_GetUrParentCertNum. In the function, there is of course a recursive call to itself - GetUrParentCertNum. However, when I try to run the CREATE FUNCTION script, I get the error:

Server: Msg 195, Level 15, State 10, Procedure ufunc_ST_GetUrParentCertNum, Line 26
'ufunc_ST_GetUrParentCertNum' is not a recognized function name.

I tried the same thing with a Stored Procedure, and that worked fine. However, I really want this to work as a function.

Does anyone have advice on how I can achieve this?

Thanks in advance.

- will f

Did you forget to put the schema name before the function name,

try to call your function like dbo.ufunc_ST_GetUrParentCertNum

|||

That did the trick exactly. Thank you very much

- will f

Cant create connection to database

I am having trouble creating a connection to an MS SQL 2000 database located on a server at the hosting company I'm using, with code running from my localhost. It works when the code is executed on the server at my hosting company, but not when it is executed locally, on my computer. Also, I can't connect to the database using Enterprise Manager. The error I get is this:

SQL Server does not exist or access denied

It has worked before, so I don't understand why it doesn't anymore. It's not a firewall issue, since I have tried to connect with my firewall disabled as well.

Any tips or ideas?have you tried those obvious things like using ip in place of server name? when this error appears and there is evidence that the server is running and nothinng is misspelled it just means that the network library selected is not the one that can reach the target (that's lame interpretation, i'm sure there'll be someone to take the trouble to translate it into unreadable scientific terms ;))|||Yup, have tried using IP instead. No luck.|||Your problem may be as simple as the SQL Server installation being on a dynamic port or as complex as a problem with the hosting companies firewall. Have you tried connecting the hosting company and asking them for outside connection parameters?

Randy
www.Database-Security.Info|||Yes, I have contacted them. Several times. And the say that they can connect to the database (on port 1433) from an external network, using the exact same username and password I'm using.

Can't copy databases across network with copy wizard

I am having trouble copying a database across a network using the copy database wizard.
I am receiving the following error:
'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
Regards
You would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards
|||JackO
Sue answered you correctly. However you will have good results also if you are just willing to take the DB offline temporarily and copy over the files. Then you can attach the DB at the destination. This can be done without shutting down either server.
Jeff
|||Or...you can just backup and restore to the other server.
Nothing is offline, restarted, etc.
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards

Can't copy databases across network with copy wizard

I am having trouble copying a database across a network using the copy database wizard
I am receiving the following error
'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.
I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated
RegardsYou would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:
>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards|||Or...you can just backup and restore to the other server.
Nothing is offline, restarted, etc.
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:
>I am having trouble copying a database across a network using the copy database wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You need to change your SQL Server Service account to have the rights to copy files over the network.'
>I have gone into services and set up the appropriate account to log unto the network servers with system admin priviledges but this does not solve the problem. Any step by step help would be appreciated.
>Regards

Can't copy databases across network with copy wizard

I am having trouble copying a database across a network using the copy datab
ase wizard.
I am receiving the following error:
'Your SQL Server Service is running under the local system account. You need
to change your SQL Server Service account to have the rights to copy files
over the network.'
I have gone into services and set up the appropriate account to log unto the
network servers with system admin priviledges but this does not solve the p
roblem. Any step by step help would be appreciated.
RegardsYou would need to change the destination server to run under
a domain account. Then you need to restart SQL service.
The configuration requirements for using the copy database
wizard can be found in the following article:
INF: Understanding and Troubleshooting the Copy Database
Wizard in SQL Server 2000
http://support.microsoft.com/?id=274463
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy data
base wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You nee
d to change your SQL Server Service account to have the rights to copy files
over the network.'
>I have gone into services and set up the appropriate account to log unto th
e network servers with system admin priviledges but this does not solve the
problem. Any step by step help would be appreciated.
>Regards|||JackO
Sue answered you correctly. However you will have good results also if you
are just willing to take the DB offline temporarily and copy over the files.
Then you can attach the DB at the destination. This can be done without s
hutting down either server.
Jeff|||Or...you can just backup and restore to the other server.
Nothing is offline, restarted, etc.
-Sue
On Wed, 14 Apr 2004 11:26:05 -0700, "JackO"
<anonymous@.discussions.microsoft.com> wrote:

>I am having trouble copying a database across a network using the copy data
base wizard.
>I am receiving the following error:
>'Your SQL Server Service is running under the local system account. You nee
d to change your SQL Server Service account to have the rights to copy files
over the network.'
>I have gone into services and set up the appropriate account to log unto th
e network servers with system admin priviledges but this does not solve the
problem. Any step by step help would be appreciated.
>Regards

Can't connect with Upgrade Advisor

I'm having trouble connecting the Upgrade Advisor to a SQL 2000 box at a client. Here's the setup:

1> I'm running UA on a Virtual PC image

2> I can run UA against other SQL machines on the same domain

3> I can register and administer the SQL server I'm having trouble with in Enterprise Manager

4> I have SA rights on the SQL box I'm having trouble with.

5> The problem is when entering the server name and clicking "detect," it errors out with "The network path not found (mscorlib)."

6> I've tried server name, FQDN and IP address.

This is a fairly convoluted layout, so there could be a firewall issue that I'm not aware of (but I don't think so).

Any help would be appreciated!

Bob

Bob, have you tried running UA directly on the target server? It shouldn't be a problem unless the OS level on the server doesn't support UA.|||

Hey, Allen. Thanks for the feedback...as we discussed Thursday (but I mention here in case anyone else is interested), I don't want to add the .Net Framework to the server at this point.

Bob

can't connect with OLEDB, but ODBC works

I have a local database that I'm having trouble selecting as a source in
DTS. I can connect just fine using "mymachinename", but if I try to use
(local) or an alias in Client Network Utility, I get the error:
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (Connect()).]
SQL Server does not exist or access denied.
I noticed that if I changed the driver to ODBC, then it works fine. Also, I
can connect using any name in Query Analyzer. However, I need to use OLEDB
and also the alias. I have Windows XP Pro and SQL 2000 Developer Edition w/
SP3. Here's all the different tests I have done with OLEDB:
Server Authentication Result
-- -- --
mymachinename Windows OK
mymachinename SQL login OK
myalias Windows SQL Server does not exist or access denied.
myalias SQL login SQL Server does not exist or access denied.
(local) Windows SQL Server does not exist or access denied.
(local) SQL login SQL Server does not exist or access denied.Can you make an OLE DB connection through a UDL? To create a UDL, just
right-click on your desktop and choose to create a new document. Name it
anything you want. Then rename the extension to .udl. Then double-click on
it. Choose your driver and other connection properties and test it. If it
works from there then most likely OLE DB is fine.
(local) is using shared memory and an alias is using whatever protocol is
defined in cliconfg.exe for that alias. When you get a successful
connection which protocol are you using? For a successful connection you
can do:
SELECT network_library, * from master..sysprocesses where spid = @.@.spid to
see your actual protocol.
It may be that the difference isn't odbc vs. ole db but rather tcp vs.
shared memory vs. named pipes. To force connectivity with each type of
protocol:
for tcp use: tcp:mymachinename
for named pipes use: np:mymachinename
for shared memory use: lpc: mymachinename
You can find more troubleshooting steps in:
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Can't connect to SQL server

Hi,
I'm having trouble connecting to the SQL server in a LAN. I can't even
telnet to the port 1433 of the server. Does anyone have any idea how to fix
this problem?
Shafiee.
Are you able to ping the SQL Server? What error are you getting when you try
connecting to the server using Query Analyzer?
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shafiee" <mohamed.shafee@.gmail.com> wrote in message
news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm having trouble connecting to the SQL server in a LAN. I can't even
> telnet to the port 1433 of the server. Does anyone have any idea how to
fix
> this problem?
> Shafiee.
>
|||Hi Narayana,
Yes I am able to ping to the server. The server isn't listening to client
requests. The version of SQL server installed is SQL 2000. Any ideas?
Shafiee.
"Narayana Vyas Kondreddi" wrote:

> Are you able to ping the SQL Server? What error are you getting when you try
> connecting to the server using Query Analyzer?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "shafiee" <mohamed.shafee@.gmail.com> wrote in message
> news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> fix
>
>
|||If SQL Server is running and you can ping the server, one
possibility is that the server is listening on shared memory
only which means only local connections will be allowed. Use
the server network utility on the SQL Server box to make
sure you have protocols enabled. You can also check the SQL
Server error log from when the instance started to see what
protocols, ports SQL Server is listening on. If it's only
Shared Memory, enable TCP/IP on the server using the server
network utility.
-Sue
On Tue, 30 Aug 2005 19:59:04 -0700, "Shafiee"
<Shafiee@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Narayana,
>Yes I am able to ping to the server. The server isn't listening to client
>requests. The version of SQL server installed is SQL 2000. Any ideas?
>Shafiee.
>"Narayana Vyas Kondreddi" wrote:

Can't connect to SQL server

Hi,
I'm having trouble connecting to the SQL server in a LAN. I can't even
telnet to the port 1433 of the server. Does anyone have any idea how to fix
this problem?
Shafiee.Are you able to ping the SQL Server? What error are you getting when you try
connecting to the server using Query Analyzer?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shafiee" <mohamed.shafee@.gmail.com> wrote in message
news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm having trouble connecting to the SQL server in a LAN. I can't even
> telnet to the port 1433 of the server. Does anyone have any idea how to
fix
> this problem?
> Shafiee.
>|||Hi Narayana,
Yes I am able to ping to the server. The server isn't listening to client
requests. The version of SQL server installed is SQL 2000. Any ideas?
Shafiee.
"Narayana Vyas Kondreddi" wrote:

> Are you able to ping the SQL Server? What error are you getting when you t
ry
> connecting to the server using Query Analyzer?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "shafiee" <mohamed.shafee@.gmail.com> wrote in message
> news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> fix
>
>|||If SQL Server is running and you can ping the server, one
possibility is that the server is listening on shared memory
only which means only local connections will be allowed. Use
the server network utility on the SQL Server box to make
sure you have protocols enabled. You can also check the SQL
Server error log from when the instance started to see what
protocols, ports SQL Server is listening on. If it's only
Shared Memory, enable TCP/IP on the server using the server
network utility.
-Sue
On Tue, 30 Aug 2005 19:59:04 -0700, "Shafiee"
<Shafiee@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Narayana,
>Yes I am able to ping to the server. The server isn't listening to client
>requests. The version of SQL server installed is SQL 2000. Any ideas?
>Shafiee.
>"Narayana Vyas Kondreddi" wrote:
>

Can't Connect to Reportserver using Management Studio

Dear Anyone,

I am having trouble connecting to the report server using SQL Server Management studio. Whenever I try to connect to the report server, I get the following error.

Request failed with Http status 502: Bad Gateway. (Microsoft.SQLServer.Management.UI.RSClient

What puzzles me is that I am using the SQL Server Manager on the local server using the local admin account. I've tried connecting to the server using both the server name and the IP address.

Can anyone please help me shed a light to this problem?

Thanks,

Joseph

Did you try connecting using http://servername/reportserver as the server name? Somehow it looks like the WMI instance enumeration is returning an invalid URL to Management Studio.|||Yes, I've tried tried that. I get the same error. Am I missing something?|||

Well, this error is getting returned from the network stack, it's not specific to ReportServer. Are you getting this for all of these?

http://localhost/reportserver

http://servername/reportserver

http://ipaddress/reportserver

And I assume Report Manager is working fine?

|||Brian -

I have a similar issue. and I think it's a WMI issue. How can I reset it or start over with it?

When I try

http://localhost/reportserver

http://servername/reportserver

http://ipaddress/reportserver

I get 5 bars than it hangs. Any ideas
|||i get the same problem, has any of you solved it already?|||I am in a similar situation.

I think the WMI interface is disabled/misconfigured/dead/something. I am trying to create a security extension so reporting services can be added to a current website using the already in place login to handle authentication ( which is it's own set of issues . I had the sample working and then, I assume, something changed and now the sample dies tryign to open the WMI scope. Invalid namespace. I am unable to use SQL Server management Studio ( SSMS ) to connect to the report server

It just says:

Cannot connect to localhost.

Additional Information:
Client found response content type of '', but expected 'text/html'.
The request failed with an empty response. ( Microsoft.SqlServer.Management.UI.RSClient )

How can I check the WMI is running? Configured correctly?

The firewall is turned OFF.

Cant connect to remote SQL Server from my ASP.NET 2.0

I’m going nuts and need some help with my ASP.NET 2.0 application which has trouble talking to a remote SQL Server 2000. First, before I describe my problem let me say that everything works perfectly on my XP development workstation when I point to the local SQL Server database. Screens load fine, saves and edits all work perfectly.

Problem is when I connecting to SQL Server on a remote windows 2003 server I get

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Now, I’ve researched this error and have successfully made the following changes to the remote windows 2003 server where the database resides:

1) Added logins for “ASPNET”, “NT AUTHORITY\NETWORK SERVICE”, and “IIS_WPG”. The reason I added NT AUTHORITY is because we plan on deploying this web site to the same windows 2003 server and I understand that IIS6 (on this server) has ASP.NET running as NT AUTHORITY acct.

2) For all the logins above I’ve added them as users to the database and given dbo role.

I still get same login for user null error when attempting to connect from my XP workstation.

Can anyone help?

Hi,

You need to authenticate against the remote SQL server. Do that in your connectionstrong.

Check www.connectionstrings.com

Regards

|||

Thanks, I'm still getting error. I also want to state I am using windows authentication for this web application, and my understanding is ASP.NET is running as NT AUTHORITY (if windows 2003 and IIS 6) or ASPNET(if XP ) is this a correct assumption?My web.config is set to windows authentication.

I looked at connectionstrings.com as you suggested. This is the connection stringI auto created (it seems very consistent w/ examples on connectionstrings.com) using VisualStudio by dragging a table onto a form from the remote server "TESTSERVER" and using the Configure Data Source dialog which creates the connection string automatically. The SQL Database on TESTSERVER is set to mixed mode for both SQL and Windows authentication. Here is the string, do you see any issues?

Data Source=TESTSERVER;Initial Catalog=CompanyDB1;Integrated Security=True.

I get the same error :Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Do you have any ideas on what I'm doing wrong? Why is user null? Should the user be ASPNET or NT AUTHORITY coming from my XP based web server?

|||Where is the SQL server located in?|||

The SQL Server 2000 database is located remotely on machine called TESTSERVER. This is what is in the connection string

(PS - When I want to point locally to my machine "PUU304" I use this connection string which works fine on my machine

connectionString="Data Source=PUU304;Initial Catalog=JBLocalDatabase;Integrated Security=True")

|||Well, using windows authentication for your winxp login is not working. Try to create a user/pass for your database on the remote server|||check the permission of your database|||NT AUTHORITY has dbo rights in the database. Is this the permission you are referring to?