Re: error on conn.open()



ugg helps when i have the ; in the connection string... lol

"M K" <ski_freakREMOVETHECAPS@xxxxxxxxx> wrote in message
news:yVihi.2270$Od7.1620@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I found this...
http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx

and i did not find the "Protocols for MSSQLSERVER" then enable the
protocols you need"
SQL Server 2005 Open SQL Server Configuration Manager. Select "SQL Server
2005 Network Configuration | Protocols for MSSQLSERVER" then enable the
protocols you need.

there was nothing listed under network configuration selection...



"M K" <ski_freakREMOVETHECAPS@xxxxxxxxx> wrote in message
news:3Rihi.2269$Od7.1870@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I got this error and have no clue what to do.

Error code( -2146232060 ) An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure maybe caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: SQL: Network
Intervaces, error:26 - Error Locating Server/Instance Specified))

any suggestions as what exactly to check or change?

Mark






.



Relevant Pages

  • RE: Cant start SQL 2000 after MS Update
    ... I do have the SQLServer icon in the tray, ... A connection could not be established to. ... Please verify SQL Server is running and check your SQL ... >Try running: Net start MSSQLServer ...
    (microsoft.public.sqlserver.security)
  • Re: Problem connection to SQL Server with ODBC
    ... What protocols are being used by the client and what is the ... Are you using an alias for the connection? ... SQL Server Clients May Change Protocols When They Try ...
    (microsoft.public.sqlserver.connect)
  • Re: Trans Replication over VPN
    ... (Source: MSSQLServer, Error number: 1326) ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.replication)
  • Re: error on conn.open()
    ... and i did not find the "Protocols for MSSQLSERVER" then enable the protocols ... SQL Server 2005 Open SQL Server Configuration Manager. ...
    (microsoft.public.dotnet.languages.csharp)
  • ODS
    ... Source: MSSQLServer ... Category: ODS ... connection 'servername' is already in use. ... But my SQL Server are working normally. ...
    (microsoft.public.sqlserver.server)