January 7, 2007 at 7:27 pm
Our mssql 2005 standard server will only answer to remote/local connections using the sql server name only. If I try using the server IP (LAN only no internet) it will not connect. Where can I tweak this so that it will answer to IP and or name?
For example I can create an sql obdc connection and "look" for sql servers and find ours, and it connects. If I try the server IP, it will not connect.
January 7, 2007 at 9:32 pm
hi
just a guess... have u enabled TCP/IP and NamedPipes protocols for your server.
"Keep Trying"
January 8, 2007 at 12:27 am
Hi,
Please check the following KB for more information on connectin to SQL Server.
http://support.microsoft.com/kb/265808/en-us
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
January 8, 2007 at 12:27 am
Hi,
Please check the following KB for more information on coonectin to SQL Server.
http://support.microsoft.com/kb/265808/en-us
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
January 8, 2007 at 7:08 pm
I am now confused. I am coming from a mysql novice background. Does sql2005 not use a static port? Is that my issue, sql is using a port based on an instance? By default, does sql allow a conenction via ip address once remote connections are enabled?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply