Please do help me with the configuration of my MSSQL 2005Sever. I always receive this message: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in C:\wamp\www\test.php on line 6
This error comes from connect test code I created. (Below for more details)
MS SQL2000 Connection Test
$connection = mssql_connect( "localhost","sa","4321") or die ( "Sorry - unable to connect to MS SQL2005" ); echo( "Congratulations, you connected to MS SQL2005" ); ?>
I am using wampp server (Includes php5, apache, and mysql) I enable mssql on settings since that is the database that I am using.
Most probably the problem is on ODBC. I cannot connect to mssql on it.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Detach you database. Overwrite the mdf and ldf files you've restored from your backup with your files from the D: drive. Reattach the database.
There is no guarantee that this will work or if it works, that your database is in a state where you can continue to work with.
If that doesn't work then there is an option to try to restore database using SQL Server Recovery Toolbox. It is a powerful tool for data recovery. They have a demo version. So you can check it works in your situation or not. http://www.oemailrecovery.com/sql_repair.html
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
An MDF file isn't a backup file isn't the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks and then Attach Database.
When you do this you will get an error about the log file missing. This shouldn't matter as SQL Server will simply create a new log file for you.
This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you copied the file while the SQL Server was running this file probably will not attach either and you will need to get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox. http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here. http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104/
sounds like you accidentally changed the settings on time management. this could be a little difficult to fix and may require looking directly at database settings. If you want my help,
Feel free to email me with more details if need be.
This article describes how to troubleshoot problems that you may experience when you try to activate a 2007 Microsoft Office application. Additionally, this article contains several methods that you can use to troubleshoot activation issues.
This article is intended for a beginning to intermediate computer user. You may experience the problems in the following scenarios:
Scenario 1 When you try to activate a Microsoft 2007 Office suite, you may experience one of the following symptoms:
You receive the following error message:Your software cannot be activated because the product key you installed with is not valid. Please uninstall the software and reinstall it using a valid product key.
The activation process fails. Additionally, you receive a message that states that you have reached the limit on the number of computers on which you can activate the 2007 Office suite.
Scenario 2 When you successfully started a 2007 Office application and all functions worked correctly for you in the past, you receive an error message. The error message indicates that significant changes were made to the configuration of the computer. In addition to this error message, you may also experience any of the following symptoms:
When you try to activate the 2007 Office suite, the Activation Wizard disappears.
When you try to to activate the 2007 Office suite over the Internet, you receive a communications-related error.
When you try to activate a 2007 Office suite , the Activation Wizard does not start. Additionally, you receive no error messages.
Scenario 3 You try to activate the 2007 Office suite over the phone. However, after you enter the confirmation ID that the support staff supplied to you, you receive an error message. The error message states that the confirmation ID is invalid.
Scenario 4 When you successfully started a 2007 Office application and all functions worked correctly for you in the past, the 2007 Office application now runs in a reduced functionality mode.
Scenario 5 When you start a 2007 Office Trial version for the first time after you complete License Activation, the 2007 Office Trial version runs in a reduced functionality mode, and the Office Activation Wizard is displayed. Additionally, the following text is displayed:
2007 Office system is expired. In this expired state, many features of the version are unavailable until you convert to the full product. Click Convert to begin the conversion process.
Note This activation problem indicates that the Opa12.dat file is corrupt for the 2007 Office application. Scenario 6 When you try to obtain an activation key for a trial version of the 2007 Microsoft Office system over the Internet, you receive the following error message:The Microsoft Activation Assistant was unable to request your trial activation key This issue is temporary until the updated version of Try Microsoft Office 2007 is available. Microsoft is in the process of updating Try Microsoft Office 2007 based on the January 2010 update for Office Word. For more information, click the following article number to view the article in the Microsoft Knowledge Base:978951 Description of the January 2010 update for Office Word
Usually, when there is no server reply then it means that there are no connections to the mail, please check the connection to the mail server. please check the configuration of the incoming and outgoing mail server in the outlook configuration. if u still have problems, please get back to me and i will take you through step by step configuration in outlook
Well there is more than one or two answers 4 that.
you should first check if you are at simple recovery mode. If not (now this will sound strange) right click the database, click tasks/backup and make a LOG backup.
Now right click databases and click Restore Database.
You should choose a new database name (for restore practice) .
You will probably have your last backups at the bottom of the screen...if not click add and choose you latest data backup.
click the log backup and the data backup should be checked , too. on options tab make sure the database is left ready to use.