| Author |
Message |
    
CMH (chuber)
Intermediate Member
Username: chuber
Post Number: 313
Registered: 03-2006
| | Posted on Thursday, February 28, 2008 - 03:35 pm: | 
|
Hey, I know this is not the proper forum for this, but thought one of the SQL guys might find this easy.
In SQL Server Config. Mgr, cannot get SQL Server Browser to run. Screen shot below. Right click options are all greyed out and only allows "Properties" and "Help".
Loaded SQL Server Express w/ Adv to XP Pro. Machine is newly reformatted and running only AVG, MS Office and eB. All Windows updates applied (yes, including .NET 2.0).
Any help is appreciated.
Thanks,
Chris
 |
Clark Frazier (cfrphoto)
Senior Member
Username: cfrphoto
Post Number: 1684
Registered: 03-2005
| | Posted on Thursday, February 28, 2008 - 03:42 pm: |
|
Chris,
The SQL Server Browser must be enabled in the SQL Server Surface Area Configuration Utility in the Start Menu. Once enabled, it will start automatically the next time SQL Server is restarted. There are previous beta posts with screen shots. Just search for SQL Server Browser. Other networking settings will be there also. The SQL Server Browser Service is not needed unless connecting across a network.
Clark
cfrphoto |
CMH (chuber)
Intermediate Member
Username: chuber
Post Number: 314
Registered: 03-2006
| | Posted on Thursday, February 28, 2008 - 05:42 pm: |
|
Thanks Clark - It is now running. FYI for the user guide, step 19 in the "HOWTO - Tips on Installing SQL Server Express 2005" does not mention that it must first be enabled in the SQL Server Surface Area Configuration Utility. Here's what it says: You must now change some configuration settings in SQL Server to allow eB to work as it needs to. From the Start menu in Windows select Start|All Programs|Microsoft SQL Server 2005|Configuration Tools|SQL Server Configuration Manager. In the SQL Server Configuration Manager, select SQL Server 2005 Services in the sidebar on the left. Check the SQL Server Browser values on the right and make sure the State is Running. If not, then right click the setting and click Start. If the SQL Server Browser is not running, you will not be able to connect to the database..
Thanks again-
Chris |
John Slocum (jslocum)
Moderator
Username: jslocum
Post Number: 8796
Registered: 03-2004
| | Posted on Friday, February 29, 2008 - 12:06 pm: |
|
Chris,
Actually this should go in the "HOWTO - Sharing Data Across the Internet" documentation since it will only be needed for internet sharing. Thanks for pointing this out. I'll add it to the docs.
John
Founder - Blackthorne Software
Board Moderator
"I only hope we never lose sight of one thing, that it was all started by a mouse.... and a keyboard."
|
|
Closed: New threads not accepted on this page 
