create contentDB in sharepoint 2016

Question

I am trying to create a content db from asp.net application c# hosted in share point server.

my code is

  SPWebApplication elevatedWebApp = spWeb.Site.WebApplication;
                        string serverName = "xxx\xxx";
                        string newDbName = "WSS_Content_1";
                        string username = "xxxx\\spfarm";
                        string password = "xxxxx";
                        var contentDatabase = elevatedWebApp.ContentDatabases.Add(serverName,newDbName,username,password,0,1,0);

                        contentDatabase.Update();
                        elevatedWebApp.Update();

I got this error message

Cannot connect to database master at SQL server The database might not exist, or the current user does not have permission to connect to it.

I'd appreciate any thoughts.

Thanks

Is it event receiver? Or what type of application? Under which account it is running? — Waqas Sarwar MVP
– Waqas Sarwar MVP ♦, Commented Dec 22, 2016 at 14:31
Use powershell to create web appln, content db etc entities instead of C#. is there any particular reason for creating these entities using C# — samolpp2
– samolpp2, Commented Dec 23, 2016 at 5:56

Waqas Sarwar MVP · Accepted Answer · 2016-12-23 05:38:31Z

0

the issue is mostly with the account under which the application is running, If the application is running under non-farm account then you will get access denied.

account should need DB creator and Security admin on the SQL Server.

answered Dec 23, 2016 at 5:38

Waqas Sarwar MVP♦

57k17 gold badges44 silver badges81 bronze badges

Add a comment |

Stack Exchange Network

create contentDB in sharepoint 2016

1 Answer 1

Hot Network Questions

create contentDB in sharepoint 2016

1 Answer 1

Related

Hot Network Questions