[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied

ok im a CS student, installed visual studio .net, and im trying to connect to a ms sql database (Northwind), but I keep getting a error that "[DBNETLIB][ConnectionOpen(Connect()).] SQLServer does not exist or access denied" in visual studio whenever I try creating a new database connection. How do I know if SQL server is installed on my system? cuz in my systray I see SQL server service manager, is that the same thing as SQL server? or do I need to download the full version or something? also could it be that a certain port on my system is not open that SQL server requires to be open?

Thanks

Ron

The tray icon doesn't mean SQL is running, so use the tray icon to start SQL if it isn't. I do not know if SQL Express uses a tray icon, so i would assume you are using MSDE 2000. You might need to grant the user ASPNET access to the database.

SQL uses Port 1433. DTE services use ports 5000-5020, however I don't think you are using DTE.

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().]SSL Server error

For some reason, I'm no longer able to connect to any database on SQL Server.

If I click on the + sign before a Data Connection in Visual Studio Server Explorer, a Logon dialog opens. Whatever I enter in the dialog results in the following error message:

Connection failed.

Sql State: '0 80001'

Sql Server Error: 18

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().] SSL Server error

Help please.

What version of SQL Server are you using?

Have you tried connecting through some other method, such as using sqlcmd/osql or Management Studio/Query Analyzer?

What errors appear in the server errorlog?

Thanks
Laurentiu

|||

I'm using SQL Server 2000.

I've tried several ways to connect, all unsuccessful.

With Management Studio, I get the following error:

Cannot connect to COMPAC

Additional Information:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error: 0- The token supplied to the function is invalid) (Microsoft SQL Server)

With Query Analyzer

Unable to connect to server COMPAC

Server: Msg 18, level 16, State 1

[Microsoft]]ODBE SQL Server Driver]

[Shared Memory] SSL Security Error

With Enterprise Manager

A connection could not be established to (local)

Reason: SSL Security error

Connection Open (SECDoClientHandshake())

Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the (local) node and try again.

(The Server was running according to SQL Service Manager, and right-clicking said node/properties returned the same error)

Thanks for your consideration.

|||

Is there an error in the server errorlog? Look into MSSQL\Log directory for the latest ERRORLOG files. If there is an error there, please add it to this thread.

I'll move the thread to the data access forum, where someone might be able to help with this issue.

Thanks
Laurentiu

|||

I'm not up on reading the errorlog, so I've posted it at

http://www.e-windowsonline.com/errorlog.html

Thanks again

|||

The errorlogs don′t show anything in this case, the database is started up just fine. Have a look at the articles [1] and [2] at KB. Seems that you are trying to use SSL top connect to the server. Did you make the appropiate settings for SSL ? If you do not want to use SSL you have to disable the enforcement of encryption at the client and server side, otherwise the connection will be refused if not encrypted.

The settgin is stored at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib as of [3].

[1] http://support.microsoft.com/default.aspx?scid=kb;en-us;309398
[2] http://support.microsoft.com/default.aspx?scid=kb;en-us;302409
[3] http://support.microsoft.com/default.aspx?scid=kb;en-us;841695

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

I am moving the thread to the data access forum, because there's no login failure message in the log.

Thanks
Laurentiu

|||

Thanks for your email.

I check the settings at the key referred to and found the following:

ab (Default) REG_SZ (value not set)

ab Protocolorder REG_MULTI_SZ tcp np

and the key contains a folder TDS with:

ab (Default) REG_SZ (value not set)

ab (local) REG_SZ 7.0

ab COMPAC REG_SZ 7.0

Do you see any changes that need to be made?

Thanks

|||

Hi,

It is possilbe that if you enabled client-side 'force encryption' option but the sql server does not support SSL from server-side.

Please open Client Network Utility, (you can run cliconfg.exe from the Run menu). Make sure that 'foce encryption' is not checked.

Thx, -Justin

|||

Mostlikely, this is because your server does not have trusted certificate and client driver is configured to "Force protocol encryption". If you truly need to force encryption, you can take a look at

http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx

Otherwise, you can use cliconfg.exe to turn off "Force protocol encryption". option.

[ConnectionWrite (send()).]General network error

Hi All
I have a visual basic application, which uses SQL Server 2000(sp3a) as
the database, MDAC 2.8 library. I open one connection to the db on the
application start, and the applicaiton works fine for few days, then
suddenly it gives this error [DBNETLIB][ConnectionWrite
(send()).]General network error. -2147467259 .
I tried to close the connection and open again on this error, and I get
this error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
not exist or access denied. -2147467259. If the application is closed
and opened again, it works fine without any problems.
This applicaiton runs on at around 12 different sites.There is no
pattern to when this error
occurs and I really cannot replicate it.
I have checked the SQL server logs, application logs, system logs on
server and client machines, there is nothing useful I could find.
The client running the application, and the server and on the same LAN,
no firewall.
I already posted this message in SQLSERVER.Server group, but didnt get
any help.
Any help is highly appreciated.
Thanksi have seen faulty NICs do weird things. the error simply means the app
can't get to the server. this is definitely _connection_ problem.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150444943.918481.99820@.g10g2000cwb.googlegroups.com...
> Hi All
> I have a visual basic application, which uses SQL Server 2000(sp3a) as
> the database, MDAC 2.8 library. I open one connection to the db on the
> application start, and the applicaiton works fine for few days, then
> suddenly it gives this error [DBNETLIB][ConnectionWrite
> (send()).]General network error. -2147467259 .
> I tried to close the connection and open again on this error, and I get
> this error, [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does
> not exist or access denied. -2147467259. If the application is closed
> and opened again, it works fine without any problems.
> This applicaiton runs on at around 12 different sites.There is no
> pattern to when this error
> occurs and I really cannot replicate it.
> I have checked the SQL server logs, application logs, system logs on
> server and client machines, there is nothing useful I could find.
> The client running the application, and the server and on the same LAN,
> no firewall.
> I already posted this message in SQLSERVER.Server group, but didnt get
> any help.
> Any help is highly appreciated.
> Thanks
>|||oj wrote:
> i have seen faulty NICs do weird things. the error simply means the app
> can't get to the server. this is definitely _connection_ problem.
> --
> -oj
Thanks for ur reply oj., but i certainly do not think this is a case of
faulty NIC's. One or two or three pcs getting this error, i would
understand., but this happens everywhere, but without a pattern.|||would you by any chance using windows authentication? unable to communicate
with the domain controller would cause issue.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150451691.161431.42480@.r2g2000cwb.googlegroups.com...
> oj wrote:
> Thanks for ur reply oj., but i certainly do not think this is a case of
> faulty NIC's. One or two or three pcs getting this error, i would
> understand., but this happens everywhere, but without a pattern.
>|||oj wrote:
> would you by any chance using windows authentication? unable to communicat
e
> with the domain controller would cause issue.
> --
> -oj
>
> <tech.support.b@.gmail.com> wrote in message
> news:1150451691.161431.42480@.r2g2000cwb.googlegroups.com...
No, I am not using Windows authentication, I am using SQL server
authentication. No Domain, its a workgroup. Funny part is, the moment
this error happens, if i kill the application and run the application
again, there is no problem., however, if at the time of the error, I
try to close and re-open the connection, it always fails.|||hmm...what is the value for @.@.max_connections. and @.@.version.
can you ping the server once an error occurs. can you connect via <ip,port>.
-oj
<tech.support.b@.gmail.com> wrote in message
news:1150483296.616430.109960@.h76g2000cwa.googlegroups.com...
> No, I am not using Windows authentication, I am using SQL server
> authentication. No Domain, its a workgroup. Funny part is, the moment
> this error happens, if i kill the application and run the application
> again, there is no problem., however, if at the time of the error, I
> try to close and re-open the connection, it always fails.
>|||oj wrote:
> hmm...what is the value for @.@.max_connections. and @.@.version.
> can you ping the server once an error occurs. can you connect via <ip,port
>.
>
> --
> -oj
>
> <tech.support.b@.gmail.com> wrote in message
> news:1150483296.616430.109960@.h76g2000cwa.googlegroups.com...
@.@.version returns
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: )
@.@.max_connections is 32767
The server is pingable, and other users continue working without any
problems while this problem happens.

[Ask]Getting files from pocket pc emulator to desktop pc

hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ?

thanx b4

Moving this thread to SQL Mobile forum where it has got better chances of being answered.

-Thanks,

Mohit

|||

Yes, you sure can copy this file (e.g. by using file explorer on emulator and network drive on PC). But you can't use it on desktop.

|||Can you tell me what should i do to copy the file, more specifically (step by step) ?
I don't have a plan to use it on desktop, I just want to copy the .sdf file from emulator to desktop, then to the real pocket pc

thanx
|||

Please see this (don't mind it mentions wireless network, work the same way on emulator):

http://pocketpccentral.net/help/browsewlan.htm

[2.0] deploy of a Report Model ?

Hello,

I use a Report Model Project to build a Report Model and I'd like to deploy it on my production server (Win 2003 server).

I can't use Visual Studio to deploy since I don't have web access to the server (only Remote Desktop access)

The command line tool RS seems to work for a simple report (rdlc) but I have a model (smdl)...

Hi

Did you find a solution to this problem?

Cheers

|||

Not sure this is exactly what you arelooking for, I tried this tool and it solved my problem,

Reporting Services Scripter -http://www.sqldbatips.com/showarticle.asp?ID=62

Overview

Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server. Depending on the scripting options chosen, Reporting Services Scripter can also transfer all catalog item properties such as Descriptions, History options, Execution options (including report specific and shared schedules), Subscriptions (normal and data driven) and server side report parameters.