CRM Installation Error : Sql instance name must be the same as computer name

When the Sql server instance is differ from the machine name, this error will be given as a result of verification tasks under the system check of CRM installation. Most of the time this happens if the Sql server instance changes after the first installation and reinstallations. Anyhow this can be fixed easily as we … Continue reading CRM Installation Error : Sql instance name must be the same as computer name

Create a Proxy in SQL Server Management Studio

Microsoft SQL Server Agent proxy accounts define a security context in which a job step can run. To create a proxy account1.In Object Explorer, expand a server.2.Expand SQL Server Agent.3.Right-click Proxies and select New Proxy.4.On the General page of the New Proxy Account dialog, specify the proxy name, credential name, and description for the new … Continue reading Create a Proxy in SQL Server Management Studio

Create a Credential in SQL Server Management Studio

A credential is required to connect from a outside resource to SQL Server. I needed to created a proxy to run an Integration Service and I wanted to create a credential for that.MSDN says that a single credential can be mapped to multiple SQL Server logins and a SQL Server login can be mapped to … Continue reading Create a Credential in SQL Server Management Studio

Create Log file and attach Data file in SQL Server

You can attach a SQL Server data file(.mdf) which has no log file(.ldf) associate with the data file. Use the following SQL Query with the correct path of the data file.  CREATE DATABASE MyDB ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MyDB_Data.mdf')  -- change the drive and file path FOR ATTACH_REBUILD_LOG ;

Access to a SQL Server in some other Domain from SQL Server Management Studio

Senario in brief: My normal working domain is DomainA. But i have to connect to a sql server in DomainB. Administrators have given me remote desktop connection to the server which has sql server in DomainB but not to direct access from my SQL Server management studio.Following is the solution. runas /netonly /user:DomainB\sqladmin "C:\Program Files (x86)\Microsoft … Continue reading Access to a SQL Server in some other Domain from SQL Server Management Studio