ssms - How to use a alias name instead of the server name in sql management console -


i want login in mssms different name instead of local server name. can test applications acceptance without changing app.config , web.config.

now can log in localhost\sqlexpress want login f.i.:algsql08-acc\sqlexpress.

i've changed local host file:

127.0.0.1   algsql08-acc 

i've made alias in sql configuration manager (alias name: algsql08-acc , server: localhost)

but i'm still getting same error:

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: sql network interfaces, error: 26 - error locating server/instance specified) (microsoft sql server, error: -1)

i installed dns server , can nslookup of server.

how can this?


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -