SQL server Management studio express

Question

Hai all....

I am a begineer in SSMS......

1--->With windows authentication mode i could easily get into the server....but wat should i give in uid and pwd of my connection statement in the program ............

2--->wat is the step to create a new login with all the credentials and i also want to create a new database where the owner is the login which i am gonna create.....

Any suggestion or materials reffered would be a great help to me....

Answer 1

You need to have Trusted_Connectio set to YES.

Sample Connection string

"data source=Sql01;initial catalog=Northwind;
integrated security=SSPI;persist security info=False;
Trusted_Connection=Yes."

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com