The credentials you provided for analysis services service are invalid.

The credentials you provided for analysis services service are invalid. To continue, provide a valid account and password for analysis services service.

We are going to share with all of you about how to troubleshoot when error occurred while installing Microsoft SQL Server on Domain Server. Below mentioned step are tested, these are working perfectly. Hope you will also enjoy and easy troubleshoot this problem by your end. 

Please follow mentioned step to troubleshoot issue.

Step 1: Some times it's happen just because of System require Restart, so firstly restart operating                     system and see that still error occurred continuously. 

Step 2:  Select  NT AUTHORITY\SYSTEM and leave password tab blank, It works right now.

SQL Server

Hope this will help to all of you and resolved your all query if you have any query or question so you may ask to send email on our email account (onlinenetworkssolution@gmail.com) or leave comment on page.

Read More

To take backup and restore sql express by cmd

How to take backup of Microsoft SQL express by command prompt (CMD)?

Now going to share experience about that how to take backup and restore of Microsoft SQL express by command prompt (cmd). As we know about Microsoft SQL express edition it's totally free that's why it has limited feature. In Microsoft SQL express edition  have not feature to create job for backup. We have another option to take backup of Microsoft SQL express by command prompt (cmd).




To take backup of Microsoft SQL express :

SQLCMD -E -S Sql_instanceName –Q "BACKUP DATABASE [Name_of_Database] TO DISK='PathOfDestination\[Name_of_Database].bak'"

For Instance:

SQLCMD -E -S .\SQLEXPRESS -Q "BACKUP DATABASE TEST TO DISK='E:\Backup\test\test.bak'"

To restore backup of Microsoft SQL express :

SQLCMD -E -S Sql_instanceName –Q “RESTORE DATABASE [Name_of_Database] FROM DISK='PathOfDestination\[Name_of_Database].bak'"


For Instance:

SQLCMD -E -S .\SQLEXPRESS -Q "RESTORE DATABASE TEST FROM DISK='E:\Backup\test\test.bak'"

Hope this will help to all of you and resolved your all query if you have any query or question so you may ask to send email on our email account (onlinenetworkssolution@gmail.com) or leave comment on page.

Read More

ODBC administrator has stopped working

ODBC administrator has stopped working.

How to troubleshoot when we click on file DSN so crash our ODBC Data Source administrator?

Solution:- 

The ODBC shortcuts point to %windir%\system32\odbcad32.exe This is the version that crashes.

The version in %windir%\SysWOW64\odbcad32.exe works allright! If the ODBC administrator in SysWOW64 works allright for you, you might consider changing your shortcuts to point to that location.

Hope this is helpful and easy to resolve query.

Read More

Could not start the Service on Local Computer.

windows could not start the sql server (mssqlserver) service on local computer error 1067

How To Fix Error Code 1067 in Microsoft SQL Server?

Today we are going to share with you all about Microsoft SQL Server troubleshooting of Error code 1067 It's happened when Microsoft SQL server service stopped and user start SQL service but this error show so many time. we have several step which help to start Microsoft SQL server services.

Following step are mentioned here:-

Step 1:- Open SQL Server Configuration Manager or Open Run and then type QLServerManager<version>.msc such as SQLServerManager13.msc.

Step 2:- Right Click on SQL Server and click on Properties 

Step 3:- Click on Log On Tab 

Step 4:- Change Built-in account setting Local system or Network Service or Local service so select one of three one by one and check that on which your Microsoft SQL server service is start.

Second Option and step:-

Step 1 :- Open Run dialog box and type Regedit and then go into SQL Server instance name where you have to change SQL server instance name.

Registry Location :

Step 2:-  Open Run dialog box and type services.msc and then select SQL server service and see there that name has been change and now you can start SQL server services.

Read More

SQL Server database showing read only

SQL Server database showing read only

We are going to share with you Microsoft SQL server database solution when you attached your old database with SQL server at that time some time you see that Read-only database show so we have solution of this make sure that your database same directory where all the database working because some time happen that you have not permission on that particular folder where you are going to store database in these condition you make sure your database file is correct location and you have required permission on that work.

Following all the steps:-

Step 1:- Right Click on your read only database and select Properties.

Step 2:- Click on General Tab and cursor scroll down  and see "Database Read Only - TRUE " If database read only true so change it into False before doing false make sure that your SQL database not connected with another user. 

Read More