OK, First what MSSQL are you using? 2005 or 2008?

What are you using to develop your Reports (rdl)? VS2005, VS2008, BI Development Studio?

On the IIS machine, is there...

If I understand you correctly, The user, authenticated or not, can view your Web.config from the browser. In doing so the username and password is exposed. If this is the...

a couple of questions.

1 In reporting services, "Deploy" refers to pushing the reports to the Reporting Service Server. In you situation, Is that what you are saying or are...

While I understand (first hand) the practice of blaming others.

If we as Professionals do not assume the Responsibility of and Accountability for our actions, then we should not be...

you could use something like this:

select c.category,v.sequence,sum(v.value)

from Categories c, [Values] v

where v.category = c.category

group by c.category,v.sequence

order by v.sequence

Categories:

Category Description

1 ...

Depending on your comfort level.

The "Design" table option will allow you to alter the structure of the table. NOW know that since the table is populated (has data in...

I have to agree with Lynn.

Shops that small don't lend themselves to having a controlled job responsibilities. The smaller the team, the more blurred the line becomes. The one...

If you can add a column to the table that you are bulk inserting as a Identity

[ID] [int] IDENTITY(1,1) NOT NULL

This will act in the same way as a sequence...

You are on the right track. Make sure that the account you are logged into has "DBA" role. Then use the create user command. If you have privileges, it will...