Question about Microsoft SQL Server 2008 for Small Business - Device CAL & SA

1 Answer

SQL Server and Internal Website

Hi,

We have just implemented a newer server from Windows NT to XP. We have installed the necissary SQL server managements etc.
People are able to connect to the specified server. But we house our internal website on this server, its able to be shown but we have online track and trace for customers to track there despatches.
But it doesnt work, is there any reason why they cant find what there looking for?

Posted by on

  • Emma J
    Emma J Jun 19, 2009

    It says access is denied if that helps.???

  • Trevor Daniel May 11, 2010

    has the server name, it's ip address or the name of the database changed?

×

Ad

1 Answer

  • 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
  • 86 Answers

I would expect that the hostname of your webserver has changed. this means that the custom software you are using needs to have this changed as well otherwise it will continue to look for your old server...

you could also change the server name to be the same as the old server and that should solve the problem as well

please remember to rate this answer if it has been useful

thanks trev

Posted on Aug 16, 2009

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

I have installed Windows 2012 server Os and in that system i have installed Sql Server 2008 R2 Express Edition and Microsoft SQL Server 2012 Transact-SQL with Same Instences,now i want to stop sqlserver...


Hi Sarma,

If it is the single instance, SQL server service is registered only once. Please remove and reinstall with named instance.

Warm Regards,
Abhay Pujari

Dec 11, 2014 | Microsoft Computers & Internet

Tip

How to recover sql 2000 sa password


Microsoft SQL Server 2000 is a full-featured relational database management system that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration. It operates in one of two authentication modes: Windows Authentication Mode (the default) or Mixed Mode.

When you install the SQL Server 2000, you can log in the server with Windows Authentication and SQL Server Authentication if you select mixed mode authentication. If you select Windows Authentication, you cannot assign a sa password during installation. However, you should set the sa password after installation.

It is very easy for one to set sa password in SQL 2000. Just follow the below steps:

* 1. Expand a server group, and then expand a server.
* 2. Expand Security, and then click Logins.
* 3. In the details pane, right-click SA, and then click Properties.
* 4. In the Password box, type the new password.

The type of client connections determines the choice of security mode. If all of the incoming clients support trusted connections, you can use Windows Authentication Mode. If some clients do not support trusted connections, you can select Mixed Mode.

If you forget the sa password, you will need to use MS SQL Server Password Unlocker to reset sa password SQL 2000. MS SQL Server Password Unlocker is easy yet powerful SQL Server password reset software for you to reset SQL password, including reset SA password and other user passwords. It provides you an easy and safe way to reset SQL Server password for Microsoft SQL Server 2000/2005/2008 in a minute. No need for you to reinstall MS SQL Server on your PC. The file in master.mdf format is enough for you to recover sa password SQL 2000.

Steps to reset sql password 2000 for sa as follows:
* 1. Download and install MS SQL Server Password Unlocker.
* 2. Click the application icon to run it.
* 3. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
* 4. Select sa account, click Change password button to reset sa password.
* 5. Type a new password, and then click OK to finish your operation.

Note: This method to reset sa password in sql server 2000 is usually applied when you cannot login SQL Server 2000 by Windows Authentication wile you forget system administrator login password.

More information about sa password:

According to Microsoft, System administrator (sa) is a special login provided for backward compatibility. By default, it is assigned to the sysadmin fixed server role and cannot be changed. Although sa is a built-in administrator login, do not use it routinely. Instead, make system administrators members of the sysadmin fixed server role, and have them log on using their own logins. Use sa only when there is no other way to log in to an instance of Microsoft SQL Server.

on Oct 19, 2010 | Computers & Internet

1 Answer

I can't install the service pack 3 of SQL server


Are you installing SP3 for SQL 2005 Standard or Express editions?

According to Microsoft, the standard edition will not work on XP Home.

See:
http://technet.microsoft.com/en-us/library/ms143506(SQL.90).aspx

Aug 01, 2010 | Microsoft Windows XP Home Edition

4 Answers

Hay Bahratt, I have uninstalled the 3 SQL programs in the control panel a few times with no effect on the issue. I didn't try moving directory C:\Program Files\Microsoft SQL Server\MSSQL to another...


If you have removed it from control panel, its done. You just have to clean up any left over registry entries using CCleaner and then try installing again
http://www.ccleaner.com/download
You may also want to check out this microsoft link if it doesn;t work
http://office.microsoft.com/en-us/help/HP011128601033.aspx

Jan 10, 2010 | Computers & Internet

1 Answer

Try to type my username and password in and error message shows


hi there hey it looks to me like you may need to go to device manager and uninstall the device and than turn off the computer and reboot the computer and you will see the new hardware found pop up on the taskbar just let it reinstall it and it will tell you that the device has been installed and is ready to be used now you should be able to log onto it as normal . best regards mike

Jan 14, 2009 | Dell Dimension 4600 PC Desktop

2 Answers

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


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

That is not part of the management product.

Jan 03, 2009 | Microsoft Windows XP Professional With...

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

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. http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

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...

Not finding what you are looking for?
Microsoft SQL Server 2008 for Small Business - Device CAL & SA  Logo

Related Topics:

64 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...