I recently needed to upgrade a sql 2000 machine to 2005. Instead of
upgrading the sql 2000 default instance, I installed sql 2005 as a
separate named instance so we could go back to sql 2000 if necessary.
The web server that connected to the new server didn't have anything
change on it except the database ip was changed to
machinename\ins tancename instead of just machinename. SQL
authentication was being used and the exact same userid/password was
created on sql 2005. I logged into the database server using the same
userid/pass to confirm it worked.
However, when using the app, it reported "Login failure for: username"
error and I confirmed 600 times over the next two hours that it was in
fact correctly typed in. The "State" in the sql server log indicated a
password mismatch, but again, it was correct and I verified it worked
using the sql 2005 management studio from the web server itself.
Finally I had the bright idea of making the password blank, figuring it
was getting mangled somewhere in the process...
That worked. So my question is, what is going on and how can I set a
normal password? There is no encryption of the connection string and
nothing changed in the web app between converting the machine from 2000
(worked fine) to 2005 (password mismatch).
3  3723 
pb648174 (go****@webpaul .net) writes: I recently needed to upgrade a sql 2000 machine to 2005. Instead of
upgrading the sql 2000 default instance, I installed sql 2005 as a
separate named instance so we could go back to sql 2000 if necessary.
The web server that connected to the new server didn't have anything
change on it except the database ip was changed to
machinename\ins tancename instead of just machinename. SQL
authentication was being used and the exact same userid/password was
created on sql 2005. I logged into the database server using the same
userid/pass to confirm it worked.
However, when using the app, it reported "Login failure for: username"
error and I confirmed 600 times over the next two hours that it was in
fact correctly typed in. The "State" in the sql server log indicated a
password mismatch, but again, it was correct and I verified it worked
using the sql 2005 management studio from the web server itself.
Finally I had the bright idea of making the password blank, figuring it
was getting mangled somewhere in the process...
That worked. So my question is, what is going on and how can I set a
normal password? There is no encryption of the connection string and
nothing changed in the web app between converting the machine from 2000
(worked fine) to 2005 (password mismatch).
What about upper/lowercase? I seem to recall that in SQL 2000, the
password is case-insensitive if the system collation is case-insensitive,
whereas on SQL 2005 it's always case-sensitive.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
No, the password was all lower case in both sql server and the
connection string. I deleted and re-added different users with
different names and passwords, painstakingly trying different things
over the course of a few hours.
pb648174 (go****@webpaul .net) writes: No, the password was all lower case in both sql server and the
connection string. I deleted and re-added different users with
different names and passwords, painstakingly trying different things
over the course of a few hours.
And only lowercase letters? That is, no special characters or anything
else?
I'm sorry, I have no idea of what might be going on.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Dagwood |
last post by:
Good morning:
At least it's morning where I am. :)
I have a rather newbie question I'm afraid. I have VisualStudio.NET, and
have installed it along with SQL server. However I can't seem to find an
administration front-end to SQL, other than the VisualStudio, which is
ok for creating databases and adding tables/columns. However when I go
to generate create script, I'm told that I need client tools.
|
by: Glen A Stromquist |
last post by:
I have a 6.5 db that I want to create a copy of, I can move it to either
a machine running 7 or 2000. I am more used to doing this in Oracle so
pls bear with me...
I don't want to have any downtime on the 6.5 db, so I'm thinking perhaps
import is the best way to go? I am assuming that 6.5 backups are not
comaptible with either 7 or 2000 restore, or I'd go that route.
The database in question is fairly simple, pretty well just tables...
|
by: kg7poe |
last post by:
I'm trying to install SQL server 2000 inside SBS 2000. Actually I
think I already did it. I just don't know how to run/start it up. I
want to upgrade my SQL 6.5 database backup into 2000.
I have the book SQL Server 2000 Administration by SYBEX.
Here is what I need to know:
The best book on installing SQL 2000 under SBS2000 for a beginner
|
by: Dave |
last post by:
I have developed a VB.net application that transfers a
SOAP wrapped message to another server securely(using SSL
and sever/client certificates). When I run this app from
a Windows 2000 Professional box everything works as
expected, the secure channel is established and the
message is sent properly. When I use the exact same app
on the Windows 2000 Server(running IIS) box the app does
not work properly. I have used a packet sniffer to...
|
by: Mike Watson |
last post by:
I've got MSDE, SQL Server 7.0, installed. I want to handle an .mdf
developed by someone else so I loaded the .mdf into my /DATA folder.
But, MSDE/ODBC can't see the database. I subsequently discovered that
it was created using SQL Server 2000. Is this the reason that my MSDE
7.0 doesn't see the .mdf? If so, how can I use this database with my
7.0? Backup from 2000, restore to 7.0?
Thanks for any help.
| | |
by: news.fl.comcast.giganews.com |
last post by:
Something strange has happened on my computer. I am unable to link tables
from SQL Server 2000. I have tried from Access 97 and 2000, but keep
getting the error "The Microsoft Jet database engine could not find the
object 'tablename'..."
I have SQL Server 7 and SQL Server 2000 installed as an instance on the same
computer. Linking has always worked fine previously, but something has
obviously changes in the meantime. I tried to...
|
by: tskelley |
last post by:
Something strange has happened on my computer. I am unable to link tables
from SQL Server 2000. I have tried from Access 97 and 2000, but keep
getting the error "The Microsoft Jet database engine could not find the
object 'tablename'..."
I have SQL Server 7 and SQL Server 2000 installed as an instance on the same
computer. Linking has always worked fine previously, but something has
obviously changes in the meantime. I tried to...
|
by: N. Graves |
last post by:
I'm using the replace function in an unbound text field to clean up
some data. I have Access 2000 on both an XP and 2000 machines. When
I use this DB on an XP machine works great last a long time.... When
I put it one a 2000 machine the field display #Name? instead of the
data and when I go to Properties/Control source I get an error "The
object doesn't contain the Automation object 'Replace."
Here is the value of Control Source...
|
by: com |
last post by:
MS Access 2000 Password Recoverer 4.2 Screenshot - Soft30.com
MS Access 2000 Password Recoverer will display the password to a MS
Access
database (*.mdb). This program works for MS Access files saved in MS
Access 2000. ...
www.soft30.com/screen-149-12232.htm - 32k - Cached - Similar pages
MS Access HTML Help Generator 1.2 - Soft.com
MS Access HTML Help Generator 1.2. ... System Requirements: MS Access
2000 / XP /
|
by: hhh12347 |
last post by:
FolderBrowserDialog crashes on my Windows 2000 computer.
Here is a C# test program:
using System;
using System.Windows.Forms;
public class TestForm : Form {
FolderBrowserDialog folderBrowserDlg;
OpenFileDialog openFileDlg;
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
