How to set up a username and password for MSDE

Hi,

I have installed MSDE using the following parameter:

commandline> setup SAPWD="MySAPwd"

now all was set up... when i opened the osql utility..i wasnt able to login... it kept asking me the login name ans password...

i entered my windows login name which is 'home' and entered 'kham00s' as the password... it didnt work... then i entered my windows login name again which is 'home' and entered 'OTHERPASSWORD' as the password which is my system password...but did not work either...

then i logged in using :

commandline> osql -E

It successfully logged in... and i was able to create databases and tables...

can someone tell me how to set a username and password for MSDE please... so that i can connect to MSDE using WebMatrix...

i m coming from a PHP/MySQL background so i know SQL and stuff... but dont know how to handle and configure MSSQL...

waiting for the response..
thanks in advance...
Bye.
Kamran.The SAPWD option sets the sa users password, and so you need to use a username of sa and the password you supplied.

I edited your message so that your passwaords are not visible...|||thanks douglas! :)

But can you plz tell me what is my sa username? i read the term 'sa' a lot in the msdn library but couldnt figure out what it means... it wud be gr8 if i get to know what is 'sa'...

btw thanks for editing...but the passwords i entered were not the real ones. ;)

looking forward to replies.. thanks...|||The sa password is 'sa' (without the quotes).|||thanks again...

but that isnt working either...

after installation.. i do this:

commandline> osql -U sa -P "mypwd"

also tried this:

commandline> osql -U sa -P mypwd

and this:

commandline> osql -U sa
enter password: (keyboard hits)

but doesnt connect either... tells me that 'sa' is an unknown user... etc...

plz help me... i can connect using the -E parameter...but i need to connect to MSDE using ASP.net Web Matrix... so plz help... many thanks...

regards,
Kamran.|||Here is the procedure for adding a user to a database (from the "Microsoft ASP.NET Programming C# .NET" book):

When you installed your .NET IDE, it should have set up an ASPNET Windows user account. ASP.NET is configured by default to use the unprivileged ASPNET account to run ASP.NET worker processes.

1)
comline: osql -E

2)
grant login access to the ASPNET account. <domain> is your local machine name.
1> sp_grantlogin '<domain>\ASPNET'
2> go

3)
call the sp_defaultdb system stored procedure to change the default database to the database you want ASPNET to use.
1> sp_defaultdb '<domain>\ASPNET', '<yourdatabasename>'
2> go

4)
add the ASPNET account to the db_datareader role.
1> sp_adduser '<domain>\ASPNET', 'ASPNET', 'db_datareader'
2> go

5)
to add ASPNET to the db_datawriter role, do:
1> sp_addrolemember 'db_datawriter', 'ASPNET'
2> go|||thanks everyone...

all is working fine now... thanks to douglas and dran001...

i m able to ger web matrix connect to the database...

btw i m unable to connect through web data administrator... thankx anyways...

i hav no probs 'inserting' using OSQL...

regards,
Kamran.

How to set the current connectionString user as a defualt value?

Hi,

I'm using username & password in my connectionString to connect my program (C#.net) with Sql Server 2005..

I put in defualt value in one feild: user_name()

it replace the user: dbo, not the user which I used in my connectionString.

so.. how to get this user?

I tried to put: currnet_user

but I get the same result, "dbo" not the user in my connectionString..

I tried SESSION_USER, it gave the same result :(|||

This is my connectionString:

connectionString="Provider=SQLOLEDB;Data Source=LEWEHSBF\LEWEENG;Persist Security Info=True;Password=HsBfL4w4;User ID=Lewe;Initial Catalog=MyDatabase"

|||

I think the resone is the user I which I used in myConnectionString, is Admin user, I tried with "dataread, datawrite" user and its worked..

Thank you myself

how to set password when installing MSDE (was "Newbie to SQL")

Hi Guys,

I am Access user of both BE and FE. I would like to set my BE with SQL

Therefore, as trial I just downloaded MSDE2000A.Exe a Desktop SQL Engine from Microsoft. I need to install it. But due to some technical aspect (which I might not understand) I could not install it. Bcz whenever I am trying to install its setup file, it ask me a strong password. How to set it ? or how to supply it I dont know...

Any help.

Regards,
AshfaqueThis (http://support.microsoft.com/default.aspx?scid=kb;en-us;814463) is what you need (in English).

-PatP|||Thanks Pat,

I installed it successfully. The information page is good. Thanks.

Do you have any other referece web page that would show me how to transfer my Access table data over to this installed SQL server and allow my FE to be still in MS ACCESS.bcz I desined my beautiful forms and its code after a lot of excesize. What are the initial steps I must follow?

With kind regards,
Ashfafque|||I'd suggest using the Access Upsizing Wizard as a start. It isn't a complete solution, but it gives you one heck of a head start! Microsoft has a great "How to (http://support.microsoft.com/default.aspx?scid=kb;en-us;237980)", and there are versions for 2000 (http://support.microsoft.com/default.aspx?scid=kb;en-us;325017) and 2002 (http://support.microsoft.com/default.aspx?scid=kb;en-us;330468).

-PatP|||Again thanks Pat,

Article is very usefule. I will be back if face any problem.

With kind regards,
Ashfaque

How to set password through CRviewer to DSN less connection in crystal report

Hi,please help.
I have crystal reports bearing DSN less(direct) connection with password protected Access database.But i dont know how to set password through CRviewer in VB 6.0 .Moreover my reports have no. of subreports too.How are you calling Reports? If you use front end application, then you need to supply the password informations