SQL server instance

  • Thread starter Jens Peter Karlsen [FP MVP]
  • 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.
 
A

Alex White MCDBA MCSE

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.
 
J

jouhayna

During installation or connecting to sql server ... I Am asked about SQL
server instance name ...How can I get it
 
J

jouhayna

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to open multiple instances of Word 365? 5
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Append to SQL Server 3
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Access 2007 and ADP to SQL Server 2005 in Vista 13
Opening 2003 ADP in 2007 fails even with newly defined SQL Serverconnection 12
Troubleshoot connecting client to SQL Server instance on a server 6
Deploying Project Server to machine with existing instance of SQL 1

Top