Select backlog navigation levels for your team in Visual Studio Team Service

 

  1. From your team’s backlog page, click the gear icon (gear icon) to open the common configuration team settings.
    Backlog board, open team settings
  2. Click the Backlogs tab and check the boxes of those backlog levels you want your team to manage.

    Team Services, web portal, team settings dialog, Backlogs tab

  3. To see the changes, open or refresh your team’s backlog web page.

Reff: https://www.visualstudio.com/en-us/docs/work/customize/select-backlog-navigation-levels

Advertisements

VS2013 An exception occurred while initializing the database

I’m doing a code first Entity database

{“An exception occurred while initializing the database. See the InnerException for details.”}

It was working fine, but I decided to delete the physical database to see it recreate it, but it just fails every time.

I get the error

Cannot attach the file ‘C:\ASP\OdeToFood\OdeToFood\App_Data\OdeToFoodDb.mdf’ as database ‘OdeToFoodDb’.”}

Its code first so I don’t understand why its not recreating the database.

 

 

So deleting the file from Visual Studio was a dumb idea.

SQL still has it registered.

Fire up MS Sql Management Tool, connect to the server in my case

(localdb)\v11.0

You will see the database, still exists, delete it, you will get an error. The file doesn’t exist. Refresh and its gone from SQL. Now run your code again and all is good.

So delete the DB from the management tool not visual studio

SQL Server replication requires the actual server name to make a connection to the server

Symptom:

Error Msg: “SQL Server replication requires the actual server name to make a connection to the server”

 

When attempting to create a new replication publication the following error is produced:

New Publication Wizard

SQL Server is unable to connect to server ‘SSSS’.

Additional information:
SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternative name are not supported. Specify the actual server name, ‘OOOO’. (Replication.Utilities)

Where “SSSS” is the name of the current server, and (in my case) “OOOO” was the previous name of the same server.

Steps to reproduce this problem:

Microsoft SQL Server Management Studio
Expand the server
Expand Replication
Right click “Local Publications” and select “New Publication …”
Cause:

This error has been observed on a server that had been renamed after the original installation of SQL Server, and where the SQL Server configuration function ‘@@SERVERNAME’ still returned the original name of the server. This can be confirmed by:

select @@SERVERNAME
go

This should return the name of the server. If it does not then follow the procedure below to correct it.

Remedy:

To resolve the problem the server name needs to be updated. Use the following:

sp_addserver ‘real-server-name’, LOCAL

if this gives an error complaining that the name already exists then use the following sequence:

sp_dropserver ‘real-server-name’
go
sp_addserver ‘real-server-name’, LOCAL
go

If instead the error reported is ‘There is already a local server.’ then use the following sequence:

sp_dropserver old-server-name
go
sp_addserver real-server-name, LOCAL
go

Where the “old-server-name” is the name contained in the body of the original error.

Stop and restart SQL Server.

 

 

Reff: http://www.cryer.co.uk/brian/sqlserver/replication_requires_actual_server_name.htm 

Fail2ban unban a IP or Unblock an IP

cd /var/log/

nano fail2ban.loga and search for banned IP address.

 

iptables –L –n

Get the banned type from the output and try the following:

fail2ban-client set ssh-iptables unbanip 192.168.1.101

 

ssh-iptables can be replaces by banned type like “pbx-gui”

 

By simplemsexchange Posted in VOIP

VS 2013 : Project name with number in brackets

In file C:\Users\Username\Documents\IISExpress\config\applicationhost.config, under section

<sites>

</sites>

there was all websites (projects) I have ever opened. I deleted these items and now, on New Website there is no number in brackets. NOTE: I think it is not wise to delete the entire file but only the part that applies to sites/projects.

 

 

Reff: http://forums.asp.net/t/1953275.aspx?Project+name+with+number+in+brackets

Visual Studio 2013 Change the Default Location for Projects

For corporate office user my document is always redirected to a file server where creating exe file is restricted.

1. Create a folder in c drive called: vs 2013

2. Inside that folder create 2 folders

Projects

Templates

3. Inside Templates, create another 2 folders:

ItemTemplates

ProjectTemplates

4. Open visual studio and follow the steps

  • On the Tools menu, select Options.
  • From the Projects and Solutions folder, select General.
  • In the Visual Studio projects location text box, enter a location for files and projects.

 

vs2013

 

And you should be all set.

 

Allow remote connections to your MySQL server

nano /etc/my.cnf

Now that the file is backed up let’s open this baby up for editing. When you have the file open you are going to want to look for this line:

bind-address = 127.0.0.1

What the above line does is limit connections to the localhost and only the localhost. You want to comment this line out by changing it to:

#bind-address = 127.0.0.1

Now save that file and restart MySQL with the command:

service mysqld restart

mysql -u root -p

Where root is the MySQL administrative user (most like it is root).

You will be prompted for the MySQL administrators password. After you have successfully authenticated you will have a new prompt that looks like:

mysql>

You are now at the MySQL prompt. You only have one command to enter for this to work. You will want to enter this command carefully:

GRANT ALL PRIVILEGES ON *.* TO username@address IDENTIFIED BY “password”;

Where username is the username on the remote machine that will be connecting, address is the IP address of the remote machine, andpassword is the password that will be used by the remote user.

When that command is issued successfully you should see something like:

Query OK, 0 rows affected (0.00 sec)

As long as you get Query OK, you should be good to go.

 

Full Reff: http://www.ghacks.net/2009/12/27/allow-remote-connections-to-your-mysql-server/