Question about Microsoft Windows XP Professional With Servise Pack 2 (e8503040) for PC

2 Answers

Unable to add local server with SQL-Server Management Studio 2005

I m using Win-XP Professional+ServicePack2, and i have installed SQL-Serverr Management Studio 2005. While running this SQL it is asking for local server.... but in the local server list there is no such items in this list.. pls solve my problem asap....

Thanks Experts.........

Posted by on

  • Anonymous Mar 16, 2009

    i m using Win-XP Professional+ServicePack2, and i have installed SQL-Serverr Management Studio 2005. While running this SQL it is asking for local server.... but in the local server list there is no such items in this list.. pls solve my problem asap....

×

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Microsoft Expert
  • 43 Answers

Take a look at this informative article, this will show you how to create a local database in SQL Server:
https://msdn.microsoft.com/en-us/library/hh272703(v=vs.103).aspx

Posted on Jun 13, 2016

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 91 Answers

Ok, you installed the management studio but did you install SQL server?

That is not part of the management product.

Posted on Jan 05, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

Tip

SQL 2008 SA Password Reset


How to reset sa password in SQL Server 2008 when forgot the sa password?

Many time, This problem comes, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login sa password by which they can connect to server. In SQL Server 2005, SQL used to fixed group sysadmin with the server role BUILTINAdministrators, that is to say, all local NT administrator automatically add a SQL Server system administrator. But since 2008 Windows BUILTINAdministrators group is not included by default in the sysadmin server role in SQL Server.

So, follow the steps mentioned to reset SQL 2008 password for SA account if no BUILTINAdministrators.

Step 1. Download and install MS SQL Server Password Unlocker.

Step 2. Run MS SQL Server Password Unlocker, click Open, import the master.mdf file. All the user names of your SQL Server will be displayed.

Step 3. Select an SQL account, such as 'SA', click Change Password button.

Step 4. Type a new password, and then click OK.

The new password has been set for your SA account, now you can login
SQL Server with the new password.

Currently SQL Server 2008 still supports two types validation and authentication for access link to resources database, Windows authentication mode and SQL Server and Windows authentication mode which also known as mixed mode. Both of these authentication methods provide access to SQL Server 2008 and its resources.

The Mixed Mode - SQL Server and Windows Authentication Mode

SQL Server and Windows Authentication Mode uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server. SQL Server 2005 introduces a new way, the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. SQL Server 2008 also to do so. The policy of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode.

on Oct 26, 2010 | Computers & Internet

Tip

4 Methods to Change MS SQL Server Password


Have you ever forgot or lost your MS SQL Server password? Did you reinstall MS SQL Server or change SQL Server Password by some ways at that time? I once forgot my MS SQL Server password and I reinstalled My MS SQL at last as I failed to find some good methods to solve the problem. What annoying and terrible experience it is! In order to avoid reinstalling SQL Server for a second time due to the same reason, so I collect some methods to change SQL Server password for sa account.

Method 1: Use Command Prompt to Change SQL Server Password


Step 1. Open a command prompt (Start -> Run -> cmd)
Step 2. Type the follow commands, and press Enter after each line:
Osql –S yourservername –E
1> EXEC sp_password NULL, ’yourpassword’, ’sa’
2> GO
The yourservername is the name of your server, yourpassword is the new sql sa password.
The command line 1> also can be changed to other command, the model is EXEC sp_password ‘oldpassword’, ‘newpassword’, ‘sqlaccount’.


Method 2: Use the Query Windows in Management Studio to Change MS SQL Server Password

Step 1. Open SQL Server Management Studio
Step 2. Open a new query
Step 3. Type the follow commands and excute:
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO
The NewPassword is set for your SQL Server sa account.


Method 3: Change SQLServer Password by Windows Authentication

If Builtin/Administrator is present in SQL Server, you can login with an ID which is member of Administrators group and change sa password in SQL Server. Just do as follows:
1. Login into SQL server using Windows Authentication.
2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
3. Type a new SQL sa password, and confirm it. Click OK to finish.
After restarting SQL Server and all its servers, you can log into SQL Server by sa login with new SQL sa password.


Method 4: Change MS SQL Server Password with Third Party Software

In addition to the methods above, you can aslo choose some SQL Server password recovery tool to change SQL Server password. MS SQL Server Password Unlocker is one of the good MS SQL passwrod reset tools which can help you change SQL Server password in a few seconds. It allows you to chage MS SQL password on SQL Server and Express 2000/2005/2008.

Following is a guide for you to change MS SQL password with MS SQL Server Password Unlocker.
Step 1.Download and install MS SQL Server Password Unlocker.
Step 2. Run MS SQL Server Password Unlocker, click Open, import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 3. 3. Select an SQL account, click Change password button.
Step 4. Type a new password, and then click OK.
This SQL account password has been reset. You can login with it.

Well, the four solutions are the easy-to-use MS SQL Server Password Reset ways.

on Aug 10, 2010 | Computers & Internet

2 Answers

How to convert SQl server 2005 to SQL server 2008


upgrade it or
take backup of your database
install sql server 2008
Restore backup in sql server 2008

Feb 05, 2011 | Office Equipment & Supplies

1 Answer

How to configure the sql server 2005


Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition loadTOCNode(2, 'moreinformation'); You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
  2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
  3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

    Note Click OK when you receive the following message:Changes to Connection Settings will not take effect until you restart the Database Engine service.
  4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Feb 28, 2009 | Microsoft Visual Studio 2005 Professional...

1 Answer

I have installed sql-server management studio at Win-XP professional.. but it is while run this it is looking for LOCAL SERVER... but it is unable to find any local server at my system.... pls solve my...


First of all you need to be sure that when you installed sql server you also checked Database server. I assume you have.

Then you need to check if SQL is running.

You have to go to start and type services.msc in the search field.

then you have a list of services. go down to sql server and check if its running.

Now go to sql management studio and connect to your local server.

You also might have a instance name. like local server\sql express or an other name.

Jan 03, 2009 | Computers & Internet

1 Answer

Unable to create database from within VWD 2005 Express


try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

Dec 01, 2008 | Computers & Internet

2 Answers

What is a .sdf file? How to generate a .sdf file using ms access?


Regarding what is .SDF -- A file format that is compliant with the combination of SQL Server 2005 Compact Edition, SQL Server 2005 and Visual Studio 2005 to build, test, deploy, and manage applications for users. Databases of this type can be accessed directly as a datasource, e.g., from Visual Studio 2005, or from SQL Server Management Studio. As such, they can be passed around with programs or projects, although they are mainly used for embedded applications. The file includes all necessary code points to access the data, and so does not require an instance of SQL Server to be installed.

You can create a .SDF file with a software called PocketSYNC. (Although i have never tried it myself, a lot of people claim that this software works like charm. But it is not free)

Oct 17, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

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.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

Not finding what you are looking for?
Microsoft Windows XP Professional With Servise Pack 2 (e8503040) for PC Logo

Related Topics:

533 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18357 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...