Microsoft SQL Server Management Objects Collection -- Instal

masood hussain

10y840

Microsoft SQL Server Management Objects Collection -- Installation of this product failed because it is not supported on this operating system.

Please I need assistance on above error. Unable to create database.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Accepted answer
Hello,
To begin with may you should also give additional information, what is it that you installed/ trying to install on which os, etc.
Without that how can we assist?
Nitin Sontakke10y ago
Hello,
Once again, wouldn't it help if you could post what error you are getting?
There are several things to do. Does use has permission? what is that user's role?
Why do you ever want to create a db this way? Any solid business requirement?
Whatever is the generated value of variblequeryDatabaseCreate, have you tried executing it in query analyser?
When you create a db this way, there is really no need to specify .mdf and .ldf file paths they are taken care of by server itself?
Have you tried simplest ever (bare minimum) create database command?
masood hussain10y ago
Dear All,
I have an microsoft msi installer which installes database on sql server using SMO. Am using sql server 2012 smo and trying to install on 64 bit Windows OS 2012. Am tring to create database but it is failing.
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Sdk.Sfc;
using Microsoft.SqlServer.Management;
using Microsoft.SqlServer.Server
//database Creation
string csDatabaseCreate = "User ID=" + txtUserName.Text.ToString().Trim() + ";Initial Catalog=Master ;Data Source=" + txtDatabaseServerName.Text.ToString().Trim() + ";pwd=" + txtPwd.Text.ToString().Trim() + "";
SqlConnection sqlconDatabaseCreate = new SqlConnection(csDatabaseCreate);
sqlconDatabaseCreate.Open();

SqlCommand sqlcmdDatabaseCreate;

string queryDatabaseCreate = "USE Master" +
"\n CREATE DATABASE "+cmbDbName.Text+" ON PRIMARY "+
" \n ( NAME = '"+cmbDbName.Text+"', FILENAME = '" + installPath + @"\" + cmbDbName.Text+".mdf')" +
"\n LOG ON "+
"\n ( NAME = '"+cmbDbName.Text+"_log', FILENAME = '"+installPath+ @"\" +cmbDbName.Text+"_log.ldf')";
sqlcmdDatabaseCreate = new SqlCommand(queryDatabaseCreate, sqlconDatabaseCreate);
sqlcmdDatabaseCreate.ExecuteNonQuery();
sqlconDatabaseCreate.Close();