# Method 'get\_SerializationSettings' issue in New-AzureRmSQLServer

**URL:** <https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977>\
**Category:** PowerShell Help\
**Created:** [March 17, 2020, 8:35pm UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977 "2020-03-17T20:35:21Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![greg-low](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/greg-low/32/128_2.png) [@greg-low](https://forums.powershell.org/u/greg-low)\
**Post date:** [March 17, 2020, 8:35pm UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977/1 "2020-03-17T20:35:21Z")

</div>

Hi Folks,

Just trying to create a new Azure SQL Server by using New-AzureRmSQLServer. The username and password are already available in variables. I’m trying code like this:

# Create the administrator credentials

$secureAdministratorPassword = ConvertTo-SecureString $administratorPassword -AsPlainText -Force  
$sqlServerAdministratorCredentials = New-Object PSCredential($administratorUserName, $secureAdministratorPassword)

# Create the SQL Server

New-AzureRmSQLServer -ServerName $sqlServerName `-SqlAdministratorCredentials $sqlServerAdministratorCredentials`  
-Location $datacentreLocation `  
-ResourceGroupName $resourceGroupName

But I’m ending up with the following error that really doesn’t give much of a clue about the issue:

New-AzureRmSQLServer : Method ‘get\_SerializationSettings’ in type ‘Microsoft.Azure.Management.Sql.SqlManagementClient’  
from assembly ‘Microsoft.Azure.Management.Sql, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ does  
not have an implementation.

Is there a wrong version of one of the dependencies?

Thanks,

Greg

---

<div class="post-metadata">

**Author:** ![Olaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/olaf/32/992_2.png) [@Olaf](https://forums.powershell.org/u/Olaf)\
**Post date:** [March 17, 2020, 9:11pm UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977/2 "2020-03-17T21:11:21Z")

</div>

When you crosspost the same question at the same time to different forums you should at least post links to the other forums along with your question to avoid people willing to help making their work twice or more.  
Thanks.

[https://stackoverflow.com/questions/60732661/method-get-serializationsettings-issue-in-new-azurermsqlserver](https://stackoverflow.com/questions/60732661/method-get-serializationsettings-issue-in-new-azurermsqlserver)

---

<div class="post-metadata">

**Author:** ![greg-low](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/greg-low/32/128_2.png) [@greg-low](https://forums.powershell.org/u/greg-low)\
**Post date:** [March 17, 2020, 9:44pm UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977/3 "2020-03-17T21:44:24Z")

</div>

Hi Olaf,

I was trying to work out how to remove it from here (after posting, I thought SO might be a better option), but for the life of me, I can’t find a “delete” button. The “Edit” option doesn’t offer a Delete either. Is there one?

---

<div class="post-metadata">

**Author:** ![greg-low](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/greg-low/32/128_2.png) [@greg-low](https://forums.powershell.org/u/greg-low)\
**Post date:** [March 17, 2020, 9:57pm UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977/4 "2020-03-17T21:57:22Z")

</div>

I have no idea why the AzureRm option doesn’t work, but I changed all the code to use Az instead, and it all just works.

So nothing else required thanks.

---

<div class="post-metadata">

**Author:** ![sam-boutros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/sam-boutros/32/5_2.png) [@sam-boutros](https://forums.powershell.org/u/sam-boutros)\
**Post date:** [March 18, 2020, 8:01am UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977/5 "2020-03-18T08:01:58Z")

</div>

Use the current New-AzSqlServer cmdlet of the AZ PS module (Az.Sql)  
You also need to uninstall-module AzureRM

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:30pm UTC](https://forums.powershell.org/t/method-get-serializationsettings-issue-in-new-azurermsqlserver/13977/6 "2024-05-16T20:30:15Z")

</div>