Sorry...forgot to include that...we need this result in a mail.

gavindux (5/18/2010)

---

My apologies - I misunderstood - I thought you meant when executing a report. When deploying that would be credentials of a user that is allowed to publish on...

Hi

That looks to me like the credentials of the datasource you published. You can (1) edit the datasource and lock down some credentials on the Report Server or (2) prompt...

you mean directory security under reports property in IIS ?

if yes what should I need to check in that ?

Expecting the replies!!!! but still no response from anyone.

I have provided Target Server URL in project properties as http://localhost/reports.

Please help me me.

I have developed a SSRS project, and checked the preview and working fine.

When I tried to deploy that project at the end it is asking for login and passwords, I...

it was configured as bak to be deleted.

but we have tried both .bak and bak, but no use.

we cannot find any errors in the history.

SQL Server and Agent is running under domain account and...

Here, if any user dont have any database roles but it has select permissions on some tables and execute permissions on some stored procedures...How to retrive that information ?

For this one I have a solution, suggest me whether it can be a feasible solution or not:

As SQL Server is running on local groups --- > We will create...

ok.....Thank you.

Can any body give me the solution how to connect to the SQL Server ?

Sasidhar Pulivarthi (4/13/2010)

---

hi,

Is it possible to run from CMD prompt.....

if possible we can execute the commands...the authentication mode is set to Mixed mode....

& Then restart the server.....

Correct me if...

Its also not...

No...It dont have any ETL operations...

Ok, we can track the queries...but here can we track which query is using most database log space ?