Message
From
10/10/2016 11:08:37
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
SQL Server Agent
Miscellaneous
Thread ID:
01641791
Message ID:
01641791
Views:
64
Hi,
New installation of my app with SQL Server. I created a user in the SQL Server (this is SQL 2012 Express) and assigned the role of Owner.
I can connect to the SQL Server from SSMS using my created user ID and password.
But when I try to connect from my app, using the same credentials, the connection is denied.
I have checked the in the SQL Configuration Manager the TCP/IP is enabled and the SQL is listening on port 1433. The only thing (so far) I find is that the SQL Server Agent and SQL Server Browser stopped. Do I need any of these?
Or any other suggestions?
TIA
New installation of my app with SQL Server. I created a user in the SQL Server (this is SQL 2012 Express) and assigned the role of Owner.
I can connect to the SQL Server from SSMS using my created user ID and password.
But when I try to connect from my app, using the same credentials, the connection is denied.
I have checked the in the SQL Configuration Manager the TCP/IP is enabled and the SQL is listening on port 1433. The only thing (so far) I find is that the SQL Server Agent and SQL Server Browser stopped. Do I need any of these?
Or any other suggestions?
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