SQLSERVER 2005

S

Steve Taylor

I am setting up SQL SERVER 2005 on a local machine to test upsizing of
databases etc, but I cannot connect to the SQL SERVER or work out what the
SERVER name is or how to create one. Help file says call the server "(local)"
for connecting on a local machine but this server is not found either.
 
S

Sylvain Lafontaine

If this is the first installation of a SQL-Server on your machine (no other
SQL-Server 2000, MSDE, etc.) and if you have chosen the default installation
without choosing a name for it, then its name is (local) or the name of your
machine (both can be used) or tcp:127.0.0.1 (if the TCP/IP protocol has been
activated.

However, if this is a named instance, then you must access it by adding the
name of the instance after the name of the machine:

(local)\SQLExpress

in the case of an instance with the name SQLExpress. The best way is to
open the SQL Server Configuration Manager, make sure that the service is
started and use its instance name (this name should be displayed in
parenthesis). The following references will give you a lot of information
on that topic, not only for your local machine but also for remote machines:

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
 
S

Steve Taylor

Dear Sylvain

Many thanks for the help - it is the first time SQL SERVER has been loaded
on the machine and I have used defaults on installation. Your suggestion of
"(local)\SQLExpress " works where I substitute the name of the machine for
"(local)", but not when I use "local" alone. The help file suggest that
"local" by itself will conect to the server, but this does not work still. I
dont mind now howeveras you have now supplied an alternative, and the
important thing is that it works.
Rgds
Stephen
 
Top