Check your web.config file in report server directory and see if you see anything like this

and change it to

Try this out if it helps!!!

The process should be straight forward, just you need to give a name to your SQL Server 2000 Instance if SQL Server 2005 is installed with a default instance setting.

SELECT '' as emp_id,emp_name,emp_dsg from table name if you want to manipulate only for retrieval. If you want to modify the values in the table use can just run a...

It will be prudent for you to refer to the help provided with SQL Server 2005 and post any specific questions if you have with respect to understanding the same.

The...

Please check To use multiple anonymous accounts for resource access in the following location

http://msdn2.microsoft.com/en-us/library/aa302436.aspx

Sorry I understood that you do not have Allow IIS to Control Password on your server where you are facing problem.

Let me check.

You can use browse button against the user name and select a user with an administrator access rights and if you know the password for the corresponding user, uncheck the...

select datename(dw,getdate()) will give you the day of the week, you can script you logic based on this.

SQL King (4/23/2008)

---

Guys, been wrestling with this case for almost 2 weeks now. Please help......

1. There are 2 servers where the reports are being deployed. The reports are there for...

USE [master]

GO

CREATE DATABASE [test] ON

( FILENAME = N'c:\temp\test.mdf' ),

( FILENAME = N'c:\temp\test.ldf' )

FOR ATTACH ;

GO

Should work for Attaching a db.

I am sorry, but are you trying to retrieve the data or insert the data ? If you are trying to generate a report for Username realname by groupmembership you...

UPDATE [TABLENAME]

SET

FULLNAME = FIRSTNAME + ' ' + LASTNAME

Please post atleast the suedo code to mimic your procedure, the content that you have posted could not be used for replicating the error that you are getting.

sid_sarkar (4/8/2008)

---

CREATE TABLE...

Hello Rod,

Thank you for the comments, I see what you were doing! You tried to generate the stored procedure for a table that has no Identity defined and as you...

Try this

SELECT CAST(GETDATE() AS SMALLDATETIME)