Viewing 15 posts - 1,591 through 1,605 (of 5,394 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...
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...
May 22, 2012 at 2:58 pm
Steve Jones - SSC Editor (5/22/2012)
Gianluca Sartori (5/22/2012)
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....
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...
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...
May 10, 2012 at 5:32 am
Jan Van der Eecken (5/7/2012)
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...
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...
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...
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.
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...
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...
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...
April 30, 2012 at 5:13 am
For those wondering where Vinu512's help is needed, this seems to be the thread.
April 30, 2012 at 2:18 am
Viewing 15 posts - 1,591 through 1,605 (of 5,394 total)