Microsoft SQL Server Management Objects Collection -- Instal

Question

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.

Nitin Sontakke · 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 Sontakke · Answer

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 varible queryDatabaseCreate, 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 hussain · Answer

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" + "
 CREATE DATABASE "+cmbDbName.Text+" ON PRIMARY "+ " 
 ( NAME = '"+cmbDbName.Text+"', FILENAME = '" + installPath + @"" + cmbDbName.Text+".mdf')" + "
 LOG ON "+ "
 ( NAME = '"+cmbDbName.Text+"_log', FILENAME = '"+installPath+ @"" +cmbDbName.Text+"_log.ldf')"; sqlcmdDatabaseCreate = new SqlCommand(queryDatabaseCreate, sqlconDatabaseCreate); sqlcmdDatabaseCreate.ExecuteNonQuery(); sqlconDatabaseCreate.Close();

Microsoft SQL Server Management Objects Collection -- Instal

Answers (3)