Question about Dell Dimension 4600 PC Desktop

1 Answer

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

The error message is as follows!!

Sql Error:[[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.] sSql[update tblextusers set lastlogin=getdate(), lastrefresh=getdate(), ipaddress='90.204.96.115', useragent='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Sky Broadband; FunWebProducts; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; Zango 10.3.37.0)', numlogins=numlogins+1 where id=203]

Posted by on

  • Jon May 11, 2010

    What are you trying to log on to?

×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Dell Master
  • 3,051 Answers

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

Posted on Feb 16, 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:

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | 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

Tip

How to Create and Remove SQL Server Password


SQL Server is a Microsoft product used to manage and storeinformation. It uses tables to contain large sets of records for thedatabase. Do you have a SQL server and have you ever used SQL server?Do you know how to create a SQL Server passwordto protect your data stored on SQL server? What to do if you forgetyour SQL password? Following it will introduce you how to create a SQLpassword. And it also tells you how to remove SQL Server password ifyou forget as password can be easily lost.

How to create a SQL Server password?

As we know, it is an important security measure to set a passwordfor user accounts and in particular the SA account. And it is very easyfor you to create a SQL Server password. Just follow the simpleinstructions.

1. Open the Microsoft SQL Server Management Studio program from the Start menu bar in Windows.
2. Click on the SQL Server instance on which the new user will be created.
3. Right-click the Security folder, point to New, and then click Login.
4. On the General page, enter a name for the new login in the Login name box.
5. Select SQL Server Authentication and enter a password for the login.
6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
7. Click the OK to complete the creation of the new user.

Sometimes it happens that you ignore or forget the systemadministrator password. What will you do if you forget SQL password andcannot access to SQL database? The effective way I know is to remove SQL Server passwordwith the help of SQL Server password remover software. MS SQL ServerPassword Unlocker is one of the good MS SQL password remover toolswhich can help you remove SQL password in a few seconds.

How to remove SQL password with Windows Password Unlocker?

MS SQL Server Password Unlocker is handy SQL Server password remover software for you to reset SQLpassword including reset SA password and other user passwords. It caneasily remove SQL Server password for Microsoft SQL Server2000/2005/2008 in a minute. You don’t need to install MS SQL Server onyour PC, and the file in master.mdf format is enough for you to removeSQL Server password and set a new one for it.
Step 1. Download and install MS SQL Server Password Unlocker, and run the application.
Step 2. Click Open to import your master.mdf file. All the user names of your MS SQL Server will be displayed.
Step 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 the newly set SQL password. Although it is easy for you to remove SQL Server passwordwith SQL password remover, it is better to keep your SQL password inheart. Or you can also write it down on a paper and keep in a safeplace.

on Sep 07, 2010 | Computers & Internet

1 Answer

Java.sql.SQLException:[Microsoft][ODBC SQL Server Driver]login failed for user 'Sony-PCSony'


Either the user Sony-PCSony is not having login rights to the SQL server or the SQL server is in windows authentication mode and not in mixed authenticatin mode.

May 24, 2010 | 1999 Daewoo Lanos

1 Answer

Im not able to instalthe primavera p6 on my new hp lap windows 7


Before installing primavera p6, check whether any SQL databases with the same name exists. Uninstall the SQL if the databases created during the previous failure installation of primavera p6(go to add or remove programs to uninstall). After uninstallation of SQL express, try to run installation files for primavera p6 will solve your problem.

Revert back for more assistance.

Dec 26, 2009 | Computers & Internet

2 Answers

Printing syntax


'declare the variables
Dim Connection
Dim ConnString
Dim Recordset
Dim SQL

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _
"PWD=yourPassword;DATABASE=yourDatabasename"

'declare the SQL statement that will query the database
SQL = "SELECT * FROM TABLE_NAME"

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
Else
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
Recordset.MoveNext
Loop
End If


'close the connection and recordset objects to free up resources
Recordset.Close
Set Recordset=nothing
Connection.Close
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

5 Answers

When booting the system the following error message appears: SQLDUMPER failed initialization


the uninstall tool vs_uninst.exe located at http://download.microsoft.com/download/0/a/a/0aacd9c1-a0c5-43ab-a428-0ee440d4472c/vs_uninst.exe.

this error usually occurs when removing certain Microsoft products, or when using the SQL server. Here is a few articles which may help you correct your issue. First, it is a forum where an individual has a similar issue, and the help offered:

http://www.sqlteam.com/forums/topic.asp?...

Next, a Microsoft Knowledge base article on the SQL sqldumper utility, and some troubleshooting techneques:

http://support.microsoft.com/kb/827690

The next page is the SQL tech support and has different errors which can be generated. Look down the list and see if you can locate your particular error and when/how it occurs:

For SQL 2000:

http://www.gridview.org/kb/SQL2000/defau...

For SQL 2005:

http://www.gridview.org/kb/SQL2005/SQLSe...

May 13, 2009 | Microsoft Windows XP Professional for PC

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

3 Answers

Connecting of SQL Server and .net


TITLE: Connect to Server
------------------------------
Cannot connect to KRISHNA-02E4A78\SQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'KRISHNA-02E4A78\Guest'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

Jan 10, 2008 | Microsoft SQL Server Standard Edition for...

2 Answers

The sound


You can visit the following link, make appropiate selections and download the drivers for sound: http://support.fujitsu-siemens.com/com/support/downloads.html cheers

May 02, 2007 | Fujitsu Siemens AMILO D-7830 Notebook

Not finding what you are looking for?
Dell Dimension 4600 PC Desktop Logo

286 people viewed this question

Ask a Question

Usually answered in minutes!

Top Dell Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

mukhtar21 shaikh
mukhtar21 shaikh

Level 3 Expert

2017 Answers

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

Answer questions

Manuals & User Guides

Loading...