Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.
Anyone know why?
thanks in advanceAfter that login by SQL user and password is denied after restart local MSDE machine
With this I mean access from other machines on the network. Local login is working ok.|||Solution found!
Install MSDE again with DISABLENETWORKPROTOCOLS=0.
Changing it afterwards with SQL Server enterprice manager doesn't work.
just for those who are having the same problem
No comments:
Post a Comment