Wednesday, September 18, 2013

[MS SQL Server] Where to see when error occurs during installation of SQL Server 2008

[MS SQL Server] Where to see when error occurs during installation of SQL Server 2008

Where to see when error occurs during installation of SQL Server 2008

Posted: 17 Sep 2013 08:53 PM PDT

Hi friends,when error occurs during installation where i can find the error than means how can i know the cause of that error.Iam new to dba....please help..thanks and regards

Login Failed for user - Password did not match

Posted: 18 Sep 2013 02:13 AM PDT

Hi,So i am migrating an application database from an SQL Server 2000 instance to an SQL Server 2005 instance.When i try to connect to the database on the new instance using the application, "i get the login failed for user: password did not match that for the login provided" 18456 error appearing in the SQL Server log.The application uses SQL Server Authentication and i have re-created the login and re-mapped it to the database on the new server.I am also able to login using management studio with the same account without a problem, it just seems to be when i try to connect via the application. It's almost as if the password is being lost or changed before it reaches the SQL Server to be authenticated.Could anyone offer and advice on this?Thanks in advance.

Kerberos Authentication stopped working

Posted: 17 Sep 2013 06:44 PM PDT

Hi guys, i´ve only been a DBA for 2 years and still i feel like a rookie at this, need some help with kerberos not working.We had a service weekend this weekend, meaning we installed a boatload of windows fixes and restarted all our servers.after that one of our linked servers stopped working.its a double hop thing, user executes SP on server a, going though LS to server B and gathers dataafter looking into it, it seemed like my colleague had installed a developement instance in our test cluster using the same sql service account we use in a production instance, so... the SPNs where tied to 2 different sql server instances.i removed the SPN relating to the dev instance so now it looks like this:MSSQLSvc/SERVERNETWORKNAME.domain.com:<port from sql server log>MSSQLSvc/SERVERNETWORKNAME.domain.com:INSTANCENAMEand this is how all my other instances look, that have a working kerberos authentication... but still it doesnt workServer A has been restarted after removing the bad SPNs and the linked server has been recreated (i read that somewhere)select auth_scheme from sys.dm_exec_connections where session_id=@@spidgives the result "Kerberos" on both server A and server Bstill, the query:select auth_scheme from sys.dm_exec_connections where session_id=@@spidselect * from openquery(DWH, 'select auth_scheme from sys.dm_exec_connections where session_id=@@spid');is getting this result:Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.Msg 4060, Level 11, State 1, Line 1Cannot open database "DATA" requested by the login. The login failed.I just dont see what i have missed, it all worked for the last year at least without a problem, the dev instance that used the prod instance service account is an old one, its been around for a loong time and although we had some issues with it before, we decided to change the service account on the dev instance now, so it doesnt have anything to do with the prod instance.any thoughts?

Replace xp_sqlMaint (RebldIdx) and (RmUnusedSpace) for SQL 2008 R2

Posted: 17 Sep 2013 05:40 AM PDT

Hi,I have to update a SQL script that was running on SQL Server 2000.This is the command line:[code="sql"]EXECUTE master.dbo.xp_sqlmaint '-D MYDATABASENAME -RebldIdx 10 -RmUnusedSpace 50 10'[/code]This line does not work in SQL Server 2008 R2. I receive this error:The SQLDMO 'Application' object failed to initialize (specific error: One of the library files needed to run this application cannot be found.)This is a common error. Tons of post on Google, but no real alternatives.I do not want to install any backward compatibility stuff. I need to find new SQL Server 2008 commands to replace it.----To replace the RmUnusedSpace parameter, I could maybe use :--> DBCC SHRINKFILE (LOG, 50) Is 50 the value that would replicate the old behaviour ?But which SQL command would replicate the (-RebIdIdx 10) parameter?Thank you for helping.Dom.

Rename Server & SQL Instance ??

Posted: 17 Sep 2013 06:22 AM PDT

We have Server_A used for reporting. As a backup if Server_A dies, I would like to copy the databases to Server_B everyday. If Server_A is down, could server_B be renamed to Server_A, and rename the default instance of SQL from Server_B to Server_A ??Otherwise I think I need to have all the users change their various connections to point to Server_B.Is there a better way ?This is a non-production scenario, where it is ok for Server_B to be a bit out of date, based on whenever the last backup was. But minimal cutover time is more important so users are not wasting a lot of time.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog