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....
Loading
Vijaya KadiyalaPosted Feb 10, 2009, 2:35 PM
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