Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of Daeta42
Daeta42🇺🇸

Cannot connect to SQL Database
Greetings-
     We are running Microsoft RMS for our Point of Sale system.  We have 3 locations and 2 are working just fine.  The mail site I cannot get RMS to access the database.  Things just started to happen like this last week.  I've been trying to research the error messages but I am getting so many conflicting potential answers to the problem and have tried so many things I am afraid to move to much more forward because I might break something completely...

When I go to open the "Store Operations Manager" I get this error message first.
______________________________________________________________________
Error # 3709
Requested operation requires an OLE DB session object, which is not supported by the current provider.
(Source: ADODB.Command)
Update TimeCard
SET TimeOut = GetDate (), Hours = DateDiff(mi, TimeIn, GetDate()) /60.0
Where ID = ?
 User generated image______________________________________________________________________

I click OK and then I get this:
_______________________________________________________________________
Run-time error '3709':
Requested operation requires an OLE DB session object, which is not supported by the current provider..
 User generated image_____________________________________________________________________________

When I got to open the "Store Operations Administrator".  I get prompted to login as if I was logging into a SQL Database.  I type in the "SA" password and it thinks and then gives me this error.
_________________________________________________________________________
SSL Security error
ConnectionOpen (SECdClientHandshake())
 User generated image_______________________________________________________________________

I click OK and it puts me back to the login screen,  As seen in the screen shot above.

I am totally lost...  Please help...!

Thanks!

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of LowfatspreadLowfatspread🇬🇧

so what has changed in this environment?

what software has been upgraded recently?

Avatar of Daeta42Daeta42🇺🇸

ASKER

Nothing...  I mean nothing...  Everything's been the same for weeks...  

Do you always use the sa account?

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of Daeta42Daeta42🇺🇸

ASKER

the way that it was setup it was always like that when I took over.  I tried my account and it didn't work.  I was about to just add myself to all the security groups that say "allow access to SQL something"......

Then try and access it...  Other then that can't think of much else I didn't already do...

Avatar of Daeta42Daeta42🇺🇸

ASKER

I tried Winblows auth and I got this error...  And I am on the server.  SBS2003...  Where everything is...

Avatar of Daeta42Daeta42🇺🇸

ASKER

I meant to continue... I got this error.... User generated image

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of honmapoghonmapog🇮🇪

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of Daeta42Daeta42🇺🇸

ASKER

The SQL was all jacked up.  There were 8 instances of SQL running on the box I found.  35 databases...  Most 90% doing nothing.  I got on the phone with good old Microsoft tech support and it took them 5 days of grueling at it and escalating my ticket to someone who went in and deleted everything SQL related.  Every Certificate, cleaned the machine up nice...  IT did eventually come down to just a SSL cert.  But what a ride of a bunch of screwed up databases and configuration to get there...
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.