Viewing 15 posts - 1,591 through 1,605 (of 5,393 total)
Looks like a good place for Application Roles: http://msdn.microsoft.com/en-us/library/ms190998.aspx
You create a Windows group for all the authorized users and you add the group as a Windows login in SQL Server.
You...
-- Gianluca Sartori
May 22, 2012 at 3:10 pm
OK, since I'm back to posting on The Thread, I think I'll share this one with you.
Lately I've been working a lot as a SQL Server trainer and I taught...
-- Gianluca Sartori
May 22, 2012 at 2:58 pm
Steve Jones - SSC Editor (5/22/2012)
Gianluca Sartori (5/22/2012)
-- Gianluca Sartori
May 22, 2012 at 2:45 pm
WayneS (5/22/2012)
Has anyone heard from Gianluca since the earthquake in northern Italy? I think he's up in that area, and just want to make sure that he's okay.
Thank you Wayne....
-- Gianluca Sartori
May 22, 2012 at 2:28 pm
jswong05 (5/22/2012)
This is one thing SQL Server is less than Oracle.
I guess you mean "less messy". 🙂
If you use NOLOG and take hot backups, you're just wasting tape.
With SQL...
-- Gianluca Sartori
May 22, 2012 at 10:45 am
Thanks for the article, Wayne.
Very informative and well written!
Along the same line, I recently compared the format function with some other T-SQL and CLR methods here.
Turns out that FORMAT...
-- Gianluca Sartori
May 10, 2012 at 5:32 am
Jan Van der Eecken (5/7/2012)
-- Gianluca Sartori
May 8, 2012 at 12:59 am
Seems to be just a typo (EXITS instead of EXISTS):
SELECT *
FROM OPENQUERY(LSCTLRDAT1, '
SELECT *
FROM TableA
WHERE EXISTS (
SELECT *
FROM CompanyNumbers
WHERE TableA.CompanyNo = CompanyNumbers.CompanyNumber
)
')
If it still doesn't work, you could...
-- Gianluca Sartori
May 4, 2012 at 3:30 pm
Thank you Robert,
I guess I will stick to clustering, then.
I found that whitepaper and I'm in the process of reading it. It's a bit of manual work, but could...
-- Gianluca Sartori
May 2, 2012 at 7:27 am
OMG! Turns out I'm an idiot! :blush:
The MDS database had been restored from another instance and the MDS Administrator was a Windows login from the source instance.
Thanks for your help...
-- Gianluca Sartori
April 30, 2012 at 5:50 am
Koen Verbeeck (4/30/2012)
And if you really log into your computer using that newly created user account and you go to the website, do you still have the same issue?
Yes, unfortunately.
-- Gianluca Sartori
April 30, 2012 at 5:43 am
Koen Verbeeck (4/30/2012)
Did you run IE or whatever browser under the user account that you created?
It doesn't make any difference. I tried with that user and with Administrator, but it's...
-- Gianluca Sartori
April 30, 2012 at 5:36 am
Also, I checked the IIS log files and this is what I found:
#Software: Microsoft Internet Information Services 7.5
#Version: 1.0
#Date: 2012-04-30 10:23:19
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip...
-- Gianluca Sartori
April 30, 2012 at 5:16 am
Hi Koen, thanks for responding!
So you did enable Windows Authentication?
Yes.
I assume you have full permissions on the underlying database?
Yes.
During the set-up of your database in the MDS configuration, you...
-- Gianluca Sartori
April 30, 2012 at 5:13 am
For those wondering where Vinu512's help is needed, this seems to be the thread.
-- Gianluca Sartori
April 30, 2012 at 2:18 am
Viewing 15 posts - 1,591 through 1,605 (of 5,393 total)