please forgive me being a little wet behind the ears on this. I have just started implementing RBS into my application and one thing has been nagging me for a while.
My application will most likely be deployed in scenarios where there is no domain controller so I am opting for SQL Server authentication. I have set up RBS and it works well so far. However, my database connection is still using Windows authentication and I need to move this now to SQL Server authentication which requires the set up of logins on SQL Server, yes?
I was working through the security editor and saw that it creates users and I thought that this might create the needed logins on SQL Server, but this didn't happen. So, what I am asking here is what is best way of organizing a SQL Server login for my application that the data connection can use and access the application database.
I hope the above makes sense.
Q2.
Using your SecurityDialog, is there any way I can put my applications name on it? I would rather not create a custom one just to add my application name.
thanks
Geoff.
I think I see what you are saying, use the sa user. I did consider this, but I come from the Bill Vaughn school of SQL hard knocks and the sa user is pretty sacrosanct.
So, I have changed my connection to use the sa account and all seems well. I don't think I explained my issue very well to start with, but hey it's getting late here.
On the login form front, I just found your example, and it doesn't look like it's too complex to create my own after all.
thanks for being there just to bounce ideas at.
Actually I think you missed my point....you need to be able to define your connection PRIOR to the login form coming up in the SetDataSources method. So you could have this login information stored in an external XML file, registry, etc. and then use these external pieces to setup your connection string. You should never hard code a connection string, user, or password into your application. Maybe that will clear things up a bit.