The postings on this site are my own and do not represent my Employer's positions, advice or strategies.


  Tuesday, December 18, 2018


bob tech
Contact Bob
VW Buses
Cook Book


Family Vacation Summer 20

  bob Links
Sallie Mae Net RePay...
I asked the Indians: "Do men ever make Chicha?" My question was met with gales of laughter. The woman howled. Bent over in hilarity, one replied, "Men can't brew. Chicha made by men would only make gas in the belly. You are a funny man! Beer is women's work." - Alan Eames
Wider View Insert

IBM - AS400
Performance Counters
Service Broker
SQL Server
     Temporary Database
     SQL Mail
     DTS - Data Transformation Services
     Jobs SQL Agent
          MSDE Not accepting N...
     User Management
     System Databases
     Temp Tables
Windows OS

Insert Category

Will be added as a sub-category of, MSDE
MSDE Not accepting Network Connection
-----Original Message----- From: Horkay, Robert Sent: Tuesday, October 28, 2003 6:59 AM To: Conner, Scott Cc: Slaubaugh, Duane; DL - SQL DBA Subject: Configuring MSDE / MSAC (RE: Sa pswd msde whqbnwww06) Scott and Duane, The MSDE Instance used by MSAC (Microsoft Application Center ?) WHQBNWWW06 is now properly configured and setup. The sa password is sysmarvel. Sorry we couldn’t get to this yesterday it can get quite busy. Please remember to patch this instance of MSDE, it is currently not patched to any level ! Briefly what needs to happen with MSAC to accept network connections from outside it’s own machine with a sql server login is: 1. Stop the MSDE Services 2. Change the instance to mixed mode authentication 3. Configure the instance to listed for network connections 4. Re start the services (remember to include sql server agent for the instance) 5. Using a trusted NT connection that is part of the Administrators group (through osql), change the sa password: a. OSQL -E -S(local)\MSAC -q “exec sp_password Null,’sysmarvel’,’sa’ 6. Test from local machine a. OSQL -S sa -P sysmarvel -S(local)\MSAC -q “select @@Version” 7. Test from another network machine a. OSQL -S sa -P sysmarvel -SWHQBNWWW06\MSAC -q “Select @@Version” That’s about it. MSDE by default does not accept network connections and does not use mixed mode authentication, this is by design, by default MSDE is meant to be a desktop database, so these options are turned off. Bob