all groups > sql server connect > december 2004 >
You're in the

sql server connect

group:

Connection Problems



Connection Problems Michael O'S
12/21/2004 2:56:45 AM
sql server connect: Hello,
I have a small workgroup of computers (4) all running windows xp sp2. One
of them is running msde2000. I can connect to a named instance of sql server
but can not connect to the default instance. I am using osql and using
trusted connection. I am not sure what other information is needed so
please do not hesitate to ask! I am really pulling my hair out on this one!
Any help would be greatly appreciated.

Re: Connection Problems Derrick Leggett
12/27/2004 5:18:02 PM
Are you sure there is a default instance? If it's just MSDE 2000, there
usually is not a default instance. It installs to a named instance by
default. Look in Administrative Tools/Services for all SQL Server services.
See if you have any running besides the named instance.


[quoted text, click to view]

Re: Connection Problems Philippe RUELLO
12/27/2004 10:35:41 PM
Hello,
Did you activated TCPIP network protocol for this default instance (verify
in the error.log for the instance)?
Hope this will help.
--
Philippe RUELLO
DBA MSSQL

"Michael O'S" <mroresolutions@woh.rr.com> a écrit dans le message de news:
NhMxd.3864$mA3.1811@fe2.columbus.rr.com...
[quoted text, click to view]

RE: Connection Problems Michael O'S
12/30/2004 11:05:09 AM
Thank you for your input! I did check tcpip settings and all were good. I
did however find in the server logs that some intances (including the
default) were not listening or failing to bind to port 1433.
I ended up removing msde instance that I could not connect to and
reinstalling making sure to use the DISABLENETWORKPROTOCOLS=0 parameter.
After I did this, I could see all instances of msde on any computer from any
computer in my workgroup.
Good Luck!


[quoted text, click to view]
AddThis Social Bookmark Button