How to setup a connection to MS SQL without /InstanceName in the address?
772
How can I setup my SQL server to allow connections without having to type in the instance name? For example in the picture nelow, I'd like to connect without /SQLEXPRESS in the server name.
If on the client side you are using the SQL Server native client you can look at using an alias (http://technet.microsoft.com/en-us/library/ms190445.aspx). This would have to be setup for each client connecting to that instance.
Alternatively as pauska mentioned, you would have to install this instance as a default instance.
Install MSSQL without using a named instance.
If on the client side you are using the SQL Server native client you can look at using an alias (http://technet.microsoft.com/en-us/library/ms190445.aspx). This would have to be setup for each client connecting to that instance.
Alternatively as pauska mentioned, you would have to install this instance as a default instance.