ISSUE :
 
Profile photo
Submitted by Cara Reed
on August 17th, 2011 at 16:34:11 EST

Microsoft SQL Server 2008 R2 Creating sample database schema user-password to connect from Visual Studio2010

Hi,
I am trying to use Microsoft SQL Management Studio to create a sample schema and
connect to this database using my application code written in .NET 4 C#.
I am able to create the database using their UI.
But I am not able to create the test user and password.
What are the steps in performing this task?
Any direction will be useful.
Thanks,
Cara


Profile photo
Replied by Cara Reed
on August 17th, 2011 at 16:41:55 EST
I did some research and my question now is how do I reach to this screen.
SQL server authentication
Under security folder I don't see it.

Profile photo
Replied by Cara Reed
on August 17th, 2011 at 16:47:32 EST
I am getting Error 15007 saying 'sampleuse' doesn't have valid permission or not a valid user

Profile photo
Replied by Yogaraj Khanal
on August 24th, 2011 at 10:50:34 EST
Accepted Answer
Accepted
 Answer

Profile photo
Replied by Cara Reed
on August 24th, 2011 at 10:59:49 EST
Thanks.