MSDE Installation & Configuration

(Install .Net Framework (dotnetfx) & SDK (sql2kdesksp3)

(data stored location: C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\Data\dbname.MDF)

cd:>sql2sp3\MSDE\setup.exe \qb+ instancename=netsdk disablenetworkprotocols=1 sapwd=adminton
/* instancename=netsdk username=sa passwd=adminton disablenetworkprotocols=1 window authentication->Mixed Mode authentication*/

Default mode MSDE : Window Authentication mode // need to change to mixed mode for sQL server authentication

Enable Mixed Mode Authentication After Installation
To enable Mixed Mode authentication after installation, you must change this value to 2.

Install with instance, loginmode subkey located as follows

1. Control Panel > Services >Stop MSSQL server
2. Run REGEDIT
3. HKEY_LOCAL_MACHINE>Software>Microsoft>Microsoft SQL Server>netsdk>MSSQLServer>Loginmode
4. Change 1->2 with Hex , restart MSSQL server

Verify Connectivity(can connect properly to an instance of MSDE:)

1. Open notepad and save Test.udl.
2. Double-click the .udl file to open the Data Link Properties.
3. On the Provider tab, click Microsoft OLE DB Provider for SQL Server.
4. On the Connection tab, follow these steps:
a. Under item 1, select or type the server that you want to connect to. eg. slim\netsdk
b. Under item 2, select one of the following options:
• Use Windows NT Integrated security
Select this option if you are using Windows Authentication.
• Use a specific user name and password
Select this option if you are using SQL Server Authentication. If you select this option, you must type the user name and the password.
c. Click Test Connection.

OSQL UTILITY

C:\> osql –U sa –P password –S localhost\netsdk
1> use master
2> go
1> exec sp_password @old = null, @new = ‘enunst88’, @loginame = 'sa' //sa is default admin name
2> go
Password changed.
1>quit

http://localhost/SqlWebAdmin > username:sa password: enunst88 Server:slim\netsdk