check the firewall for port and exception settings. And, also do a telnet from command prompt for the port in question.

TELNET serverIP port#

What you can do here is, design a SSIS package where you have the freedom to define the source and destination databases as well as several types of transformations (on...

Well I wonder that. I am eager to know where.

For the edition, you can check the system registry. The location of the value is different for each SSRS 2000 and 2005. For SSRS 2000 the value is...

Ohh okk SF. I just overlooked that the DB engine is not installed.

hi Mike, never come across with this problem.

You may like to place this question in SQL Server 2005>Development section.?

Execute xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services','Version'

http://technet.microsoft.com/en-us/library/bb630446.aspx

HTH

Questions:

1. In one line. What is the difference between SQL Active/Passive and Active/Active Cluster

Active/Active cluster provides you the High availability along with the Load Sharing while Active/Passive will only provides...

Why can't we try this?

Execute xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\','Domain'

perhaps, the path changes from OS to OS. But the above should work on windows XP, 2000,2003.

First try to do a telnet on port number 2438. if its getting in or not.

I believe SELECT HOST_NAME() can show me different results. for example if in a cluster node1 and node2

If I login to node1 and register SQL server here for both node1...

I know I can check it from CA but I want to check it from SQL Server.

manoj2001 (8/1/2009)

---

Hi VS,

Based on error mentioned by you:

"the Smaple errors were like this:

Server: Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 206623779. The text, ntext, or image...

Okay, check this MS - blog first. you may find your answers.

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/360ed941-83f9-41d9-9a05-ee449711b971/

then it wont be a compatibility issue. Can you help with the contents of below file from it?

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.