hi,
NWx said:
Hi,
I'm an old developer, but didn't used SQL Server or MSDE to much before.
I have NetSDK instance of MSDE installed on my PC by Net Framework SDK.
All quickstart samples access it using trusted connection.
However, I want to access it using user / password, but I have no idea what
is default username / password to use.
Any help is appreciated.
Regards
in order to use SQL Server authentication instead of WindowsNT trusted
authentication, you have to hack a little bit the registry as described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;285097 .... the same
article explains how to change the default trusted authentication setting at
install time...
as regard login credential, there is no "default" user in SQL Server....
there is a default super user, a system administrator member that can not be
removed, known as "sa" ... this user is available on all SQL Server
installations...
you can use this standard "sa" login with the password you provided at
install time.... hope you did not leave it blank, but still remember it
=;-))
if you do not remember anymore, please login as a sysadmin (or security
admin) trusted Windows login and execute, via oSql.exe,
EXEC sp_password @new = 'your new pwd', @loginame = 'sa'
you can change user's pwd with Enterprise Manager too, if available....
then, logging as 'sa' or with a Windows NT trusted user, you can create
additional SQL Server authenticated logins with fewer prmission, accordingly
to you needs.
hth
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.5.0 - DbaMgr ver 0.51.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
