Post Number: 313
|Posted on Thursday, February 28, 2008 - 02: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.
Clark Frazier (cfrphoto)
Post Number: 1684
|Posted on Thursday, February 28, 2008 - 02:42 pm: ||
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.
Post Number: 314
|Posted on Thursday, February 28, 2008 - 04: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..
John Slocum (jslocum)
Post Number: 8796
|Posted on Friday, February 29, 2008 - 11:06 am: ||
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.
Founder - Blackthorne Software
"I only hope we never lose sight of one thing, that it was all started by a mouse.... and a keyboard."