Re: Connecting remotely through VPN

Tech-Archive recommends: Fix windows errors by optimizing your registry

-Charles,

Here is the output when I run sqlbrowser -c

SQLBrowser: starting up in console mode.
SQLBrowser: starting up SSRP redirection service
SQLBrowser: failed starting SSRP redirection service -- shutting down

Dale

""Charles Wang [MSFT]"" wrote:

Hi Brassica,
I think that your SQL Browser Service did not work well. I recommend that
you first stop your SQL Server Browser service and then run it from console
mode as following:
<drive>\<path>\sqlbrowser.exe -c
By default, the SQL Server Browser service is located in the folder
%ProgramFiles%\Microsoft SQL Server\90\Shared.
Please post the output here.

Also I recommend that you try connecting to your SQL Server instance by
explicitly specifying the tcp: prefix. For example:
osql -S tcp:192.168.16.3\SQLEXPRESS -E
Go

If this issue persists, I would like to check with you what the version of
your SQL Server 2005 Express is. You can run SELECT @@VERSION to check it.
If the version number is less than 9.0.4035, I recommend that you try
installing the latest service pack to see if that helps.
Microsoft SQL Server 2005 Express Edition Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-
acdd-9a1c832e65a6&displaylang=en
If you want a GUI management tool for SQL Server 2005 Express, please
install this package:
Microsoft SQL Server 2005 Express Edition with Advanced Services Service
Pack 3
http://www.microsoft.com/downloads/details.aspx?familyid=b448b0d0-ee79-48f6-
b50a-7c4f028c2e3d&displaylang=en

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages

  • Re: SQLBrowser 2005 will not start up as service
    ... Perhaps the password has changed for the account that the SQL Server Browser Service is using? ... get the SQLBrowser to run from a command pront but it ...
    (microsoft.public.sqlserver.setup)
  • Re: How to connect 2005 express
    ... Enterprise manager can't mange SQL Server 2005 instances correctly. ... reason EM doesn't see it is probably because you haven't enabled and started ... the sqlbrowser and enabled networking for your Express instance but even ...
    (microsoft.public.sqlserver.msde)
  • Re: Access denied after OS Disk upgrade!?
    ... Take a look at the ERRORLOG for more details. ... You can also try starting sql server in the console mode from the command ... >through Enterprise Manager or Query Analyzer: "A connection could not be ...
    (microsoft.public.sqlserver.connect)
  • Console Windows Forms hybrid
    ... I have an application that I want to be to run in Console mode and GUI ... If no params are entered, I want the GUI fired up, if params are ... Mark Allison, SQL Server MVP ... Looking for a SQL Server replication book? ...
    (microsoft.public.dotnet.languages.csharp)