No announcements
Found 668 threads
-
0 Votes
Resource Based Kerberos constrained delegation for cluster for SQL Server
Hi All, To solve the Double HOP issue we are taking Kerberos Constrained Delegation route and we were able to get it working for non windows ...Unanswered | 5 Replies | 2585 Views | Created by BTLearner2016 - Friday, February 7, 2020 8:52 PM | Last reply by MIAOYUXI - Friday, February 14, 2020 8:57 AM -
0 Votes
Server Error in '/' Application. (Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. )
Line 712: myCommand.CommandType = CommandType.StoredProcedure; Line 713: ...Answered | 3 Replies | 2482 Views | Created by mgines3 - Wednesday, February 5, 2020 11:47 AM | Last reply by Amelia Gu - Thursday, February 6, 2020 7:12 AM -
0 Votes
SQL Server Linked Server to DB2 using ODBC
I have a linked server connection to a DB2 server configured using an ODBC connection. Is there a way to pass through a user's AD security to DB2? Since the ODBC connection is configured to pass a ...Unanswered | 2 Replies | 1824 Views | Created by OriginalMusician - Friday, January 17, 2020 3:31 AM | Last reply by OriginalMusician - Tuesday, January 21, 2020 11:04 PM -
0 Votes
Sending message/notification to client that order has arrived in sql server table
have a legacy order system where a c++ program was written to send a message to the client to indicate an order had arrived by making a sound on the client (ding!). this was implemented as a trigger ...Answered | 5 Replies | 2120 Views | Created by Abeljdang - Wednesday, January 8, 2020 3:53 PM | Last reply by Cris Zhan - Monday, January 13, 2020 1:42 AM -
2 Votes
In our enviroment Sqll server running Slow & Also query running slow
hi, In our environment Sql server running Slow & Also query running slow.IT is performance issues., How to handle these think ...Unanswered | 3 Replies | 1785 Views | Created by ajit kumar1991 - Wednesday, January 8, 2020 5:20 AM | Last reply by Dawn Young - Friday, January 10, 2020 6:58 AM -
1 Votes
How to Compare two nvarchar datatype values?
Hi All, This is sriram.I need help from you.In one of my stored procedure I have to compare two nvarchar datatype values.The values containing both numerical and ...Answered | 2 Replies | 32896 Views | Created by SriramJitendra - Wednesday, December 1, 2010 5:58 AM | Last reply by DhanuSurya - Wednesday, December 25, 2019 9:45 PM -
0 Votes
We are trying to shrink a single database in SQL server 2008r2 , which is giving error due to insufficient space.
Hello there, We are trying to shrink a single database in SQL server 2008r2 without affecting any existing database. We are unable to shrink it as it ...Proposed | 2 Replies | 2064 Views | Created by Isak Z - Wednesday, December 11, 2019 7:03 AM | Last reply by Cathy Ji - Thursday, December 12, 2019 6:32 AM -
1 Votes
Licenses SQL Express and IIS-7
Hello, I like to have professional advice how to deal with licenses. Let me explain our future plan. We want to install a Windows 2019 server with SQL Express and ...Answered | 3 Replies | 2275 Views | Created by servicesbyone - Thursday, December 5, 2019 4:33 AM | Last reply by Cathy Ji - Friday, December 6, 2019 1:27 AM -
0 Votes
Real Time synchronisation of Remote server and client sever MS SQL database
Hii, Can anyone help me out, how to synchronise sql database available on server with the local database ? The database should get update in real time ...Proposed | 8 Replies | 2092 Views | Created by Sandeep_Gupta2210 - Monday, November 25, 2019 1:51 PM | Last reply by Dedmon Dai - Tuesday, November 26, 2019 7:13 AM -
1 Votes
Can't install Dabase Engine or SQL Server Replication
I received error code 1639.See the below screenshot. I tried to rerun the installation manager as ...Unanswered | 7 Replies | 2771 Views | Created by Kingsql - Wednesday, November 20, 2019 10:26 PM | Last reply by Cris Zhan - Monday, November 25, 2019 8:11 AM -
0 Votes
Severity: 16 Error:258, OS: 258 [Microsoft][SQL Server Native Client 11.0]Shared Memory Provider: Timeout error [258].
SQL 2012 crashed with following error: The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on ...Unanswered | 1 Replies | 2931 Views | Created by PascalJC - Friday, October 11, 2019 7:02 PM | Last reply by Cathy Ji - Monday, October 14, 2019 3:49 AM -
0 Votes
can we deploy SmartConnect database to a client that only has SQL Runtime license ?
can we deploy SmartConnect database to a client that only has SQL Runtime license ?Proposed | 1 Replies | 2081 Views | Created by Jignesh Khatri - Thursday, October 3, 2019 6:41 PM | Last reply by Dedmon Dai - Friday, October 4, 2019 5:46 AM -
0 Votes
SQL Server Configuration Manager
Hi, Thanks in advance, If anyone can help on this error! Tried almost solutions ...Proposed | 2 Replies | 2485 Views | Created by Moses Sebastian - Saturday, September 7, 2019 8:37 AM | Last reply by Dedmon Dai - Monday, September 9, 2019 7:56 AM -
0 Votes
Connection Timeout Pre Login-Handshake
Hi, We are running an ASP.Net MVC 5 application (Net Framework 4.5.2) ...Answered | 9 Replies | 7557 Views | Created by BreninMike - Tuesday, June 4, 2019 6:39 PM | Last reply by Peter Kandra - Wednesday, August 28, 2019 10:05 PM -
0 Votes
Newest Version Of SSMS Missing Feature
Database -> [Database Name] -> Connections -> right-click on connector name -> Refresh Credentials. This would prompt me for my Microsoft credentials and allow me to enter in my ...Proposed | 3 Replies | 2453 Views | Created by JVEGAFL - Wednesday, August 7, 2019 2:24 PM | Last reply by Cathy Ji - Monday, August 12, 2019 8:31 AM -
0 Votes
SQL Server 2014 - Ring Buffer Connectivity Errors - Error code - 17830
Hi Team, We use SQL Server 2014 at client location and we are having a series of performance issues reported with respect to our application, when everything looks fine in ...Unanswered | 1 Replies | 4557 Views | Created by Shailashreev - Friday, August 9, 2019 3:33 AM | Last reply by Cathy Ji - Monday, August 12, 2019 8:06 AM -
0 Votes
SQL Server License usage
I'm planning to buy a core license for SQL Server 2016 Standard edition. My scenario is, I can install SQL server in centralized VM Server. 1.How many users can ...Answered | 4 Replies | 2707 Views | Created by Rakesh Ponnala - Friday, June 21, 2019 10:18 AM | Last reply by Cathy Ji - Monday, June 24, 2019 2:22 AM -
0 Votes
SQL server management Studio | The client and server cannot communicate, because they do not possess a common algorithm
Hello, I have SQL server 2016 sp2 operating under windows server 2012 r2 and i need to create linked server on another instance (SQL server 2008 SP4) operating under windows server ...Unanswered | 3 Replies | 4784 Views | Created by EL-ABD - Sunday, June 16, 2019 10:57 AM | Last reply by Dedmon Dai - Thursday, June 20, 2019 8:53 AM -
0 Votes
Not able to get OracleOLEDB provider in MS SQL linked server
I am trying to link Oracle server in MS SQL Server. I have already installed Oracle Client in my machine. But, nothing will display OracleOLEDB Provider in my MS SQL ...Answered | 2 Replies | 2495 Views | Created by Gani tpt - Wednesday, June 19, 2019 9:49 AM | Last reply by Gani tpt - Wednesday, June 19, 2019 1:12 PM -
0 Votes
Error occured during DB Disk Latency data source executing
HI we have application running in the SQL server 2012 and base OS windows server 2008 R2 Ent and its clustered. i am getting the below error in Health ...Proposed | 7 Replies | 2925 Views | Created by Ansar.Ali - Wednesday, June 12, 2019 6:24 AM | Last reply by Dedmon Dai - Friday, June 14, 2019 9:19 AM
No announcements