sql server connect: SQLDMO connects to wrong sql server instance -- sql server connect

SQLDMO connects to wrong sql server instance

aromani NO[at]SPAM gmail.com
9/21/2006 1:19:10 AM

sql server connect:

I have a small utility that is used to run sql script files from
command line. It's created in c#. This utility uses sqldmo objects to
connect to server and run script.
I have two SQl server instances installed - 2005 and 2000. I'm using
2005 as a default instance and 2000 as .\sql2000 named instance.
Everything was OK but recently I reinstalled my 2000 instance
(developer edition instead of personal). And now my utility doesn't
work. I pass (local) or machine name as a server name but it looks like
it tries to connect to \sql2000 instance. I can notice it because
connection fails with error "Invalid connection" and when I stop my
2000 server it fails with error "SQL Server does not exist or access
denied".
Any thoughts?

Re: SQLDMO connects to wrong sql server instance

aromani NO[at]SPAM gmail.com
9/21/2006 1:26:43 AM

I also want to add that some time ago I had the same issue. But I was
able to fix it after playing with sql server/client 2000/2005 settings.
The problem is that I'm not sure what I actually did to resolve the
problem. I tried to enable/disable, change order of protocols for both
instances - no luck :-(

[quoted text, click to view]

Re: SQLDMO connects to wrong sql server instance

aromani NO[at]SPAM gmail.com
9/21/2006 1:29:06 AM

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.