CODEWITHSUNDEEP
sql-serverazuressms
BeniaminoBaggins
BeniaminoBaggins

Reputation: 12493

Am I using SQL Server or SQL Azure?

I have this issue which I have asked about here

In all my programmatic attempts to fix the issue above, things like this are displayed in the messages box:

Reference to database and/or server name in 'master..sp_addsrvrolemember' is not supported in this version of SQL Server.

How do I find the version of SQL Server,I am using? It seems nothing is supported by my version.

Is the issue can be that - I am not using SQL Server somehow? I am using Microsoft Azure to host my database. Does that make you use SQL Azure? In SSMS, in the Object Explorer, at the top where it says the server, it says gonskh1ou0.database.windows.net(SQL Server 13.0.201 - Amber). Amber is my user name, and is the administrator. SQL Server 13.0.201 is not in this list of SQL Server build numbers

Upvotes: 0

Views: 759

Answers (2)

Sami Kuhmonen
Sami Kuhmonen

Reputation: 31193

Yes, you are using the Azure version of SQL Server, which does not support sp_addsrvrolemember.

(Do note that that stored procedure is deprecated and you should be using ALTER SERVER ROLE, which is supported at least in Azure SQL Data Warehouse's preview.)

The only way to run a full SQL Server is to create a VM and run it there yourself. The Azure version will never be the full version.

Upvotes: 2

WeeniehuahuaXD
WeeniehuahuaXD

Reputation: 852

You are using Microsofts implementation of SQL server, the version number and name(Amber) supplied are indeed correct. Depending on the level of Azure account you are using, this server is usually configurable.

Microsoft Azures platform contains some very nice support and I would advise consulting directly with a rep. They have always been very helpful and quick to help in regards to configuration issues, even performing the configurations for you if required.

Upvotes: 0

Related Questions