You need the IP-address of the physical sevrers or the IP-address of the virtual servers?

How many virtual servers do you have? If you have the names of the Physical...

Do you know the server name?

You have got to check in the cluster administrator. Check the SQL Server Group and in the group look for "Resource Type" = IP Address.

Other option is if you have...

So as I already told you it is Analysis Services. Thanks Bru!

That is what it looks like!

AS, refers to Analysis Services. http://dbaspot.com/forums/sqlserver-programming/374747-sql2000-kb884525-sp4-x86-enu-exe.html

I just finished running DBCC ShrinkFile with the EMPTYFILE option for a 300GB data file. I created 2 ndf datafiles where the data from the mdf file was moved. The...

tst tou said that you could connect using the SQL Analyzer, Do you mean SQL Server Query Analyzer? Can you connect using SQLCMD? Is you SQL Server Browser Running?

Try to connect using the server Ip-address

I'm planning to do the same very soon, my database is smaller (300 GB). I will test it this weekend in the test environment. Monday I will get back to...

Glad it helped!

I found this link http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/f4d292c0-72d5-4075-adf3-03427542567e where the ALTER SERVICE MASTER KEY FORCE REGENERATE its explained. I hope it helps.

I google the error and I found some links you may want to check:

http://www.eggheadcafe.com/software/aspnet/31120336/linked-server-error.aspx

http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/b1b94766-daba-4679-9dd3-725f8fd35206

Please let me know if it helps.

I notice that you changed the @useself parameter to 'true'. It should be 'false'

Change it and try again.

Scott's script should help you out.