Different names that work! Thanks.

I plan to reboot the server to free up memory. There is not enough memory to run the DBCC command.

I did every mentioned in this post, but nothing worked.

http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

I see this link for downloads, but will these upgrade Advanced Services to SP2. The overview says is not listed.

http://www.microsoft.com/en-us/download/details.aspx?id=30437

You are right, there is something wrong with the email server. The Net Send option is not checked. When I ran that script, I see this:

The mail could not be...

The SQL Server 2008 R2 (Standard Edition) is running on a Windows Server 2008 R2. So, is this feature on Windows Server 2008 R2?

Yes, I had those steps completed.

Sorry, I have figured this out.

Thanks for T-SQL MM.

Basically, I like to import the data from the XML and import it into a table. Each data element would be placed in a column in the...

It appears the code will take the whole file and place it into a column in the table.

I am looking for is taking the data in the XML file and...

I tried connecting as:

Admin:HERMES\MICROSOFT##SSEE

And that failed. Error message:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify...

Here is the error message. See attachment.

I can use Remote Desktop to this same server and use SSMS to connect and see other instances on the SQL Server, while having full admin rights to the database....

Both, I see the same error connecting via my Desktop with SQL Server Express.

I connect to HERMES\MICROSOFT##SSEE. HERMES is the server name. MICROSOFT##SSEE is the instance

I use Remote Desktop to...

Well, my account is a domain admin account and I have DBA rights to other databases when I login to other servers with SQL Server. I checked my AD account...