Couldn't connect to sql server database from ado.net.

Question

Hi there!

I wrote simple sql script that creates my database:

create database [MaterialStream];
exec sp_addlogin N'MaterialStreamLogin', N'123', N'MaterialStream'
exec sp_adduser N'MaterialStreamLogin', N'MaterialStreamUser', N'db_owner'

And then couldn't connect to my database from ADO.NET. How can I set up credentials for my user?

Answer 1

Have you tried logging on as that user using Management Studio? It's possible it's defaulted to requesting a password change on first login or similar.