It is an wired situation I also faced. I suggest you to try using TSQL instead of GUI. It should work

Could not find the way to send message. You may mail me at query@consultdba.com

Riga

I am so sorry for the late.. I was not online for past couple of days :crying:

Glad to know you figured it by yourself; Please let me know if...

This is how it works...

A SQL DB typically has SQL Login and/or Domain Login

Each Login is mapped to a Server Login

When you move a DB to a new server, it...

My understanding is as follows:

====

When you directly use SQL Server and login, you just use Integrated Windows Authentication

But if you use run as (Irrespective if you are giving your credential/some...

It depeneds how you are going to upgrade the server. If you will upgrade your server directly from 2k to 2k5, it will take care of security itself.

If you plan...

I beleive below approach will help you:

1. Pick a server where the job will run

2. Add all other servers as linked server there

3. Write your code for each server in...

If you are sure that you do not need log backups (that means you will have only restore capability till last full/differential backup if you implement this approach), use...

Did you double checked that the account in question have sufficient right? I recomend to do the same (If not already done) as it looks like this account is experiencing...

It is possible in 2K5 as it has inbuilt encryption. Let me know if you need more details

If you do not want to add a third party for 2k, the...

Glad that the issue is resolved Kevin 😀

I believe you need to fix this dormant connections.

Can you cap the number of connections for “time”? If so, it will allow you to restrict “time” to open many connections....

I will suggest to take a complete backup here. Use litespeed/redgate if you have it. Otherwise native backup is also ok.

But taking a full backup is the safest approach.

For syntax,...

Gyus

Thanks for the advices and I am sorry for late reply.

I actually completed this clustering now. I found no way to directly upgrade standalone instance to clustered one. However, I...

Thank you guys for your helps.... I asked developer to use GUID only. Alternately I asked him to write a code which will do it with a cost to performace.

I...