January 30, 2009 at 6:09 am
Hi
In my aplication I search for the available servers in the network, but at each reconnect the number of servers is different. And when I try to connect to my local server and I use Windows Authentication I receive the error : "cannot generate sspi context", but after some reconects while I use my aplication the connection is succesfully.
Can you please help me solve those hazards?
Thank you
January 30, 2009 at 6:23 am
shnex (1/30/2009)
In my aplication I search for the available servers in the network, but at each reconnect the number of servers is different.
Yes, this always happens on but the smallest networks. I have my program make a folder/group in Registered Servers, and accumulate every new one that it sees there, then I use that as my selection list.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 6:51 am
I supose it also removes the ones that aren't also...because if a server is really stoped and you try to connect, what happens?
So it's better to keep them in a list ,or something like this and to actualize it?( I hope I understand what you said:D but I don't really know stuff about Registered Servers...)
January 30, 2009 at 7:17 am
shnex (1/30/2009)
I supose it also removes the ones that aren't also...because if a server is really stoped and you try to connect, what happens?
Nope, keep them all in. The only way that you can truly tell if a SQL Server is really running is to connect to it anyway. If it is not there then you hang for Login Timeout seconds. That's usually 30 to 120 seconds, but you can set it to whatever you want.
By the way, I would recommend using SMO instead of SQLDMO. No sense writing new code that's already obsolete.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 10:11 am
I used SQLDMO because there in my way to my solutions I descovered it , and it was a easy way to find servers, to script objects in db.
I know that at a moment I looked over SMO, but it seemed harder,and I don't know if there were materials for it
The problem is I have a project that needs to be finished on 4 feb and I don't think that I have time to learn how to do all the tings I've done in SMO.
I will look if I can get a little time.
Could you give me a link, pls?
Thanks for your responses
January 30, 2009 at 11:14 am
shnex (1/30/2009)
Could you give me a link, pls?
SMO is documented in BOL.
If you want a code example of how to do this with SMO, see here: http://www.sqlservercentral.com/Forums/Topic494616-386-1.aspx#bm494720
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 2:18 pm
and..another question about SQLDMO...
I see everywhere that is for SQL Server 2000, but I'm using it for 2005.
It can see may server and my SQL Server 2000 databases.
Is there any trick?
Thank you again for your responses
January 30, 2009 at 3:07 pm
shnex (1/30/2009)
and..another question about SQLDMO...I see everywhere that is for SQL Server 2000, but I'm using it for 2005.
It can see may server and my SQL Server 2000 databases.
Is there any trick?
Yes, the trick is to use SMO instead. AFAIK, DMO does not work on SQL Server 2005.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 3:24 pm
I'm using C#, and the documentation for DMO is prety difficult to understand for my level...:D, I haven't searched enough, I admit
I' managing with SQLDMO , not very good but enough for what I need
Though this thing between 2000 and 2005 is weird.
When i'm connecting to (local) I see my 2000 databases, when I'm using the named instance I see the 2005 databases.I don't know...It shows SQL Server 2005 when I log in:D, and in Start I have Sql Server 2005.I hope this is not a confusion, and in fact to use 2000. I don't think that's possible:)
Anyway....I am using SQLDMO till the end of the project,is too late to change it now. I'm sorry I haven't asked earlier
Thanks man
January 30, 2009 at 3:32 pm
You probably have both 2000 and 2005 on your local system. Named instances were new with SQL Server 2000 & DMO and they do not handle named instances as well as SQL Server 2005 and SMO.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 3:39 pm
but they handle?
SQLDMO works with SQL Server 2005? that's the question:)
I understand from what you say that sqldmo works with named instances in 2000. Maybe it works with 2005 too?:)
You know better...I'm just experimenting , but unfortunetly I need to present this project and I have lot to learn:D...and don't have time ... so I'm asking you:) to be sure 🙂
January 30, 2009 at 3:52 pm
shnex (1/30/2009)
but they handle?SQLDMO works with SQL Server 2005? that's the question:)
I understand from what you say that sqldmo works with named instances in 2000. Maybe it works with 2005 too?:)
You know better...I'm just experimenting , but unfortunetly I need to present this project and I have lot to learn:D...and don't have time ... so I'm asking you:) to be sure 🙂
OK, let me be a little bit clearer:
1) As far as I know, SQLDMO does NOT work with SQL server 2005. If it is working for you, then I stand corrected, but that was my understanding.
2) SQLDMO may or may not work with Instance Names correctly. I suspect that you will have a problem with them, especially when trying to detect server instances.
I have used SMO a lot, but I have not used SQLDMO. DMO was already obsolete when I started using SMO 3 years ago, so I never had a reason to use it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 30, 2009 at 3:57 pm
ok:D
I understand
Thank you for your time and you responses
Unfortunately it is a liitle too late to change my project...though I understand from you that it is a better solution...:D
Again 10x
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply