SQL Server “.” Alias Not Working

问题:

I've added an alias of "." which should point to my local (named) instance, ".\SQL2008". But when I try to connect to ".", it times out.

Am I missing something or is this not allowed?

Aliases I've tried which do not work:

(Set for both 32 and 64-bit, I've also tried leaving the port blank.)

回答1:

If you are creating TCP/IP aliases you need to ensure the "SQL Server Browser" service is running. As well as checking the TCP/IP protocol is enabled for both server and client.

In Sql Server configuration Manager under the SQL Server Services node right click the SQL Server Browser and set the Start Mode to Automatic. If you are not going to do a reboot you will also need to Start the service manually.

The SQL Server Browser service is responsible for telling the client which port to use. See http://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx for more details.

回答2:

There is no limitation preventing that alias name. At leas it works on my machine ;)

However, when setting up the alias make sure you create it in the 32 as well as the 64 bit area:

I did also spell out localhost instead of just using the .:

Also, a SQL Server Alias always uses TCP/IP as connection protocol, which is not enabled by default. Under SQL Server Network Configuration (see above screen shot) check that TCP/IP is enabled for your instance.

回答3:

In your Alias definition remove the .\ from the Server box leaving just your instance name, that works on my machine. So in your case the dialog should look like this:

回答4:

you need to run "cliconfg" and setup the alias on your local machine as well. If you have SSMS installed, create the alias in SQL Config Mgr, as this take precedance over the ones set in cliconfg. Remember, SSMS uses 32bit connection to SQL Server, even if is 64bit. If you don't set them locally, how does your PC know where to go for the alias. You could create DNS entries as an alternative.

回答5:

I have a similar issue ,however on SQL server I did create alias on 32bit and 64 bit.I did the same thing on Sharepoint server using CliConfg. In short, for 64 bits Windows operating systems run: C:\windows\syswow64\cliconfg.exe For 32 bits Windows operating systems run: C:\windows\system32\cliconfg.exe on all server which you need to access to your database. Please see great article below. https://knowledge.zomers.eu/SharePoint/Pages/How-to-create-a-SQL-Alias-to-use-with-SharePoint.aspx

回答6:

It was not working for me after applied all the options mentioned here. For me, port number to TCP/IP protocol was not assign.

After assigning (highlighted in yellow color) it started working for me.

回答7:

Also make sure the selected protocol for alias (e.g. TCP/IP) is enabled under SQL Server Network Configuration / Protocols for YOUR SERVER NAME

This was the issue in my case.