<div>
Hi,<br />
<br />
I don't find anything wrong there. Please give some more details what's wrong. You are successfully connected to the SQL Server instance, you can see restored database. Nothing unusual there. If you're worried by these XTP messages, please don't. There is a connect item registered for this by Robert L. Davis : 
<pre><code class="code-1 nolinks" id="code-20-42373663-1"><span>https://connect.microsoft.com/SQLServer/feedback/details/2876739/excessive-non-usable-messages-in-sql-log-when-running-checkdb-in-sql-server-2016</span>
</code></pre>
</div>


<div>
Hi Daniel_PL. &nbsp;Thanks for the info. &nbsp;My concern is when I look in the existing (old server) I can see items in the network config that the Office Tools FAQ points out. &nbsp;I do not see these items in the new SQL server.<br />
<br />
Depending on your network settings, you many have to add an exception to the firewall on your sever for the Dynamic Port associated to your SQL installation. The SQL dynamic port can be located in: Start&gt; Programs&gt; Microsoft SQL Server 2012&gt; Configuration Tools&gt; SQL Server Configuration Manager.<br />
<br />
Expand “SQL Server Network Configuration (32bit)” and select “Protocols for NORTH40SYSTEMS”. Double click TCP/IP, &nbsp;on the IP Addresses tab scroll all the way to the bottom and the TCP Dynamic Port is displayed in there. If you need assistance making an exception for this port in your fire wall contact our support team at (661) 794-2220 or support@officetools.com.<br />
<br />
<a href="https://www.officetools.com/knowledgebase/server-installation/" rel="ugc">Office Tools server install link</a>
</div>


<div>
New SQL Server uses default static TCP 1433 port, because it is a default instance (instance name is MSSQLSERVER). From Office Tools server, or wherever you're running your app, test whether port is open. Either by using telnet &lt;srver address&gt; 1433 or by using port query tool (provided by Microsoft).<br />

<pre><code class="code-1 nolinks" id="code-20-42373714-1"><span>https://www.microsoft.com/en-us/download/details.aspx?id=24009</span>
</code></pre>
<br />
The installation guide you provided is pointing new instance of SQL Server Express. As far as I understand you have your own licensed SQL Server Standard edition with restored database. You should config your software for this server. I'm not sure about this app modules but it seems database is being choosen in Workstation component:<br />

<pre><code class="code-1 nolinks" id="code-20-42373714-2"><span>https://www.officetools.com/knowledgebase/workstation-installation/</span>
</code></pre>
<br />
Regards,<br />
Daniel
</div>


<div>
I also don't see anything wrong. You have only a single SQL Server instance installed in that machine (PDC01), right?
</div>


<div>
Thanks for the comments. &nbsp;The server name is &quot;PDC01&quot;. &nbsp;I used the port query tool from a client PC and 1433 is listening. &nbsp;My concern is the clients can't connect to the office tools database. &nbsp;I am attaching a screenshot. &nbsp;The Office Tools client requires the following path &quot;PDC01\NORTH40SYSTEMS&quot;.
</div>


<div>
You need to install your SQL Server as named instance, or just reconfigure your Office Tools client to point it to PDC01 SQL Server.
</div>


<div>
Here is the screen shot<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211615/SQL-port-screen-shot.JPG" target="_blank" class="file-inline" title="SQL-port-screen-shot.JPG (207 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SQL-port-screen-shot.JPG</a>
</div>


SQL-port-screen-shot.JPG

<div>
Cut <i>\NORTH40SYSTEMS</i> from server name, leave PDC01.
</div>


<div>
I tried that and same results. &nbsp;Attach<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211617/Sql-screen-shot.jpg" target="_blank" title="Sql-screen-shot.jpg (1.7 MB)"><img alt="Sql-screen-shot.jpg" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w47/800_1211617/Sql-screen-shot.jpg" /></a>ed is the screenshot of Office tools instructions.
</div>


Sql-screen-shot.jpg

<div>
Is there a way I can see / browse the SQL instances running on the server from a client PC?
</div>


<div>
You need to enter just <b>PDC01</b> into server name, nothing else.
</div>


<div>
Thanks, I tried that too and still the same results. &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211618/SQL-Capture.JPG" target="_blank" title="SQL-Capture.JPG (80 KB)"><img alt="SQL-Capture.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w47/800_1211618/SQL-Capture.JPG" /></a>
</div>


SQL-Capture.JPG

<div>
Uncheck <i>Use IP Address</i>, test, if failed go to the SQL Server and check logs fo any errors.<br />
<br />
Look here for example:<br />

<pre><code class="code-1 nolinks" id="code-20-42374278-1"><span>https://www.officetools.com/knowledgebase/workstation-installation/</span>
</code></pre>
</div>


<div>
This error is new. &nbsp;I was not seeing this Friday when I restored the database.<br />
<br />
Service: Instance Found <br />
Error: System.Data.SqlClient.SqlE<wbr />xception (0x80131904): 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)<br />
&nbsp; &nbsp;at System.Data.SqlClient.SqlI<wbr />nternalCon<wbr />nectionTds<wbr />..ctor(DbC<wbr />onnectionP<wbr />oolIdentit<wbr />y identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandlin<wbr />g)<br />
&nbsp; &nbsp;at System.Data.SqlClient.SqlC<wbr />onnectionF<wbr />actory.Cre<wbr />ateConnect<wbr />ion(DbConn<wbr />ectionOpti<wbr />ons options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nFactory.C<wbr />reatePoole<wbr />dConnectio<wbr />n(DbConnec<wbr />tionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nPool.Crea<wbr />teObject(D<wbr />bConnectio<wbr />n owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nPool.User<wbr />CreateRequ<wbr />est(DbConn<wbr />ection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nPool.TryG<wbr />etConnecti<wbr />on(DbConne<wbr />ction owningObject, UInt32 waitForMultipleObjectsTime<wbr />out, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nPool.TryG<wbr />etConnecti<wbr />on(DbConne<wbr />ction owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nFactory.T<wbr />ryGetConne<wbr />ction(DbCo<wbr />nnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nInternal.<wbr />TryOpenCon<wbr />nectionInt<wbr />ernal(DbCo<wbr />nnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)<br />
&nbsp; &nbsp;at System.Data.ProviderBase.D<wbr />bConnectio<wbr />nClosed.Tr<wbr />yOpenConne<wbr />ction(DbCo<wbr />nnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)<br />
&nbsp; &nbsp;at System.Data.SqlClient.SqlC<wbr />onnection.<wbr />TryOpenInn<wbr />er(TaskCom<wbr />pletionSou<wbr />rce`1 retry)<br />
&nbsp; &nbsp;at System.Data.SqlClient.SqlC<wbr />onnection.<wbr />TryOpen(Ta<wbr />skCompleti<wbr />onSource`1<wbr /> retry)<br />
&nbsp; &nbsp;at System.Data.SqlClient.SqlC<wbr />onnection.<wbr />Open()<br />
&nbsp; &nbsp;at System.Data.Linq.SqlClient<wbr />.SqlConnec<wbr />tionManage<wbr />r.UseConne<wbr />ction(ICon<wbr />nectionUse<wbr />r user)<br />
&nbsp; &nbsp;at System.Data.Linq.SqlClient<wbr />.SqlProvid<wbr />er.get_IsS<wbr />qlCe()<br />
&nbsp; &nbsp;at System.Data.Linq.SqlClient<wbr />.SqlProvid<wbr />er.Initial<wbr />izeProvide<wbr />rMode()<br />
&nbsp; &nbsp;at System.Data.Linq.SqlClient<wbr />.SqlProvid<wbr />er.System.<wbr />Data.Linq.<wbr />Provider.I<wbr />Provider.E<wbr />xecute(Exp<wbr />ression query)<br />
&nbsp; &nbsp;at System.Data.Linq.DataQuery<wbr />`1.System.<wbr />Collection<wbr />s.Generic.<wbr />IEnumerabl<wbr />e&lt;T&gt;.GetEn<wbr />umerator()<wbr /><br />
&nbsp; &nbsp;at System.Collections.Generic<wbr />.List`1..c<wbr />tor(IEnume<wbr />rable`1 collection)<br />
&nbsp; &nbsp;at System.Linq.Enumerable.ToL<wbr />ist[TSourc<wbr />e](IEnumer<wbr />able`1 source)<br />
&nbsp; &nbsp;at AutoReminderEngine.Classes<wbr />.AutoRemin<wbr />der.LoadIn<wbr />tervals()<br />
&nbsp; &nbsp;at AutoReminderEngine.Classes<wbr />.AutoEngin<wbr />e.Start()<br />
ClientConnectionId:0000000<wbr />0-0000-000<wbr />0-0000-000<wbr />000000000<br />
Error Number:-1,State:0,Class:20<wbr />
</div>


<div>
I'm not sure how this software behaves but on the manual for Workstation component they don't have <i>Show all instances</i> checked. Therefore please uncheck it and try again.
</div>


<div>
You said you restored the database in a new server. How about the logins? You'll need to migrate or recreate the logins that have access to the database on the old server to the new one.
</div>


<div>
They have this in the manual<br />

<blockquote>
The “Select Server” window will appear. Click the down arrow in the Server box and select “Your_Server_Name\NORTH40S<wbr />YSTEMS” from the list.
</blockquote>
I'm not sure but they might hardcoded instance name, which means your SQL Server needs to be named instance and it's name has to be NORTH40SYSTEMS. That's crazy, I son't see lot of software like this. If another attempt is not working I suggest to install SQL Server named instance with name: NORTH40SYSTEMS.<br />
<br />
@Vitor,<br />
It's not login issue, error states: <i>(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)</i><br />
It sounds crazy but it really seems these gyus hardcoded instance name in the connection string...
</div>


<div>
You can fool the system by adding an entry in the hosts file: <b>C:\Windows\System32\driver<wbr />s\etc\host<wbr />s</b><br />
<br />
Edit the above file and enter the following line:<br />

<div class="indent">
PDC01\NORTH40SYSTEMS 192.168.200.1
</div>
<br />
Then you can use PDC01\NORTH40SYSTEMS in the configuration screen.
</div>


<div>
I'm afraid you can't do something like that Vitor, did you try your solution? It won't work, the same is possible in native client alias, but you're only operating on server name level, not instance. What you want to achieve is to create hostname PDC01\NORTH40SYSTEMS. If creators of this software hardcoded instance name they'll probably build something like: PDC01\NORTH40SYSTEMS\NORTH<wbr />40SYSTEMS if that entry will work in hosts, but it won't.
</div>


<div>
Yes, I've tried this few times already. Usually during migrations and when we didn't know where the old SQL Server instance has been used so this guarantee us a smooth migration.<br />
Other option is to change on the DNS in the AD.
</div>


<div>
<blockquote>
If creators of this software hardcoded instance name they'll probably build something like: PDC01\NORTH40SYSTEMS\NORTH<wbr />40SYSTEMS if that entry will work in hosts, but it won't. 
</blockquote>
If that's true it wouldn't work before with the old configuration when the author had the PDC01\NORTH40SYSTEMS configured.
</div>


<div>
Find attached file, maybe I'm missing something. <br />

<blockquote>
If that's true it wouldn't work before with the old configuration when the author had the PDC01\NORTH40SYSTEMS configured.
</blockquote>
Not exactly, if it was default instance with SQL Server Express provided by OfficeTools installer then it should work fine. But it's not the case here. Author installed new SQL Server and from what I understood server name was adjusted to new hostname leaving instance name untouched.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211641/hosts.jpg" target="_blank" class="file-inline" title="hosts.jpg (238 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>hosts.jpg</a>
</div>


hosts.jpg

<div>
Ah, it might need to have an alias created. I need to review that.<br />
Thanks.
</div>


<div>
Here is 1 screen shot of the old sever. &nbsp;The database was on SQL Express 2012<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211652/Sql-old-server.JPG" target="_blank" title="Sql-old-server.JPG (102 KB)"><img alt="Sql-old-server.JPG" class="file-block lazyload" style="max-width: 722px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211652/Sql-old-server.JPG" /></a>
</div>


Sql-old-server.JPG

<div>
Here is a second screen shot of the old server<a href="https://filedb.experts-exchange.com/incoming/2017/11_w47/1211653/Sql-old-server2.JPG" target="_blank" title="Sql-old-server2.JPG (753 KB)"><img alt="Sql-old-server2.JPG" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w47/800_1211653/Sql-old-server2.JPG" /></a>
</div>


Sql-old-server2.JPG

sql.log

<div>
sql.log is from the new server which is running SQL Standard 2016
</div>


<div>
ok thanks! This helped a lot. &nbsp;I created the new instance. &nbsp;Now getting password error for the sa. &nbsp;I didn't create the database and there is no record of the sa password.
</div>


<div>
Hi,<br />
<br />
You need to enable mixed mode authtentication, restart SQL Server. After that enable sa account and set strong password for it.<br />

<pre><code class="code-1 nolinks" id="code-20-42374763-1"><span>https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode#SSMSProcedure</span>
</code></pre>
<br />
Next is restore or detach/attach database from default instance. Lastly retry Workstation component configfuration.
</div>


<div>
<div class="content wysiwyg-content">
I restored a SQL database on a new 2016 server (SQL standard 2016). &nbsp;Database seems to run however something seems wrong. &nbsp;The database is for a CRM program called &quot;office tools&quot;. &nbsp;I have attached screen shots.<br />
<br />
I believe I should see the SQL instance in Sql Server Configuration Manager however it does not appear.<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w46/1211539/SQLa.JPG" target="_blank" class="file-inline" title="SQLa.JPG (108 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SQLa.JPG</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w46/1211540/SQLb.JPG" target="_blank" class="file-inline" title="SQLb.JPG (95 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SQLb.JPG</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w46/1211541/SQLc.JPG" target="_blank" class="file-inline" title="SQLc.JPG (506 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SQLc.JPG</a>
</div>
</div>


SQLa.JPG

SQLc.JPG

SQLb.JPG

I restored a SQL database on a new 2016 server (SQL standard 2016).  Database seems to run however something seems wrong.  The database is for a CRM program called "office tools".  I have attached screen shots.

I believe I should see the SQL instance in Sql Server Configuration Manager however it does not appear.

I restored a SQL database on a new 2016 server (SQL standard 2016).  Database seems to run however something seems wrong.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.