all groups > sql server connect > march 2006 >
You're in the

sql server connect

group:

No "(local)" server name in servers list for SQL Server 2005


No "(local)" server name in servers list for SQL Server 2005 Michael Freidgeim
3/20/2006 7:07:10 AM
sql server connect: I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server for
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?

If it is a setup problem, how can I add (local) to the list of available
servers?

By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reported
"Sql Server doesn't exist or access is denied"

Michael Freidgeim.
<a href="http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
RE: No "(local)" server name in servers list for SQL Server 2005 Michael Freidgeim
3/20/2006 2:51:20 PM
I was able to fix the problem. ADE Connection "Data Link Properties" accepts
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.

2. Restarted SQL Server service.

--
Michael Freidgeim.
<a href="http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>


[quoted text, click to view]
AddThis Social Bookmark Button