> From: Francois Pepin [mailto:[EMAIL PROTECTED]] > Subject: Stupid MSDE question > > Is there anyone who could tell me if MSDE can be accessed by TCP/IP like > MS-SQL (in the view of the recent worm)? > > If so, is there any way to tell it to change the sa password in it?
The SQL Server 2000 version (which isn't called MSDE anymore even though that's basically what it is) supports pretty much everything the MS-SQL enterprise-level servers do. The only administrative difference is that it has no admin tools with it. If you have access to Enterprise Manager, you can connect to a running Desktop Engine instance the same way you connect to a remote SQL Server instance, and change the password there. Otherwise, the only way I know of is to use osql. osql -S SERVERNAME\INSTANCENAME -U sa Will connect you as sa. (You can use any user in the *sysadmin* role. A securityadmin cannot change a sysadmin password, though). From there, the SQL command to change sa's password is: exec sp_password @old = 'currentpass', @new = 'newpass', @loginname = 'sa' (If you have a MSDE from SQL 7, the process is the same, the only major difference is SQL 7 didn't have instances, just servers). --K
