Search results for query: *

Thank you so much to everyone who helped. Finally found it. We had MOM running and the database it uses (PointOne) didn't exist. We had uninstalled 2000 and installed 2005, but didn't remove MOM first.

I killed all the processes running under pri\sqlservice. sp_who shows no pri\sqlservice. I am still getting the error in the log failed login for pri\sqlservice.

No password change. I don't know why the startup is in the error log. Nope, not 64 bit. Running standard version. I stopped all sql services through the sql server configuration manager and started them back up one at a time. Its the sql server service that's generating the error. I didn't...

I ran the service packs and hot fixes. No luck. I ran the sp_who, and these are the processes: SQLAGENT90 - Id<5908> SQLAgent - Job invocation engine SQLAgent - Generic Refresher SQLAgent - Email Logger All jobs...

They don't seem to completely correspond. The failed login runs more often than the Testing Connection. There is also some replication events in the trace, but those are under a different login and I had this issue before I turned replication on. There is a section under the sql agent...

Thanks for your response! I never get an error message popping up. I just happened to be in the log and saw this failed login multiple times. Access to the SQL Server is fine and all the jobs are running fine. I never get kicked out. I took your suggestion and ran a trace file. Every so...

I am getting the error Error: 18456, Severity: 14, State: 16. Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2] in the log repeated every 15 seconds or so. I am logged into the server as pri\sqlservice, I have started the sql server and sql server agent with pri\sqlservice and I...

I am trying to override the default Base Unit for the X axis from days to months, but it never saves my option. Has anyone else run into this? I've searched the forums with no luck. I even tried to search Business Object's bug list, but you have to have support to do that.

FinishedMonthDate is from the first table.

Sorry, I was copying and pasting and renaming. That last part should read ON DatePart(mm,FinishedMonthDate) = DatePart(mm,RO.Finished_Date) AND DatePart(yyyy,FinishedMonthDate) = DatePart(yyyy,RO.Finished_Date) The FinishMonth was my attempt to pull out the month and year into separate...

I have one table with a list of finished dates (one date for each month a date range). I have another table with a line item having a finished date. I am trying to do an outer join (so I get each month) using datepart, but the results are an inner join. I've tried splitting the date out into...

I couldn't get it to save with User:: in front, but chaning the scope worked perfect. Thank you!!

Data Flow level. I couldn't figure out how to change the scope.

I want to do a simple package that will send an e-mail if the rowcount of a query is > 0. I add the rowcount data flow component and assign a variable cnt. In the precendence constraint I add the expression @cnt > 0. When I run, I get the error The expression "@cnt > 0" must evaluate to True...