Oracle to SQL Server Migration – Step by Step Guide

Why Oracle to SQL Server Migration ?

Oracle and SQL Server are two popular relational database management systems (RDBMS) that are commonly utilized to operate enterprise applications. Oracle has a high price tag, as well as additional charges if you use services such as Oracle enterprise manager or data guard. SQL Server, on the other hand, includes all database capabilities in a single licensing cost, whether it’s the database engine, Reporting Services, or Analysis Services. SQL Server has also proven its reliability and power in handling large data processing loads and running mission-critical corporate applications. For their applications, many clients are now selecting SQL Server over Oracle.

Many customers are looking to save their technological … Read the rest

connectionstring sql server versions supported

Connectionstring sql server versions supported

Microsoft SqlClient Data Provider for connectionstring SQL Server
Standard Security

Server=myServerAddress;Database=DatabaseName;User Id=UserName;Password=Password;
SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008,SQL Server 2005, SQL Server 2000, SQL Server 7.0

Trusted Connection
Server=myServerAddress;Database=DatabaseName;Trusted_Connection=True;

Connection to a SQL Server instance using connectionstring SQL Server

The server/instance name syntax used in the server option is the same for all SQL Server connection strings.

Server=ServerName\InstanceName;Database=DatabaseName;User Id=UserName;Password=Password;
SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008,SQL Server 2005, SQL Server 2000, SQL Server 7.0

Connection to a SQL Server instance using connectionstring SQL Server on a non-standard port

If your SQL Server … Read the rest

How to resolve microsoft ole db provider for sql server error 80004005?

Error Description:

microsoft ole db provider for sql server error 80004005

Open Database Connectivity, or ODBC, is a simple approach to construct dynamic website applications.

Web apps, on the other hand, can fail owing to ODBC database connection issues. They too report an microsoft ole db provider for sql server error 80004005

It can be difficult to figure out what’s causing the ODBC problem.

In this article, we’ll look at the top five causes of ODBC error 80004005.

What is microsoft ole db provider for sql server error 80004005?

The back-end of the great majority of websites on the internet is a database. The user information and linked data are stored in databases on these websites. We frequently utilize the … Read the rest

SQL Server- Unable to connect to SQL Server Error 26

Error Description:

SQL server error 26- Unable to connect to SQL Express Error: 26-Error Locating Server/Instance Specified

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Error Details: this sql server error 26 error locating server instance message is often encountered when connection to a SQL Server is tried and don’t know where to start to solve the problem.

We get this sql server error 26 error message only when we are trying to … Read the rest

SQL Server Error 40 Could not open connection Named Pipes Provider, error: 40

Error Details:

SQL Server Error 40 Could not open connection Named Pipes Provider, error: 40 or sql server error 40 named pipes provider and other forms of error below

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

or

ERROR: (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error:) An error has occurred while establishing a connection to the server. (provider: Named … Read the rest

How to fix the SQL server error 18?

Error Details:

The Error below are the related errors for this error.

SQL server error 18
sql server error 17
sql server error: 772 sql server error: 18
odbc connection failed sqlstate 01000 sql server error 18
connection failed sql server error 18 ssl security error
sql server error 18 dbnetlib ssl security error
sql state 08001 or sql server error 18456
sqlstate: ‘01000’ sql server error 1
odbc sql server driver(dbnetlib)ssl security error
error 08001 odbc sql server driver
sql server ssl security error

How to fix the SQL server error 18?

When users connect to the SQL server due to issues with encryption or TLS version, SQL server error 18 occurs.

We assist our customers with SQL related … Read the rest

SQL Server Error 21 – The operating system returned error 21(The device is not ready)

Error Description:

The operating system returned error 21(The device is not ready) Databases not accessible after restart.  The following error is popped up every time restart Windows operating system is done :

Error 21 was returned by the operating system.(The device is not yet operational.) or
sql server drop database error 21 or
the operating system returned error 21(failed to retrieve text for this error. reason: 15105) or
sql server error: 21, encryption not supported on the client

you will see that running chkdsk /r on the disc and found no bad sectors.
DBCC CHECKDB and you will not found errors.

DBCC CHECKDB discovered 0 allocation and 0 consistency errors in the database

But When you restart SQL Server … Read the rest

SQL Server Error : 132, Severity: 15. The label ‘%.*ls’ has already been decla

SQL Server Error : 132 Details

SQL Server Error: 132 Severity: 15 Event Logged or not: No Description: The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure. Severity 15 Description: Indicates syntax errors in the Transact-SQL command.

Solution:

Make sure the label for variables and tables are unique in a batch or Stored procedure.

Example:

declare one varchar(10)

declare one varchar(40)

SQL Server Error Code and solution summary

SQL Server Error: 132 Severity: 15 Event Logged or not: No Description: The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.

Make sure the label for variables and tables are unique in … Read the rest

SQL Server Error : 229, Severity: 14. The %ls permission was denied on the obj

SQL Server Error : 229 Details

SQL Server Error: 229 Severity: 14 Event Logged or not: No Description: The %ls permission was denied on the object ‘%.*ls’, database ‘%.*ls’, schema ‘%.*ls’. Severity 14 Description: Indicates security-related errors, such as permission denied.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

 

Error 229 in Microsoft SQL … Read the rest