April 10, 2012 at 1:14 am
Hi,
I have a database server installed with MSSQL Server 2008 (R1) on a non-standard port. On our client machines, we use SQL Server Configuration Manager tool to create SQL Server Alias. So when connecting from client using Management Studio, we don't have to specify the non-standard port number. All our client machines have got the client version of Microsoft SQL Server 2008 (R1) installed. This setup works well from Windows XP and Vista clients.
Recently, we have added a new client machine that runs on Windows 7. It is installed with the client version of Microsoft SQL Server 2008 R2. We have similarly created SQL Server Alias on the new client machine. Unfortunately, the Alias does not seem to be recognized as the client is not able to connect to the SQL Server using Management Studio. On the other hand, if we specify the port number along with the server name (as in <server>,<portno>), the connection is successful.
Does anybody know what could be the problem and how to resolve it?
Any help will be much appreciated. Thanks!
April 10, 2012 at 4:35 am
Is the SQL Browser service running?
April 10, 2012 at 8:15 pm
Hi,
No, the SQL Browser service is not running.
By the way, I have found out the cause. It is because the SQL2008 client that is installed on the Windows 7 machine is 32-bit. And the SQL Server ALIAS we have created is for 64-bit, so it is not recognised. Once we create the same ALIAS for 32-bit, the connection problem is resolved.
Thanks to everyone who have contributed their time to read this and offer their help.
April 11, 2012 at 6:38 am
Glad you found the solution.
Although as an aside, enabling the SQL Browser service on the server should mean you don't need to create the aliases on your client machines.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply