Message
De
22/02/2010 08:46:02
À
22/02/2010 08:37:06
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01450193
Message ID:
01450196
Vues:
50
I believe I use Windows authentication (Trusted_Connection=Yes] in SQLStringConnect.)
I don't understand the question on default database for login. In my SQLStringConnect there is a name of the database I am trying to connect; is that what it is?
>Are you using Windows or SQL Server authentication in app? What is default database for the login? What database are you login to?
>
>>
>>Every so often when I start my app (VFP9) that uses SQL 2005, I get the message:
>>
>>Then I have to restart my computer and 9 out of 10 times things start working. What causing this problem of database access being denied?
>>
>>TIA
I don't understand the question on default database for login. In my SQLStringConnect there is a name of the database I am trying to connect; is that what it is?
>Are you using Windows or SQL Server authentication in app? What is default database for the login? What database are you login to?
>
>>
>>Every so often when I start my app (VFP9) that uses SQL 2005, I get the message:
>>
>>Connection failed: >>SQL State: '08004' >>SQL Server Error: 4060 >>Server rejected the connection; Access to selected database has been denied >>>>
>>Then I have to restart my computer and 9 out of 10 times things start working. What causing this problem of database access being denied?
>>
>>TIA
"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
"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