SQL Server Script not working

[mtaber]

I'm having a problem with the Microsoft SQL Server script. I'm passing it the username of 'sa' and the correct password to a SQL Server 2000 instance (default instance) that resides on a remote machine. The only command I'm calling in the script is:

select getdate();
GO

That's it. I keep getting an error when trying to connect. I used ethereal to look at the network traffic and it doesn't appear as if the installer is even trying to contact my database machine.

I thought it might be sending traffic down the wrong pipe. I have 4 total network interfaces, 3 of which I have disabled to help eliminate them as the source of the problem. 1 is a physical card, another is for a 1394 port, and the last two are for VMWare. The only one that isn't disabled is the physical card.

I have tried this with both SQL authentication and Windows Authentication, but neither seems to be working. Both result in a return code of ERROR. I have also tested using Query Analyzer to see if I can connect directly to the database.

On the machine I'm running the install on, I have SQL 2k Developer edition (1 instance), and 2 instances of SQLEXPRESS (2k5). The SQL Server I'm trying to connect to is a Windows 2000 Server with SQL 2000 Standard Edition (fully patched) installed.

I can connect to databases installed on the client workstation, but can't seem to touch the SQL 2000 server. I'd chalk it up to being SQL 2000, but with a prior version of IA, it seemed to be working fine.

All of the network client settings are set to use TCP/IP, so it's not a shared memory issue or anything like that.

Anyone have any ideas?

[mtaber]

I've got a little bit more on this. I created a new account on the SQL 2000 machine with a username/password of test/test and it seemed to work fine.

It would appear that the password for the account I'm using contains the @ symbol and for some reason, this isn't being passed properly to the "Microsoft SQL Server Script", although the password displays properly in the "MessageBox" if I use one to print out the password I'm passing into it.

Is there a bug fix coming for this? It's in IA 7.0 build lonepine_rtm.070707.