|
|
 Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
 SQL Server
Temporary Database
Views
Backup
SQL Mail
DTS - Data Transformation Services
Memory
Security
Excel
Jobs SQL Agent
MSDE
 MSDE Not accepting N...
Install
DBCC
User Management
System Databases
BCV
Deadlocks
Temp Tables
Windows OS
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
|
|
|
|
|