Re: Error accessing MSDE by network (no locally) when instance created after installing Visual Studio 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



You were right. Thank you very much !

SQL Server Browser it's the responsible of it. I didn't know of its
existence :-(

At http://support.microsoft.com/?scid=kb%3Ben-us%3B905618&x=19&y=12 there is
good explanation how to solve it.


Josep.



"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> escribió en el
mensaje news:C87951E8-1823-4BD7-BC82-BB5209F4598B@xxxxxxxxxxxxxxxx
I'm not quite sure of your situation, but if SQL Server 2005 Express
Edition was installed with Visual Studio 2005, then perhaps you need to
start the SQL Server Browser service. It replaces the SQL Server 2000
system of identifying the instances on a computer.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no
rights.

"Josep" <jmartinez@xxxxxxxx> wrote in message
news:el37se1gHHA.4032@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

a weird thing is happening in all development PC in the company. The
developers have some MSDE instances created in their machine, used for
different purposes. When someone create a new instance after installing
Visual Studio 2005 (some with and some without SQL Server 2005 Express
Edition) this new instance cannot be accessed by other computers while
the other instances created before (with the same configuration, where
DISABLENETWORKPROTOCOLS=0, just the instance name is different) have no
problem.

If I do a telnet on MSDE port it goes OK (don't reject the connection).
Has that happened to someone?


Thank you in advance,


Josep.




.



Relevant Pages

  • Re: Server Discovery Instance Name Problem
    ... SQL Server 2000 became aware of SQL Server Browser with SP3. ... machines, ALL machines on our network start having a problem detecting the ... Server Browser service running, these machines would be enumerated as: ...
    (microsoft.public.sqlserver.connect)
  • Re: Create ODBC to SQL SErver 2008 in Windows Vista Ultimate
    ... Could not start the SQL Server Browser service on Local Computer ... the SQL Server Browser service is disabled. ... Using either the Services applet or SSCM, on the General tab change the ... Rick Byham (MSFT), SQL Server Books Online ...
    (microsoft.public.sqlserver.connect)
  • Re: Create ODBC to SQL SErver 2008 in Windows Vista Ultimate
    ... Looks like SQL Sever (SQLEXPRESS) is good to go. ... However, the SQL Server ... Under SQL Server Browser Should i got to the "Log On" tab, ... Rick Byham (MSFT), SQL Server Books Online ...
    (microsoft.public.sqlserver.connect)
  • Re: Error accessing MSDE by network (no locally) when instance created after installing Visual Studi
    ... I'm not quite sure of your situation, but if SQL Server 2005 Express Edition was installed with Visual Studio 2005, then perhaps you need to start the SQL Server Browser service. ... The developers have some MSDE instances created in their machine, ... When someone create a new instance after installing Visual Studio 2005 this new instance cannot be accessed by other computers while the other instances created before have no problem. ...
    (microsoft.public.sqlserver.connect)
  • Re: SSAS 2005 Port #
    ... Is your SQL Server Browser running on the SQL Server Machine? ... the SSAS default instance listens on TCP ... port 2383 and named instances of SSAS are assigned a port dynamically. ...
    (microsoft.public.sqlserver.olap)