|
Home > Archive > MS SQL Server > October 2006 > instance name
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| SQLken@gmail.com 2006-10-24, 6:31 pm |
| Hi,
my machine name is webdev5
when I run sql server, it asks for the server name, I enter 'webdev5'
and using windows authentication.
where can I find out about the instance name? on my machine? I am using
2005
thank you
ken
| |
| Arnie Rowland 2006-10-24, 6:31 pm |
| Instance name is most commonly used when there are multiple installations of
SQL Server on the same computer. If you have only one SQL Server, and if you
did not deselect the "Use DEFAULT Instance" option when installing, then
your instance is named 'webdev5'.
Read about Instance and Instance Names in Books Online.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<SQLken@gmail.com> wrote in message
news:1159221843.315654.187670@m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
>
> where can I find out about the instance name? on my machine? I am using
> 2005
>
> thank you
>
> ken
>
| |
| Hari Prasad 2006-10-24, 6:31 pm |
| Hi,
If you are logged into SQL Server Management studio then connect to SQL
server and open a Query window and execute
SELECT @@SERVERNAME
If its a default instance it just returns the machine name. This will be
trated as the SQL Server name. If you have Servername\Instancen
ame;
then you have installed a named SQL Server instance.
You could also get this information from Errorlog of SQL Server. There you
have to look for Server name:.................
Thanks
Hari
SQL Server MVP
<SQLken@gmail.com> wrote in message
news:1159221843.315654.187670@m7g2000cwm.googlegroups.com...
> Hi,
> my machine name is webdev5
> when I run sql server, it asks for the server name, I enter 'webdev5'
> and using windows authentication.
>
> where can I find out about the instance name? on my machine? I am using
> 2005
>
> thank you
>
> ken
>
|
|
|
|
|