sql server - No connection could be made because the target machine actively refused it 127.0.0.1:2382 -
i trying connect ssas engine(sql server denali) failing following error "no connection made because target machine actively refused 127.0.0.1:2382" ssas service running under network service account , sql browser service running on local system acc
what os running? had similar problem , resolved issue changing sql server browser account built in account name account password.
open sql server configuration management
- right click sql server browser , select properties.
- in log on tab select "this account:" radio button. can enter user , password or can press browser button. use admin log local machine sql server installed.
- if press browser button when select user or group page appear press advance button , select 1 of account.
in bid may need impersonate data source. dirty solution work me in vista machine installed sql server r2 practicing. let me know if work you.
Comments
Post a Comment