What else is running on the server? Sounds like something is utilizing port 1433 on the WAN connection, which is where you aren't connecting. One thing you could do is...

Please don't crosspost.

See reply here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=246794

There is a known issue with indexes on computed columns that has plagued maintenance plans for years now. As of SP4 there is a new option that handles this properly:

In general terms, what does the DTS package do? Avoid posting anything that reveal internal information about your organization or sensitive internal processes. For instance, saying, "It reads a flat...

Okay, folks, before this turns into a flamewar, let's leave at these points:

1) David posted his experience with one of Apex's products.

2) Others happen to disagree with David's stance on...

What happens when you try to connect to the <server>,1433 (this forces a connection to the server on port 1433)?

You have the service running under one user but you want to make the connection under a completely different user context? In that case you'd have to resort to impersonation...

Looks like the error occurred before this.

The short answer is no. There is nothing native that provides this functionality, especially within SQL Server. That's not to say there's not a component out there that does such...

I'm assuming you did the copy and replace due to the KB article (308866). Do the last few lines of sqlstp.log (usually found in C:\Windows or C:\WinNT) give any indication...

Out of curiosity, what happens if you do a linked server connection to another SQL Server?

What happens if you create a system DSN on the SQL Server pointing to the MySQL database and use it instead of the full-blown connection string? Any difference?

If it is a service, your connection string just needs to reflect integrated security. No username/password need be specified in it. In that case the connection to the database will...

What do your queries look like? Also, if you have MyODBC installed on your workstation, do you have the same issue, say connecting from SQL Server (if installed) or MS...

Basically the same as you:

EXEC sp_addlinkedserver @server ='LocalMySQL' ,
@srvproduct = 'MySQL' ,
@provider = 'MSDASQL',
@datasrc = null ,
@location ='localhost' ,
@provstr = 'DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=world;USER=hidden;PASSWORD=hidden;OPTION=3',
@catalog = null
GO

My MySQL install is local...