Re: SA Password changes
From: "Wayne Snyder" <firstname.lastname@example.org>
Date: Wed, 9 Apr 2003 07:39:41 -0400
A word of caution.... using a null password for SA login is begging, begging
for someone to break in and do you harm...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corp (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Robert Moorehouse" <email@example.com> wrote in message
> I have just started looking at SQL2000 and have a server
> set up running Windows 2000 and SQL 2000, i have some test
> web sites and links to some databases running.
> Can anyone tell me why every 3 or 4 days the SA password
> is changed automatically and i have to change it back
> (null) for the system to work again.
- Lock Pages In Memory policy disabled
... Group Policy editor to grant the policy. ... This setting is not compatible with computers running Windows 2000 ... I need to enable AWE for SQL Server. ...
- Connecting to database from a remote machine
... - a new production box running Windows 2000 ... Not associated with a trusted SQL Server connection. ... So there must be some difference in the setup of the new production box and the setup of the old development box. ... I have compared the IIS settings and they seem to be identical. ...
- Re: Cannot Generate SSPI Context
... Can you tell me where the configuration for this kerberos ticket ... Have your network guys check to see if your Kerberos tickets are expiring ... I can connect normally to SQL Server (running Windows ... Server 2003) from my PC (running Windows XP SP2) for around half to one ...
- Cannot Generate SSPI Context
... quite confused with long explanation at Microsoft Support. ... I can connect normally to SQL Server (running Windows ... Server 2003) from my PC (running Windows XP SP2) for around half to one ... Is there anyway I can connect to SQL Server with Windows Authentication ...
- Re: Cannot connect weird issue
... ARe you sure you are using the same connection string? ... >> 841252 How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL ... >> 839980 How to use a script to programmatically open ports for SQL Server ... >> use on systems that are running Windows XP Service Pack 2 ...