we just got it fixed. It turns out this error will occur when you have the DB server with a different time (in this case, it was 12 minutes off)...

I can't log in. I know the DB exists, but can't get in.

I'm not sure what you mean by SQL Server-specific windows groups.

Sorry I should have mentioned I tried that.

Wow. So glad I asked,...

princess.lipscomb (2/2/2010)

---

When you say you are moving them over. Do you mean you are just going to take the backup and restore to 2005 and leave the compatibility at...

No, you posted that as I was writing my reply.

As for the one you posted, I ran it...

that is a good start, but it only gives me a resultset of 10, when I can see many more listed when I expand the Logins tree.

this was in reference...

I've not seen that delay code before. Tempting to try it for 5 minutes or something.

thanks

It ran without error. The result set, of course, is:

2009-10-06 16:21:13.143

Sure, I only trimmed the connection stuff because I didn't think it was important.

The 2nd one is the Progress one.

RiccaDB connection string: Data Source=xxxx;Initial Catalog=ricca;Integrated Security=True

Chempax connection string: DSN=ChempaxLive;UID=xxxx;PWD=xxxx

The connection string is at the top of my code. I snipped most of it because I didn't want to post certain parts of it on a public website.

I am not sure, but I don't think it will matter, because this thing is failing on the SQL server connection.

I will check on recent changes.

Not sure what profiler is. Got a link to a tutorial?

Right-click>>Tasks>>Import.

Thus my question.

You can use the Generate...