SQL server instance

  • Thread starter Thread starter Jens Peter Karlsen [FP MVP]
  • Start date Start date
J

Jens Peter Karlsen [FP MVP]

Set it to whatever you want (only alphanumeric characters allowed, must
start with alphabetic character) or leave it blank. if you have more
than one instance of a SQL Server running, you can't leave it blank.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
your instance name will be nothing unless you have specified one, and then
it is only worth doing because you have multiple copies of SQL installed.

if you are installing SQL and don't know about this option, you should not
be doing an advanced installation it will cause you problems messing with
these options just do a standard install.

if you are trying to connect to a SQL install on the same computer that you
are running access you can use (local) as the server name including the
brackets.

if you really do need to specify an instance name then the format is

is1\myinstance is1 being your server name and myinstance bang your
instance name,

check the services to make sure the SQL server service is running for that
instance.
 
During installation or connecting to sql server ... I Am asked about SQL
server instance name ...How can I get it
 
thank you alex ..get it
Alex White MCDBA MCSE said:
your instance name will be nothing unless you have specified one, and then
it is only worth doing because you have multiple copies of SQL installed.

if you are installing SQL and don't know about this option, you should not
be doing an advanced installation it will cause you problems messing with
these options just do a standard install.

if you are trying to connect to a SQL install on the same computer that
you are running access you can use (local) as the server name including
the brackets.

if you really do need to specify an instance name then the format is

is1\myinstance is1 being your server name and myinstance bang your
instance name,

check the services to make sure the SQL server service is running for that
instance.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk
Click to expand...
 
Back
Top