PC Hardware requirements for SQL 2005 Standard Edition

Hello,

I'm wondering if it is possible to install SQL2005 standard edition on a standard dual core pc with Win XP Pro SP2 OS.

Kindly advice.

Regards

Andy

That should be fine.

As a first part of the install process, a program will execute that will verify that the hardware and software environment will support SQL Server 2005.

To check the requirements, see this resource:

SQL Server 2005 Installation Requirements (Hardware/Software)
http://msdn2.microsoft.com/en-us/library/ms143506.aspx

|||Thank you, that should save me some cash from buying a server unit.

Patch question re: SQL 7.0 SP4

I'm getting ready to apply SQL 7.0 SP4 and the SQL Server instance is running on Win NT
4.0 SP6. According to http://support.microsoft.com/?id=327068, there is an
O/S patch that needs to be applied, per KB 258437. Fine and well, but then
I see in http:/
/support.microsoft.com/?id=821279 that this patch superseeds (sp?) the previ
ous SQL patch.
So, all that being said, do I still need to apply the O/S patch in KB 258437
? At what point to I apply the patch; before SP4, between SP4 and KB 821279
, or after KB 821279?
Better yet, how do I convince management / users / vendors to upgrade to Win
2K / SQL 2K? ;-)
TIA,
Mike
mstuart_nospam@.gates.comAll,
FYI, I spoke to some folks at Microsoft, and I was told to install SP4 then KB821279 (p
atch available at http://www.microsoft.com/downloads/...&displaylang=en) and that should take care of i
t.
Mike

Password Problem

i have Win 2000 server and I hv installed SQL Server 200 on it. I have
changed my win 2000 Administration server password. Now SQL Server doesn't
Run. What Should I do.?
I must keep Administration password.
Pl. helpIt sounds like you've changed the password for the account under which
the SQL Server service runs. It isn't a good idea to use a domain admin
account for this anyway because doing so may be a potential security
vulnerability.
I suggest you create an account specifically for the SQL Server
service. You can find the service listed as MSSQLSERVER under the
Services node in the server MMC Management Console. Right-click, select
Properties, then select the Log On pane. Do the same for the other SQL
services that you may use: DTC, Search, Agent, etc.
David Portas
SQL Server MVP
--

Password Problem

i have Win 2000 server and I hv installed SQL Server 200 on it. I have
changed my win 2000 Administration server password. Now SQL Server doesn't
Run. What Should I do.?
I must keep Administration password.
Pl. help
It sounds like you've changed the password for the account under which
the SQL Server service runs. It isn't a good idea to use a domain admin
account for this anyway because doing so may be a potential security
vulnerability.
I suggest you create an account specifically for the SQL Server
service. You can find the service listed as MSSQLSERVER under the
Services node in the server MMC Management Console. Right-click, select
Properties, then select the Log On pane. Do the same for the other SQL
services that you may use: DTC, Search, Agent, etc.
David Portas
SQL Server MVP

Password Problem

i have Win 2000 server and I hv installed SQL Server 200 on it. I have
changed my win 2000 Administration server password. Now SQL Server doesn't
Run. What Should I do.?
I must keep Administration password.
Pl. helpIt sounds like you've changed the password for the account under which
the SQL Server service runs. It isn't a good idea to use a domain admin
account for this anyway because doing so may be a potential security
vulnerability.
I suggest you create an account specifically for the SQL Server
service. You can find the service listed as MSSQLSERVER under the
Services node in the server MMC Management Console. Right-click, select
Properties, then select the Log On pane. Do the same for the other SQL
services that you may use: DTC, Search, Agent, etc.
--
David Portas
SQL Server MVP
--

password for sa was changed spontaneously

Hello!

We are running MS SQLServer 7.0 with ASP on Win 2k Server.
Today suddenly the Web server couldn't connect to the DB Server
because the password for sa was wrong.
We found out that the password was changed.

Is it some kind of hacking thing or just normal password expiration?
The same thing happended several month ago.

Thanks.

SamSam Kong (ssk@.chol.net) writes:
> We are running MS SQLServer 7.0 with ASP on Win 2k Server.
> Today suddenly the Web server couldn't connect to the DB Server
> because the password for sa was wrong.
> We found out that the password was changed.
> Is it some kind of hacking thing or just normal password expiration?
> The same thing happended several month ago.

There is no password expiration in SQL7. So that means that somebody
changed the password for you.

I would recommend that you change to Windows Authentication and turn
off SQL Authentication. I would also recommand that the web server
does not log with an account that has sysadm privileges. Preferrably
it should no special rights, but access to the SQL objects it needs
to access. (And that should ideally only be stored procedures!).

Finally, if the SQL Server is exposed on the Internet, you should
stick it behind a firewall.

All these precautions increase your security and decreases the risk
for malign attacks.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp