Viewing 15 posts - 1,201 through 1,215 (of 2,008 total)
While a database mirroring session is active, the following restrictions apply:
•Backup and restore of the mirror database are not allowed.
•Backup of the principal database is allowed, but BACKUP LOG...
November 30, 2011 at 7:12 am
anthony.green (11/30/2011)
Doh..... missed that part
Now I believe my eyesight is quite OK.
OR
Both of us need to visit eye specialist. :doze:
November 30, 2011 at 7:08 am
It's possible for Windows Server 2008 SP2 + SQL Server 2005 SP3 combination.
November 30, 2011 at 7:02 am
anthony.green (11/30/2011)
if you take a look at the MSDN link Dev provided it doesn't mention Windows2008R2 in the article, so I wouldn't install SQL2005 on Windows2008R2You can install on Windows2008
Actually,...
November 30, 2011 at 7:00 am
Yes.
Granting a permission removes DENY or REVOKE of that permission on the specified securable. If the same permission is denied at a higher scope that contains the securable, the DENY...
November 30, 2011 at 6:58 am
Not Sure on R2 but you can install on Windows Server 2008.
Hardware and Software Requirements for Installing SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.90).aspx
List of known issues when you install SQL Server 2005 on...
November 30, 2011 at 5:14 am
Usman Butt (11/30/2011)
Dev (11/30/2011)
•Members of the securityadmin role cannot make any login a member of the sysadmin fixed...
November 30, 2011 at 5:09 am
It might be a security issue in SS2K, not any more.
•Members of the securityadmin role cannot make any login a member of the sysadmin fixed server role.
•Members of the securityadmin...
November 30, 2011 at 4:53 am
Are you making attempt on correct server? Please check server name / instances (named / default).
Can you login on the server with Windows Account? Are SQL Logins enabled on Server?
November 30, 2011 at 4:32 am
Usman Butt (11/30/2011)
I hope you keep in mind that adding member to security admin is almost equal to giving CONTROL SERVER permission. 🙂
Not Exactly. CONTROL SERVER has more privileges.
http://msdn.microsoft.com/en-us/library/ms175892(v=SQL.105).aspx
November 30, 2011 at 4:28 am
Are you sure nobody touched the Authentication Mode? Please verify. It can't just appear without user intervention.
November 30, 2011 at 4:22 am
It's my name. 'Dev' is a Hindi (Indian) word which means 'God'. Coincidently I have worked as DEV and DBA both.
My name creates confusion (in IT industry at least). That’s...
November 30, 2011 at 4:16 am
I suppose I could have just given it CONTROL SERVER and thus avoid the extra hassles with insufficient privileges to perform its job but to be honest, it just strikes...
November 30, 2011 at 3:51 am
It's good that you are able to resolve it. 🙂 But I am curious to know the scenario & what actually worked out there. Did you achieve following?
The user is...
November 30, 2011 at 3:31 am
May I know why do you want to do it?
November 30, 2011 at 3:18 am
Viewing 15 posts - 1,201 through 1,215 (of 2,008 total)