January 15, 2011 at 12:22 pm
Hey all,
I recently installed 2008 R2 (had 2008 before). There are a number of SQL instances at the company that I work for, and most are referred to simply as the server name (e.g. if the computer name is compsql, you would just put comp1 in the connect to server field.
On my computer, however, I have to put comp1\[sql instance name]. This is tedious, and it makes it difficult to tell people how to connect to my SQL instance. What's more, I have seen SQL installed on other computers in the same way I did on mine, and the user is able to connect using the server name without a problem.
As such, I was disappointed to discover after naming my instance that the naming convention still defaulted to [server name]\[sql instance name]. I considered the possibility that a default installation would permit this, but I seem to remember (perhaps incorrectly) that you can name the SQL instance and still use the server name to connect.
Before I re-install SQL, I'd like some clarification on this. I tried researching for past threads on the topic, and some did come up, but they didn't seem to address my particular question. How do I install SQL such that it will allow me to connect using just the server name? I would greatly appreciate any advice anyone can give.
January 15, 2011 at 12:32 pm
Hey again,
After reading further, it seems that installing SQL as a default instance will allow me to reference it using just the server name. Sorry for the basic question. 🙂
January 15, 2011 at 12:32 pm
OP answered own question while I was typing! Answer removed.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);January 15, 2011 at 2:26 pm
cjohn5552 (1/15/2011)
Hey all,I recently installed 2008 R2 (had 2008 before). There are a number of SQL instances at the company that I work for, and most are referred to simply as the server name (e.g. if the computer name is compsql, you would just put comp1 in the connect to server field.
On my computer, however, I have to put comp1\[sql instance name]. This is tedious, and it makes it difficult to tell people how to connect to my SQL instance. What's more, I have seen SQL installed on other computers in the same way I did on mine, and the user is able to connect using the server name without a problem.
As such, I was disappointed to discover after naming my instance that the naming convention still defaulted to [server name]\[sql instance name]. I considered the possibility that a default installation would permit this, but I seem to remember (perhaps incorrectly) that you can name the SQL instance and still use the server name to connect.
Before I re-install SQL, I'd like some clarification on this. I tried researching for past threads on the topic, and some did come up, but they didn't seem to address my particular question. How do I install SQL such that it will allow me to connect using just the server name? I would greatly appreciate any advice anyone can give.
use a TCP\IP alias for the named SQL Server instance 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply