>>Hi,
>>
>>When I am testing my ASP.NET to connect to SQL Server I use the following connecting string:
>>
>>
>>connString = "server=MYCOMPUTER\\SQLEXPRESS; database=MyDatabaseName; Trusted_Connection=Yes"
>>
>>
>>But I get an error:
>>
>>
>>Cannot open database "MyDatabaseName" requested by login. The login failed.
>>Login failed for user 'MYCOMPUTER\Dmitry'
>>
>>
>>I suppose the "Trusted_Connection" syntax is not recognized, right? What should I change in my connString?
>
>You could try swapping it for 'Integrated Security=True' - but the simplest way to get it right might be to just let the IDE create the string via ServerExplorer ?
I don't know, yet, how to use ServerExplorer. I am just trying to create a "Hello World" of the SQL Server connection (if you know what I mean). Changing Trusted_Connection to Integrated Security didn't solve the problem. I suppose next I need to create a log in (learn how) in the SQL Server and enter the 'uid' and 'pwd' in the connection string.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham