Re: can't login to sql after i've installed a self made certificat

Hi,

I am experiencing the exact same issue. MS SQL was working fine previously.
After installing a new self signed certificate using SelfSSL for an IIS
website. I am no longer able to use the SQL 2005 Management Studio to connect
to the server.

Any suggestions would be very helpful.

Regards,

"William Vaughn (MVP)" wrote:

Ah, I expect that the two are unrelated--especially since you're apparently
trying a local connection. Let's see your connection string.
Have you checked out the whitepaper on connecting on my blog? See
www.betav.com/blog/billva.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



"Roberto" <Roberto@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8BDF1F83-8CE1-405B-A541-B8FB394FAC52@xxxxxxxxxxxxxxxx
hello,
i've made a self signed ssl certificate with selfcert, but now i
can'tlogin
into sql server: i get this error:


The connection with the server was set correctly, but then there was an
error during the handshake pre-login. (provider: Provider shared memory,
error: 0 - No other process on the other end of pipe.) (Microsoft SQL
Server,
Error: 233)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

I've tryed almost everyting but have found no solution:
i disabled via protocol
checked if remote conn was enabled
selected trust certificate (in sq lconfiguration manager)
removed my certificate
uninstalled selfcert
and so on


.

Relevant Pages

  • Re: SQL Resets
    ... If it were SQL that was falling short, ... The default backlog for SQL Server is 5. ... System.InvalidOperationException: Internal connection fatal error. ... From time to time, under heavy loads, we are getting resets at ...
    (microsoft.public.sqlserver.connect)
  • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (microsoft.public.sqlserver.connect)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • .Net framework error
    ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Web Synchronization over HTTPS fails
    ... about the certificate, so you have to focus your attention here. ... Looking for a SQL Server replication book? ... "Hilary Cotter" skrev: ... So it seems like the connection from the device into IIS works fine. ...
    (microsoft.public.sqlserver.replication)
Quantcast