I got the username and password and I can open tables/select records in each database in SSMS.

User is getting an error...

Test connection unsuccessful (4) Unable to query mssql server (check...

Hello

I don't know the specific error message from the application - I was going back and forth in e-mail with the end user and he only said that the login...

Just to be sure I didn't have an orphaned login, I ran sp_change_users_login 'report' and got zero results

I ran select * from sys.database_permissions and got the results below (not...

No, no red arrow, its enabled.

I also tried creating a second login and adding the second login as users to each database and it worked.

Thanks

Dave

Thank you - your reply enabled me to put a query together for active jobs

-- How to find the name and database of enabled jobs

select [name], database_name

from sysjobs sj

join...

Thanks - the naming convention for our servers were sj361, sj362, sj363 etc

Then sj362 & sj363 were refered to as SSNT-A cluster - and sj365 & sj366 were SSNT-B cluster

But...

Thank you for the quick replies.

Is there a way in R2 to make their backup comapatible with SQL 2008 (that is not R2)?

Thanks

Dave

Thanks Elliot – your info is very helpful.

“So 16 cores, is that 2x8, 4x4? Either way standard supports it, remember in SQL 2008 they don't license COREs, they license PROCESSORS,...

Thanks for the quick reply - I tried to answer each question below...

How many cores?

How do I determine this? They use 16 now...

How much memory? 2GB -based on the...

Thanks Anon - the db is estimated at 6gb and it is being copied over so it can be imported into Oracle. Not sure on the amount of activity -...

Thanks Dev - but what if the witness loses power?

What if the datacenter hosting the active node and the witness loses all power?

Thats what the client is interested...

Thanks Gail - is there any way to protect against a situation where the datacenter that hosts the witness loses all power?

Or, is there any way SQL Server can stay...

Thank you for all of the replies. I'm new to being a DBA but was a developer for about 10 years. But DBA is different

I'm not the only DBA, so...

----One idea was to use log shipping but security was a concern.

"Well you can review your security concern by discussing it with your security Admin. I don't think there should...