CF7 Accessing SQL 2000 for first time

[cf_code_warrior]

I am installing CF7 on a laptop for 1st time. I am very familiar with
SQL2000. Yet cannot get cf7 admin panel datasource to connect to db. KNOW the
SQL 'sa' password. Am using either 127.0.0.1 or localhost or laptopname as
server Using correct datasource name. Port is set to 1443. I have the exact
same setup on a production db. Using 7.0 beta, except it points to another
server which is db. (not localhost) Etc. etc. I get error Connection
verification failed for data source: dataname java.sql.SQLException:
[Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The
requested instance is either invalid or not running. The root cause was that:
java.sql.SQLException: [Macromedia][SQLServer JDBC
Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either
invalid or not running.

[The ScareCrow]

What OS do you have on the laptop ?

Ken

[cf_code_warrior]

Sorry, stupid of me to omit that.

Windows XP Professional.

[The ScareCrow]

Have you installed sp2 for xp ?

A couple of points to note:

You have to install sp3 for sql server after the installation of the sp for xp
If you have the xp firewall active, you may need to create an exclusion for
the sql server port

Here's a link to resolve this

[url]http://www.docs.com/HelpFiles/WindowsXPServicePack2Fix.htm[/url]

Ken

[cf_code_warrior]

Scarecrow Thanks for that help. I had 'installed' SP3 for SQL before i got
your post but after I posted thinking in that direction. I thought MS had
installed it, but it had done nothing more than unplack, not installed. Ran
the @@ version in QA and RAN the install. The firewall is turned off, I use
hardware. So it was SP3 only. Then I was halted for not having a trusted
connection. Modified SQL to allow both Windows Authentication and by User.
Now I am allegedly getting a connection. Indeed I am. Had to modify the usual
rubbish in iis. Robert