Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hemalkotak
Starting Member
3 Posts |
 Posted - 2008-02-07 : 06:57:30
|
| Regarding Server Management Object (SMO) and (DMO) Data Management Object.While Querying the Named instance of particular SQL Server it is giving Exception "An exception occurred in SMO while trying to manage a service" for this what is the solution...? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 20:08:34
|
| How and what did you query it? |
 |
|
|
hemalkotak
Starting Member
3 Posts |
Posted - 2008-02-08 : 02:12:49
|
quote:
Originally posted by rmiao
How and what did you query it?
i am writing application in C#.net written the workaround given by microsoft person in msdn forum like this.ManagedComputer mc = new ManagedComputer(string machineName);foreach (ServerInstance si in mc.ServerInstances){ lstInstanceNames.Items.Add(si.Name);}for localsystem it shows all the available named instances but for remote system's named instances it doesn't show. for that one exception is generated. " An exception occurred in SMO while trying to manage a service " for this i have searched on web that gives link in microsoft and that is been removed or moved not able to find it, please help me solve this problem. Hemal Kotak |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-08 : 21:41:36
|
| Does windows account you use have proper permission on remote servers? |
|
|
|
hemalkotak
Starting Member
3 Posts |
Posted - 2008-02-12 : 00:54:00
|
quote:
Originally posted by rmiao
Does windows account you use have proper permission on remote servers?
yes i do have permission to log on to the particular system, and remote setting is also there, and added explicitly my windows user account to that system also, but still i m getting the same exception and now i have installed the latest service pack 2 of sql server 2005 on both the system. but the same problem occurs...Hemal Kotak |
|
|
|
|
|
|
SQL Server Management Object (SMO)