Getting SQL Server Browser

[ckohoutek]

Hello,
The company I work for got a free copy of Sharepoint Team services from Microsoft before I started working here. However, the ldf files have filled up the hard drive of the server. We have SQL Server Management Studio Express, but can't login because the server does not have SQL Server Browser. I was wondering how to get that?
Thanks for the help.

 

[Roadki11]

You need to enable the SQL server browser service, read the following link it will tell how:

http://support.microsoft.com/kb/914277

RoadKi11

"This apparent fear reaction is typical, rather than try to solve technical problems technically, policy solutions are often chosen." - Fred Cohen

 

[ckohoutek]

The server doesn't have the browser service on it. I browsed out the the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe. where the file should be, but in the shared folder there is no such executable. So I am trying to find a way to get the Server Browser on the server.

 

[Roadki11]

Ahh, i bet its the embeded version of SQL, which really doesnt allow remote connections and probably wouldnt have the browser service. You need to install that SQL managment studio on the sharepoint/sql server. Then use this to connect:

Server Name
\\.\pipe\mssql$microsoft##ssee\sql\query

Use windows authentication

RoadKi11

"This apparent fear reaction is typical, rather than try to solve technical problems technically, policy solutions are often chosen." - Fred Cohen