Question about Microsoft SQL Server Standard Edition for PC

1 Answer

MSSQL Related Problems

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.

Anybody would help me with this?

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert who has answered 200 questions.

  • Expert
  • 244 Answers
Re: MSSQL Related Problems

Please see link below

Basic tutorial in connection PHP Language to MS SQL Server.

Please rate me SOLVED.

Posted on Nov 23, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

3 Answers

How do I recover data from .mdf file

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.

Jan 19, 2016 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

Attach a database without the corrupted log file

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


More information you can dig out from resources directly connected with SQL Server databases and database corruption in MS SQL Server any version... SQL Server Repair Toolbox

May 15, 2015 | Microsoft SQL Server 2008 Enterprise Full...

2 Answers

Creating a new database using an MDF file

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.
You can read up more on SQL Server here.

Nov 16, 2014 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

SQL Error515 on employee clock in

hi luke,

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.

May 06, 2014 | Pc America Restaurant Pro Express

1 Answer

I am having trouble with Microsoft Office Home and Student 2007

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

Oct 26, 2011 | Microsoft Office Home and Student 2007...

1 Answer

Incoming and outgoing problems' and no server connection

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

Sep 16, 2011 | Microsoft Office Outlook 2007: Windows

1 Answer

421 Authorization failed: please authenticate by doing get message first can some one help me solve this problem

421 Authorization failed: please authenticate by doing get message first using outlook 2007 rediffmail configured received mail but cant send mail please help

Jan 13, 2011 | Business & Productivity Software

1 Answer

Error installing MS Office pro 2007 with BCM

Uninstall from control panel the following:
Microsoft SQL Server native client
Microsoft SQL Server Setup Support files
Microsoft SQL Server VSS writer

Move directory C:\Program Files\Microsoft SQL Server\MSSQL.1 to another location for possible use. Delete everything under Microsoft SQL Server in c:\Program Files


Jan 10, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Hibernate configuration with windows authentication

When you login to your database (download the management tool) right click on server name->properties->security.

There you can choose mixed authentication.

Sep 05, 2008 | Business & Productivity Software

3 Answers


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.

Oct 16, 2007 | Microsoft SQL Server Standard Edition for...

Not finding what you are looking for?
Microsoft SQL Server Standard Edition for PC Logo

145 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides