Showing posts with label applications. Show all posts
Showing posts with label applications. Show all posts

Friday, March 30, 2012

Impact of AD Migration on Windows authenticated SQL user account

We have SQL applications in which some of the SQL user
accounts are integrated with Windows authentication.
We would like to find out whether any of you have
migrated any SQL based applications of which the SQL user
accounts were configured to make use of Windows
authentication instead of SQL authentication. Will the
Windows accounts in SQL be automatically translated to
the new AD account (with all necessary SQL
rights/permissions) or do we have to manually recreate &
reconfigure all Windows accounts in SQL and its
rights/permissions?
Appreciate some feedback. Thanks.
.Hi
If you are using the AD migration tool then you should keep the same SIDs
and therefore there should not be a problem.
If you do change SIDS then the amount of rework would be reduced if you used
NT groups when granting premissions rather than individual users.
John
"Teo Chee Yang" <anonymous@.discussions.microsoft.com> wrote in message
news:c11b01c40893$25655870$a301280a@.phx.gbl...
> We have SQL applications in which some of the SQL user
> accounts are integrated with Windows authentication.
> We would like to find out whether any of you have
> migrated any SQL based applications of which the SQL user
> accounts were configured to make use of Windows
> authentication instead of SQL authentication. Will the
> Windows accounts in SQL be automatically translated to
> the new AD account (with all necessary SQL
> rights/permissions) or do we have to manually recreate &
> reconfigure all Windows accounts in SQL and its
> rights/permissions?
> Appreciate some feedback. Thanks.
> .
>|||Personally I doubt that ADMT does translate any SQL
permissions and rights assigned to Windows-authenticated
SQL user accounts.
Besides, I realized that from the Security, Logins folder
that once the logins are defined as <NT4
domain>\<username>, we cant changed it, even before the
migration of the SQL server computer account.
Any more feedback?

>--Original Message--
>Hi
>If you are using the AD migration tool then you should
keep the same SIDs
>and therefore there should not be a problem.
>If you do change SIDS then the amount of rework would be
reduced if you used
>NT groups when granting premissions rather than
individual users.
>John
>"Teo Chee Yang" <anonymous@.discussions.microsoft.com>
wrote in message
>news:c11b01c40893$25655870$a301280a@.phx.gbl...
user
&
>
>.
>|||Hi
This sounds like you are changing the domain as well during the migration.
In which case look at:
http://support.microsoft.com/defaul...kb;EN-US;240872
I believe in the documentation that SIDs are retained by ADMT, if it did not
all sorts of other privilege related problems would occur.
John
"Teo Chee Yang" <anonymous@.discussions.microsoft.com> wrote in message
news:c64d01c40915$7d155610$a401280a@.phx.gbl...
> Personally I doubt that ADMT does translate any SQL
> permissions and rights assigned to Windows-authenticated
> SQL user accounts.
> Besides, I realized that from the Security, Logins folder
> that once the logins are defined as <NT4
> domain>\<username>, we cant changed it, even before the
> migration of the SQL server computer account.
> Any more feedback?
>
> keep the same SIDs
> reduced if you used
> individual users.
> wrote in message
> user
> &

Monday, March 19, 2012

I'm new, I'm lost, I think I've installed the wrong this!

Hi folks

I've got experience of developing applications using relational databases, but I've never installed a database on my PC.

I've just downloaded and installed .NET Framework 2.0 without issues. I also did Visual C# Express with no problems and I've made a couple of example projects successfully.

What I wanted to do next was install SQL Server Express so I can design a database and then use Visual C# to create a GUI to do a simple add/edit/delete type scenario.

So, I have installed something called SQL Server 2005. I tried to install SQL Server Express, but for some reason it isn't called that on my list of programs.

When I open that up I have a choice of SQL Server Configuration Manager or SQL Server 2005 Surface Area Configuration. None of these look like what I was expecting - a nice Studio where I can create tables much like MS Access.

Perhaps I need to do something with one of these tools to get to where I want to be, or perhaps I am barking up the wrong tree and I need to do some uninstalling.

I wondered if someone could guide me? I feel so lost that I don't even know the right questions to ask to get the answers.

Thanks

Richard

The 'standard' installation for SQL Express does not include any 'client tools', i.e., "where I can create tables".

However, you can download and install the SQL Server Management Studio Express from:

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx

SQL Server 2005 Express Edition (Advanced/SSMS)
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn2.microsoft.com/en-us/library/ms365247.aspx
http://tinyurl.com/yelwr9

I included the url for Books Online -the definitive help source for SQL Server.

|||

Thank you kind sir.

I guessed there was another step to do but I just couldn't figure it out.

I'm downloading now, so if I have any issues with the installation I'll pop back for help. Or, I'll try the online book which looks like it'll be a great help.

Have a nice day.