Why Does It Say Unknown Caller

SQL Server how to fix the error Can not generate SSPI context

When you encounter this error "Can not generate SSPI context" when connecting to SQL Server or if this error is generated in the Event Viewer Server SQL Server can be caused by the following reasons:

1. Time differences between SQL Server and the client tries to connect

2. Time zone differences between SQL Server and the client tries to connect

3. Differences in hours between SQL Server and the domain controller

4. No record was made for SQL Server SPN, the SPN is used by Kerberos.

An SPN for SQL Server consists of the following:

• ServiceClass : It identifies the general class of service. This is always MSSQLSvc for SQL Server.
• Host: This is the DNS domain name of the computer you are running SQL Server.
• Puerto : This is the port number on which the service is listening.

For example, a typical SPN for a computer running SQL Server is:

MSSQLSvc / SQLSERVER.CONTOSO.COM: 1433

Once these SetSPN SPN with the command, you should check the configuration of DNS servers, for this run the ping command and ping SQLServer-a [IPaddress] these commands must respond appropriately server name and the corresponding IP. If this is not the case then you should fix your DNS so that the security of SQL Server to function properly.

When you start an instance of SQL Server service is running under a domain account, it tries to register its own SPN in Active Directory using an API call DsWriteAccountSpn. If the call is unsuccessful, the following warning is logged in Event Viewer:

MSSQLServer EventID: 19011 Description: SuperSocket Info: (SpnRegister): Error 8344.

To grant the SQL Server service to automatically configure the SPN can then follow these steps:

• To configure the SQL Server service to create SPNs dynamically, you must modify the access control settings for the account in the Active Directory directory service. You must grant permissions "Read ServicePrincipalName" and "Write ServicePrincipalName" for the user running the SQL Server.

This configuration is done using the ADSI Edit, the following steps ( http://support.microsoft.com/kb/811889/es ):

1. Click Home and Run, type Adsiedit.msc click OK .
2. In the ADSI Edit snap, expand Domain [DomainName ] , expand DC = RootDomainName , expand CN = Users , click the right mouse button CN = AccountName and then click Properties .
   
3. Table Properties dialog CN = AccountName , click the Security tab .
4. Security tab , click Advanced .
5. dialog box Advanced Security Settings, make sure CURRENT shown below Permission entries. CURRENT
   If not listed, click Add and then add CURRENT . In
6. Permission entries, click CURRENT and then click Modify .
7. dialog box Permission Entry, click the Properties tab .
8. tab Properties, click This object only listed Apply, and then make sure the boxes for the following permissions are selected under Permissions :
   • ServicePrincipalName
   Read Write ServicePrincipalName
9. Click three times in OK and then quit the ADSI Edit.

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom. spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default. aspx

http://sqlserverpedia.blogspot.com/

Cover Letter For Visual Communication

Reporting Services Reporting Services HTTP 401 (Unauthorized) in cluster environment

When you install Reporting Services in a NLB cluster using a virtual name to access it this can cause them to show the error HTTP 401 (Unauthorized) or the browser is a loop asking for user credentials.

To solve this problem you have two options:

1. Disable LoopBackCheck this is done in HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet \\ Control \\ Lsa and create a DWORD with the name DisableLoopbackCheck with a value of 1, this fixes the problem

Start Registry Editor (Regedt32.exe).

Locate the following registry key and click on it:

HKEY_LOCAL_MACHINE \\ System \\ CurrentControlSet \\ Services \\ LanmanServer \\ Parameters

On the Edit menu, click Add Value and add the following registry value:

Value Name: DisableStrictNameChecking
Data Type: REG_DWORD
Base: Decimal Value
: 1

In Registry Editor, locate the following key and then click it:

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet \\ Control \\ Lsa

Click the right mouse button (mouse) Lsa, point to New, and then click DWORD Value. Write

DisableLoopbackCheck and press Enter.

Right click DisableLoopbackCheck right-click and then click Modify.

In the Value data box, type 1 and click OK.

Close the Registry Editor and restart your computer.

2. Specify the name of the host headers, this is a preferred method.

Start Registry Editor (Regedt32.exe).

Locate the following registry key and click on it:

HKEY_LOCAL_MACHINE \\ System \\ CurrentControlSet \\ Services \\ LanmanServer \\ Parameters

On the Edit menu, click Add Value and add the following registry value:

Value Name: DisableStrictNameChecking
Data Type: REG_DWORD
Base: Decimal Value
: 1

In Registry Editor, locate the following key and click on it:

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CurrentControlSet \\ Control \\ Lsa \\ MSV1_0

Click the right mouse button MSV1_0 selected New, and then click Multi-String Value. Write

BackConnectionHostNames and press ENTER.

Click the right mouse button BackConnectionHostNames, and then click Modify.

In the Value data box, type the host name or virtual host name for sites that are on the local computer, and then click OK.

Watch Los Hombres De Paco Season 1

Performance Optimization of SQL Server 2008 Event

I share this presentation we used in the WebCast on Performance Optimization of SQL Server 2008. The presentation can be viewed on http://www.slideshare.net/ecastrom/ajuste-tuning-del-rendimiento-de-sql-server-2008 .

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Soft During Menstruation

Face Denali

Windows

The Community IT Training invites you to SQL Server 2011 Morning Denali to be held this Thursday March 24 at 8:00 am in the Auditorium of the Universidad Latina de Costa Rica.

Microsoft SQL Server code-named "Denali" is the new version of SQL Server which includes changes to mission-critical solutions through a scalable and highly available. In this event we will see the following topics:
1. SQL Server 2011 New Features and Denali vNext features. In this session we will see major improvements in SQL Denali present will be covered aspects such as T-SQL enhancements, high availability HADR changes, new tools for monitoring and performance improvements.
2. SQL Server 2011 Business Intelligence Denali vNext. In this session we will see the improvements that has SQL Server 2011 with regard to business intelligence, such as improvements in SSIS, Data Quality Services, Column Indexes Store, and PowerPivot Bism.

To attend must register at the following address http://www.sqlserverdenali.eventbrite.com

Greetings,

Windows Community

When Jenna Jameson Piercing

SQL Server 2011 SQL Server Storage Presentation In The Cloud

In this presentation we see the features of SQL Server and storage in the cloud with Azure.

http://www.authorstream.com/Presentation/ecastrom-890996-introduction-to-sql-storage-and-azure/

introduction to

sql storage and storage azure

More

PowerPoint presentations from Eduardo Castro

Long Don Silva Stream

introduction to sql storage and azure s. ..

More PowerPoint presentations from Eduardo Castro

Baby Antique English Prams Ebay

Guide to configure SQL Reporting Services 2008 environment in NLB in Windows 2008 R2

The following is a consolidated guide that includes step by step to configure SQL Server 2008 in a NLB Farm Windows 2008 R2. You can download the document from the following address http://comunidadwindows.org/files/folders/tutoriales/entry894.aspx

Guide to Configure SQL Server Reporting Services on NLB

View more documents from Eduardo Castro .

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http: / / ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Sample Letters For Community Service Hours

How to connect to a SQL Server that is completely blocked

Sometimes you can not connect to SQL Server because we do not have the administrator password, you can not connect to the instance, or have removed all members of the groups that were allowed to connect to SQL Server. In order to access the SQL Server will again to make an administrative connection to SQL Server, to do this we must perform the following steps:

1. First you have to stop all SQL Server services, that is to start the SQL Server in administrative mode, to stop the services running the following commands:

net stop MSSQLSERVER net stop

SQLSERVERAGENT

net stop MSSQLServerOLAPService

SQLBrowser net stop net stop

MsDtsServer100

net stop ReportServer

2. Now we must find the directory where you installed SQL Server to start SQL ; administrative mode from the Command Prompt, this route depends on the version of SQL Server, but it could be the next to SQL 2008 R2 C: \\ Program Files \\ Microsoft SQL Server \\ MSSQL10_50.MSSQLSERVER \\ MSSQL \\ Binn, there must run from the command prompt the following command

sqlservr.exe-m If

you have is a named instance of SQL Server, then you should run the following command

sqlservr.exe-m-s \u0026lt;instanceName>

3. Now SQL Server is running in Single User Mode to access the service should open another Command Prompt and run the following command

sqlcmd-E ;

4. After we are connected to SQL Server, run the following command to create a new login in SQL Server. The following command adds the local administrator rights sysadmin, you can add to the group they wish.

create login [BUILTIN \\ Administrators] from windows go exec
sp_addsrvrolemember [BUILTIN \\ Administrators], [sysadmin]
go

5. After you modify the security lowers the SQL Server service shutdown go 6. Now that SQL Server out of Single User Mode, we can start again Servernet SQL services start MSSQLSERVER net start

SQLSERVERAGENT

MSSQLServerOLAPService net start net start

SQLBrowser

MsDtsServer100 net start net start

ReportServer

6. Now you can connect to SQL Server with a user who belongs to local Administrators group.

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Diesel Leak Astra Fuel Pump

Screencast on Building Business Intelligence Dashboards with SQL Server 2008 R2

I share this ScreenCast on which SQL Server 2008 R2 review and the creation and publication of Business Intelligence Dashboards with Integration Services, Analysis Services and PowerPivot .

SQL Server 2008 Business Intelligence Dashboard from Eduardo Castro on Vimeo .

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http : / / citicr.org / blogs / news / default.aspx

http://sqlserverpedia.blogspot.com/

What Is The Best Way To Get A Spectral Tiger

Guide Dashboard creation BI in SQL Server 2008 R2

I share a guide to building business intelligence dashboards with SQL Server 2008 R2. This guide is complementary to the lecture given on March 9, 2011 at the Universidad Latina de Costa Rica. If you want a machine already installed with the Microsoft BI platform can use the following

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=751fa0d1-356c-4002-9c60-d539896c66ce&displaylang=en

BI Step by Step

View more documents from Eduardo Castro .

Regards, Eduardo Castro Martinez


Microsoft SQL Server MVP
http://comunidadwindows.org

How To Promote Waxing At A Business

Presentation Dashboard Talk BI with SQL Server 2008 R2

BI Dashboards with SQL Server 2008 R2

View more presentations from Eduardo Castro .

Regards, Eduardo Castro


http://comunidadwindows.org

Images Of Testicles Of Guys

BI Dashboards with SQL Server 2008 R2

I share the presentation of the talk on Business Intelligence, which was held on March 9, 2011.

BI Dashboards with SQL Server 2008 R2

More PowerPoint presentations from Eduardo Castro

Regards, Eduardo Castro

When

Confidentialty Language

free tools for trace analysis and SQL Server performance monitoring

performs a trace of SQL Server in many cases is because we want to analyze a server performance problem, the analysis of the traces can be a task that takes time, however there are three free tools that can help identify performance problems based on traces.

1. Project Lucy. Analyzes performance information is uploaded to the website tool to access the features you need to create an account and then you can use for free. https: / / www.projectlucy.com/ these are some examples of using the tool:

2. Clear Trace. Allows importing files of profiler trace and SQL Server 2000, SQL Server 2005 and SQL Server 2008 and displays performance information in summary form. The purpose is to provide a graphical tool for performance analysis. It can be downloaded from http://www.scalesql.com/cleartrace/

3. Qure Workload Analyzer. Graphical tool to analyze performance based on traces of SQL Server, is available in http://www.dbsophic.com/qure-workload-analyzer/

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Microsoft

Fart Fantasy.com Stacey

SQL Server with SQL Server Denali

Atlanta is a cloud-based service that allows proactive monitoring of local installations of SQL Server, in its main features include: helps avoid configuration problems, reduce the time offline, and most importantly allows you to keep track of changes have been made in the configuration of SQL Server instances.

The project is in beta and can be applied for use in this direction https: / / www.microsoftatlanta.com/

Within the constraints of Atlanta are the following:

• The agent and the gateway Atlanta requires Windows Server 2008 or later, either 32 bits or 64 bits
• The agent analyzes and monitors Microsoft SQL Server 2008 or later, either 32 bits or 64 bits
• To enter the portal requires Silverlight 4.0 Atlanta

Atlanta When you enter you have the option to enter or apply control panel to initiate the beta:

must enter their credentials to Windows Live

After entering

shows the main panel

Atlanta

To start monitoring a server must choose

server add

The option to add server, we have several options:

1. Download the certificate that can be accessed Atlanta

2. Download instadores Gateway and Agent Atlanta

OS must have a Gateway that has Internet access and servers to be monitored, the agent's task is to upload the information gathered by the agent to the cloud.

Atlanta agent must be installed on each SQL Server server to be monitored.

Once you have installed the agent and the gateway, will begin to capture monitoring information which Atlanta may be deployed as follows:

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live. com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr. org / blogs / sql / default.aspx

http://sqlserverpedia.blogspot.com/

Head Fire Liquidmetal

Atlanta-Features

I share the presentation used in the event SQL Server Denali, in this presentation we see the main features of the next version of SQL Server. Presentation available at http://www.slideshare.net/ecastrom/sql-server-denali-features

SQL Server Denali Features

View more presentations from Eduardo Castro .

Here are some photos of the event at which we review the main features of SQL Server Denali CPT1

		Event Denali SQL BI Dashboards VIEW SLIDE SHOW DOWNLOAD ALL

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Unlock Resettable Combination Lock Santa Barbara

Live Migration with SQL Server 2008 R2

When you have a server consolidation strategy, virtualization is one of the prinicipal tools, in the case of database servers is always the doubt to virtualize or not, in the case of SQL Server 2008 R2 it has the full support from Microsoft for virtualization http://support.microsoft.com/?id=956893 also has released the document " Planning, Implementing and Supporting SQL Server Virtualization with Windows Server 2008 R2 and Hyper-V Live Migration" which is set in a detailed guide to plan and implement SQL Server with Windows 2008 R2-V HyperV, also includes the necessary considerations to support LiveMigration.

Another product that can be used for server virtualization products is the System Center Virtual Machine Manager (VMM) 2008 R2, Configuration Manager 2007 R2, Operations Manager 2007 R2 and the Data Protection Manager 2010.

virtualization The paper has the following parts:

1. Planning. Includes all necessary steps to identify instances of SQL Server that can be consolidated through virtualization.
2. Implementation. Includes step by step guides to using tools such as P2V to convert physical machines to virtual machines running within HyperV
3. High availability with Live Migration. Step by step details how to configure the Live Migration to SQL Server 2008 R2 and Windows 2008 R2.
4. continuous support. Presents the necessary tools to manage a virtualized environment.

The full document can be downloaded from " Planning, Implementing and Supporting SQL Server Virtualization Windows Server 2008 with Hyper-V R2 Live Migration and "

Greetings,

Mr. Eduardo Castro Martínez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Missildigital 10 X 25 Camera Binocularsany Good?

Creating Business Intelligence Dashboard SQL Server

Les shared the presentation of the event on creating dashboards for business intelligence with SQL Server 2008 R2.

BI Dashboard Creation

More PowerPoint presentations from ecastrom

Greetings,

Mr. Eduardo Castro Martínez , PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http: / / ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr .org / blogs / news / default.aspx

http://sqlserverpedia.blogspot.com/