Question about Microsoft SQL Server 2000 Standard Edition for PC

1 Answer

SQL server won't work on my laptop

I have SQL Server 2000 installed on my "local" server, using the default settings, and want to use it with Visual Studio 2003. Query Analyzer doesn't pick up the databases I've created. Any suggestions? Thanks Michael

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 whose answer gotĀ voted for 20 times.

  • Expert
  • 150 Answers
Re: SQL server won't work on my laptop

Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Posted on Nov 24, 2007

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

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

Lost SQL Server 2005 product key. How to find installed SQL Server product key?

If you have SQL Server 2005 installed on your computer, you could find lost product key with effective software, iSunshare Product Key Finder.
How to Find Product Key with iSunshare Product Key Finder

Step 1: Install Product Key Finder on your computer.
The computer is which one where SQL Server 2005 installed.

Step 2: Click "Start Recovery" button.
Few seconds later, SQL Server, Windows, Office, IE etc product keys are listed in Product Key Finder.

Step 3: Click "Save" button on menu or "Save to File" button to save product keys for them.

This way to find SQL Server product key also applies to SQL Server 2000/2008/2012/2014.

Jun 27, 2014 | Microsoft SQL Server 2005 Enterprise...

1 Answer

I am trying to connect to a SQL Server 2005 DB from Visual Studio

You must create an ODBC connection to your SQL database in the Windows Control Panel. Than you can call your ODBC connection via Visual Studio 2005. You can also create a DSN in Visual Studio 2005 and reference in that way. You will not be able to connect to an MDF but instead you have to connect to the SQL Server Service. Of course the username you use to connect must have access that will be created on the SQL server.

Apr 13, 2009 | Microsoft SQL Server 2005 Standard Edition

1 Answer

SQL Server 2005 set up ... ERROR Replprov .dll

are you installing from DVD ?

Maybe try copying installation to local drive.
Do not copy to desktop or other sub folder of "Documents and Setting" as this causes other problems in some cases.

Oct 17, 2008 | Microsoft SQL Server 2000 Standard Edition...

2 Answers

Java.sql.SQLException: Network error IOException: Connection refused: connect


I too was facing the same problem as mentioned by you and couldn't connect through telnet localhost 1433.
Solution : Just go to SQL server configuration manager----SQL Server Network configuration----Protocols for SQLEXPRESS and in that right click on TCP/IP and in properties field make all TCP/IP port to 1433 which is blank. Start and Restart the SQL server and you can telnet localhost 1433 and it works. Hope this will help.


Aug 07, 2008 | Microsoft SQL Server 2000 Standard Edition...

1 Answer

Sql server

It should install automatically when you insert the CD - double clikc cd-rom drive if it does not begin to load.

This might be a useful article - there was a bug - you may need to upgrade to SP2.

Note: If you are running a 64-bit version of a Microsoft Windows Server™ operating system, you need to use SQL Server 2000 Enterprise Edition (64-bit). Visit the SQL Server 2000 (64-bit) System Requirements page for additional information.

Apr 06, 2008 | Microsoft SQL Server 2000 Standard Edition...

5 Answers


Perform following steps to recover sql server database:
  • Create a database with same size that you are trying to recover
  • Shutdown the SQL server
  • Swap old mdf file with new mdf file
  • Start the SQL server
  • Database may go in suspect
  • Set database in emergency mode
  • Run DBCC CHECKDB with repair_allow_data_loss to repair database

USE [master]

It may result some data loss. If you don't want to lose any single data then use 3rd party SQL repair software from Stellar Phoenix.

Mar 19, 2008 | Business & Productivity Software

1 Answer


You need to either use a Domain Account if you are using Windows authentication or you need to use SQL server authentication.
The reason for this is because the user account that you are using only exists on the machine that you are on not on the machine that you will be replicating to.

Sep 24, 2007 | Microsoft SQL Server Standard Edition for...

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

Related Topics:

265 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