Thursday, May 2, 2013

[MS SQL Server] SQL failed logins are appearing in the error log but application user failed logins aren't?

[MS SQL Server] SQL failed logins are appearing in the error log but application user failed logins aren't?

SQL failed logins are appearing in the error log but application user failed logins aren't?

Posted: 01 May 2013 09:07 PM PDT

I'm having an issue where SQL failed logins i.e. my admin account or any user accessing SQL from the database server it self is being logged in the error log. Thats fine but the problem I'm having is the account from the application (SharePoint) is trying to access the SQL database but is failing to connect. Should this also appear in the SQL error log? If not is there a way I can check why the application account is failing? I can connect to the database server from my laptop so it's not an issue with remote login.Many thanks in advance for any assistance

Removing a partitioning scheme from a table with one filegroup and no clustered indexes

Posted: 02 May 2013 02:55 AM PDT

OK, I'm going to be removing a partitioning scheme from a table which no longer needs it, and just want to confirm a few things.First, the table lives entirely on a single filegroup, the Primary filegroup. There is only one index, a non-clustered, which is using the partitioning scheme.So, if my reading is correct, I should be able to re-create the index on Primary, then drop the partition scheme and function, yes?I'm basing this on this [url=http://ask.sqlservercentral.com/questions/50016/how-to-remove-the-sql-server-partitioning-implemen.html]AskSQLServerCentral post[/url] and this [url=http://www.patrickkeisler.com/2013/01/how-to-remove-undo-table-partitioning.html]blog post[/url].Thanks,Jason

Checking if any database objects are encrypted

Posted: 01 May 2013 08:51 PM PDT

Hi,I have just been given a database to check over to see if we can get at all the data. The database has restored fine, so that's step 1 complete as there is no backup encryption.Step 2 was to check the objects. I ran the following query[code="sql"]SELECT SCHEMA_NAME(sp.schema_id) AS [Schema], sp.name AS [Name], sp.object_id AS [ID], sp.create_date AS [CreateDate], sp.modify_date AS [DateLastModified], CAST(CASE WHEN smsp.definition IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted]FROM sys.all_objects sp LEFT JOIN sys.sql_modules smsp ON smsp.object_id = sp.object_idWHERE smsp.definition IS NULL -- This identifies an encrypted object AND sp.type IN ('FN', 'IF', 'V', 'TR', 'PC', 'TF', 'P') AND sp.is_ms_shipped = 0SELECT sp.type, sp.type_desc , COUNT(smsp.definition) AS UnencryptedObjects -- only non-null or unencrypted objects will be counted , COUNT(*)-COUNT(smsp.definition) AS EncryptedObjects , COUNT(*) AS TotalFROM sys.all_objects sp LEFT JOIN sys.sql_modules smsp ON smsp.object_id = sp.object_idWHERE sp.type IN ('FN', 'IF', 'V', 'TR', 'PC', 'TF', 'P') AND sp.is_ms_shipped = 0GROUP BY sp.type, sp.type_desc[/code]....which returned 0 encrypted objects.I noticed that tables are not included in the above query as they do not have a record in sys.sql_modules.What checks, if any, do i need to run to check for encrypted data in tables without having to do a select top 1 from each table.RegardsJohn

Production Move

Posted: 01 May 2013 08:47 AM PDT

[i]Hi All,I am going to a move a server to production. The present production is 2005 enterprise, now i am going to move this production to 2008 r2 slandered.Here is my Question What are the steps to follow to move server to production?If something happen to the production what are the steps to rollback?Could you please give me some suggestions? In advance Thank you [/i]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog