Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Name Instance

Author  Topic 

Westley
Posting Yak Master

229 Posts

Posted - 2005-08-02 : 01:25:49
Hi all,
I'm having a very funny issue, where i got a sql server running in a named instance, default port 1434, when i try to connect to it via EM, using just the instance name, its works fine, but when i try on other PC using EM trying to connect to it, it fail to auth, but if I try to connect to it using the port number (without the instance name), and it works fine, does anyone have any ideas with this?
Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-08-02 : 01:53:17
are you running a downlevel version of MDAC? try updating your client to the latest (MDAC 2.8 SP1).

you can find the MDAC update at www.microsoft.com/data



-ec
Go to Top of Page

Westley
Posting Yak Master

229 Posts

Posted - 2005-08-02 : 02:40:00
Nope, already running MDAC 2.8, the funny thing is that PC can connect to the server through EM before, it just after some time, it somehow doesn't connect to it anymore, but it can if I give the port number, thats something I don't understand.

any other ideas?
Go to Top of Page
   

- Advertisement -