February 4, 2005 at 11:56 am
I downloaded MSDE RelA and installed it on my Windows XP Desktop.
I cannot connect to it from ENT MGR or from Query Analyzer and I am getting very frustrated!!!
I used a parameters.ini file to specify the target directory and Instance name and I set the the SA PWD at install time from the command line.. The install ran OK and the Services are started, but I cannot connect to the Instance!!!! I know I'm missing something stupid here.. help?
February 4, 2005 at 12:15 pm
Run C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe
...and enable either NamedPipes, TCPIP, or both.
If you have more than one instance on that machine, make sure you are doing this for the correct instance.
You should be able to connect.
February 4, 2005 at 1:00 pm
Many Thanks!!!!!!!!
February 24, 2005 at 1:27 pm
By default, MSDE Release A installs with all network protocols off (DISABLENETWORKPROTOCOLS in the setup.ini file). As long as you are using it for your own local machine, this is good. You (and any application) can still connect to it using the default shared memory protocol (which is faster/better on same machine, anyhow).
Downside is that SQL tools that "browse" for SQL Servers will not see the instance to display in a list. Since MSDE has no network protocols running, it does not respond to the messages on UDP/1434 that the SQL tools are using to ask for SQL Server instances. But you can still explicitly type in the machine name, or the word "(local)", or even just a period ("."), and it will connect to the MSDE instance. This will work for SQL Manager, or Enterprise Manager, or Query Analyzer, or ADO or ODBC connection strings.
While enabling the network protocols (as suggested here) does work, that defeats the purpose of the security setting Microsoft has set (by not opening UDP/1434 for SQL Slammer attacks), as well as adds a layer of unnecessary overhead on each and every call to your databases. It is better to just leave the network protocols off, and give up on the nice little dropdown box in the SQL tools.
Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply