Why C# does not recognize Server() even after adding assembly "Microsoft.SqlServer.ConnectionInfo"

Question

The type or namespace name 'Server' could not be found (are you missing a using directive or an assembly reference?)

string connetionString = @"connectionStirng"; 
SqlConnection conn = new SqlConnection(connetionString); 
var server = new Server(new ServerConnection(conn));

added at the top

using Microsoft.SqlServer.Management.Common;

Still giving error.
Any help appricated.

Already checked:
Why i'm getting error for the Microsoft.SqlServer.Server namespace?
I can't add Microsoft.SqlServer.Management.Common to my ASP.NET MVC Application

"are you missing a using directive or an assembly reference?" - You added the using, but did you also add the assembly reference? — molnarm, Oct 11 '18 at 09:07
Make sure that `C:\Program Files (x86)\Microsoft SQL Server\140\SDK\Assemblies\Microsoft.SqlServer.ConnectionInfo.dll` is in the references of your project. The folder might different if you use different SQL Server. Mine is SQL Express bundled in VS 2017. — Han, Oct 11 '18 at 09:24
Which `Server` class are you trying to use? I can't find one in the `Microsoft.SqlServer.Management.Common` namespace, so I'm not that surprised that the compiler cannot either. — Damien_The_Unbeliever, Oct 11 '18 at 09:48
@Damien_The_Unbeliever : trying to implement https://stackoverflow.com/questions/12140422/generating-sql-code-programmatically — Suresh Kamrushi, Oct 11 '18 at 09:49
Those seem to be using the SMO objects from the `Microsoft.SqlServer.Management.Smo` namespace, E.g. [`Server`](https://learn.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.management.smo.server?view=sqlserver-2016) — Damien_The_Unbeliever, Oct 11 '18 at 09:50
Well now you're getting the casing wrong. It's `Server` not `server`. — Damien_The_Unbeliever, Oct 11 '18 at 11:29

Han · Accepted Answer · 2018-10-11T11:35:43.273

1

Install this nuget package:

https://www.nuget.org/packages/Microsoft.SqlServer.SqlManagementObjects

Then add using directive:

using Microsoft.SqlServer.Management.Smo;

Now you can create Server object.

var server = new Server();

Installing SMO

Beginning with SQL Server 2017 SMO is distributed as the Microsoft.SqlServer.SqlManagementObjects NuGet package to allow users to develop applications with SMO.

This is a replacement for SharedManagementObjects.msi, which was previously released as part of the SQL Feature Pack for each release of SQL Server. Applications that use SMO should be updated to use the NuGet package instead and will be responsible for ensuring the binaries are installed with the application being developed.

https://learn.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo?view=sql-server-2017

edited Oct 11 '18 at 11:35

answered Oct 11 '18 at 09:59

Han

3,052
2
22
31

It is already added to references and exists in folder you specified. still getting error – Suresh Kamrushi Oct 11 '18 at 10:02
cant install that because of NuGet version required 2.12 but i can update NuGet because of VS 2012. see https://stackoverflow.com/questions/27384885/how-to-upgrade-nuget-with-visual-studio-express-2012 – Suresh Kamrushi Oct 11 '18 at 10:27
@SureshKamrushi I saw your screenshot. You wrote `new server(...)`. It should be `new Server(...)`. C# is case sensitive. – Han Oct 11 '18 at 11:29
@SureshKamrushi It would've been solved quicker if you had posted the screenshot earlier. – Han Oct 11 '18 at 11:35
1

`using` *directive*, not `using` *statement*. C# has two features that both use the `using` keyword. Using the name of one to refer to the other doesn't aid communication. – Damien_The_Unbeliever Oct 11 '18 at 11:35
@Damien_The_Unbeliever Yes, my mistake. I was working with VB.Net earlier. I posted Import statement in my earlier edit. Then changed Import into using, I forgot to change the statement into directive. – Han Oct 11 '18 at 11:37
1

It solved because of installation of "Microsoft.SqlServer.SqlManagementObjects". typo is because i trying it with different cases. – Suresh Kamrushi Oct 11 '18 at 11:47

score 0 · Answer 2 · answered Oct 11 '18 at 09:50

As suggested by Han, Please check the assembly reference path and make sure that the file is there at the referenced location. I had faced similar problem, this was working on the Development environment but error on test server. The reason was the SQL Server Management studio was not installed on the Test server. So i copied the required Assemblies from dev machine to bin folder of the application on test server and that worked.

score 0 · Answer 3 · answered Oct 11 '18 at 10:09

0

Can you try adding a reference to:

Microsoft.SqlServer.dac.dll

If cant find the dll, then need to install SSDT (Sql Server Data Tools).

answered Oct 11 '18 at 10:09

Gauravsa

6,330
2
21
30

Why C# does not recognize Server() even after adding assembly "Microsoft.SqlServer.ConnectionInfo"

3 Answers3