Hi Lakshmi

You can import certificates if you have a CA or you buy one or you have created one with the makecert.exe utility, see following link:

http://msdn2.microsoft.com/en-us/library/bfsktky3(vs.80).aspx

In my opinion...

Hi Ben

Thank you for the useful advice. After localizing the thread loading one CPU to 100%, I run the queries against the server. The result is not very encouraging: no...

Hi Lakshmi

Hhhmmm, strange if "force protocol encryption" is disabled SQL should not search for a certificate.

Anyway you can open the certificate snap-in, through mmc, add snap-in, certificate, and check if...

Looks like SSL is enabled. You want to connect through SSL ? If not, make sure that under Client Network Utility the option"Force Protocol Encryption" is disabled.

If you want to...

As far I know you cannot copy DB between sql2k and sql2005 with the Copy Database Wizard. Make a backup of your DB on sql2k and restore it on your...

If xp_cmdshell is not enabled error:

"Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned...

Hi Peter

Strange. I believe that the port you defined manually is in use by another application. Normally I define Port 1434 for a second named instance.

You should see the...

Hi Denise

What do you mean with database files ? After uninstall there are some folders and files of the binaries remaining on the drive. You can delete them, but it...

Hi Denise

check for this white paper on Microsoft

"Failover Clustering for Microsoft SQL Server 2005 and SQL Server 2005 Analysis Services".

As Rich mentioned, you have first to build the cluster on...

Denise

I have already installed a (64-bit) SQL 2005 failover cluster. Honestly I do not know if you can make out a failover Cluster of two existing servers, I have heavy...

Ask your admin or somebody who has sysadmin rights on this server. If you are the admin, then you have an other problem. In this case ask the OS Admin...

Hi Malka,

If you receive an answer from the server, I do not think that you have a network problem.

Follow the advice of SQLBill. It seems to be a permission...

It seems that you have a name resolution problem. Do you have a WINS Server in your domain ?

Try to ping the server with its name. If you get...

Your problem is not clear. Have you restored a DB on another Server ? If yes, check if you have the logins. If not run on the previous server the...

I agree with the two  methods. DTS will not work. If you are moving from one server to another, look for the new sp_help_revlogin to move logins.

moreno