Even though I have direct access to the physical database machine, I have to specify
dbmachine\sql in the connection field, rather than just the instance name. Why is that?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Quite simply, client tools need to know explicitly which machine you're trying to connect to. This is like trying to access
For SQL Server you can indicate the local machine in a variety of ways:
This is possibly because you have named instance installed instead or apart from Default instance.
So the default instance looks like
While the named instance in you're case is
Just to add in case you want to understand more of difference between two :
@noxetrox, I would like to say that if you will mention
Definitely you shall get error as per MSDN BOL naming convention rule Here