Prev: To Shrink or Not to Shrink?
Next: sys.dm_db_index_operational_stats
From: Erland Sommarskog on 4 May 2010 18:10
coltrane (tendengarci(a)yahoo.com) writes:
> No, even if I type in the machine name an instance name, i.e.
> COLTRANE\MSSQLSERVER, I still cannot connect to the server

You should only specify COLTRANE. MSSQLSERVER is the default instance
that you access without instance name.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: coltrane on 4 May 2010 18:21
On 5/4/2010 6:10 PM, Erland Sommarskog wrote:
> coltrane (tendengarci(a)yahoo.com) writes:
>> No, even if I type in the machine name an instance name, i.e.
>> COLTRANE\MSSQLSERVER, I still cannot connect to the server
>
> You should only specify COLTRANE. MSSQLSERVER is the default instance
> that you access without instance name.
>
>
thanks but still no cigar. The reason I tried coltrane\mssqlserver is
that I can make a connection to sqlexpress and that is displayed as
coltrane\sqlexpress.

thanks again

john
From: coltrane on 4 May 2010 18:25
On 5/4/2010 4:59 PM, coltrane wrote:
> On 5/4/2010 4:29 PM, John Bell wrote:
>> On Tue, 04 May 2010 15:29:34 -0400, coltrane<tendengarci(a)yahoo.com>
>> wrote:
>>
>>> On 5/4/2010 2:54 PM, John Bell wrote:
>>>> On Tue, 04 May 2010 12:16:39 -0400, coltrane<tendengarci(a)yahoo.com>
>>>> wrote:
>>>>
>>>>> I have sqlserver 2008 installed. I am creating a program in
>>>>> visualstudio
>>>>> 2008, although I have the same problem in VS 2010.
>>>>> When I try to create a connection to the sqlserver the server
>>>>> connection
>>>>> is not listed. Are there any tricks I need to do?
>>>>>
>>>>> thanks for the help
>>>>>
>>>>> john
>>>>
>>>>
>>>> Hi John
>>>>
>>>> The browaser service is probably not running. If you start it and do a
>>>> refresh the instances available should appear in the drop down list.
>>>>
>>>> John
>>> Me again,
>>> I went into the services mmc app and manually started the browser. Now I
>>> can select SQLExpress but I cannot see the the MSSQLSERVER instance.
>>> Well at least I am getting closer.
>>>
>>> john
>>
>> Hi
>>
>> The browser service will read the registry to find out what services
>> are available, so both services should appear.I assume that you can
>> type in the machine name and connect to it?
>>
>> John
> No, even if I type in the machine name an instance name, i.e.
> COLTRANE\MSSQLSERVER, I still cannot connect to the server
>
> argh!
well at least I have made a little headway. I was able to connect to
coltrane with visual studio 2010. I read that there is a problem with
visual studio 2008 but that applying sp1 should fix the problem. I guess
I should continue my work with VS 2010 and call it a day.

thanks again for your help

john
From: John Bell on 5 May 2010 04:24
On Tue, 04 May 2010 18:21:58 -0400, coltrane <tendengarci(a)yahoo.com>
wrote:

>On 5/4/2010 6:10 PM, Erland Sommarskog wrote:
>> coltrane (tendengarci(a)yahoo.com) writes:
>>> No, even if I type in the machine name an instance name, i.e.
>>> COLTRANE\MSSQLSERVER, I still cannot connect to the server
>>
>> You should only specify COLTRANE. MSSQLSERVER is the default instance
>> that you access without instance name.
>>
>>
>thanks but still no cigar. The reason I tried coltrane\mssqlserver is
>that I can make a connection to sqlexpress and that is displayed as
>coltrane\sqlexpress.
>
>thanks again
>
>john

SQLExpress will always be a named instance, but MSSQLSERVER is the
default instance and you should be able to connect to it with the
machine name, (local) or a period symbol .

If you know the instance name it is usually quicker to type it in
rather than using the browse/refresh option.

John
First  |  Prev  | 
Pages: 1 2 3
Prev: To Shrink or Not to Shrink?
Next: sys.dm_db_index_operational_stats