March 18, 2011 at 1:44 pm
A sql server and a instance are the same?
March 18, 2011 at 2:22 pm
No. They are different. A server can host one default instance and/or many named instances. A default instance has no instance name and can be accessed without providing a port number or instance name.
Some examples of ways to access a SQL Server instance...there are many more but you get the idea:
Access the local default instance:
.
Access the local default instance:
SERVER_NAME
Access a named instance:
SERVER_NAME\INSTANCE_NAME
Access an instance by server name by its dedicated port number:
SERVER_NAME,PORT_NUMBER
Access a local instance by its dedicated port number:
.,PORT_NUMBER
Access a default instance by IP address:
IP_ADDRESS
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 19, 2011 at 12:39 am
NO
server and instance are not same
one server can have many instance
there are two types of instance
1)default instance
2)named instance
server can have only one default instance and 50 named instances
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply