SQL Connection Error.......how to come out?

[Hiten]

Hi
i tried all but still its not connecting
I have WindowsXP, and SQL2000 installed on it with WindowsNT integrated
security
When i tried with ConnectionString to connect Northwind it works fine
but when i Trying it with other Database which i have created for
learning it wont connect and it gives following error in ASP.Net

Cannot open database requested in login 'mydb'. Login failed for user
'GOKUL/ASPNET'

Connection String is
"Workstation id=GOKUL;packet size=4096;user id=sa;integreated
secutity=SSPI; data source=GOKUL;persist security info=False;Initial
catalog=mydb"

instead of mydb if i write Northwind, connection establish without
error
and if i change catalog to myDB it gives error..

plz help

 

[Guest]

You are using integrated security. Therefore the user account logging into
the database is your local account. I think your local account is not a
database user. When you add your account your problm should be solved.

Marinus Holkemaq

 

[yatharth]

sorry man i could not understand your problem ,
Give the details of error.