How to connect two different database in two servers from one ser

After you connect to the appropriate instance of the SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. Tweakbox How To Use

There might be other options out there. This is something that worked for me once but there are no guarantees that it will work at all times.

Stop SQL Server instance -> Copy MDF and LDF files to another location -> Delete original MDF and LDF files -> Start SQL Server instance again -> Create new database with exact same name and file names -> Stop SQL Server -> overwrite newly created MDF and LDF.

After this your database should be back online. If it is then go ahead and put it into EMERGANCY mode and SINGLE USER mode.

Finally go ahead and execute DBCC CHECKDB like this

DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

More information you can dig out from resources directly connected with SQL Server databases and database corruption in MS SQL Server any version...
http://itknowledgeexchange.techtarget.com/itanswers/how-to-restore-mdf-file-as-bakcup-databe/
https://www.repairtoolbox.com/sqlserverrepair.html SQL Server Repair Toolbox

Use SQL Server Repair Kit. A convenient, reliable and ultimately efficient MS SQL database repair tool for system administrators, developers and database experts. Best in class performance and outstanding usability for users with and without experience.

Read more: http://www.mssqlserver.repair/

You can find more information here:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file

Open your SQL Server Management Studio console. This application shortcut is available in the SQL Server directory in the Windows Start button.
· Enter the system administrator user name and password. SQL Server's administrator user name is "sa." This account is required for privileges to restore the database. If your restoring on a host provider server, use the administrator user name and password they supplied for your account.
·Right-click your database name and select "Attach." In the new window that opens, click the "Add" button to open a dialog box.
·Select your MDF file and press the "Ok" button. It may take several minutes to restore the database if it is a large file. Once the process is finished, browse your tables to verify the data. The database is now restored.
If nothing helped try to use:SQL Server Fix Toolbox
http://www.fixsqldatabase.com/

get information here:
http://www.answerbag.com/polls/sql-database-corrupted-plz-help_3244311

Or get info here:SQL Server Fix Toolbox
Source: http://www.fixsqldatabase.com/

SQL database Recovery Software remove errors from corrupted SQL server database and allow to recover your all database of SQL Server Recovery tool support with all the MS SQL server version and MS windows.

Visit more here:- SQL Database Recovery Software SQL Recovery Tool

Your getting a connection successful because your looking at the localhost. The server would be the network name of your server. And the password is case sensitive and is pcAmer1ca. (Note the number 1, not an i)

there is facility in enterprise manager to take back of database!