Re: SQL Network Interfaces, error: 26

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

One of my earlier tries was to simply changed Data Source=./SQLExpress to
Data Source=./zz

where zz is the name SQL Server Service Manager shows which is just the
computer name followed by nothing else. Guess that's the way the default
instance is named.

That did not work but when I removed the .\ it worked.

What does the dot stand for?



What if I run the program on another machine? Maybe using just the dot means
use the default instance. I'll try that now to see if it works. Comment?



I also had to remove User Instance=True which I guess is unique to the
Express version. Read the help but still don't know if removing will bite me
later. Think so?



SQL Server Service Manager Studio does not appear in my Taskbar tray when
it's running. Maybe there's an option I have to find for that to happen.

Thanks a lot


"Juan T. Llibre" <nomailreplies@xxxxxxxxxxx> wrote in message
news:uEJb6dN6IHA.1468@xxxxxxxxxxxxxxxxxxxxxxx
re:
!> How do I reference that in the connectionString="Data Source=

Use the same name which the SQL Server Service Manager shows.

You should have an icon for the SQL Server Service Manager in your Taskbar
Tray.
Double click it...and use the exact name it shows.

If the service manager isn't running, run it from
"Start Menu", "Programs", "SQL Server", "Service Manager".





Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"AAaron123" <aaaron123@xxxxxxxxxxxxxx> wrote in message
news:eKw7iPN6IHA.1592@xxxxxxxxxxxxxxxxxxxxxxx

"bruce barker" <nospam@xxxxxxxxxx> wrote in message
news:e$MOpcI6IHA.4352@xxxxxxxxxxxxxxxxxxxxxxx
a mdf file is a detached database. to create one you create a database in
sqlserver, then detach it (via a sql command).

in the connect string you can specify a mdf to auto attach which is
useful for simple sites. you can upload the database then attach on the
first connect.

from a programs point of view there is no difference between sqlexpress
and sqlserver 2005. only the license is different, and the tools
supplied.

to connect to a sqlserver you need to know the server its on and the
instance name. this is specified in the connect string, along with
default database, and an attach command if desired.

if you have sql2005, then run the management studio and browse for
sqlservers. this will list the instance names.



The default instance is unnamed and is shown as the computer name.
How do I reference that in the
connectionString="Data Source=

thanks for staying with me




read the docs on sqlserver connect strings

This helped using management studio


-- bruce (sqlwork.com)



AAaron123 wrote:
I'll ask you the same questions I asked Michael Nemtsev.

I find two such strings as shown below.

I see now that who ever wrote this assumed it would be used with the
Express version.
How do I change it to point to the SQL Server2005?


Also, I do see the file Personal.mdf in the solution list of file
names.
But I do not see the file aspnetdb.mdf there. Do you thing the program
might create it when it runs?

Finally, the error message mentioned SQL2005 as if it converted from
the Express to 2005 since that is what it found. If that's the case why
didn't it make the connection?

Very confusing!

Thanks for the help

"bruce barker" <brucebarker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A494C34-B560-45BC-B9E2-4D6378505776@xxxxxxxxxxxxxxxx
the error means the sqlserver specified in the connection string was
not
found. if you had both sqlserver 2005 & 2008, the 2008 is probably not
the
default instance. either specify the instance, or create a new default
instance (reinstall sqlserver 2008)

-- bruce (sqlwork.com)


"AAaron123" wrote:

I downloaded the personal website starter kit and when I run it I get
the
error shown below.
I found a way of using Launch Surface Area Configuration that is
supposed
to fix the remote setting but I tried it and still get the error.

I do not have SQL Server 2005 installed (thought I did once). I do
have SQL
Server 2008 installed.

I don't see anywhere in the code where SQL Server 2005 is referenced.

Don't I have to tell in the code that I want to use SQL Server 2008?
Suppose I hade both on my machine?

Do I have some registry entry that did not get up dated from the 2005
to the
2008 versions?

Thanks for any help.



An error has occurred while establishing a connection to the server.
When
connecting to SQL Server 2005, this failure may be caused by the fact
that
under the default settings SQL Server does not allow remote
connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified)
Description: An unhandled exception occurred during the execution of
the
current web request. Please review the stack trace for more
information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An error has
occurred
while establishing a connection to the server. When connecting to
SQL
Server 2005, this failure may be caused by the fact that under the
default
settings SQL Server does not allow remote connections. (provider: SQL
Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)

Source Error:

Line 194: Using command As New SqlCommand("GetNonEmptyAlbums",
connection)
Line 195: command.CommandType = CommandType.StoredProcedure
Line 196: connection.Open()
Line 197: Dim list As New Generic.List(Of Album)()
Line 198: Using reader As SqlDataReader = command.ExecuteReader

Source File: I:\MyDocuments\Visual Studio
2008\WebSites\PersonalWebSite1\App_Code\PhotoManager.vb Line: 196










.

Relevant Pages

  • Re: Error 80070006
    ... Looking for a SQL Server replication book? ... > it down using the sql server service manager or the windows tasks control ... > process panel. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Who is using MSMQ?
    ... To add on to the other responses, the MSMQ warning messages you get from the ... SQL Server Service Manager are the same ones you get from the Windows MMC ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot connect to database
    ... I Think the problem might be that the SQL server is not configured, because when I open the SQL Server Service Manager the fields with server and services are empty. ... then another window pop's up: and saids: the following applications should be closed before continuoing the installation: SQL Server Service Manager and Microsoft sync centre. ...
    (microsoft.public.windowsxp.embedded)
  • Starting up the SQL server on SBS 2003
    ... I see the SQL Server Service manager icon on the task bar. ... which i presume is the name of the sbs server and once i enter that in the ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Service Manager
    ... I have run FP2003 with that icon in the taskbar, and the SQL Server ... In the process it installed an SQL Server Service Manager. ...
    (microsoft.public.frontpage.programming)