Hi all,
Im a newbi at ASP.NET -just getting my dirty at it .

ProbBackground: :D
Im trying to connect to the MSDE database that I have created a database called WroxJokeShop, using Windows NT integrated Security coz it wouldn't allow sa or any name for that matter as login :error is "user sa is not associated with trusted SQL server connection" as a result i ended up with using Windows NT integrated Security .


Prob:
I am using a ConnectionSting in Web.config . But im unsure of how to go on doing it for NT integrated security.
I have following at the moment and it doesnt work.


<add key="ConnectionString" value="Server=(local)\NetSDK;Integrated Security=SSPI;Initial Catalog=WroxJokeShop" />

I am calling this from another method GetDepartments() which is a stored procedure.

Dim command As New SqlCommand("GetDepartments", connection)
command.CommandType = CommandType.StoredProcedure

connection.Open()


An error always occurs at connection.Open()
Which states that the User is not part of Authoriszed members-- some thing like that. I believe its the way I have set up the server thats causing the prob. I can run the stored procedure directly.

Hers is how I installed MSDE.

Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=admin

And when I create the dbShop using VS.NET I am using the NT Secure Authentication.

Can you cc anything Im doing wrong.. this is soo frustating.
Any help is appreciated.
Cheers.

Imran.
-=there are 10 type of people in this world=-
 -those who understand binary and the rest-

__________________
Imran.
-=there are 10 type of people in this world=-
&nbsp;-those who understand binary and the rest-

oh
im Running:
Windows XP pro
MSDE
Visual Studio.NET 2003 Pro TrialVersion


Imran.
-=there are 10 type of people in this world=-
 -those who understand binary and the rest-

First of all, you might get into trouble using NT Secure in later chapters, try to get MSDE running.

Have you installed MSDE? Is SQL running on your task bar?

also}}

This might help:
http://support.microsoft.com/default...NoWebContent=1

Maybe MSDE is not set up correctly. Try this:

This will setup the "sa" password if you are using Windows XP.

1) Open a DOS windows by selecting start/run and type cmd, then click ok

2) At the prompt type the following exactly as you see it as it is
case-sensitive:

' replace the "VSdotNET" part with the name of your SQL server
' instance...
Osql –E –S (local)\VSdotNet

then press enter.

You will see something like "1>" appear.

Type: sp_password null,’newpassword’,’sa’

then press enter

Type: Go

then press enter

It should come back and tell you that the password was changed.

Type: quit

Type: exit

This should close the DOS window and you are ready for the next bit. -
creating the database


Kevin

Thanks Kevin for that reply,
I think my MSDE setup was not correct.

I have uninstalled VS.net and MSDE.. am gonna install VS.Net2002 instead, and use Sql2000. If that doesnt work.. i will install MSDE2002.

Thanks again for the reply..gives me hope:)

Imran.
-=there are 10 type of people in this world=-
 -those who understand binary and the rest-

Hi ya Kevin,
Ok I have done just like yoiu said.. but it giving ADO error when I try to create the database.
Refer to :
<http://homepages.paradise.net.nz/imran/asp/>


Cheers.

Imran.
-=there are 10 type of people in this world=-
 -those who understand binary and the rest-

This might be a little out of my league...but did you select the "option" to install MSDE when you installed VS 2002?

If you had selected to install MSDE during installation of VS 2002 your instance name would be

ILIA004\VSdotNET

you still might have to go back and set the password again...

Kevin

I think i have got it.

I reinstalled every thing from scratch.

Refer following, I cant test the WRoxshop rite now.. beepin tired.. i have tested a connection with Masters db and that seems to be working.. dammit i wasted more time administring this thing than actually coding it :( pisses me off + I got my MCP exam on Mon.
As long as this works.. I soo wanna get this website online before endofthisyear. MayB i shoud write a intallation bible for dummies :-)

ANyways..If U have time, please hav a quick look at following just to make sure I am correct:-

VS.NET 2002 Installation::
http://homepages.paradise.net.nz/imran/vs2k/

Sql2000 Installation::
http://homepages.paradise.net.nz/imran/sql2k/

Sql2000 SP1 Installation::
http://homepages.paradise.net.nz/imran/sqlsp1/

After al thsi crap.. this is the result:
http://homepages.paradise.net.nz/imran/snap/

Cheers.

Imran.
-=there are 10 type of people in this world=-
 -those who understand binary and the rest-

SUCCESS ...
its working now.
Thanks for ur help.

Imran.
-=there are 10 type of people in this world=-
 -those who understand binary and the rest-

Sweet! Good luck on your exam.

Kevin