Actually I set it to 1. I normally only have about a 100 users logged in on this server during the day and my transactions per second hardly go above...

We had a similar problem with one of our Java applications that was hitting the server. Are you seeing an abnormally high number of connections opening up? I had to...

Thanks maddog & aliciaw. What I ended up doing was reinstalling Reporting Services and the SP and that seemed to reslove the logon problem. I still have backward compatability challenges...

Jason that was all it took. That field is coming in from an exteranal source and is defined as a char datatype so it din't even occur to me change...

Jack:

Yes I am able to use  SSMS to manage the report server. We have Report Manager installed on a web server and that is what I am getting prompted to Logon to....

JacK

     I am not the the only one manging the server but I am the only Content Manager for Reporting Services. The OS is Windows Server 2003. I am on an Intranet...

This tool has been around for awhile but I still use it. SQLH2 uses Reporting Services so it helps to be familiar with that. I just export the perfmon charts to...

Attaching the AdventureWorks database is exactly what I was sttempting to do when I got the error. When I have done this in the past, like you, it worked just fine. It might...

Jim it looks like you have figured out a great solution. We are not currently using Reporting Services to print labels for some of the reasons that you mention on your...

Farrell:

        I did have to tweek your suggestion for better syntax and clarification just a bit and when I reran it in my test environment it worked even much faster...

GG:

      You'll need to begin by scripting out all your tables, views, stored procedures, DTS packages, etc.  Look at Books OnLiine and other sources about recreating users and passwords. Decide whether you...

Tobias:

        While working in a Finance department I was able use Excel pivot tables fairly easily when the datasource was ACCESS or SQL Server. You said that perhaps 'Excel cannot...

Silaphet:

        I have used the functionality available in DTS to do a lot of data cleanup during a migration, such as trimming spaces, case conversion, etc. We did have to...

Oh never mind! After reading Thomas' post on the 'row footer' thread I realized I must have done somehting bogus when I tried using DISTINCTCOUNT and wasn't getting a correct...

I have done this several times by copying the BAK file to the new server and using the MOVE option. From BOL:

MOVE 'logical_file_name' TO 'operating_system_file_name'

Specifies that the given logical_file_name...